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
- Current Ratio= Current Assets/Current Liabilities
- Quick or Acid Test Ratio= (Cash+Short-term Investment+Net Receivables)/Current Liabilities
- Current Cash Debt. Coverage= Net Cash Provided by Operating Activities/Average Current Liabilities
- Accounts Receivable Turnover= Net Sales/Average accounts Receivables (Net)
- Inventory Turnover= Cost of Goods Sold/Average Inventory
- Asset Turnover= Net Sales/Average Total Assets
- Profit Margin on Sale= Net Income/Net Sales
- Return on Assets= Net Income/Average Total Assets
- Return on Common Stock Equity= (Net Income-Preferred Dividends)/Average Common Stockholders' Equity
- Earnings Per Share= (Net Income-Preferred Dividends)/Weighted -average Number of Shares Outstanding
- Price-Earnings Ratio= Market Price of Stock/Earnings Per Share
- Payout Ratio= Cash Dividends/Net Income
- Debt. To Assets= Total Liabilities/Total Assets
- Times Interest Earned=(Income before Income Taxes+Interest Expense)/Interest Expense
- Cash Debt. Coverage= Net Cash Provided by Operating Activities/Average Total Liabilities
- Book Value Per Share= Common Stockholders' Equity/Outstanding Shares
- 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
Get step-by-step solutions from verified subject matter experts
