Question

115 CM ng stocks: Pfizer (pfe), Disney (dis), Cisco (esco), Sysco (syy), or Qualcomm (qcom). For Por compute ratios below. Yo
0 0
Add a comment Improve this question Transcribed image text
Answer #1

Stock 1: Infosys Limited

Stock 2: HDFC Bank Limited

  1. Gross profit ratio = (Gross profit / Net sales) x 100
  2. Net profit ratio = (Net profit / Net sales) x l00
  3. Operating profit ratio = (Operating profit / Net sales) x 100
  4. Expense ratios = (Individual expenses / Net sates) x 100
  5. Operating (cost) ratio = (Operating cost / Net sales) x 100
  6. Net profit to net worth ratio = (Net profit after interest and tax / Net worth) x 100
  7. Return on capital employed (ROI) = (Net profit before interest, tax / Capital employed) x 100

  8. Earning per share = net profit available for equity shareholders / Number of equity shares

  9. Dividends per share = Dividend amount / Number of equity shares

  10. Capital employed turnover ratio = Cost of sales / Capital employed

  11. Fixed assets turnover ratio = Cost of sales or sales / Fixed assets

  12. Working capital turnover ratio = Cost of sales or Net sales / Net working capital

  13. Inventory turnover ratio = Cost of goods sold / Average inventory

  14. Debtors (receivables) turnover ratio = Annual net credit sales / Average accounts receivable

  15. Debtors (receivables) collection period = Accounts receivables / Net credit sales per day

  16. Creditors turnover ratio = Net credit purchases / Average creditors

  17. Average credit period = Average account payables / Net credit purchases per day

  18. Current ratio = Current assets / Current liabilities

  19. Quick ratio/Acid test ratio = Quick assets / Current liabilities

  20. Debt Equity Ratio = Total long term debts / shareholder' funds

  21. Debt to net worth = Total long term debt / Shareholder's funds
  22. External-internal equity = External equity / Internal equity
  23. Debt vs. funds = total long term debts / Total long term funds
  24. Debt service ratio = Earnings before interest and taxes / Fixed interest charges
  25. Fixed assets ratio =Net fixed assets / Long-term funds
  26. Solvency (debt to total funds) ratio = Total liabilities / Total assets
  27. Reserves to capital ratio = Reserves / Capital
  28. Capital gearing ratio =Equity / Fixed interest hearing securities
  29. Proprietary ratio = Proprietor's funds / Total assets

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
Add a comment
Know the answer?
Add Answer to:
115 CM ng stocks: Pfizer (pfe), Disney (dis), Cisco (esco), Sysco (syy), or Qualcomm (qcom). For...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • need help with the first part of the question, not the article part. below are Ebuy's...

    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...

    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...

    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,...

    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...

    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...

    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...

    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...

    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....

    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 Asse...

    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...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT