Answered step by step
Verified Expert Solution
Question
1 Approved Answer
13 The balance sheets for a company for 2025 and 2024 are presented below. Required: 1. Prepare a vertical analysis of the balance sheet data
13 The balance sheets for a company for 2025 and 2024 are presented below. Required: 1. Prepare a vertical analysis of the balance sheet data for 2025 and 2024. Express each amount as a percentage of total assets 2. Prepare a horizontal analysis for 2025 using 2024 as the base year Complete this question by entering your answers in the tabs bel below. Required 1 Required 2 Prepare a vertical analysis of the balance sheet data for 2025 and 2024. Express each amount as a percentage of total assets. (Amounts to be deducted should be indicated by a minus sign Round your answers to 1 decimal place.) Assets Cash A COMPANY Balance Sheet December 31 Amount 2025 $ 3,000,000 % 2024 Amount Accounts receivable Inventory Buildings Less Accumulated depreciation Total assets Liabilities and Stockholders' Equity Accounts payable Contingent liability Common stock Retained eamings Total abilities and stockholders' equity 1.800.000 3,300,000 14,700,000 (2.800,000) $ 20,000,000 $1,920.000 1,840.000 9,100,000 7,140,000 $ 960,000 1,242,500 1.977,500 14,700,000 (1.400.000) $ 17,500,000 $ 2,187,500 1,150,000 9,100,000 5,062,500 $ 20,000,000 $ 17,500,000 13 of 20 Next > 13 1. Prepare a vertical analysis of the balance sheet data for 2025 and 2024. Express each amount as a percentage of total assets 2. Prepare a horizontal analysis for 2025 using 2024 as the base year Complete this question by entering your answers in the tabs below. eBook Required 1 Required 2 Prepare a horizontal analysis for 2025 using 2024 as the base year. (Note: If the percentage increase or decrease cannot be calculated, then leave the cell blank. Decreases should be indicated by a minus sign. Round your percentage answers to 1 decimal place.) A COMPANY Balance Sheet December 31 Assets Cash Accounts receivable Inventory Year Increase (Decrease) 2025 2024 Amount $ 3,000,000 $ 1.800.000 980,000 1,242,500 3,300,000 1,977,500 14,700,000 14,700,000 (2.800.000) (1,400,000) Buildings Less Accumulated depreciation Total asses Liabilities and Stockholders' Equity Accounts payable Contingent ability Common stock Retained eamings Total abilities and stockholders' equity $ 20,000,000 $ 17,500,000 $ 1,920,000 $2,187,500 1,840,000 1,150,000 9,100,000 9,100,000 7,140,000 5,062,500 $ 20,000,000 $17,500,000
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started