Answered step by step
Verified Expert Solution
Link Copied!

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Managerial Accounting Custom Publication

Authors: Belverd E. Needles

7th Edition

0618681922, 978-0618681921

More Books

Students also viewed these Accounting questions