Kindly make a thorough analysis or explanation of this ho

FINANCIAL ACCOUNTING
10th Edition
ISBN:9781259964947
Author:Libby
Publisher:Libby
Chapter1: Financial Statements And Business Decisions
Section: Chapter Questions
Problem 1Q
icon
Related questions
Question

Kindly make a thorough analysis or explanation of this horizontal analysis comparative income statement.

Particulars
ASSETS
Current Assets
Cash & Cash Equivalents
Accounts Receivable, Net
Inventories
Prepaid Expenses
Other Current Assets
Total Current Assets
Non-Current Assets
Property, Plant and Equipment
Capitalized/Purchased Software
Long Term Investments
Goodwill
Other Intangibles
Other Long Term Assets
Total Non-Current Assets
TOTAL ASSETS
LIABILITIES
Current Liabilites
Accounts Payable
Accrued Expenses
Current Portion of LT Debt
Current Portion of Capital Lease Obligatio
Other Current Liabilities
Total Current Liabilites
Non-Current Liabilities
Long-Term Debt
Capital Leases
Other Non-Current Liabilities
Total Non-Current Liabilities
TOTAL LIABILITIES
EQUITY
Common Stock
Additional Paid in Capital
Retained Earnings
Treasury Stock
Other Common Equity Adj.
Common Equity
Total Preferred Equity
Minority Interest, Total
TOTAL EQUITY
TOTAL LIABILITIES & EQUITY
Cash and Short Term Investments
TOTAL DEBT
2017-2018
Amount
P12,004.20
472.60
1,612.20
322.20
1,597.00
P16,008.20
P6,791.20
(739.40)
(934.50)
(142.80)
(1,042.70)
1,791.80
P5,723.60
P21,731.80
(P961.50)
2,179.20
8,478.70
0.00
(3,513.90)
P6,182.50
P8,273.20
(624.80)
1,315.00
P8,963.40
P15,145.90
P6.90
208.90
5,459.40
0.00
929.20
P6,604.40
0.00
(18.50)
P6,585.90
P21,731.80
Globe Telecom Inc.
Comparative Income Statement
Horizontal Analysis
For the Years Ended December 31, 2017 to 2021
2018-2019
12,004.20
P16,127.10
%
106.97%
1.73%
49.72%
17.07%
11.52%
27.83%
(14.66%)
8.76%
102.41%
0.00%
(8.88%)
7.80%
6.71%
(100.00%)
16.33%
6.79%
7.17%
0.10%
0.58%
25.15%
0.00%
1888.62%
10.20%
4.18%
P16,835.00
(6.11%)
(115.60)
(2.54%)
(1,395.80)
(11.13%) P1,759.10
(7.67%)
P95.80
(29.16%)
(601.90)
2.60%
P16,576.60
7.82%
P4,792.60
0.00%
(43.33%)
9.90%
7.82%
Amount
106.97%
12.20%
(P14,928.30) (64.27%)
407.80
1.47%
(141.30)
16,738.70
(13,860.90)
(89.68%)
(P11,784.00) (16.03%)
F4,267.80
2,743.70
(3,838.30)
981.80
(5,043.40)
(P888.40)
(P8,580.90)
2,681.80
3,476.70
(P2,422.40)
(P3,310.80)
%
P7.70
280.5
10,002.20
0
(2,297.40)
P7,993.00
0
110.4
P8,103.40
P4,792.60
(14,928.30)
(P8,755.50)
(2.91%)
757.65%
9.94%
(1.02%)
(3.89%)
154.28%
0.76%
13.82%
7.34%
1.60%
76.27%
10.14%
(22.90%)
0.00%
(13.99%)
(1.04%)
(6.52%)
0.00%
37.12%
(1.72%)
(1.46%)
0.12%
0.77%
36.82%
0.00%
(234.81%)
11.21%
0.00%
456.20%
11.08%
1.60%
(64.27%)
(5.90%)
2019-2020
Amount
P11,210.00
(2,641.40)
1,275.30
(7,450.80)
(34.70)
P2,358.40
P8,364.40
826.00
1,232.60
251.40
1,248.40
21,207.90
33,130.70
P35,489.10
P2,874.50
1,312.00
(4,398.50)
17.40
(4,107.60)
(P4,302.20)
P33,327.90
843.70
4,062.20
#38,233.80
P33,931.60
P11.20
192.80
3,512.90
0.00
(2,262.30)
P1,454.60
0.00
102.80
P1,557.40
P35,489.00
11,210.00
P29,790.40
%
135.09%
(9.37%)
27.06%
(39.32%)
(2.18%)
3.82%
4.49%
7.34%
3.58%
8.67%
9.87%
(427.94%)
13.66%
11.66%
29.14%
4.40%
(34.04%)
1.77%
27.11%
31.46%
31.63%
27.61%
15.21%
0.17%
0.52%
9.45%
0.00%
171.52%
1.83%
0.00%
76.37%
1.92%
11.66%
Amount
7,497.10
2,665.10
(13.24%)
28,646.30
(5.09%) #37,251.90
135.09%
21.35%
P4,731.10
(2,601.00)
(1,943.90)
2,459.70
1,102.90
P3,748.80
P95,841.00
3,958.00
6,862.70
(43.30)
3,751.80
4,561.00
P114,931.20
P118,680.00
(P2,235.20)
678.60
P37,764.40
12,689.50
(617.20)
49,836.70
P87,088.60
P9.40
225.00
9,093.00
(10,000.00)
32,207.80
P31,535.20
0.00
56.30
P31,591.50
P118,680.10
4,731.10
P60,616.10
%
24.25%
(10.18%)
(32.46%)
21.39%
70.69%
5.85%
49.25%
32.77%
19.22%
(1.37%)
26.99%
28.06%
41.69%
34.93%
(17.55%)
2.18%
87.98%
266.72%
106.45%
46.41%
24.17%
359.93%
(3.65%)
28.20%
33.89%
0.14%
0.61%
22.35%
0.00%
(899.33%)
39.04%
0.00%
23.72%
38.15%
34.93%
24.25%
35.80%
Transcribed Image Text:Particulars ASSETS Current Assets Cash & Cash Equivalents Accounts Receivable, Net Inventories Prepaid Expenses Other Current Assets Total Current Assets Non-Current Assets Property, Plant and Equipment Capitalized/Purchased Software Long Term Investments Goodwill Other Intangibles Other Long Term Assets Total Non-Current Assets TOTAL ASSETS LIABILITIES Current Liabilites Accounts Payable Accrued Expenses Current Portion of LT Debt Current Portion of Capital Lease Obligatio Other Current Liabilities Total Current Liabilites Non-Current Liabilities Long-Term Debt Capital Leases Other Non-Current Liabilities Total Non-Current Liabilities TOTAL LIABILITIES EQUITY Common Stock Additional Paid in Capital Retained Earnings Treasury Stock Other Common Equity Adj. Common Equity Total Preferred Equity Minority Interest, Total TOTAL EQUITY TOTAL LIABILITIES & EQUITY Cash and Short Term Investments TOTAL DEBT 2017-2018 Amount P12,004.20 472.60 1,612.20 322.20 1,597.00 P16,008.20 P6,791.20 (739.40) (934.50) (142.80) (1,042.70) 1,791.80 P5,723.60 P21,731.80 (P961.50) 2,179.20 8,478.70 0.00 (3,513.90) P6,182.50 P8,273.20 (624.80) 1,315.00 P8,963.40 P15,145.90 P6.90 208.90 5,459.40 0.00 929.20 P6,604.40 0.00 (18.50) P6,585.90 P21,731.80 Globe Telecom Inc. Comparative Income Statement Horizontal Analysis For the Years Ended December 31, 2017 to 2021 2018-2019 12,004.20 P16,127.10 % 106.97% 1.73% 49.72% 17.07% 11.52% 27.83% (14.66%) 8.76% 102.41% 0.00% (8.88%) 7.80% 6.71% (100.00%) 16.33% 6.79% 7.17% 0.10% 0.58% 25.15% 0.00% 1888.62% 10.20% 4.18% P16,835.00 (6.11%) (115.60) (2.54%) (1,395.80) (11.13%) P1,759.10 (7.67%) P95.80 (29.16%) (601.90) 2.60% P16,576.60 7.82% P4,792.60 0.00% (43.33%) 9.90% 7.82% Amount 106.97% 12.20% (P14,928.30) (64.27%) 407.80 1.47% (141.30) 16,738.70 (13,860.90) (89.68%) (P11,784.00) (16.03%) F4,267.80 2,743.70 (3,838.30) 981.80 (5,043.40) (P888.40) (P8,580.90) 2,681.80 3,476.70 (P2,422.40) (P3,310.80) % P7.70 280.5 10,002.20 0 (2,297.40) P7,993.00 0 110.4 P8,103.40 P4,792.60 (14,928.30) (P8,755.50) (2.91%) 757.65% 9.94% (1.02%) (3.89%) 154.28% 0.76% 13.82% 7.34% 1.60% 76.27% 10.14% (22.90%) 0.00% (13.99%) (1.04%) (6.52%) 0.00% 37.12% (1.72%) (1.46%) 0.12% 0.77% 36.82% 0.00% (234.81%) 11.21% 0.00% 456.20% 11.08% 1.60% (64.27%) (5.90%) 2019-2020 Amount P11,210.00 (2,641.40) 1,275.30 (7,450.80) (34.70) P2,358.40 P8,364.40 826.00 1,232.60 251.40 1,248.40 21,207.90 33,130.70 P35,489.10 P2,874.50 1,312.00 (4,398.50) 17.40 (4,107.60) (P4,302.20) P33,327.90 843.70 4,062.20 #38,233.80 P33,931.60 P11.20 192.80 3,512.90 0.00 (2,262.30) P1,454.60 0.00 102.80 P1,557.40 P35,489.00 11,210.00 P29,790.40 % 135.09% (9.37%) 27.06% (39.32%) (2.18%) 3.82% 4.49% 7.34% 3.58% 8.67% 9.87% (427.94%) 13.66% 11.66% 29.14% 4.40% (34.04%) 1.77% 27.11% 31.46% 31.63% 27.61% 15.21% 0.17% 0.52% 9.45% 0.00% 171.52% 1.83% 0.00% 76.37% 1.92% 11.66% Amount 7,497.10 2,665.10 (13.24%) 28,646.30 (5.09%) #37,251.90 135.09% 21.35% P4,731.10 (2,601.00) (1,943.90) 2,459.70 1,102.90 P3,748.80 P95,841.00 3,958.00 6,862.70 (43.30) 3,751.80 4,561.00 P114,931.20 P118,680.00 (P2,235.20) 678.60 P37,764.40 12,689.50 (617.20) 49,836.70 P87,088.60 P9.40 225.00 9,093.00 (10,000.00) 32,207.80 P31,535.20 0.00 56.30 P31,591.50 P118,680.10 4,731.10 P60,616.10 % 24.25% (10.18%) (32.46%) 21.39% 70.69% 5.85% 49.25% 32.77% 19.22% (1.37%) 26.99% 28.06% 41.69% 34.93% (17.55%) 2.18% 87.98% 266.72% 106.45% 46.41% 24.17% 359.93% (3.65%) 28.20% 33.89% 0.14% 0.61% 22.35% 0.00% (899.33%) 39.04% 0.00% 23.72% 38.15% 34.93% 24.25% 35.80%
Expert Solution
steps

Step by step

Solved in 2 steps

Blurred answer
Recommended textbooks for you
FINANCIAL ACCOUNTING
FINANCIAL ACCOUNTING
Accounting
ISBN:
9781259964947
Author:
Libby
Publisher:
MCG
Accounting
Accounting
Accounting
ISBN:
9781337272094
Author:
WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:
Cengage Learning,
Accounting Information Systems
Accounting Information Systems
Accounting
ISBN:
9781337619202
Author:
Hall, James A.
Publisher:
Cengage Learning,
Horngren's Cost Accounting: A Managerial Emphasis…
Horngren's Cost Accounting: A Managerial Emphasis…
Accounting
ISBN:
9780134475585
Author:
Srikant M. Datar, Madhav V. Rajan
Publisher:
PEARSON
Intermediate Accounting
Intermediate Accounting
Accounting
ISBN:
9781259722660
Author:
J. David Spiceland, Mark W. Nelson, Wayne M Thomas
Publisher:
McGraw-Hill Education
Financial and Managerial Accounting
Financial and Managerial Accounting
Accounting
ISBN:
9781259726705
Author:
John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting Principles
Publisher:
McGraw-Hill Education