Financial Statement Analysis Compute for Activity Ratios/Asset Management Ratios with Analysis for year 2018 - 2020: Average Age of Inventory Operating Cycle Fixed-Asset Turnover Ratio Total Asset Turnover

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

Financial Statement Analysis

Compute for Activity Ratios/Asset Management Ratios with Analysis for year 2018 - 2020:

  1. Average Age of Inventory
  2. Operating Cycle
  3. Fixed-Asset Turnover Ratio
  4. Total Asset Turnover
Equity Attributable to Equity Holders of the Parent Company
Capital stock (Note 22) :
Php 872,124.00
200,000.00
Php 872,124.00
200,000.00
Common
Php 872,124.00
200,000.00
Preferred
Additional paid -in capital
Treasury shares and Philippine depository receipts convertible to
4,745,399.00
475,399.00
4,745,399.00
common shares (Note 22)
(1,638,719.00)
244,980.00
(1,638,719.00)
550,689.00
(1,638,719.00)
921,624.00
Exchange differences on translation of foreign operations
Unrealized gain on AFS Investments ( Note 13)
Fair value reserves on financial assets at FVOCI (Note 13)
Retained earnings (Note 22)
71,712.00
172,920.00
205,969.00
13,794,643.00
271,114,963.00
30,291,703.00
Equity attributable to equity holders of the Parent Company
18,290,139.00
32,017,376.00
35,598.100.00
Noncontrolling Interest (Note 4)
(1,091,288.00)
(926,171.00)
126,348.00
Total Equity
17,198,851.00
31,091,205.00
35,724,448.00
TOTAL LIABILITIES AND EQUITY
Php 58,926,177.00
Php 79,244,536.00
Php84,559,217.00
ABS-CBN CORPORATION AND SUBSIDIARIES
CONSOLIDATED STATEMENTS OF INCOME
(Amounts in Thousands, Except Per Share Amounts)
Years Ended December 31|
2020
2019
2018
REVENUES (Notes 5, 23, 24 and 31)
P21,419,757
P42,834,842
P40,130,592
(12,345,277)
(10,785,230)
(2,493,359)
PRODUCTION COSTS (Notes 10, 12, 23, 25, 30 and 31)
COST OF SERVICES (Notes 8, 10, 12, 15, 23, 26, 30 and 31)
COT OF SALES (Notes 8, 10, 23, 26, 30 and 31)
(10,310,826)
(9,136,575)
(284,707)
(13,135,798)
(11,010,926)
(2,136,680)
GROSS PROFIT
1,687,649
16,551,438
14,506,726
GENERAL AND ADMINISTRATIVE EXPENSES
FINANCE COSTS (Notes 18, 20 and 28)
INTEREST INCOME (Note 6)
(Notes 7, 8, 10, 11, 12, 22, 23, 27, 30 and 31) (13,815,768)
(1,213,934)
201,101
(16,113,809)
(1,547,422)
(12,310,128)
(1,124,677)
560,421
202,801
FOREIGN EXCHANGE GAINS (LOSSES) – Net
(382,796)
(312,254)
404,031
EQUITY IN NET LOSSES OF ASSOCIATES AND
JOINT VENTURES (Note 14)
(47,634)
(18,721)
(29,706)
OTHER INCOME - Net (Notes 15, 21, 28 and 31)
92,837
530,469
331,253
INCOME (LOSS) BEFORE INCOME TAX
(13,478,545)
(349,878)
1,980,300
PROVISION FOR (BENEFIT FROM) INCOME TAX (Note 29)
Current
538,985
676,294
600,791
Deferred
(486,714)
1,618,975
(528,732)
52,271
2,295,269
72.059
NET INCOME (LOSS)
(P13,530,816)
(P2,645,147)
P1,908,241
Net Income Attributable to:
Equity holders of the Parent Company (Note 34) (P13,456,161)
Noncontrolling interests
(P1,624,858)
(1,020,289)
P2.110,251
(74,655)
(202,010)
(P13,530,816)
(P2,645,147)
P1,908,241
Basic/Diluted Earnings (Loss) Per Share Attributable
to Equity Holders of the Parent Company (Note 34) (P16.356)
(P1.979)
P2.560
Transcribed Image Text:Equity Attributable to Equity Holders of the Parent Company Capital stock (Note 22) : Php 872,124.00 200,000.00 Php 872,124.00 200,000.00 Common Php 872,124.00 200,000.00 Preferred Additional paid -in capital Treasury shares and Philippine depository receipts convertible to 4,745,399.00 475,399.00 4,745,399.00 common shares (Note 22) (1,638,719.00) 244,980.00 (1,638,719.00) 550,689.00 (1,638,719.00) 921,624.00 Exchange differences on translation of foreign operations Unrealized gain on AFS Investments ( Note 13) Fair value reserves on financial assets at FVOCI (Note 13) Retained earnings (Note 22) 71,712.00 172,920.00 205,969.00 13,794,643.00 271,114,963.00 30,291,703.00 Equity attributable to equity holders of the Parent Company 18,290,139.00 32,017,376.00 35,598.100.00 Noncontrolling Interest (Note 4) (1,091,288.00) (926,171.00) 126,348.00 Total Equity 17,198,851.00 31,091,205.00 35,724,448.00 TOTAL LIABILITIES AND EQUITY Php 58,926,177.00 Php 79,244,536.00 Php84,559,217.00 ABS-CBN CORPORATION AND SUBSIDIARIES CONSOLIDATED STATEMENTS OF INCOME (Amounts in Thousands, Except Per Share Amounts) Years Ended December 31| 2020 2019 2018 REVENUES (Notes 5, 23, 24 and 31) P21,419,757 P42,834,842 P40,130,592 (12,345,277) (10,785,230) (2,493,359) PRODUCTION COSTS (Notes 10, 12, 23, 25, 30 and 31) COST OF SERVICES (Notes 8, 10, 12, 15, 23, 26, 30 and 31) COT OF SALES (Notes 8, 10, 23, 26, 30 and 31) (10,310,826) (9,136,575) (284,707) (13,135,798) (11,010,926) (2,136,680) GROSS PROFIT 1,687,649 16,551,438 14,506,726 GENERAL AND ADMINISTRATIVE EXPENSES FINANCE COSTS (Notes 18, 20 and 28) INTEREST INCOME (Note 6) (Notes 7, 8, 10, 11, 12, 22, 23, 27, 30 and 31) (13,815,768) (1,213,934) 201,101 (16,113,809) (1,547,422) (12,310,128) (1,124,677) 560,421 202,801 FOREIGN EXCHANGE GAINS (LOSSES) – Net (382,796) (312,254) 404,031 EQUITY IN NET LOSSES OF ASSOCIATES AND JOINT VENTURES (Note 14) (47,634) (18,721) (29,706) OTHER INCOME - Net (Notes 15, 21, 28 and 31) 92,837 530,469 331,253 INCOME (LOSS) BEFORE INCOME TAX (13,478,545) (349,878) 1,980,300 PROVISION FOR (BENEFIT FROM) INCOME TAX (Note 29) Current 538,985 676,294 600,791 Deferred (486,714) 1,618,975 (528,732) 52,271 2,295,269 72.059 NET INCOME (LOSS) (P13,530,816) (P2,645,147) P1,908,241 Net Income Attributable to: Equity holders of the Parent Company (Note 34) (P13,456,161) Noncontrolling interests (P1,624,858) (1,020,289) P2.110,251 (74,655) (202,010) (P13,530,816) (P2,645,147) P1,908,241 Basic/Diluted Earnings (Loss) Per Share Attributable to Equity Holders of the Parent Company (Note 34) (P16.356) (P1.979) P2.560
ABS-CBN CORPORATION AND SUBSIDIARIES
CONSOLIDATED STATEMENT OF FINANCIAL POSITION
(Amounts in Thousands)
12/31/2020
12/31/2019
12/31/2018
ASSETS
Current Assets
Cash and cash equivalents (Note 6)
Short- term Investments (Note 6)
Trade and other receivables (Note 7 and 23)
Php 6,429,726.00
11,680.00
Php 12,169,917.00
6,998,695.00
Php18,104,686.00
1,804,041.00
5,563,130.00
10,605,433.00
10,369,080.00
524,905.00
675,607.00
1,286,661.00
Inventories
680,628.00
Program rights and other Intangible assets (Note 12)
Other current assets (Note 9,15 and 23)
1,011,070.00
1,359,188.00
5,142,376.00
18,682,887.00
5,383,138.00
37,780,761.00
5,411,370.00
Total Current Assets
37,147,683.00
Noncurrent Assets
Property and equipment (Notes 10,18 and 31)
26,758,264.00
27,473,741.00
27,875,625.00
Goodwill, program rights, and other intangible assets-net of
current position (Note 12)
10,421,284.00
11,384,697.00
13,310,366.00
Financial assets at fair value through other comprehensive
income (FVOCI) (Note 13)
61,846.00
263,126.00
268,304.00
Investment properties (Note 11 and 18)
Investments in associates and joint ventures (Note 14)
Deferred tax assets (Note 29)
141,112.00
198,692.00
268,304.00
161,382.00
425,864.00
202,763.00
1,715,052.00
1,147,107.00
495,247.00
Other noncurrent assets (Notes 7,16 and 23)
984,350.00
1,203,626.00
3,020,803.00
40,243,290.00
58,926,177.00
Total Noncurrent Assets
42,096,853.00
79,244,536.00
1,685,348.00
84,559,217.00
TOTAL ASSETS
LIABILITIES AND EQUITY
Current Liabilities
Trade and other payables (Notes 4, 17, 23 and 30)
Php 9,826,832.00
Php 11,772,942.00
Php13,637,426.00
756,876.00
Contract Liabilities (Note 9)
Income tax payable
Obligations for program rights (Note 19)
Current lease liabilities (Note 31)
Interest-bearing loans and borrowings (Notes 10,11, 18)
1,064,650.00
890,644.00
218,521.00
302,649.00
208,056.00
303,440.00
302,647.00
513,755.00
233,560.00
441,875.00
310,088.00
17,053,458.00
414,911.00
Total Current Liabilities
28,399,335.00
14,260,065.00
15,592,912.00
Noncurrent Liabilities
Interest-bearing loans and borrowings - net of current
portion (Notes 10, 11, and 18)
4,433,796.00
25,512,844.00
27,810,584.00
Obligations for program rights -net of current portion
(Note 19)
360,996.00
441,466.00
541,548.00
Accrued pension obligation and other employee benefits
(Note 30)
Deferred tax liabilities (Note 29)
Noncurrent lease liabilities (Note 31)
Convertible note (Note 20)
Other noncurrent liabilities (Note 21)
6,958,955.00
4,029,891.00
138,271.00
6,004,432.00
353,639.00
458,355.00
636,234.00
780,719.00
221,217.00
500,346.00
243,477.00
238,305.00
340,894.00
457,145.00
Total Noncurrent Liabilities
13,327,991.00
33,893,266.00
33,241,857.00
Total Liabilities
41,727,326.00
48,153,331.00
48,834,769.00
Transcribed Image Text:ABS-CBN CORPORATION AND SUBSIDIARIES CONSOLIDATED STATEMENT OF FINANCIAL POSITION (Amounts in Thousands) 12/31/2020 12/31/2019 12/31/2018 ASSETS Current Assets Cash and cash equivalents (Note 6) Short- term Investments (Note 6) Trade and other receivables (Note 7 and 23) Php 6,429,726.00 11,680.00 Php 12,169,917.00 6,998,695.00 Php18,104,686.00 1,804,041.00 5,563,130.00 10,605,433.00 10,369,080.00 524,905.00 675,607.00 1,286,661.00 Inventories 680,628.00 Program rights and other Intangible assets (Note 12) Other current assets (Note 9,15 and 23) 1,011,070.00 1,359,188.00 5,142,376.00 18,682,887.00 5,383,138.00 37,780,761.00 5,411,370.00 Total Current Assets 37,147,683.00 Noncurrent Assets Property and equipment (Notes 10,18 and 31) 26,758,264.00 27,473,741.00 27,875,625.00 Goodwill, program rights, and other intangible assets-net of current position (Note 12) 10,421,284.00 11,384,697.00 13,310,366.00 Financial assets at fair value through other comprehensive income (FVOCI) (Note 13) 61,846.00 263,126.00 268,304.00 Investment properties (Note 11 and 18) Investments in associates and joint ventures (Note 14) Deferred tax assets (Note 29) 141,112.00 198,692.00 268,304.00 161,382.00 425,864.00 202,763.00 1,715,052.00 1,147,107.00 495,247.00 Other noncurrent assets (Notes 7,16 and 23) 984,350.00 1,203,626.00 3,020,803.00 40,243,290.00 58,926,177.00 Total Noncurrent Assets 42,096,853.00 79,244,536.00 1,685,348.00 84,559,217.00 TOTAL ASSETS LIABILITIES AND EQUITY Current Liabilities Trade and other payables (Notes 4, 17, 23 and 30) Php 9,826,832.00 Php 11,772,942.00 Php13,637,426.00 756,876.00 Contract Liabilities (Note 9) Income tax payable Obligations for program rights (Note 19) Current lease liabilities (Note 31) Interest-bearing loans and borrowings (Notes 10,11, 18) 1,064,650.00 890,644.00 218,521.00 302,649.00 208,056.00 303,440.00 302,647.00 513,755.00 233,560.00 441,875.00 310,088.00 17,053,458.00 414,911.00 Total Current Liabilities 28,399,335.00 14,260,065.00 15,592,912.00 Noncurrent Liabilities Interest-bearing loans and borrowings - net of current portion (Notes 10, 11, and 18) 4,433,796.00 25,512,844.00 27,810,584.00 Obligations for program rights -net of current portion (Note 19) 360,996.00 441,466.00 541,548.00 Accrued pension obligation and other employee benefits (Note 30) Deferred tax liabilities (Note 29) Noncurrent lease liabilities (Note 31) Convertible note (Note 20) Other noncurrent liabilities (Note 21) 6,958,955.00 4,029,891.00 138,271.00 6,004,432.00 353,639.00 458,355.00 636,234.00 780,719.00 221,217.00 500,346.00 243,477.00 238,305.00 340,894.00 457,145.00 Total Noncurrent Liabilities 13,327,991.00 33,893,266.00 33,241,857.00 Total Liabilities 41,727,326.00 48,153,331.00 48,834,769.00
Expert Solution
steps

Step by step

Solved in 2 steps with 1 images

Blurred answer
Knowledge Booster
Ratio 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
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