2. A computer problem at Mike Owjai Finance has resulted in incomplete financial statements. Management of the company has asked you to see if you can fill in the missing data. Me Owjal dance Mike Owjallance Income Statements Balance Sheet For the Year Ended December 31, 2016 As of December 31, 2016 2016 2016 Salos Ratio Ats Cost of Goods Ratie Cad $11,000 Gross Profile Formula Accounts Receivable Ratio Depreciation 63.000 Torventory 386,250 Selling & Admin. Expense 654.250 Total Current Assets Formula Lease Expense 45750 Gross Fixed Assets 2,010,000 Earnings Before Internet & Taxes Formula Accumulated Depreciation Formula ferest Expense Ratie Net Plant & Equipment Ratio Earnings Before Taxes Formula Total Assets 2.325,500 Taxes Formula Liabilities & Owner's Equity Net Income Ratio Accounts Payable 378,750 Short-term Notes Payable Formula Note: Tax Rate 40001 Total Curities Ratio Long-term Debe Ratio Common Equity Ratio Total Lab. & Owner's Equity Formula a. 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 S10. Value 1.832716 4.414239 8.333333 1.657982 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 0.843090 1.833333 0.016000 0.018061 0.040307 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