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 %

FINANCIAL ACCOUNTING
10th Edition
ISBN:9781259964947
Author:Libby
Publisher:Libby
Chapter1: Financial Statements And Business Decisions
Section: Chapter Questions
Problem 1Q
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.
Recommended textbooks for you
FINANCIAL ACCOUNTING
FINANCIAL ACCOUNTING
Accounting
ISBN:
9781259964947
Author:
Libby
Publisher:
MCG
Accounting
Accounting
Accounting
ISBN:
9781337272094
Author:
WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:
Cengage Learning,
Accounting Information Systems
Accounting Information Systems
Accounting
ISBN:
9781337619202
Author:
Hall, James A.
Publisher:
Cengage Learning,
Horngren's Cost Accounting: A Managerial Emphasis…
Horngren's Cost Accounting: A Managerial Emphasis…
Accounting
ISBN:
9780134475585
Author:
Srikant M. Datar, Madhav V. Rajan
Publisher:
PEARSON
Intermediate Accounting
Intermediate Accounting
Accounting
ISBN:
9781259722660
Author:
J. David Spiceland, Mark W. Nelson, Wayne M Thomas
Publisher:
McGraw-Hill Education
Financial and Managerial Accounting
Financial and Managerial Accounting
Accounting
ISBN:
9781259726705
Author:
John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting Principles
Publisher:
McGraw-Hill Education