Required: 1. Prepare a vertical analysis of the balance sheet data for Year 2 and Year 1. 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.) COMPANY A Balance Sheet December 31 Year 2 Year 1 Amount Amount % Assets Cash $ 2,310,000 2$ 840,000 Accounts receivable 1,305,000 1,044,000 Inventory 4,005,000 2,136,000 Buildings 8,580,000 8,580,000 Less: Accumulated depreciation (1,200,000) (600,000) Total assets $ 15,000,000 $ 12,000,000 Liabilities and Stockholders' Equity Accounts payable $ 1,725,000 $ 1,380,000 Contingent liability 1,230,000 Common stock 4,920,000 4,920,000 Retained earnings 7,125,000 5,700,000 Total liabilities and stockholders' equity $ 15,000,000 $ 12,000,000
Required: 1. Prepare a vertical analysis of the balance sheet data for Year 2 and Year 1. 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.) COMPANY A Balance Sheet December 31 Year 2 Year 1 Amount Amount % Assets Cash $ 2,310,000 2$ 840,000 Accounts receivable 1,305,000 1,044,000 Inventory 4,005,000 2,136,000 Buildings 8,580,000 8,580,000 Less: Accumulated depreciation (1,200,000) (600,000) Total assets $ 15,000,000 $ 12,000,000 Liabilities and Stockholders' Equity Accounts payable $ 1,725,000 $ 1,380,000 Contingent liability 1,230,000 Common stock 4,920,000 4,920,000 Retained earnings 7,125,000 5,700,000 Total liabilities and stockholders' equity $ 15,000,000 $ 12,000,000
Essentials Of Investments
11th Edition
ISBN:9781260013924
Author:Bodie, Zvi, Kane, Alex, MARCUS, Alan J.
Publisher:Bodie, Zvi, Kane, Alex, MARCUS, Alan J.
Chapter1: Investments: Background And Issues
Section: Chapter Questions
Problem 1PS
Related questions
Question
![Exercise 12-4B Prepare vertical and horizontal analyses (LO12-1, 12-2)
[The following information applies to the questions displayed below.]
The balance sheets for Company A for Year 2 and Year 1 are presented below.
Exercise 12-4B Part 1
Required:
1. Prepare a vertical analysis of the balance sheet data for Year 2 and Year 1. 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.)
COMPANY A
Balance Sheet
December 31
Year 2
Year 1
Amount
Amount
Assets
Cash
$ 2,310,000
$
840,000
Accounts receivable
1,305,000
1,044,000
Inventory
4,005,000
2,136,000
Buildings
8,580,000
8,580,000
Less: Accumulated depreciation
(1,200,000)
(600,000)
Total assets
$ 15,000,000
$ 12,000,000
Liabilities and Stockholders' Equity
Accounts payable
$
1,725,000
$ 1,380,000
Contingent liability
1,230,000
Common stock
4,920,000
4,920,000
Retained earnings
7,125,000
5,700,000
Total liabilities and stockholders' equity
$ 15,000,000
$ 12,000,000](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2F79d33672-ba3e-4918-88f0-04249b0ef7b1%2F4fc22cab-2933-482f-85e5-0e18adb15f12%2Fr9xegs_processed.jpeg&w=3840&q=75)
Transcribed Image Text:Exercise 12-4B Prepare vertical and horizontal analyses (LO12-1, 12-2)
[The following information applies to the questions displayed below.]
The balance sheets for Company A for Year 2 and Year 1 are presented below.
Exercise 12-4B Part 1
Required:
1. Prepare a vertical analysis of the balance sheet data for Year 2 and Year 1. 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.)
COMPANY A
Balance Sheet
December 31
Year 2
Year 1
Amount
Amount
Assets
Cash
$ 2,310,000
$
840,000
Accounts receivable
1,305,000
1,044,000
Inventory
4,005,000
2,136,000
Buildings
8,580,000
8,580,000
Less: Accumulated depreciation
(1,200,000)
(600,000)
Total assets
$ 15,000,000
$ 12,000,000
Liabilities and Stockholders' Equity
Accounts payable
$
1,725,000
$ 1,380,000
Contingent liability
1,230,000
Common stock
4,920,000
4,920,000
Retained earnings
7,125,000
5,700,000
Total liabilities and stockholders' equity
$ 15,000,000
$ 12,000,000
![Reyuii eu immoITTiativiI
Exercise 12-4B Prepare vertical and horizontal analyses (LO12-1, 12-2)
[The following information applies to the questions displayed below.]
The balance sheets for Company A for Year 2 and Year 1 are presented below.
Exercise 12-4B Part 2
2. Prepare a horizontal analysis for Year 2 using Year 1 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.)
COMPANY A
Balance Sheet
December 31
Year
Increase (Decrease)
Year 2
Year 1
Amount
%
Assets
Cash
$ 2,310,000 $
840,000
Accounts receivable
1,305,000
1,044,000
Inventory
4,005,000
2,136,000
Buildings
8,580,000
8,580,000
Less: Accumulated depreciation
(1,200,000)
(600,000)
Total assets
$ 15,000,000
$ 12,000,000
Liabilities and Stockholders' Equity
Accounts payable
$
1,725,000 $ 1,380,000
Contingent liability
1,230,000
Common stock
4,920,000
4,920,000
Retained earnings
7,125,000
5,700,000
Total liabilities and stockholders' equity
$ 15,000,000 $ 12,000,000](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2F79d33672-ba3e-4918-88f0-04249b0ef7b1%2F4fc22cab-2933-482f-85e5-0e18adb15f12%2F02r7vty_processed.jpeg&w=3840&q=75)
Transcribed Image Text:Reyuii eu immoITTiativiI
Exercise 12-4B Prepare vertical and horizontal analyses (LO12-1, 12-2)
[The following information applies to the questions displayed below.]
The balance sheets for Company A for Year 2 and Year 1 are presented below.
Exercise 12-4B Part 2
2. Prepare a horizontal analysis for Year 2 using Year 1 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.)
COMPANY A
Balance Sheet
December 31
Year
Increase (Decrease)
Year 2
Year 1
Amount
%
Assets
Cash
$ 2,310,000 $
840,000
Accounts receivable
1,305,000
1,044,000
Inventory
4,005,000
2,136,000
Buildings
8,580,000
8,580,000
Less: Accumulated depreciation
(1,200,000)
(600,000)
Total assets
$ 15,000,000
$ 12,000,000
Liabilities and Stockholders' Equity
Accounts payable
$
1,725,000 $ 1,380,000
Contingent liability
1,230,000
Common stock
4,920,000
4,920,000
Retained earnings
7,125,000
5,700,000
Total liabilities and stockholders' equity
$ 15,000,000 $ 12,000,000
Expert Solution

This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
This is a popular solution!
Trending now
This is a popular solution!
Step by step
Solved in 3 steps with 4 images

Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, finance and related others by exploring similar questions and additional content below.Recommended textbooks for you

Essentials Of Investments
Finance
ISBN:
9781260013924
Author:
Bodie, Zvi, Kane, Alex, MARCUS, Alan J.
Publisher:
Mcgraw-hill Education,



Essentials Of Investments
Finance
ISBN:
9781260013924
Author:
Bodie, Zvi, Kane, Alex, MARCUS, Alan J.
Publisher:
Mcgraw-hill Education,



Foundations Of Finance
Finance
ISBN:
9780134897264
Author:
KEOWN, Arthur J., Martin, John D., PETTY, J. William
Publisher:
Pearson,

Fundamentals of Financial Management (MindTap Cou…
Finance
ISBN:
9781337395250
Author:
Eugene F. Brigham, Joel F. Houston
Publisher:
Cengage Learning

Corporate Finance (The Mcgraw-hill/Irwin Series i…
Finance
ISBN:
9780077861759
Author:
Stephen A. Ross Franco Modigliani Professor of Financial Economics Professor, Randolph W Westerfield Robert R. Dockson Deans Chair in Bus. Admin., Jeffrey Jaffe, Bradford D Jordan Professor
Publisher:
McGraw-Hill Education