In: Finance
14. PLEASE SHOW EXCEL WORK THANKS!
Based on the following financial data, calculate the ratios requested. (Round your answers to 4 decimal places.) |
Liabilities | $ | 7,800 | Net worth | $ | 58,000 |
Liquid assets | $ | 4,600 | Current liabilities | $ | 1,300 |
Monthly credit payments | $ | 640 | Take-home pay | $ | 2,575 |
Monthly savings | $ | 130 | Gross income | $ | 2,850 |
a. | Debt ratio | |
b. | Current ratio | |
c. | Debt-payments ratio | |
d. | Savings ratio | |