For the Years Ended December 31 20Y9 Fees earned Expenses Net income 20Y8 $1,619,000 $1,340,000 (848,700)...

Transcribed Image Text:

For the Years Ended December 31 20Y9 Fees earned Expenses Net income 20Y8 $1,619,000 $1,340,000 (848,700) (833,000) $770,300 $507,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 Open spreadsheet ompany's 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 20Y9 Amount 20Y9 Percent 20Y8 Amount 20Y8 Percent Fees earned Expenses Net income $1,619,000 (848,700) $770,300 100 % $1,340,000 % (833,000) % $507,000 trend. b. The vertical analysis indicates a favorable 100 % % % For the Years Ended December 31 20Y9 Fees earned Expenses Net income 20Y8 $1,619,000 $1,340,000 (848,700) (833,000) $770,300 $507,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 Open spreadsheet ompany's 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 20Y9 Amount 20Y9 Percent 20Y8 Amount 20Y8 Percent Fees earned Expenses Net income $1,619,000 (848,700) $770,300 100 % $1,340,000 % (833,000) % $507,000 trend. b. The vertical analysis indicates a favorable 100 % % %