FSA Report Sample 1
FSA Report Sample 1
PROJECT REPORT
ON
Krati Mangal
Muskan Agarwal
Royal Shivhare
3 Ratio Analysis
a. Liquidity ratios
b. Solvency ratios
c. Activity ratios
d. Profitability ratios
4 Conclusion
5 References
6 Annexures
DR. REDDY LAB
International expansion
The company's first international move took it to Russia in 1992. There, Dr. Reddy's formed a
joint venture with the country's biggest pharmaceuticals producer, Biomed. They pulled out in
1995 amid accusations of scandal, involving "a significant material loss due to the activities of
Moscow's branch of Reddy's Labs with the help of Biomed's chief executive". [10] Reddy's sold
the joint venture to the Kremlin-friendly Sistema group. In 1993, Reddy's entered into a joint
venture in the Middle East and created two formulation units there and in Russia. Reddy's
exported bulk drugs to these formulation units, which then converted them into finished
products. In 1994, Reddy's started targeting the US generic market by building state of art
manufacturing facility.
Abiraterone
Ranitidine HCI Clopidogrel (Not in US
Acetate
Form 2 Losartan Potassium due to 2007 patent case)
Canagliflozin
Naproxen Sparfloxacin Omeprazole
Ciprofloxacin
Sodium Nizatidine Finasteride
Hydrochloride
Naproxen Fexofenadine Sumatriptan
Ramipril
Atorvastatin Ranitidine glimepiride
Terbinafine HCI
Montelukast Hydrochloride Stolin gum astringent
Ibuprofen
Nelfinavir Form 1 Senquel f
Sertraline
Mesylate Stolin r
Hydrochloride
Ratio Analysis
Ratio analysis is a quantitative method of gaining insight into a company's liquidity, operational
efficiency, and profitability by studying its financial statements such as the balance sheet and
income statement. Ratio analysis is a cornerstone of fundamental equity analysis.
People who are interested in long term investing in stocks knows about financial ratio analysis. If
you have heard about terms like price to earnings ratio, price to book value ratio etc., you know
ratio.
But in this financial ratio analysis we will go beyond these usual ratios. Generally I do a
detailed fundamental analysis of my stocks using my stock analysis worksheet. My worksheet
calculates financial ratios of stocks and presents it systematically as a final report.
These ratios are calculated using numbers taken from a company’s balance sheet, profit & loss
a/c, and cash flow statements
1. Liquidity Ratios
This type of ratio helps in measuring the ability of a company to take care of its short-term debt
obligations. A higher liquidity ratio represents that the company is highly rich in cash.
2. Profitability Ratios
This type of ratio helps in measuring the ability of a company in earning sufficient profits.
3. Solvency Ratios
Solvency ratios can be defined as a type of ratio that is used to evaluate whether a company is solvent and
well capable of paying off its debt obligations or not.
4. Turnover Ratios
Turnover ratios are used to determine how efficiently the financial assets and liabilities of an organization
have been used for the purpose of generating revenues.
LIQUIDITY RATIOS
Liquidity ratios measure a company's ability to pay off its short-term debts as they become due,
using the company's current or quick assets. Liquidity ratios include the current ratio, quick ratio,
and working capital ratio.
1. Current Ratio: The current ratio is the ratio between the current assets and current liabilities of
a company. The current ratio is used to indicate the liquidity of an organization in being able to
meet its debt obligations in the upcoming twelve months. A higher current ratio will indicate that
the organization is highly capable of repaying its short-term debt obligations.
Current Ratio = Current Assets / Current Liabilities
This is the data of Dr. Reddy lab and ratio analysis of last 5 YEARS.
Current Ratio
2.5
1.5
0.5
0
16-Mar 17-Mar 18-Mar 19-Mar 20-Mar
INTERPRETATION
In 2016, the firm’s ability to cover its current liabilities with its current assets was 2.10. In 2020,
the ratio goes up to 2.41 as compared to last five years, which means that the company has the
ability to pay its liabilities, as the definition says that higher the ratio, greater the ability of the
firm to pay its bills. This tells that Dr. Reddy Labs is improving their liquidity and efficiency,
because their current ratio is improving.
2. Quick Ratio: The quick ratio is used to ascertain information pertaining to the capability of a company
in paying off its current liabilities on an immediate basis.
The formula used for the calculation of a quick ratio is-
Quick/Liquid Ratio
2.5
1.5
0.5
0
16-Mar 17-Mar 18-Mar 19-Mar 20-Mar
INTERPRETATION
According to the definition of Acid Test Ratio, the company should have the ability to pay its liabilities
through its most liquid assets. The table shows that in 2016, the firm has the ratio 1.74 cents. Then we
observe an improvement in 2019. Then again we observed a decline from 2.24 to 1.89 in 2020... This
leads us to believe that Dr. Reddy Labs is a somewhat risky business, even though it is the largest in the
pharmaceutical.
3. Absolute Liquid Ratio: It indicates the adequacy of the 50% worth absolute liquid assets to
pay the 100% worth current liabilities in time. If the ratio is relatively lower than one, it
represents the company's day-to-day cash management in a poor light.
The formula used for the calculation of the Absolute Liquid Ratio is-
0.25
0.2
0.15
0.1
0.05
0
16-Mar 17-Mar 18-Mar 19-Mar 20-Mar
INTERPRETATION
The company absolute liquid ratio in 2016 was 0.26 but as we can see from the graph it goes on
decreasing and in 2020 it came to 0.009. So, if the ratio is relatively lower than one, it represents
the company's day-to-day cash management is going in a poor light.
Turnover ratios are used to determine how efficiently the financial assets and liabilities of an organization
have been used for the purpose of generating revenues.
The types of turnover ratios are: –
1. Fixed Assets Turnover Ratios: Fixed assets turnover ratio is used to determine the efficiency of an
organization in utilizing its fixed assets for the purpose of generating revenues.
The formula used for the determination of fixed assets turnover ratio is-
1.5
0.5
0
16-Mar 17-Mar 18-Mar 19-Mar 20-Mar
INTERPRETATION
The fixed assets turnover ratio in 2016 was 2.02 times and in 2020 it was 2.44. Which means
higher fixed asset. A higher fixed assets turnover ratio indicates that a company has efficiently
used investments in fixed assets to generate sales.
2. Inventory Turnover Ratio: Inventory turnover ratio is used to determine the speed of a
company in converting its inventories into sales.
The formula used for calculating inventory turnover ratio is-
Inventory Turnover Ratio = Cost of Goods Sold / Net Sales / Average Inventories
5.8
5.6
5.4
5.2
4.8
4.6
4.4
16-Mar 17-Mar 18-Mar 19-Mar 20-Mar
INTERPRETATION
The Dr. Reddy Labs Inventory turnover ratios deteriorated from 2016 to 2020, which means that its
ability to sell inventory has relatively come down. In 2016, Dr. Reddy Labs had a ratio of 6 and in 2020
has a ratio of 5.40. These ratios are not what we expected; we assumed that the ratios would be much
higher because Dr. Reddy Labs sell its syrup to bottling partners around the world so it does not need to
deal with the storing of the bottled product.
2.5
1.5
0.5
0
16-Mar 17-Mar 18-Mar 19-Mar 20-Mar
INTERPRETATION
Debtor’s velocity indicate the number of times the debtors are turned over during a year. The
ratio in 2016 was 2.62 times and in 2020 it was 2.55 times. Hence, low debtors turn over implies
inefficient management of debtors/sales and less liquid debtors.
160
140
120
100
80
60
40
20
0
16-Mar 17-Mar 18-Mar 19-Mar 20-Mar
INTERPRETATION
The ability of the firm of collecting the receivables in the specific time. Here in the year 2016 the
turnover in days was almost 139 days, but the collection day’s increase in the year 2020 by 142
days. This shows that the collection is slower as compared to the previous year.
5. Creditors or Payable Turnover Ratio Formula:-The accounts payable turnover ratio, also
known as the payables turnover or the creditor’s turnover ratio, is a liquidity ratio that measures
the average number of times a company pays its creditors over an accounting period. The ratio is
a measure of short-term liquidity, with a higher payable turnover ratio being more favorable.
Creditors or Payable Turnover Ratio Formula
The formula for the accounts payable turnover ratio is as follows:
Payable Turnover Ratio = Net Credit Purchases/ Average Account Payables
Net Credit Purchase= Credit Purchase – Purchase Return
Years Mar-20 Mar-19 Mar-18 Mar-17 Mar-16
0.8
0.6
0.4
0.2
0
16-Mar 17-Mar 18-Mar 19-Mar 20-Mar
INTERPRETATION
The creditors payable turnover ratio indicates to creditors the short-term liquidity and, to that
extent, the credit worthiness of the company. A high ratio indicates prompt payment is being
made to suppliers for purchases on credit.
500
400
300
200
100
0
16-Mar 17-Mar 18-Mar 19-Mar 20-Mar
INTERPRETATION
Dr. Reddy Lab’s average period for payment has reduce to 349 days in 2020 which was 430 days
in 2016. This reduction in average payment period shows that how efficiently company is paying
back their creditors and also assuring that payments are being made in a prompt manner by Dr.
Reddy Labs to its creditors. This period should remain low as much as possible.
1.5
0.5
0
16-Mar 17-Mar 18-Mar 19-Mar 20-Mar
INTERPRETATION
8. Total Asset Turnover Ratio - The total asset turnover ratio compares the sales of a
company to its asset base. The ratio measures the ability of an organization to efficiently
produce sales, and is typically used by third parties to evaluate the operations of a business.
Ideally, a company with a high total asset turnover ratio can operate with fewer assets than a
less efficient competitor, and so requires less debt and equity to operate. The result should
be a comparatively greater return to its shareholders .
Total assets turnover ratio – net sales / Average tangibles assets
2.5
1.5
0.5
0
16-Mar 17-Mar 18-Mar 19-Mar 20-Mar
INTERPRETATION
The ratio measures the efficiency of how well a company uses assets to produce sales. So, in
year 2016 it was 2.84 and in year 2020 it was 3.14. A higher ratio is favorable, as it indicates a
more efficient use of assets.
Solvency ratios
Solvency ratios can be defined as a type of ratio that is used to evaluate whether a company is
solvent and well capable of paying off its debt obligations or not.
The types of solvency ratios are: –
1. Debt Equity Ratio: The debt-equity ratio can be defined as a ratio between total debt and
shareholders fund. The debt-equity ratio is used to calculate the leverage of an organization. An
ideal debt-equity ratio for an organization is 2:1.
The formula for debt-equity ratio is-
Debt Equity Ratio = Total Debts / Shareholders Fund
Debt-Equity
Ratio
Years Mar-20 Mar-19 Mar-18 Mar-17 Mar-16
Long Term 19.3 345.4 488 485.2 994.4
Borrowings
Other Long Term 29.6 28.5 31.3 41.1 57.1
Liabilities
Total Long Term 48.9 373.9 519.3 526.3 1051.5
Liabilities
Total Shareholder's 15,191.90 12,684.10 11,807.80 11,600.60 11,605.40
Funds
0.09
0.08
0.07
0.06
0.05
0.04
0.03
0.02
0.01
0
16-Mar 17-Mar 18-Mar 19-Mar 20-Mar
INTERPRETATION
A low debt-to-equity ratio indicates a lower amount of financing by debt via lenders, versus
funding through equity via shareholders. As shown in 2020 the ratio was 0.003 which shows
lower debt-equity ratio compare to previous years.
2. Total Debt Ratio - The debt ratio is a financial ratio that measures the extent of a company's
leverage. The debt ratio is defined as the ratio of total debt to total assets, expressed as a decimal
or percentage. ... In other words, the company has more liabilities than assets.
Total debt ratio = total debt / total assets
Or
Long term debts+ current liability / total debts + net worth
0.35
0.3
0.25
0.2
Axis Title
0.15
0.1
0.05
0
16-Mar 17-Mar 18-Mar 19-Mar 20-Mar
INTERPRETATION
3. Equity Ratio - The equity ratio is a financial metric that measures the amount of leverage
used by a company. It uses investments in assets and the amount of equity to determine how well
a company manages its debts and funds its asset requirements.
Equity Ratio
0.78
0.76
0.74
0.72
Axis Title
0.7
0.68
0.66
0.64
0.62
0.6
16-Mar 17-Mar 18-Mar 19-Mar 20-Mar
INTERPRETATION
Equity ratios with higher value generally indicate that a company's effectively funded its asset
requirements with a minimal amount of debt. As we see an equity ratio is better than previous
four years i.e. 0.78 in Mar 20.
4. Solvency ratio: - Solvency ratios can be defined as a type of ratio that is used to evaluate
whether a company is solvent and well capable of paying off its debt obligations or not.
Solvency Ratio
Years Mar-20 Mar-19 Mar-18 Mar-17 Mar-16
Total Assets 19475.8 16247.5 17100.3 16447.2 17557.6
Long Term Borrowings 19.3 345 488 485 994
Other Long Term 29.6 28.5 31.3 41.1 57.1
Liabilities
Short Term Borrowings 1043.6 546.3 2100.8 1869.9 2089.6
Trade Payables 1068.4 1032 1061 779 729
Other Current Liabilities 1861 1316.7 1384.7 1401 1409.5
Total Capital And 4021.9 3268.5 5065.8 4576 5279.2
Liabilities
Solvency Ratio
0.3
0.25
0.2
Axis Title
0.15
0.1
0.05
0
16-Mar 17-Mar 18-Mar 19-Mar 20-Mar
INTERPRETATION
A solvency ratio measures the size of a company's profitability and compares it to its obligations.
By interpreting a solvency ratio, an analyst or investor can gain insight into how likely a
company will be to continue meeting its debt obligations. A stronger or higher ratio indicates
financial strength. As shown in the table the company’s solvency ratio is fluctuating between the
years and decrease in 2020 i.e. 0.2.
5. Interest Coverage Ratio: The interest coverage ratio is used to determine the solvency of an
organization in the nearing time as well as how many times the profits earned by that very
organization were capable of absorbing its interest-related expenses.
The formula used for the calculation of interest coverage ratio is-
Interest Coverage Ratio = Earnings before Interest and Taxes / Interest Expense
Interest 47 56 62 57 63
Interest
Coverage Ratio
26.17 28.08 12.24 31.37 60.06
Interest Coverage Ratio
70
60
50
40
Axis Title
30
20
10
0
16-Mar 17-Mar 18-Mar 19-Mar 20-Mar
INTERPRETATION
6. Current Debt to Inventory Ratio: - A company cannot be solvent if it is not paying its
current liabilities. This ratio compares the company’s current liabilities with its inventory levels.
It is a way to tell that, how much of current inventory it must sell to pay-off all its current
liabilities. In terms of formula, it looks like this:
2.5
2
Axis Title
1.5
0.5
0
16-Mar 17-Mar 18-Mar 19-Mar 20-Mar
INTERPRETATION
It is a way to tell that, how much of current inventory it must sell to pay-off all its current
liabilities. Higher the current debt to inventory ratio better for the company to pay off its debts
more frequently. As shown in the table of Dr.Reddy Labs the ratio has been decreased compare
to previous years i.e. 1.9.
7. Current Debt to Net worth Ratio: - There are few companies which do not have to maintain
a lot of inventory. This is a characteristic of their business model. For such companies, the above
ratio may give unnecessarily high values. They may not be a correct indicator of solvency.
For such companies, use of current debt to net worth ratio is better. In terms of formula, this
ratio looks like below:
Current Debt to Net worth Ratio = Current Liability / net worth
Current Debt To Net worth
0.45
0.4
0.35
0.3
Axis Title
0.25
0.2
0.15
0.1
0.05
0
16-Mar 17-Mar 18-Mar 19-Mar 20-Mar
INTERPRETATION
The debt to net worth ratio is used to gauge how much of a company's assets are financed by
debt. The higher the ratio, the higher the percentage financing by debt. A ratio above 100% is
not good as it means that the company cannot use its assets to pay off its debt. As shown in the
table of Dr.Reddy Labs the ratio has been decreased compare to previous years i.e. 0.27 in
mar20.
PROFITABILITY RATIOS
This type of ratio helps in measuring the ability of a company in earning sufficient profits.
1. Gross Profit Ratios: Gross profit ratios are calculated in order to represent the operating
profits of an organization after making necessary adjustments pertaining to the COGS or cost of
goods sold.
The formula used for the calculation of gross profit ratio is-
74.00%
73.00%
72.00%
71.00%
Axis Title
70.00%
69.00%
68.00%
67.00%
16-Mar 17-Mar 18-Mar 19-Mar 20-Mar
INTERPRETATION
The ratio should be high according to the definition. Because higher the ratio, higher will be the
firm’s ability to produce goods and services at low cost with high sales. Here in this table there is
difference between the ratios in five years, but its low, which means it is unfavorable. As shown
in the table of Dr.Reddy Labs the ratio has been decreased compare to previous years i.e. 69.72
in Mar-20.
The formula used for the calculation of operating profit ratio is-
Operating Profit Ratio = (Earnings before Interest and Taxes / Net Sales) * 100
Operating Profit
25.00%
20.00%
15.00%
Axis Title
10.00%
5.00%
0.00%
16-Mar 17-Mar 18-Mar 19-Mar 20-Mar
INTERPRETATION
The operating profit margin ratio indicates how much profit a company makes after paying for
variable costs of production such as wages, raw materials, etc. Higher operating margins are
generally better than lower operating margins. Here in this table there is difference between the
ratios in five years, but it’s still high, which means it is favorable as shown in the table of
Dr.Reddy Labs the ratio has been increased compare to previous years i.e. 23.51%
3. Net Profit Ratio: Net profit ratios are calculated in order to determine the overall profitability
of an organization after reducing both cash and non-cash expenditures.
The formula used for the calculation of net profit ratio is-
Net Profit Ratio = (Net Profit or profit after tax / Net Sales) * 100
25
20
15
Axis Title
10
0
16-Mar 17-Mar 18-Mar 19-Mar 20-Mar
INTERPRETATION
The net profit percentage is the ratio of after-tax profits to net sales. It reveals the
remaining profit after all costs of production, administration, and financing have been deducted
from sales, and income taxes recognized. A low net profit margin means that a company uses an
ineffective cost structure and/or poor pricing strategies. Here in this table there is difference
between the ratios in five years, but its high, which means it is favorable.
=>EXPENSE RATIO
Expense ratio is the annual maintenance charge levied by mutual funds to finance its
expenses. It includes annual operating costs, including management fees, allocation charges,
advertising costs, etc. of the fund.
Types of expense ratio:-
1. COGS ratio: - The ratio indicates the percentage of each dollar of revenue that the company
retains as gross profit.
Cost of Goods Sold (COGS) = COGS / net sales * 100
31.00%
30.00%
29.00%
28.00%
Axis Title
27.00%
26.00%
25.00%
24.00%
16-Mar 17-Mar 18-Mar 19-Mar 20-Mar
INTERPRETATION
2. Operating Ratio:-
Operating profit is that money which remains in the hand of the company after considering all
operating expenses.
It is different from gross profit because some additional expenses are considered here. Expenses
like depreciation, selling & administrative expense, and other expense are considered to compute
operating profit.
operating Ratio
18.00%
16.00%
14.00%
12.00%
Axis Title
10.00%
8.00%
6.00%
4.00%
2.00%
0.00%
16-Mar 17-Mar 18-Mar 19-Mar 20-Mar
INTERPRETATION
The operating ratio is used to measure the operational efficiency of the management. It shows
whether or not the cost component in the sales figure is within the normal range. A low operating
ratio means a high net profit ratio (i.e., more operating profit) and vice versa. Here in this table
there is difference between the ratios in five years, but its high, which means it is favorable.
1. Return on Asset (ROA):-setting up an asset base of the company which in turn will
produce and render goods and services for the customers. These goods and services in turn will
yield sales and net profit.
0.16%
0.14%
0.12%
0.10%
Axis Title
0.08%
0.06%
0.04%
0.02%
0.00%
16-Mar 17-Mar 18-Mar 19-Mar 20-Mar
INTERPRETATION
Equity is a portion of total asset. Another way to look at total asset of a company is through this
formula (Total Asset = Equity + Debt). It depicts the total capital that the company has put to use
(as on date) to do its business.
Out of this total capital, a portion is equity (shareholders money) and balance is borrowing. In
ROA calculation we are considering the total capital put to use to derive company’s profitability.
But in ROE, we consider only the equity portion. Why? Because this metric (ROE) will highlight
how profitably the company is using shareholders money to yield net profits.
High ROE or improving ROE is a symbolic of higher shareholders returns. Formula for ROE is
shown below:
0.20%
0.18%
0.16%
0.14%
0.12%
Axis Title
0.10%
0.08%
0.06%
0.04%
0.02%
0.00%
16-Mar 17-Mar 18-Mar 19-Mar 20-Mar
INTERPRETATION
ROE is more than a measure of profit: It's also a measure of efficiency. A rising ROE suggests
that a company is increasing its profit generation without needing as much capital. It also
indicates how well a company's management deploys shareholder capital. Here in this table there
is difference between the ratios in five years, but its high, which means it is favorable.
Capital
Employed
0.18
0.16
0.14
0.12
Axis Title
0.1
0.08
0.06
0.04
0.02
0
16-Mar 17-Mar 18-Mar 19-Mar 20-Mar
INTERPRETATION
The return on capital employed shows how much operating income is generated for each dollar
of capital invested. A higher ROCE is always more favorable, as it indicates that more profits are
generated per dollar of capital employed. Here in this table there is difference between the ratios
in five years, but its high, which means it is favorable.
Conclusion
Ratio analysis is a basic tool of financial analysis and financial analysis itself is an
important part of any business planning process financial analysis determines a
company’s health and stability, providing an understanding of how the company
conducts its business. A financial statement analysis is only one of the tools
(although a major one) while taking an investment decision.
The study is made on the topic financial performance using accounting ratios with
five years in Dr. Reddy Labs. The current and liquid ratio indicates the short term
financial position of Dr. Reddy Labs whereas solvency ratio indicates the long
term financial position. Similarly, activity ratio and profitability ratio are helpful in
evaluating the efficiency of performance in Dr. Reddy Labs. After applying all the
ratios we got an idea that the Dr. Reddy Labs is a profitable firm. Because
throughout the analysis of five years, we found that the company is getting
profitable return on short term and long term investment, their profit margin has
been increased as well and they are in the position to pay their debts with in their
resources.
REFERENCES
https://getmoneyrich.com/financial-ratio-analysis/
https://www.drreddys.com/
https://theinterviewportal.com/2017/05/11/internship-at-dr-reddys-labs/
https://www.moneycontrol.com/india/stockpricequote/
pharmaceuticals/drreddyslaboratories/DRL