| Financial Statement Information and Ratio Calculations |
| Company Name | | | | Instructions: If you do not understand these instructions ask me. |
| | | | | Failure to complete this spreadsheet in its entireity as required will |
| | Current | Prior | | cause you to lose significant points on this assignment. |
| Financial Statement Information | Year | Year |
| Current assets | $ - 0 | $ - 0 | | For every numerator and denominator amount in the ratios, |
| Current liabilities | $ - 0 | $ - 0 | | you need to provide the financial statement number |
| Accounts receivable | $ - 0 | $ - 0 | | for the current and prior year. |
| Financial Statement line item | $ - 0 | $ - 0 | | Current assets, current liabilities, and accounts receivable are just three of the financial |
| Financial Statement line item | $ - 0 | $ - 0 | | statement amounts you will need. Other items would be total assets, total liabilities, |
| Financial Statement line item | $ - 0 | $ - 0 | | cash flow from operating activities, common stock holder equity and several others. |
| Financial Statement line item | $ - 0 | $ - 0 |
| Financial Statement line item | $ - 0 | $ - 0 |
| Financial Statement line item | $ - 0 | $ - 0 |
| Financial Statement line item | $ - 0 | $ - 0 |
| Financial Statement line item | $ - 0 | $ - 0 |
| Financial Statement line item | $ - 0 | $ - 0 |
| Financial Statement line item | $ - 0 | $ - 0 |
| Financial Statement line item | $ - 0 | $ - 0 |
| Financial Statement line item | $ - 0 | $ - 0 |
| Financial Statement line item | $ - 0 | $ - 0 |
| | Current |
| | Year |
| Current ratio | ERROR:#DIV/0! | | | I have put the first formula in cell B26 for you. Use formulas for the other ratios. |
| Current cash debt coverage ratio | | | | Only calculate the ratios for the most current year. |
| Inventory Turnover Ratio | | | | The cells for each ratio must contain a formula using the |
| Receivables Turnover ratio | | | | amounts obtained from the financial statements above. |
| Debt to Total Assets ratio | | | | Do not hard code the answers into the cells as I cannot see |
| Times Interest Earned Ratio | | | | how you calculated the ratios. |
| Return on Common stockholders' equity ratio |
| Return on Assets ratio |
| Profit Margin Ratio |
| Price Earnings Ratio | | | | The current common stock market price is not in |
| | | | | the financial statements. Obtain the price from |
| | | | | Google Finance. I have posted instructions for |
| | | | | accessing Google finance in the week 3 articles thread. |
dhoskins69
IndividualRatioSheetweek3.xlsx
