Problem 13-18A Vertical analysis LO 13-1 Required Prepare a vertical analysis of both the balance sheets and income statements for Year 4 and Year 3 Complete this question by entering your answers in the tabs below. Analysis Bal Analysis Inc Sheet Prepare a vertical analysis of the balance sheets for Year 4 and Year 3. (Percentages may not add exactly due to ro answers to 2 decimal places. (i.e., .2345 should be entered as 23.45.) ALLENDALE COMPANY Vertical Analysis of Balance Sheets Year 4 Year 3 Amount Percentage of Amount Percentage of Assets Prev4 of 4 Next to search t9 144 5 6 8 0 3 4 ALLENDALE COMPANY Vertical Analysis of Balance Sheets Year 4 Year 3 Amount Percentage of Total Amount Percentage of Total Assets Current assets Cash $ 40,000 20,000 54,000 135,000 25,000 %| $ 36,000 Marketable securities Accounts receivable (net) Inventories 6,000 46,000 143,000 10,000 241,000 20,000 Prepaid items Total current assets Inwestments Plant (net) Land 27,000 270,000 29,000 326,000 S 600,000 255,000 24,000 Total long-term assets Total assets S 540,000 to search #0 34 56 78 9 0 Help quired epare a vertical analysis of both the balance sheets and income statements for Year 4 and Year 3 Complete this question by entering your answers in the tabs below Analysis Bal Analysis Inc Sheet Prepare a vertical analysis of an income statements for Year 4 and Year 3. (Percentages may not add exactly due to rounding Round your answers to 2 decimal placese 2345 should be entered as 23.45 ALLENDALE COMPANY Vertical Analysis of Income Statements Year 4 Year 3 Percentage of Amount Sales (net) Other revenues 5 230,000 s 210.000 Prey4 of 4 ll Next earch 5 6 8 9 ALLENDALE COMPANY Vertical Analysis of Income Statements Year 4 Year 3 Amount Percentage of Amount Percentage of Total Total Revenues Sales (net) Other revenues S 230,000 8,000 238,000 96) $ 210.000 5,000 215,000 Total revenues Expenses Cost of goods sold Selling. general, and administrative expense Interest expense Income tax expense 120,000 55,000 8,000 23,000 206,000 S 32,000 103,000 50,000 7,200 22,000 182,200 Total expenses Net income %| $ 32,800 Analysis Bal Sheet KPrey 4 of 4 lE Next 3 4 5 6 7 8 9 0