Vertical analysis Two income statements for Cornea Company follow: Cornea Company Income Statements For the Years Ended December 31 2019 2018 Fees earned $1,640,000 $1,280,000 Expenses (852,600) (825,000) Net income $787,400 $455,000 This information has been collected in the Microsoft Excel Online file. Open the spreadsheet, perform the required analysis, and input your answers in the questions below X HITHIL ppen spreadsheet a. Prepare a vertical analysis of Cornea Company's income statements. Round your answers to one decimal place. Cornea Company Income Statements For the Years Ended December 31 2019 2018 Amount Percent Amount Percent Fees earned $ 1,640,000 % $ 1,280,000 Expenses (852,600) 9 (825,000) Net income $ 787,400 $ 455,000 trend. b. The vertical analysis indicates a Paste B TUD A Format Painter Formatting was able Styles Tables Cells Number Font Unde Clipboard Alignment H 1 E F G D19 A B D 1 Vertical analysis 2. Two income statements for Comea Company follow Comea Company 5 Income Statements 6 For the Years Ended December 31 2049 20YB 8 Fees earned $1,640,000 $1,280,000 9 Expenses (852.600) (825,000) 10 Net Income $787,400 $455,000 11 Using formulas and cell references, perform the required analysis, and input your answers into the Percent columns. Transfer the numeric results for the green entry cells (619:021 and F19:F21) into the appropriate 12 fields in CNOWV2 for grading. 13 14 a Cornea Company 15 Income Statements 16 For the Years Ended December 31 Formulas 17 2049 20Y8 2049 18 Amount Percent Amount Percent Percent 19 Fees earned $1,640,000 $1,280,000 20 Expenses (852,600) (825,000) 21 Net income $787,400 $455,000 22 23 24 25 26 20Y8 Percent