Skip to document

Horizontal-Vertical-Analysis

vertical and horizontal analysis for subject AE1/VCM
Course

Accountancy

999+ Documents
Students shared 15764 documents in this course
University

STI College

Academic year: 2022/2023
Uploaded by:
Anonymous Student
This document has been uploaded by a student, just like you, who decided to remain anonymous.
Wesleyan University-Philippines

Comments

Please sign in or register to post comments.

Related Studylists

FinMan

Preview text

Amount Amount

Less: Sales returns and allowances 3960 2950.

Net Sales ₱ 391,040 ₱ 282,050.

Purchases less returns and allowances 95100 75000.

Total Cost of merchandise available for sale ₱ 137,100 ₱ 128,000.

Less: Merchandise inventiry, March 31 52200 53000.

Cost of goods sold ₱ 84,900 ₱ 75,000.

Gross Profit ₱ 306,140 ₱ 207,050.

Total operating expenses ₱ 18,831 ₱ 18,086.

Net Income before federal income tax ₱ 287,309 ₱ 188,964.

Federal income tax ₱ 14,500 ₱ 13,105.

Net Income after federal income tax ₱ 272,809 ₱ 175,859.

Company -

  • Sales ₱ 395,000 ₱ 285,000. Revenue
  • Less: Sales returns and allowances 3960 2950.
  • Net Sales ₱ 391,040 ₱ 282,050.
  • Merchandise inventory, January 1 ₱ 42,000 ₱ 53,000. Cost of goods sold
  • Purchases less returns and allowances 95100 75000.
  • Total Cost of merchandise available for sale ₱ 137,100 ₱ 128,000.
  • Less: Merchandise inventiry, March 31 52200 53000.
  • Cost of goods sold ₱ 84,900 ₱ 75,000.
  • Gross Profit ₱ 306,140 ₱ 207,050.
    • Delivery expenses ₱ 560 ₱ 250. Operating Expenses
    • Depreciation expenses-equipment
    • Payroll taxes expenses
    • Salary expenses
    • Supplies expense
    • Telephone expense
    • Utilities expense
    • Total operating expenses ₱ 18,831 ₱ 18,086.
  • Net Income before federal income tax ₱ 287,309 ₱ 188,964.
  • Federal income tax ₱ 14,500 ₱ 13,105.
  • Net Income after federal income tax ₱ 272,809 ₱ 175,859. - For Years Ended December 31, 2021 and Horizontal Analysis INCOME STATEMENT

Amount Percent

₱ 110,000 39%
1010 23%
₱ 108,990 39%
-11000 -21%
20100 27%
9,100 7%
-800 -2%
9900 13%
99090 48%
310 124%
0 0%
172 60%
38 0%
-135 -31%
-30 -14%
390 33%
745 4%
98345 52%
1395 11%
96950 55%

Increase or Decrease

% of Net Sales Amount % of Net Sales

101% ₱ 285,000 101%
1% 2950 1%
100% ₱ 282,050 100%
10% ₱ 53,000 18%
24% 75000 26%
35% ₱ 128,000 45%
13% 53000 18%
21% ₱ 75,000 26.
78% ₱ 207,050 73%
0% ₱ 250 0%
1% 4200 1%
0% 286 0%
2% 11500 4%
0% 435 0%
0% 215 0%
0% 1200 0%
4% ₱ 18,086 6%
73% ₱ 188,964 67%
3% ₱ 13,105 4%
69% ₱ 175,859 62%
2021 2020
Was this document helpful?

Horizontal-Vertical-Analysis

Course: Accountancy

999+ Documents
Students shared 15764 documents in this course

University: STI College

Was this document helpful?
2021 2020
Amount Amount
Revenue
Sales
395,000.00
285,000.00
3960.00
2950.00
Net Sales
391,040.00
282,050.00
Cost of goods sold
Merchandise inventory, January 1
42,000.00
53,000.00
Purchases less returns and allowances
95100.00
75000.00
Total Cost of merchandise available for sale
137,100.00
128,000.00
Less: Merchandise inventiry, March 31
52200.00
53000.00
Cost of goods sold
84,900.00
75,000.00
Gross Profit
306,140.00
207,050.00
Operating Expenses
Delivery expenses
560.00
250.00
Depreciation expenses-equipment
4200
4200
Payroll taxes expenses
458
286
Salary expenses
11538
11500
Supplies expense
300
435
Telephone expense
185
215
Utilities expense
1590
1200
Total operating expenses
18,831.00
18,086.00
Net Income before federal income tax
287,309.00
188,964.00
Federal income tax
14,500.00
13,105.00
Net Income after federal income tax
272,809.00
175,859.00
Company
Horizontal Analysis INCOME STATEMENT
For Years Ended December 31, 2021 and 2020