Question: please calculate below ratios for 3 years separately in excel sheet from the link given Current Ratio= Current Assets/Current Liabilities Quick or Acid Test Ratio=

please calculate below ratios for 3 years separately in excel sheet from the link given

  1. Current Ratio= Current Assets/Current Liabilities
  2. Quick or Acid Test Ratio= (Cash+Short-term Investment+Net Receivables)/Current Liabilities
  3. Current Cash Debt. Coverage= Net Cash Provided by Operating Activities/Average Current Liabilities
  4. Accounts Receivable Turnover= Net Sales/Average accounts Receivables (Net)
  5. Inventory Turnover= Cost of Goods Sold/Average Inventory
  6. Asset Turnover= Net Sales/Average Total Assets
  7. Profit Margin on Sale= Net Income/Net Sales
  8. Return on Assets= Net Income/Average Total Assets
  9. Return on Common Stock Equity= (Net Income-Preferred Dividends)/Average Common Stockholders' Equity
  10. Earnings Per Share= (Net Income-Preferred Dividends)/Weighted -average Number of Shares Outstanding
  11. Price-Earnings Ratio= Market Price of Stock/Earnings Per Share
  12. Payout Ratio= Cash Dividends/Net Income
  13. Debt. To Assets= Total Liabilities/Total Assets
  14. Times Interest Earned=(Income before Income Taxes+Interest Expense)/Interest Expense
  15. Cash Debt. Coverage= Net Cash Provided by Operating Activities/Average Total Liabilities
  16. Book Value Per Share= Common Stockholders' Equity/Outstanding Shares
  17. Free Cash Flow= Net Cash Provided by Operating Activities-Capital Expenditures-Dividends

https://drive.google.com/drive/folders/1Uvnb5cmRMXObupLC4V9o-qJWymmfaotZ?usp=sharing

thank you

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!