Korbin Company Comparative Income Statements For Years Ended December 31, 2017, 2016. and 2015 Complete the following questions. Only answer in the green highlighted cells. You are only allowed to use formulas. ABSOLUTELY NO HARD KEYING. Once you have completed the assingment, save it with the title of Chapter 17 Excel Assignment -"Your Name" Then submit it to me via the Chapter 17 Excel Assignment Dropbox module under Chapter 17 on D2L. 1. Compute each year's current ratio 2017 2016 2016 2015 Sales Cost of Goods Sold Gross Profit Selling Expenses Administrative Expenses Total Expenses Income Before Taxes Income Taxes Net Income 2017 555.000 283,500 271,500 102,900 50,558 153,568 117.932 40,800 77,132 340,000 212,500 127,500 46,920 29.920 76 940 50,660 10,370 40,290 2015 278,000 153,900 124,100 50,800 22,800 73,600 50,500 15.670 34.830 2. Express the income statement data in common-size percents. (Round percents to two decimal points.) 2017 2016 2015 Korbin Company Comparative Balance Sheets For Years Ended December 31, 2017, 2016, and 2015 2017 2016 2015 3. Express the balance sheet data in trend percents with 2015 as the base vear. (Round percents to two decimal points.) 2017 2016 2015 52,390 Assets Current Assets Long-Term Investments Plant Assets, net Total Assets 37,924 500 96,000 134,424 51.748 2.950 50.000 115,698 100,000 152,390 Liabilities & Equity Current Liabilities Carnman Stock Other Pald-in Capital Retained Earnings Total Liabilities & Equity 22,800 72,000 9,000 48,590 152.390 19,960 72,000 9,000 33,464 134.424 20,300 60,000 5,000 29,398 1 15.698 4. Compute the following ratios for the 2017 year, using data from the statements provided. Current Ratio Total Asset Turnover Debt Ratio Gross Margin Ratio Return on Total Assets