Stock 1: Infosys Limited
Stock 2: HDFC Bank Limited
Return on capital employed (ROI) = (Net profit before interest, tax / Capital employed) x 100
Earning per share = net profit available for equity shareholders / Number of equity shares
Dividends per share = Dividend amount / Number of equity shares
Capital employed turnover ratio = Cost of sales / Capital employed
Fixed assets turnover ratio = Cost of sales or sales / Fixed assets
Working capital turnover ratio = Cost of sales or Net sales / Net working capital
Inventory turnover ratio = Cost of goods sold / Average inventory
Debtors (receivables) turnover ratio = Annual net credit sales / Average accounts receivable
Debtors (receivables) collection period = Accounts receivables / Net credit sales per day
Creditors turnover ratio = Net credit purchases / Average creditors
Average credit period = Average account payables / Net credit purchases per day
Current ratio = Current assets / Current liabilities
Quick ratio/Acid test ratio = Quick assets / Current liabilities
Debt Equity Ratio = Total long term debts / shareholder' funds
You'll find all the required data on the internet.
Just put them in the formula and you're done.
KEY FINANCIAL RATIOS OF INFOSYS (in Rs. Cr.) | MAR '19 | MAR '18 | MAR '17 | MAR '16 | MAR '15 | |
INVESTMENT VALUATION RATIOS | ||||||
Face Value | 5.00 | 5.00 | 5.00 | 5.00 | 5.00 | |
Dividend Per Share | 21.50 | 43.50 | 25.75 | 24.25 | 59.50 | |
Operating Profit Per Share (Rs) | 42.87 | 79.19 | 74.91 | 68.39 | 121.57 | |
Net Operating Profit Per Share (Rs) | 167.82 | 283.60 | 258.12 | 235.02 | 411.85 | |
Free Reserves Per Share (Rs) | -- | -- | -- | -- | -- | |
Bonus in Equity Capital | 99.44 | 98.33 | 98.33 | 98.33 | 96.63 | |
PROFITABILITY RATIOS | ||||||
Operating Profit Margin(%) | 25.54 | 27.92 | 29.02 | 29.09 | -- | |
Profit Before Interest And Tax Margin(%) | 22.47 | 24.08 | 25.46 | 25.60 | -- | |
Gross Profit Margin(%) | 23.35 | 25.65 | 26.77 | 27.03 | -- | |
Cash Profit Margin(%) | 21.46 | 26.62 | 24.29 | 24.22 | -- | |
Adjusted Cash Margin(%) | 21.46 | 26.62 | 24.29 | 24.22 | 25.01 | |
Net Profit Margin(%) | 20.11 | 26.08 | 23.30 | 23.51 | 25.71 | |
Adjusted Net Profit Margin(%) | 19.35 | 24.49 | 22.16 | 22.27 | -- | |
Return On Capital Employed(%) | 31.77 | 31.35 | 27.84 | 28.81 | -- | |
Return On Net Worth(%) | 23.44 | 25.44 | 20.31 | 20.78 | -- | |
Adjusted Return on Net Worth(%) | 23.44 | 25.44 | 20.31 | 20.78 | 24.44 | |
Return on Assets Excluding Revaluations | 143.96 | 290.74 | 296.12 | 265.93 | 418.54 | |
Return on Assets Including Revaluations | 143.96 | 290.74 | 296.12 | 265.93 | 418.54 | |
Return on Long Term Funds(%) | 31.77 | 31.35 | 27.84 | 28.81 | 34.08 | |
LIQUIDITY AND SOLVENCY RATIOS | ||||||
Current Ratio | 3.03 | 3.83 | 3.80 | 4.50 | 3.41 | |
Quick Ratio | 2.96 | 3.74 | 3.77 | 4.47 | 3.38 | |
Debt Equity Ratio | -- | -- | -- | -- | -- | |
Long Term Debt Equity Ratio | -- | -- | -- | -- | -- | |
DEBT COVERAGE RATIOS | ||||||
Interest Cover | -- | -- | -- | -- | -- | |
Total Debt to Owners Fund | -- | -- | -- | -- | -- | |
Financial Charges Coverage Ratio | -- | -- | -- | -- | -- | |
Financial Charges Coverage Ratio Post Tax | -- | -- | -- | -- | -- | |
MANAGEMENT EFFICIENCY RATIOS | ||||||
Inventory Turnover Ratio | -- | -- | -- | -- | -- | |
Debtors Turnover Ratio | 5.73 | 5.36 | 5.71 | 5.86 | 5.93 | |
Investments Turnover Ratio | -- | -- | -- | -- | -- | |
Fixed Assets Turnover Ratio | 3.57 | 3.45 | 3.66 | 3.67 | -- | |
Total Assets Turnover Ratio | 1.17 | 0.98 | 0.87 | 0.88 | -- | |
Asset Turnover Ratio | 1.16 | 0.94 | 0.92 | 0.99 | 1.05 | |
Average Raw Material Holding | -- | -- | -- | -- | -- | |
Average Finished Goods Held | -- | -- | -- | -- | -- | |
Number of Days In Working Capital | 71.39 | 102.89 | 114.25 | 187.17 | 233.13 | |
PROFIT & LOSS ACCOUNT RATIOS | ||||||
Material Cost Composition | -- | -- | -- | -- | 0.08 | |
Imported Composition of Raw Materials Consumed | -- | -- | -- | -- | -- | |
Selling Distribution Cost Composition | -- | -- | -- | -- | -- | |
Expenses as Composition of Total Sales | 98.10 | 97.39 | 97.37 | 97.93 | 97.58 | |
CASH FLOW INDICATOR RATIOS | ||||||
Dividend Payout Ratio Net Profit | 93.64 | 46.42 | 50.51 | 43.88 | 42.01 | |
Dividend Payout Ratio Cash Profit | 84.46 | 42.70 | 46.07 | 40.33 | 39.08 | |
Earning Retention Ratio | 6.36 | 53.58 | 49.49 | 56.12 | 56.51 | |
Cash Earning Retention Ratio | 15.54 | 57.30 | 53.93 | 59.67 | 59.65 | |
AdjustedCash Flow Times | -- | -- | -- | -- | -- |
KEY FINANCIAL RATIOS OF HDFC BANK (in Rs. Cr.) | MAR '19 | MAR '18 | MAR '17 | MAR '16 | MAR '15 | |
INVESTMENT VALUATION RATIOS | ||||||
Face Value | 2.00 | 2.00 | 2.00 | 2.00 | 2.00 | |
Dividend Per Share | 15.00 | 13.00 | 11.00 | 9.50 | 8.00 | |
Operating Profit Per Share (Rs) | 57.70 | 69.06 | 55.44 | 33.98 | 35.93 | |
Net Operating Profit Per Share (Rs) | 363.43 | 309.20 | 270.46 | 238.20 | 193.38 | |
Free Reserves Per Share (Rs) | -- | -- | -- | -- | -- | |
Bonus in Equity Capital | -- | -- | -- | -- | -- | |
PROFITABILITY RATIOS | ||||||
Interest Spread | 7.20 | 7.78 | 7.46 | 7.52 | 8.01 | |
Adjusted Cash Margin(%) | 19.05 | 19.26 | 18.85 | 18.31 | 18.91 | |
Net Profit Margin | 21.29 | 21.79 | 20.99 | 20.41 | 21.07 | |
Return on Long Term Fund(%) | 55.57 | 62.88 | 65.17 | 70.54 | 66.77 | |
Return on Net Worth(%) | 14.12 | 16.45 | 16.26 | 16.91 | 16.47 | |
Adjusted Return on Net Worth(%) | 14.12 | 16.45 | 16.26 | 16.91 | 16.47 | |
Return on Assets Excluding Revaluations | 547.89 | 409.60 | 349.12 | 287.47 | 247.39 | |
Return on Assets Including Revaluations | 547.89 | 409.60 | 349.12 | 287.47 | 247.39 | |
MANAGEMENT EFFICIENCY RATIOS | ||||||
Interest Income / Total Funds | 8.57 | 8.32 | 8.81 | 9.27 | 8.96 | |
Net Interest Income / Total Funds | 4.18 | 4.16 | 4.21 | 4.25 | 4.14 | |
Non Interest Income / Total Funds | 1.53 | 1.58 | 1.56 | 1.65 | 1.66 | |
Interest Expended / Total Funds | 4.40 | 4.17 | 4.60 | 5.02 | 4.82 | |
Operating Expense / Total Funds | 2.82 | 2.30 | 2.41 | 2.92 | 2.47 | |
Profit Before Provisions / Total Funds | 2.79 | 3.34 | 3.26 | 2.87 | 3.21 | |
Net Profit / Total Funds | 1.17 | 1.77 | 1.84 | 1.47 | 1.88 | |
Loans Turnover | 0.13 | 0.13 | 0.14 | 0.15 | 0.15 | |
Total Income / Capital Employed(%) | 10.10 | 9.90 | 10.38 | 10.92 | 10.62 | |
Interest Expended / Capital Employed(%) | 4.40 | 4.17 | 4.60 | 5.02 | 4.82 | |
Total Assets Turnover Ratios | 0.09 | 0.08 | 0.09 | 0.09 | 0.09 | |
Asset Turnover Ratio | 0.09 | 0.09 | 0.09 | 0.10 | 0.10 | |
PROFIT AND LOSS ACCOUNT RATIOS | ||||||
Interest Expended / Interest Earned | 51.26 | 50.03 | 52.18 | 54.18 | 53.79 | |
Other Income / Total Income | 15.12 | 15.94 | 15.07 | 15.15 | 15.66 | |
Operating Expense / Total Income | 27.90 | 23.23 | 23.20 | 26.77 | 23.30 | |
Selling Distribution Cost Composition | 0.15 | 0.20 | 0.21 | 0.41 | -- | |
BALANCE SHEET RATIOS | ||||||
Capital Adequacy Ratio | 17.11 | 14.82 | 14.55 | 15.53 | 16.79 | |
Advances / Loans Funds(%) | 83.95 | 80.80 | 84.21 | 84.82 | 80.97 | |
DEBT COVERAGE RATIOS | ||||||
Credit Deposit Ratio | 86.32 | 84.68 | 85.64 | 83.24 | 81.71 | |
Investment Deposit Ratio | 31.12 | 31.88 | 31.79 | 33.13 | 35.13 | |
Cash Deposit Ratio | 8.85 | 9.95 | 5.71 | 5.77 | 6.46 | |
Total Debt to Owners Fund | 6.97 | 8.58 | 8.02 | 8.25 | 8.00 | |
Financial Charges Coverage Ratio | 1.81 | 1.84 | 1.73 | 1.68 | 1.69 | |
Financial Charges Coverage Ratio Post Tax | 1.44 | 1.46 | 1.43 | 1.40 | 1.42 | |
LEVERAGE RATIOS | ||||||
Current Ratio | 0.05 | 0.04 | 0.06 | 0.07 | 0.04 | |
Quick Ratio | 16.61 | 17.48 | 11.19 | 14.51 | 12.69 | |
CASH FLOW INDICATOR RATIOS | ||||||
Dividend Payout Ratio Net Profit | 19.22 | -- | -- | 19.53 | 19.62 | |
Dividend Payout Ratio Cash Profit | 18.23 | -- | -- | 18.47 | 18.44 | |
Earning Retention Ratio | 80.78 | 100.00 | 100.00 | 80.47 | 80.38 | |
Cash Earning Retention Ratio | 81.77 | 100.00 | 100.00 | 81.53 | 81.56 | |
AdjustedCash Flow Times | 41.55 | 42.88 | 41.84 | 42.03 | 41.46 |
115 CM ng stocks: Pfizer (pfe), Disney (dis), Cisco (esco), Sysco (syy), or Qualcomm (qcom). For...
need help with the first part of the question, not the article part. below are Ebuy's ratios below are Amazing company's ratios You have just received a large annual bonus at work, and have decided to invest it in stocks for your retirement. You have been analyzing different stocks and have narrowed your choice to two possibilities. You can either invest in Amazing Company, or in EBUY. EBUY's ratios are given below. Select 3 ratios you might use to determine...
1.4 Consider the following financial information for a company (in millions of dollars) Partial income statement (latest year ending December 31, 2017): Sales $900 Cost of goods sold ($350) Other expenses ($200) Depreciation ($120) Interest expenses ($30) Partial balance sheet (as of December 31) 2016 2017 Cash $30 $20 Receivables $200 $250 Inventories $220 $210 Net fixed assets $500 $520 Accounts payable $100 $120 Accruals $80 $100 Short-term debt $50 $10 Long-term debt $270 $270 a) Assuming an income...
1.4 Consider the following financial information for a company (in millions of dollars) Partial income statement (latest year ending December 31, 2017): Sales $900 Cost of goods sold ($350) Other expenses ($200) Depreciation ($120) Interest expenses ($30) Partial balance sheet (as of December 31) 2016 2017 Cash $30 $20 Receivables $200 $250 Inventories $220 $210 Net fixed assets $500 $520 Accounts payable $100 $120 Accruals $80 $100 Short-term debt $50 $10 Long-term debt $270 $270 Net income after taxes...
Assume you are given the following abbreviated financial statements: (attached) On the basis of this information, calculate as many liquidity, activity, leverage, profitability, and common stock measures as you can.(Note: Assume the current market price of the common stock is $62.65 per share. * huge thumbs up for correct answers* Liquidity measures: The current ratio is ? (Round to two decimal places.) The firm's net working capital is (blank million) ? (Round to the nearest million dollars.) Activity measures: The...
Ratios are mostly calculated using data drawn from the financial statements of a firm. However, another group of ratios, called market-based ratios, relate to a firm’s observable market value, stock prices, and book values, integrating information from both the market and the firm’s financial statements. Consider the case of Green Caterpillar Garden Supplies Inc.: Green Caterpillar Garden Supplies Inc. just reported earnings after tax (also called net income) of $95,000,000, and a current stock price of $28.50 per share. The...
Assume you are given the following abbreviated financial statements: Current assets $199 Fixed and other assets $368 Total assets $ 567 Current liabilities $128 Long-term debt $106 Stockholders' equity $333 Total liabilities and equity $ 567 Common shares outstanding 19 million shares Total revenues $882 Total operating costs and expenses $771 Interest expense $16 Income taxes $33 Net profits $ 62 Dividends paid to common stockholders $19 On the basis of this information, calculate as many liquidity, activity,...
Calculate the internal and sustainable growth rates Integrated mihi-case Working with Financial Juma Listed are the 2021 financial statements for Garners' Platoon Mental Health Care, Inc. Spread the balance sheet and income statement. Calculate the financial ratios for the firm, including the internal and sustainable growth rates. Using the DuPont system of analysis and the industry ratios reported, evaluate the performance of the firm. GARNERS' PLATOON MENTAL HEALTH CARE, INC. Balance Sheet as of December 31, 2021 (in millions of...
Listed are the 2018 financial statements for Garner's Platoon Mental Health Care, Inc. Spread the balance sheet and income statement. Calculate the financial ratios for the firm, including the internal and sustainable growth rates. Using the DuPont system of analysis and the industry ratios reported, evaluate the performance of the firm. GARNERS' PLATOoON MENTAL HEALTH CARE, INC. Balance Sheet as of December 31, 2018 (In millions of dollars) Assets Llabilities and Equity Current assets Current liabilities $ 421 $ 316...
The current year financial statements for Blue Water Company and Prime Fish Company are presented below. Blue Water Prime Fish Balance sheet: Cash Accounts receivable (net) Inventory Property & equipment (net) Other assets Total assets 21,000 31,000 40,000 401,000 305,000 $ 798,000 49,000 60,000 512,000 106,000 71,000 $ 798,000 $ 41,000 38,000 99,000 140,000 84,000 $ 402,000 99,000 65,000 148,000 29,000 61,000 $ 402,000 $ Current liabilities $ Long-term debt (interest rate: 10%) Capital stock ($10 par value) Additional paid-in...
Financial statements for Zachary Company follow. ZACHARY COMPANY Balance Sheets As of December 31 Year 4 Year 3 Assets Current assets Cash 25,500 $21,500 Marketable securities 21,900 7,900 Accounts receivable (net) Inventories 60,000 52,000 145,000 29,000 153,000 14,000 Prepaid items Total current assets 281,400 22,000 248,400 15,000 Investments Plant (net) 260,000 245,000 Land 29,000 24,000 $592,400 $532,400 Total assets Liabilities and Stockholders' Equity Liabilities Current liabilities $ 39,200 $ 10,800 Notes payable Accounts payable Salaries payable 73,800 60,000 22,000 16,000...