A1 for Formula: Subtract, Divide, Cell Referencing B E F G . K M N 0 F D 1 Formula: Subtract, Divide, Cell Referencing 2 3 Using Excel to Calculate Ratios PROBLEM 5 Ross Music Inc. reported the following selected information at 6 March 31. 4 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. 7 8 Calculate the following for March: 9 10 Current ratio : 1 11 Total current assets Total assets Total current 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 12 13 Debt to assets ratio 14 15 16 Free cash flow 17 18