1 Formula: Subtract, Divide, Cell Referencing 234 2 3 Using Excel to Liquidity and Solvency Ratios PROBLEM 4 5 Ross Music Inc. reported the following selected information 6 at March 31. 7 8 Total current assets 9 Total assets 10 Total current liabilities 11 Total liabilities 12 Net cash provided by operating activities Dividends paid Cost of capital expenditures 23456 13 14 15 16 $262,787 439,832 293,625 376,002 62,300 12,000 24,787 Student Work Area Required: Provide input into cells shaded in yellow in this template. Use only cell references and mathematical formulas in the input cells. Calculate the following for March: Current ratio Debt to assets ratio :1

1 Formula: Subtract, Divide, Cell Referencing Using Excel to Liquidity and Solvency Ratios PROBLEM Ross Music Inc. reported the following selected information at March 31. Total current assets Total assets Total eurrent liabilities Total liabilities Net cash provided by operating activities Dividends paid Cost of capital expenditures $262,787 439,832 293,625 376,002 62,300 12,000 24,787 Student Work Area Required: Provide input into cells shaded in yellow in this template, Use only cell references and mathematical formulas in the input cells. Calculate the following for March: Current ratio Debt to assets ratio