Please provide the following: • Horizontal Analysis • Vertical Analysis

Managerial Accounting: The Cornerstone of Business Decision-Making
7th Edition
ISBN:9781337115773
Author:Maryanne M. Mowen, Don R. Hansen, Dan L. Heitger
Publisher:Maryanne M. Mowen, Don R. Hansen, Dan L. Heitger
Chapter15: Financial Statement Analysis
Section: Chapter Questions
Problem 33BEB: The income statement, statement of retained earnings, and balance sheet for Santiago Systems are as...
icon
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
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
steps

Step by step

Solved in 3 steps with 4 images

Blurred answer
Knowledge Booster
Balance Sheet Analysis
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
Managerial Accounting: The Cornerstone of Busines…
Managerial Accounting: The Cornerstone of Busines…
Accounting
ISBN:
9781337115773
Author:
Maryanne M. Mowen, Don R. Hansen, Dan L. Heitger
Publisher:
Cengage Learning
Century 21 Accounting General Journal
Century 21 Accounting General Journal
Accounting
ISBN:
9781337680059
Author:
Gilbertson
Publisher:
Cengage
College Accounting, Chapters 1-27
College Accounting, Chapters 1-27
Accounting
ISBN:
9781337794756
Author:
HEINTZ, James A.
Publisher:
Cengage Learning,
Century 21 Accounting Multicolumn Journal
Century 21 Accounting Multicolumn Journal
Accounting
ISBN:
9781337679503
Author:
Gilbertson
Publisher:
Cengage