In: Finance
Below are numbers from a balance sheet and income statement. Based on these numbers calculate the financial ratios requested below.
All answers must be rounded to TWO decimal places including percentages
Sales |
421756 |
Operating Costs |
313053 |
Depreciation Expense |
10000 |
Interest Expense |
5000 |
Tax Expense |
29408 |
Cash |
1000 |
Receivables |
30000 |
Inventories |
52175 |
Fixed Assets, Net |
50000 |
Payables |
11000 |
Accrued Expenses |
10000 |
Long-Term Loan |
50000 |
Common Equity |
62175 |
Based on these values calculate:
Current ratio
Quick ratio
NWC-to-total-Assets (Working capital to assets)
Ratio of total debt and liabilities to total assets
Ratio of total debt and liabilities to shareholder’s equity
Interest coverage
Net profit margin
Sales to total assets (Asset turnover)
Return on assets
Equity multiplier
Return on equity
Please refer to below spreadsheet for calculation and answer. Cell reference also provided.
Cell reference -
Hope this will help, please do comment if you need any further explanation. Your feedback would be appreciated.