do these on an excel please with formulas

Sales 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. Mike Owjai Finance Mike Owjai Finance Income Statements Balance Sheet For the Year Ended December 31, 2016 As of December 31, 2016 2016 2016 Ratio Assets Cost of Goods Ratio Cash $41,000 Gross Profit Formula Accounts Receivable Ratio Depreciation 63,000 Inventory 386,250 Selling & Admin. Expense 654,250 Total Current Assets Formula Lease Expense 48,750 Gross Fixed Assets 2,010,000 Earnings Before Interest & Taxes Formula Accumulated Depreciation Formula Interest Expenses mons Reserve way not be const scanned or solicitat Ratio - 03 2002Net 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 40.00% Total Current Liabilities Long-term Debt Ratio Common Equity Ratio Total Liab. & Owner's Equity Formula Ratio 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 $10. Ratio Value Current Ratio 1.832716 Inventory Turnover* 4.414239 A/R Turnover 8.333333 Fixed Asset Turnover 1.657982 LTD to Equity 0.843090 Times Interest Earned 1.833333 Net Profit Margin 0.016000 Return on Total Assets 0.018061 Return on Equity 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