I want answers with formula in excel

Mike Owjai Finance Income Statements For the Year Ended December 31, 2016 2016 Sales Ratio Cost of Goods Ratio Gross Profit Formula Depreciation 63,000 Selling & Admin. Expense 654,250 Lease Expense 48,750 Earnings Before Interest & Taxes Formula Interest Expense Ratio Earnings Before Taxes Formula Taxes Formula Net Income Ratio Note: Tax Rate 40.00% (24 marks) Mike Owjai Finance Balance Sheet As of December 31, 2016 2016 Assets Cash $41,000 Accounts Receivable Ratio Inventory 386,250 Total Current Assets Formula Gross Fixed Assets 2,010,000 Accumulated Depreciation Formula Net Plant & Equipment Ratio Total Assets 2,325,500 Liabilities & Owner's Equity Accounts Payable 378,750 Short-term Notes Payable Formula Total Current Liabilities Ratio Long-term Debt Ratio Common Equity Ratio Total Liab. & Owner's Equity Formula (28 marks) (Each formula = 2 marks x 8 =16 marks; Each ratio = 4 marks x 9= 36 marks) 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. Ratios 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 1.832716 4.414239 8.333333 1.657982 0.843090 1.833333 0.016000 0.018061 0.040307 b. Complete the financial statements by using formulas that refer to existing data to fill in the remaining cells