60.1K

Verified Solution

Link Copied!

First part is done, need help for second part. Take the required data from part 1. Likes guaranteed if answer is correct.

N 20 points Required Prepare a vertical analysis of both the balance sheets and income statements for Year 4 and Year 3. Answer is complete but not entirely correct. Complete this question by entering your answers in the tabs below. Cash Analysis Bal Analysis Inc Sheet Stmt Prepare a vertical analysis of the balance sheets for Year 4 and Year 3. (Percentages may not add exactly due to rounding. Round your percentage answers to 2 decimal places. (i.e., 0.2345 should be entered as 23.45).) ALLENDALE COMPANY Vertical Analysis of Balance Sheets Year 4 Year 3 Amount Percentage of Total Amount Percentage of Total Assets Current assets 5 40.000 6.67% $ 35,000 6.67 Marketable securities 20.000 333 6.000 111 Accounts receivable (net) 54 000 9.00 45.000 8.52 Inventories 135 000 22 50 143 000 26.48 Prepaid items 25000 4.17 10.000 1.85 Total current sets 274 000 45.67 241 000 4463 Investments 27.000 450 20.000 3.70 Plant (net) 270.000 45.00 255.000 47.22 Land 29,000 483 24,000 4440 Total long-term assets 325.000 5433 299 000 55.37 Total 600.000 10000 10000 540,000 Labilities and stockholders' equity Lab Current liabetes Notes payable S 17.000 283 5 6.000 1.11 Accounts payable 113.800 18.97 100 000 1852 Salaries payable 21,000 350 15.000 278 Total current labies 151.800 25 30 121,000 22.41 Noncurrent liabilities Bonds payable 100.000 16.67 100.000 18.52 Other 32.000 533 27.000 5.00 Total noncurrent liabilities 132.000 2200 127.000 23 52 Total liabilities 283.800 4730 248.000 45.93 Stockholders' equity Preferred stock (par value $10,4% cumulative nonparticipating: 8,000 shares authorized and issued) 80 000 1333 80.000 1481 Common stock (no par. 50,000 shares authorized 10,000 shares issued) 80.000 13:33 80,000 14.81 Retained earning 158.200 26.03 132.000 2444 Total stockholders' equity 316 200 5270 292.000 54.07 Total liabilities & stockholders' equity 600 000 100,00 % 540 000 10000% 2 20 points Required Prepare a vertical analysis of both the balance sheets and income statements for Year 4 and Year 3. Answer is complete but not entirely correct. Complete this question by entering your answers in the tabs below. Analysis Bal Analysis Inc Sheet Stmt Prepare a vertical analysis of an income statements for Year 4 and Year 3. (Percentages may not add exactly due to rounding. Round your percentage answers to 2 decimal places i.e., 0.2345 should be entered as 23.45).) ALLENDALE COMPANY Vertical Analysis of Income Statoments Year 4 Year 3 Amount Percentage of Total Amount Percentage of Total 230 000 8,000 238,000 96 64% 3.363 100.00 210,000 5,000 215.000 97 67 % 2.33 100.00 Revenues Sales (net) Other revenues Total revenues Expenses Cost of goods sold Seling, general, and administrative expense Interest expense Income tax expense Total expenses Not income 120,000 55,000 8,000 23,000 206,000 $ 32,000 50.42 23.113 3.363 9.000 86 553 13.45% 103,000 50,000 7,200 22.000 182,200 $ 32,800 47.913 23.263 3.353 10.233 84743 15,20 %

Answer & Explanation Solved by verified expert

See Answer