Recreate the financial statements as shown using formulas with the ratios given below to fill in the cells with the word "Ratio." Use the ROUND function to round each of these answers to the nearest $10 a. Ratio Current Ratio Inventory Turnover A/R Turnover Fixed Asset Turnover LTD To Equity Times Interest Earned Net Profit Margin Return on Total Assets Return on Equity Value 0.898550 2.109890 10.000000 1.81818 0.395350 2.786890 0.047688 0.050870 0.131440 e Uses Cost of Goods Sold in numerator b. Complete the financial statements by using formulas that refer to existing data to fill in the remaining cells. 2. A computer problem at Southglenn Photography Studios has resulted in incomplete financial statements. Management of the company has asked you to see if you can fill in the missing data. Southglenn Photography Stodio Income Statemest Balance Sheet As of December 31, 2014 For the Year Ended December 31. 2014 Sales Cost of Goods Sold Gross Prof Operating Expenses Earnings Before Interest and Tanes Formla Interest Expense Earnings Before Taxes 1,500 Ratie 136,500 Formela 378,000 Fermela Formala Accounts Receivable 41,000 Total Current Asset Gross Fixed Assets Accumulated Depreciation Formela Net Fixed Asset Net Income RatieTotal Assets 450,000 Liabilities and Owner's Equity Notes: Tax Rate Accounts Payable Short-term Bank Notes 66,000 Formela Ratie Ratie Total Current Liabiles Long-term Debe Common Equity Total Liabilities and Oweer's Equity Formela