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 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.) Assets 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 A COMPANY Balance Sheet December 31 2025 $ Year 2024 2,655,000 $ 900.000 1,320,000 1,200,000 2.775.000 1,250,000 10.050.000 10.050,000 (1,800,000) (900,000) $ 15,000,000 $ 12,500,000 $ 1.725,000 $ 1.562,500 1,245,000 1,070,000 5,475,000 5,475,000 6,555,000 4.392.500 $ 15,000,000 $ 12.500.000 Increase (Decrease) Amount %

Cornerstones of Financial Accounting
4th Edition
ISBN:9781337690881
Author:Jay Rich, Jeff Jones
Publisher:Jay Rich, Jeff Jones
Chapter12: Fainancial Statement Analysis
Section: Chapter Questions
Problem 89PSA
icon
Related questions
icon
Concept explainers
Topic Video
Question
4
eBook
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 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.)
Assets
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
A COMPANY
Balance Sheet
December 31
2025
$
Year
2,655,000 $
1,320,000
2.775.000
10.050.000
10.050.000
(1,800,000)
(900,000)
$ 15,000.000 $ 12,500,000
2024
< Required 1
900,000
1,200,000
1,250,000
$ 1.725,000 $ 1.562,500
1.245,000
1,070.000
5,475,000
5,475,000
6,555,000
4.392.500
$ 15,000,000 $ 12,500,000
Increase (Decrease)
Amount
%
+
Required 2 >
Transcribed Image Text:4 eBook 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 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.) Assets 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 A COMPANY Balance Sheet December 31 2025 $ Year 2,655,000 $ 1,320,000 2.775.000 10.050.000 10.050.000 (1,800,000) (900,000) $ 15,000.000 $ 12,500,000 2024 < Required 1 900,000 1,200,000 1,250,000 $ 1.725,000 $ 1.562,500 1.245,000 1,070.000 5,475,000 5,475,000 6,555,000 4.392.500 $ 15,000,000 $ 12,500,000 Increase (Decrease) Amount % + Required 2 >
f
1
bok
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.)
Assets
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
A COMPANY
Balance Sheet
December 31
Amount
S
2,655,000
1,320,000
2,775,000
10,050,000
(1.800,000)
$ 15,000,000
2025
$ 1,725.000
1,245,000
5.475,000
6,555,000
$ 15,000,000
< Required 1
%
$
Amount
2024
900.000
1.200.000
1,250,000
10,050,000
(900,000)
$ 12,500,000
$ 1,562,500
1,070,000
5,475,000
4,392,500
$ 12,500,000
Required 2 >
%
27
Transcribed Image Text:f 1 bok 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.) Assets 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 A COMPANY Balance Sheet December 31 Amount S 2,655,000 1,320,000 2,775,000 10,050,000 (1.800,000) $ 15,000,000 2025 $ 1,725.000 1,245,000 5.475,000 6,555,000 $ 15,000,000 < Required 1 % $ Amount 2024 900.000 1.200.000 1,250,000 10,050,000 (900,000) $ 12,500,000 $ 1,562,500 1,070,000 5,475,000 4,392,500 $ 12,500,000 Required 2 > % 27
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 3 steps with 2 images

Blurred answer
Knowledge Booster
Financial Statements
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, accounting and related others by exploring similar questions and additional content below.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Cornerstones of Financial Accounting
Cornerstones of Financial Accounting
Accounting
ISBN:
9781337690881
Author:
Jay Rich, Jeff Jones
Publisher:
Cengage Learning
Intermediate Accounting: Reporting And Analysis
Intermediate Accounting: Reporting And Analysis
Accounting
ISBN:
9781337788281
Author:
James M. Wahlen, Jefferson P. Jones, Donald Pagach
Publisher:
Cengage Learning