Vertical Analysis ABC INDUSTRIES CONSOLIDATED INCOME STATEMENT DECEMBER 31, 2020 2020 2019 Amount P 38,028,500 P 26,358,500 P 11,670,000 Amount 100% P 26,315,420 69% P 16,526,084 31% P 9,789,336 Net Sales Cost of Goods Sold 100% 63% Gross Profit 37% Selling Expenses General and Administrative Expenses Total Operating Expenses Earnings before income tax P 7,111,740 P 2,123,420 P 9,235,160 P 2,434,840 P 925,239 P1,509,601 19% P 6,157,808 6% P 1,368,402 24% P 7,526,210 6% P 2,263,126 2% P 868,409 4% P 1,394,717 23% 5% 29% 9% Income tax 3% Net Income 5%
Vertical Analysis ABC INDUSTRIES CONSOLIDATED INCOME STATEMENT DECEMBER 31, 2020 2020 2019 Amount P 38,028,500 P 26,358,500 P 11,670,000 Amount 100% P 26,315,420 69% P 16,526,084 31% P 9,789,336 Net Sales Cost of Goods Sold 100% 63% Gross Profit 37% Selling Expenses General and Administrative Expenses Total Operating Expenses Earnings before income tax P 7,111,740 P 2,123,420 P 9,235,160 P 2,434,840 P 925,239 P1,509,601 19% P 6,157,808 6% P 1,368,402 24% P 7,526,210 6% P 2,263,126 2% P 868,409 4% P 1,394,717 23% 5% 29% 9% Income tax 3% Net Income 5%
Chapter1: Financial Statements And Business Decisions
Section: Chapter Questions
Problem 1Q
Related questions
Question
Prepare a ratio analysis ( Conclusion only) on each statement

Transcribed Image Text:Vertical Analysis
ABC INDUSTRIES
CONSOLIDATED INCOME STATEMENT
DECEMBER 31, 2020
2020
2019
Amount
P 38,028,500
P 26,358,500
P 11,670,000
Amount
Net Sales
Cost of Goods Sold
100% P 26,315,420
100%
69% P 16,526,084
31% P 9,789,336
63%
Gross Profit
37%
Selling Expenses
General and Administrative Expenses
Total Operating Expenses
Earnings before income tax
P 7,111,740
P 2,123,420
P 9,235,160
P 2,434,840
P 925,239
P1,509,601
19% P 6,157,808
6% P 1,368,402
24% P 7,526,210
6% P 2,263,126
2% P 868,409
23%
5%
29%
9%
Income tax
3%
Net Income
4% P 1,394,717
5%
Common Stock Shares Outstanding
Earning per share of common stock
2,500,000
0.6
2,498,750
0.56

Transcribed Image Text:Income Statement Balance Sheet
...
A
B
1
2
ABC INDUSTRIES
CONSILIDATED BALANCE SHEET
4
As of December 31, 2020
6
2020
2019
7
Amount
%
Amount
%
8.
Current Assets
Cash and Cash Equivalents
10 Accounts Receivable (Net)
9.
1,271,231
22% P
677,600
994,409
17% P
773,134
11
Note Receivable
P
350,000
6% P
320,000
12 Merchandise Inventories
3,250,000
55% P
4,190,000
13 Total Current Assets
P
5,865,640
30% P
5,960,734
14
P 13,668,850
15 Property and Equipment (Net)
16 Total Assets
70% P 11,798,800
P 19,534,490
100% P 17,758,889
17
18 Liabilities
19 Accounts Payable
20 Salaries Payable
Incomr Taxes Payable
1,275,300
7% P
1,477,800
P
330,000
2% P
245,200
21
925,239
5% P
500,200
8,000
22 Other Accrued Expenses
Total Current Liablities
P
0.40% P
48,339
23
2,538,539
13% P
2,271,539
24
25 Long-Term Liabilities
26 Mortgage Payable
27 Bonds Payable
500,000
2.56% P
536,000
2,400,000
2,900,000
12.29% P
2,340,000
28 Total Long Term Liabilities
14.85% P
2,876,000
29
30 Total Liabilities
P
5,438,539
28% P
5,147,539
31
32 Stock Holder's Equity
33 Common Stock 2,500,000 shares
34 at P 1 par Value per share
P
2,500,000
13% P
2,498,539
35
36 Capital in Excess of Par Value
P
1,750,000
8.96% P
1,726,250
37
38 Retained Earnings, January 1, 20XX
P
8,386,350
42.93% P
6,991,633
39
40 Net Income for the Year
1,509,601
7.73% P
1,424,717
41 Less Dividends
50,000
0.26% P
30,000
42
43 Retained Earnings, Dec. 31, 20XX
9,845,951
50% P
8,386,350
44
45 Total Stockholder Equity
14,095,951
72% P 12,611,350
46
47 Total Liabilities and Stockholder's Equity
P 19,534,490
100% P 17,758,889
48
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

Knowledge Booster
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


Accounting
Accounting
ISBN:
9781337272094
Author:
WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:
Cengage Learning,

Accounting Information Systems
Accounting
ISBN:
9781337619202
Author:
Hall, James A.
Publisher:
Cengage Learning,


Accounting
Accounting
ISBN:
9781337272094
Author:
WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:
Cengage Learning,

Accounting Information Systems
Accounting
ISBN:
9781337619202
Author:
Hall, James A.
Publisher:
Cengage Learning,

Horngren's Cost Accounting: A Managerial Emphasis…
Accounting
ISBN:
9780134475585
Author:
Srikant M. Datar, Madhav V. Rajan
Publisher:
PEARSON

Intermediate Accounting
Accounting
ISBN:
9781259722660
Author:
J. David Spiceland, Mark W. Nelson, Wayne M Thomas
Publisher:
McGraw-Hill Education

Financial and Managerial Accounting
Accounting
ISBN:
9781259726705
Author:
John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting Principles
Publisher:
McGraw-Hill Education