Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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
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 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.) A COMPANY Balance Sheet December 31 2025 Amount 2024 Amount % Assets Cash $ 1,712,500 $ 600,000 Accounts receivable 1,175,000 780,000 Inventory 2,862,500 1,120,000 Buildings Less: Accumulated depreciation 8,250,000 (1,500,000) 8,250,000 (750,000) Total assets $ 12,500,000 $ 10,000,000 Liabilities and Stockholders' Equity Accounts payable $ 1,237,500 $ 1,300,000 Contingent liability Common stock Retained earnings Total liabilities and stockholders' equity 1,200,000 5,100,000 4,962,500 $ 12,500,000 $ 10,000,000 1,120,000 5,100,000 2,480,000 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 Year Increase (Decrease) 2025 2024 Amount Cash Accounts receivable Inventory Buildings Less: Accumulated depreciation Total assets Liabilities and Stockholders' Equity Accounts payable Contingent liability Common stock Retained earnings Total liabilities and stockholders' equity $ 1,712,500 $ 600,000 1,175,000 780,000 2,862,500 1,120,000 8,250,000 8,250,000 (1,500,000) (750,000) $ 12,500,000 $ 10,000,000 $ 1,237,500 $ 1,300,000 1,200,000 1,120,000 5,100,000 2,480,000 5,100,000 4,962,500 $ 12,500,000 $10,000,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