Answered step by step
Verified Expert Solution
Link Copied!

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

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

Step: 3

blur-text-image

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

Design And Maintenance Of Accounting Manuals

Authors: Harry L. Brown

3rd Edition

0471253685, 978-0471253686

More Books

Students also viewed these Accounting questions