Could you please include the equations you use in each cell, that would be amazing!

The following Excel worksheet tabs contain the financial statements of Fairway Golf, Incorporated for 2018 and 2019. On the Common Size IS tab, please create the common size income statement for the company. On the Common Size BS tab, please create the common size balance sheet for the firm. On the Ratio Analysis please compute the requested ratios including a Dupont equation along with a brief explanation of the financial performance of the firm. The answer boxes in the ratio analyis should be based on the imbedded Excel formulas. This take-home spreadsheet exam is worth 30 percent of Module Exam One. The remaining 70 percent will come from the completion of the Module Exam One in Blackboard/Connect. The point values for this module exam and spreadsheet are noted below. This is an individual assignment and is to be submitted as solely your work, no collaboration. FAIRWAY GOLF, INC. 2019 Income Statement Sales Cost of goods sold Depreciation EBIT Interest paid Taxable income Taxes Net income $ 233,854 181,312 8,888 $ 43,654 1,911 $ 41,743 6,333 $ 35,410 Dividends Retained earnings $ 16,000 19,410 FAIRWAY GOLF, INC. 2019 Income Statement Common Size Sales Cost of goods sold Depreciation EBIT Interest paid Taxable income Taxes Net income Dividends Retained earnings FAIRWAY GOLF, INC 2018 2019 2018 2019 Assets S 5.727 $ $ Current assets Cash Accounts receivable Inventory Total $ 5.198 7.707 12.150 $ 25.055 21.956 $36160 3.954 3.045 152 7.151 24 400 Liabilities and owners' equity Current liabilities Accounts payable Notes payable Total Long term debt Owners' equity Common stock and paldin surplus Accumulated retained eamings Total Total liabilities and owners' equity 3.786 3,318 179 7283 16.500 $ $ $ 40.000 $ Fixed assets Net plant and equipment Total assets s 36.000 55142 91.789 115 572 75 301 100 356 79412 115 572 S 68 805 S10016 FAIRWAY GOLF, INC. Common Size 2015 2018 Common Size 2019 Common Size 2019 2019 Common Size 2018 2018 2019 Assets Current assets $ $ Liabilities and owners' equity Current liabilities Accounts payable Notes payable $ 5.198 7.707 12.150 25.055 Accounts receivable Inventory Total $ 5.727 8.477 21.956 $36.160 3.954 3.045 152 7.151 24 400 3.786 3,318 179 7283 $ $ $ 16 500 Total Long-term debt Owners' equity Common stock and paidin surplus Accumulated retained earnings Total Total liabilities and owners' equity $ Fixed assets Net plant and equipment Total assets 75 301 100 356 s 40.000 28 805 S68.805 100 356 36.600 55.189 91.789 115.572 79.412 2018 2018 2019 Assets $ $ $ Current assets Cash Accounts receivable Inventory Total 5,193 7,707 12,150 25.055 FAIRWAY GOLF, INC. 2019 Liabilities and owners' equity Current liabilities $ 5,727 Accounts payable 8,477 Notes payable 21,958 Other $ 38,100 Total Long-term dati Owners' equity Common stock and paid-in surplus Accumulated retained earnings 79,412 Total S 115,572 Tatal liabilises and owners' equity 3,954 3,045 152 7.151 24,400 3,786 3,318 179 7.283 16,500 3 $ $ $ $ Fixed assets Nel plant and equipment Total assets 40,000 28,805 68,805 100.358 $ 75,301 100,356 38,600 55,189 91,789 115,572 $ $ $ FAIRWAY GOLF, INC. 2019 Income Statement $ $ Sales Cost of goods said Depreciation EBIT Interest paid Taxable income Taxes Net income 233,854 181,312 8,888 43,654 1,911 41.743 6,333 35,410 $ $ Dividends Retained earnings 16,000 19,410 Output 35) Short form solvency radios: 2018 Current ratio 2019 Current ratio 2018 Quick ratio 2019 Quick ratio 100 Has the financial performance of Fairway Golf, Inc. improved or deteriorated from 2018 to 2019? Based your explanation on the ratios you calculated. Enter your answer in this box. ANSWER: 2018 Cash ratio 2019 Cash ratio Assot Wization Fotos: Total asset tumover Inventory tumover Receivables tumover Longdom solvency ratios: 2018 Total debt ratio 2019 Total debt ratio 2018 Debt equity rato 2019 Debt-equity ratio TODO 2018 Equity mulitplier 2019 Equity multiplier Times interesteamed ratio Cash coverage ratio ProfitabWty rados Profit margin Return on assets Return on equity 10 Rotum on Equity Using the Dupont Identity Formula The following Excel worksheet tabs contain the financial statements of Fairway Golf, Incorporated for 2018 and 2019. On the Common Size IS tab, please create the common size income statement for the company. On the Common Size BS tab, please create the common size balance sheet for the firm. On the Ratio Analysis please compute the requested ratios including a Dupont equation along with a brief explanation of the financial performance of the firm. The answer boxes in the ratio analyis should be based on the imbedded Excel formulas. This take-home spreadsheet exam is worth 30 percent of Module Exam One. The remaining 70 percent will come from the completion of the Module Exam One in Blackboard/Connect. The point values for this module exam and spreadsheet are noted below. This is an individual assignment and is to be submitted as solely your work, no collaboration. FAIRWAY GOLF, INC. 2019 Income Statement Sales Cost of goods sold Depreciation EBIT Interest paid Taxable income Taxes Net income $ 233,854 181,312 8,888 $ 43,654 1,911 $ 41,743 6,333 $ 35,410 Dividends Retained earnings $ 16,000 19,410 FAIRWAY GOLF, INC. 2019 Income Statement Common Size Sales Cost of goods sold Depreciation EBIT Interest paid Taxable income Taxes Net income Dividends Retained earnings FAIRWAY GOLF, INC 2018 2019 2018 2019 Assets S 5.727 $ $ Current assets Cash Accounts receivable Inventory Total $ 5.198 7.707 12.150 $ 25.055 21.956 $36160 3.954 3.045 152 7.151 24 400 Liabilities and owners' equity Current liabilities Accounts payable Notes payable Total Long term debt Owners' equity Common stock and paldin surplus Accumulated retained eamings Total Total liabilities and owners' equity 3.786 3,318 179 7283 16.500 $ $ $ 40.000 $ Fixed assets Net plant and equipment Total assets s 36.000 55142 91.789 115 572 75 301 100 356 79412 115 572 S 68 805 S10016 FAIRWAY GOLF, INC. Common Size 2015 2018 Common Size 2019 Common Size 2019 2019 Common Size 2018 2018 2019 Assets Current assets $ $ Liabilities and owners' equity Current liabilities Accounts payable Notes payable $ 5.198 7.707 12.150 25.055 Accounts receivable Inventory Total $ 5.727 8.477 21.956 $36.160 3.954 3.045 152 7.151 24 400 3.786 3,318 179 7283 $ $ $ 16 500 Total Long-term debt Owners' equity Common stock and paidin surplus Accumulated retained earnings Total Total liabilities and owners' equity $ Fixed assets Net plant and equipment Total assets 75 301 100 356 s 40.000 28 805 S68.805 100 356 36.600 55.189 91.789 115.572 79.412 2018 2018 2019 Assets $ $ $ Current assets Cash Accounts receivable Inventory Total 5,193 7,707 12,150 25.055 FAIRWAY GOLF, INC. 2019 Liabilities and owners' equity Current liabilities $ 5,727 Accounts payable 8,477 Notes payable 21,958 Other $ 38,100 Total Long-term dati Owners' equity Common stock and paid-in surplus Accumulated retained earnings 79,412 Total S 115,572 Tatal liabilises and owners' equity 3,954 3,045 152 7.151 24,400 3,786 3,318 179 7.283 16,500 3 $ $ $ $ Fixed assets Nel plant and equipment Total assets 40,000 28,805 68,805 100.358 $ 75,301 100,356 38,600 55,189 91,789 115,572 $ $ $ FAIRWAY GOLF, INC. 2019 Income Statement $ $ Sales Cost of goods said Depreciation EBIT Interest paid Taxable income Taxes Net income 233,854 181,312 8,888 43,654 1,911 41.743 6,333 35,410 $ $ Dividends Retained earnings 16,000 19,410 Output 35) Short form solvency radios: 2018 Current ratio 2019 Current ratio 2018 Quick ratio 2019 Quick ratio 100 Has the financial performance of Fairway Golf, Inc. improved or deteriorated from 2018 to 2019? Based your explanation on the ratios you calculated. Enter your answer in this box. ANSWER: 2018 Cash ratio 2019 Cash ratio Assot Wization Fotos: Total asset tumover Inventory tumover Receivables tumover Longdom solvency ratios: 2018 Total debt ratio 2019 Total debt ratio 2018 Debt equity rato 2019 Debt-equity ratio TODO 2018 Equity mulitplier 2019 Equity multiplier Times interesteamed ratio Cash coverage ratio ProfitabWty rados Profit margin Return on assets Return on equity 10 Rotum on Equity Using the Dupont Identity Formula