Please provide the following: • Horizontal Analysis • Vertical Analysis
Chapter1: Financial Statements And Business Decisions
Section: Chapter Questions
Problem 1Q
Related questions
Question
Please provide the following:
• Horizontal Analysis
• Vertical Analysis
![Prepare common size statement
Gross sales
Sales return
Sales Discount
Net sales
COS
Selling expense
Admin expense
Asset
Cash
AR
Prepaid insurance
Prepaid rent
Marketable securities
Merchandise inventory
Furniture and fixtures [net]
Land
Building [net]
Total assets
Liabilities and Equity
AP
Notes Payable (due in 6 months)
Total liabilities
Shareholders Equity
Ordinary shares
Retained earnings
Treasury shares
Total Shareholders equity
Total liabilities and Shareholders Equity
B
2018
P3,050,000.00
P3,200.00
P3,000.00
P3,043,800.00
P2,790,000.00
P500,000.00
P300,000.00
2018
P350,000.00
P1,500,000.00
P30,000.00
P120,000.00
P200,000.00
P350,000.00
P400,000.00
P900,000.00
P2,500,000.00
P6,350,000.00
P900,000.00
P490,000.00
P1,390,000.00
P4,000,000.00
P1,010,000.00
(P50,000.00)
P4,960,000.00
P6,350,000.00
P0.00
C
D
Comprehensive income
2019
P4,750,000.00
P16,000.00
P7,000.00
P4,727,000.00
P2,299,000.00
P900,000.00
P700,000.00
Statement of Financial position
2019
P627,000.00
P1,600,000.00
P15,000.00
P120,000.00
P500,000.00
P550,000.00
P350,000.00
P900,000.00
P2,250,000.00
P6,912,000.00
P1,100,000.00
P600,000.00
P1,700,000.00
P4,000,000.00
P1,212,000.00
P5,212,000.00
P6,912,000.00
P0.00
E
F
2020
P8,988,000.00
P35,000.00
P20,100.00
P8,932,900.00
P5,051,000.00
P3,000,000.00
P1,500,000.00
2020
P550,000.00
P1,200,000.00
P50.000.00
P150,000.00
P1,000,000.00
P400,000.00
P300,000.00
P900,000.00
P2,000,000.00
P6,550,000.00
P600,000.00
P200,000.00
P800,000.00
25.000.000.00
P750,000.00
P5,750,000.00
P6,550,000.00
P0.00
G
H
2021
P13,450,000.00
P60,000.00
P45,000.00
P13,345,000.00
P7,605,000.00
P3,090,000.00
P1,900,000.00
2021
P1,500,000.00
P2,000,000.00
P50,000.00
P150,000.00
P500,000.00
P500,000.00
P450,000.00
P900,000.00
P1,750,000.00
P7,800,000.00
P990,000.00
P600,000.00
P1,590,000.00
P5,000,000.00
P1,210,000.00
P6,210,000.00
P7,800,000.00
P0.00](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2F0ea05ab3-6a1d-4147-897f-22f8f7b53553%2Fa1c07367-3c60-4102-9699-01e5cec231f1%2Fmbisuem_processed.jpeg&w=3840&q=75)
Transcribed Image Text:Prepare common size statement
Gross sales
Sales return
Sales Discount
Net sales
COS
Selling expense
Admin expense
Asset
Cash
AR
Prepaid insurance
Prepaid rent
Marketable securities
Merchandise inventory
Furniture and fixtures [net]
Land
Building [net]
Total assets
Liabilities and Equity
AP
Notes Payable (due in 6 months)
Total liabilities
Shareholders Equity
Ordinary shares
Retained earnings
Treasury shares
Total Shareholders equity
Total liabilities and Shareholders Equity
B
2018
P3,050,000.00
P3,200.00
P3,000.00
P3,043,800.00
P2,790,000.00
P500,000.00
P300,000.00
2018
P350,000.00
P1,500,000.00
P30,000.00
P120,000.00
P200,000.00
P350,000.00
P400,000.00
P900,000.00
P2,500,000.00
P6,350,000.00
P900,000.00
P490,000.00
P1,390,000.00
P4,000,000.00
P1,010,000.00
(P50,000.00)
P4,960,000.00
P6,350,000.00
P0.00
C
D
Comprehensive income
2019
P4,750,000.00
P16,000.00
P7,000.00
P4,727,000.00
P2,299,000.00
P900,000.00
P700,000.00
Statement of Financial position
2019
P627,000.00
P1,600,000.00
P15,000.00
P120,000.00
P500,000.00
P550,000.00
P350,000.00
P900,000.00
P2,250,000.00
P6,912,000.00
P1,100,000.00
P600,000.00
P1,700,000.00
P4,000,000.00
P1,212,000.00
P5,212,000.00
P6,912,000.00
P0.00
E
F
2020
P8,988,000.00
P35,000.00
P20,100.00
P8,932,900.00
P5,051,000.00
P3,000,000.00
P1,500,000.00
2020
P550,000.00
P1,200,000.00
P50.000.00
P150,000.00
P1,000,000.00
P400,000.00
P300,000.00
P900,000.00
P2,000,000.00
P6,550,000.00
P600,000.00
P200,000.00
P800,000.00
25.000.000.00
P750,000.00
P5,750,000.00
P6,550,000.00
P0.00
G
H
2021
P13,450,000.00
P60,000.00
P45,000.00
P13,345,000.00
P7,605,000.00
P3,090,000.00
P1,900,000.00
2021
P1,500,000.00
P2,000,000.00
P50,000.00
P150,000.00
P500,000.00
P500,000.00
P450,000.00
P900,000.00
P1,750,000.00
P7,800,000.00
P990,000.00
P600,000.00
P1,590,000.00
P5,000,000.00
P1,210,000.00
P6,210,000.00
P7,800,000.00
P0.00
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
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, 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