Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

HORIZONTAL ANALYSIS - Income Statement 2020 Amount 2019 Amount Percent P -45% REVENUES Revenue from contracts with customers - net sales Rental income 12,222,341,393.00 P

image text in transcribed

image text in transcribed

HORIZONTAL ANALYSIS - Income Statement 2020 Amount 2019 Amount Percent P -45% REVENUES Revenue from contracts with customers - net sales Rental income 12,222,341,393.00 P 22,365,831,939.00 61.993,815.00 76,070,748.00 12,284,335,208.00 22,441,902,687.00 (7.287,406,758.00) (12,346,225,569.00) 4,996,928.450.00 10,095,677,118.00 -19% -45% -41% -51% COSTS OF GOODS SOLD AND SERVICES GROSS PROFIT OPERATING EXPENSES Selling and distribution General and administrative 4.184,957,968,00 1,115,966,288.00 5,300,924,256,00 7.095.912.730.00 1,299,092,427.00 8,395,005,157.00 -41% -14% -37% 20,469,580.00 106,392.946.00 28% -112% OTHER INCOME (CHARGES) Interest income Share in net earnings (losses) of an associate and joint venture Gain on remeasurement of right-of-use assets and lease liabilities Gain on sale of interest in joint venture Foreign exchange losses - net Loss on stores closures and disposals ofproperty and equipment and other assets (Notes 7 and 10) Interest expense Others - net 26,157,099.00 (13,148,422.00) 7,307,158.00 3.730,966,00 (16,058,981.00) (219,832,803.00) (535,902,141.00) 38,330,308.00 (709,416,816.00) (1,013,412,622.00) (16,786,745.00)| (60,403,364.00) (549,866,677.00) 31,025,242.00 (469,169,018.00) 1,231,502,943.00 -4% 264% -3% 24% 51% -182% INCOME (LOSS) BEFORE INCOME TAX PROVISION FOR (BENEFIT FROM) INCOME TAX Current Deferred 126,074,876.00 (235,683.284.00) 392,469,642.00 23,542,684.00 -68% -1101% (109,608,408.00) (903.804,214.00) 416,012,326.00 815,490,617.00 -126% -211% 88,981.00 (46,312.00) -292% NET INCOME (LOSS) OTHER COMPREHENSIVE INCOME (LOSS) Other comprehensive income (loss) to be reclassified to profit or loss in subsequent periods: Cumulative translation adjustment on foreign operations Other comprehensive income (loss) not to be reclassified to profit or loss in subsequent periods:Re-measurement gain (loss) on retirement benefit, net of deferred tax TOTAL OTHER COMPREHENSIVE INCOME (LOSS) TOTAL COMPREHENSIVE INCOME (LOSS) BASIC/DILUTED EARNINGS (LOSS) PER SHARE (62,434,209.00) (62,345,228.00) (966,149,442.00) (0.27) (148,583,252.00) (148,629,564.00) 666,861,053.00 0.25 -58% -58% -245% P 1) Kindly provide interpretation for the above horizontal analysis of the income statement. VERTICAL ANALYSIS - Income Statement 2020 Amount 2019 Amount Percent Percent P 100% P 22,365,831,939,00 100% REVENUES Revenue from contracts with customers - net sales Rental income 12,222,341,393.00 61.993.815.00 12,284,335,208.00 (7,287,406,758.00 1% 0.34% 76,070,748.00 22,441,902,687.00 (12,346.225,569.00) COSTS OF GOODS SOLD AND SERVICES -60% -55.20% 4,996,928,450.00 41% 10,095,677,118.00 45% GROSS PROFIT OPERATING EXPENSES Selling and distribution General and administrative 4,184,957,968.00 1,115,966,288.00 5,300,924,256.00 34% 9% 7,095.912,730.00 1,299,092,427,00 8,395,005,157.00 32% 6% OTHER INCOME (CHARGES) Interest income 26,157,099.00 0.21% 20,469,580,00 0.09% 106.392.946.00 0.48% Share in net eamings (losses) of an associate and joint venture Gain on remeasurement of right-of-use assets and lease liabilities Gain on sale of interest in joint venture Foreign exchange losses - net Loss on stores closures and disposals ofproperty and equipment and other assets (Notes 7 and 10) Interest expense Others - net (13,148,422.00) 7,307,158.00 3.730.966.00 (16.058,981.00 (219,832,803.00 (535,902,141.00) 38.330,308.00 (709,416,816.00) (1,013,412,622.00) -0.11% 0.06% 0.03% -0.13% -2% IT (16,786,745.00) (60,403,364.00) (549,866,677.00) 31.025,242.00 (469,169,018.00) 1,231,502,943.00 -0.08% -0.27% -2% 0.14% 0.31% -8% 6% INCOME (LOSS) BEFORE INCOME TAX PROVISION FOR (BENEFIT FROM) INCOME TAX Current Deferred 126.074,876.00 (235,683,284.00) 1% -2% 392,469,642.00 23,542,684.00 2% 0.11% NET INCOME (LOSS) (109.608,408.00) (903,804,214.00 416,012,326.00 815,490,617,00 -7% 4% OTHER COMPREHENSIVE INCOME (LOSS) Other comprehensive income (loss) to be reclassified to profit or loss in subsequent periods: be reclassifi 88 981.00 0.001% (46,312.00) -0.0002% Cumulative translation adjustment on foreign operations Other comprehensive income (loss) not or loss in subsequent periods:Re-measurement gain (loss) on retirement benefit net of deferred tax TOTAL OTHER COMPREHENSIVE INCOME (LOSS) TOTAL COMPREHENSIVE INCOME (LOSS) BASIC/DILUTED EARNINGS (LOSS) PER SHARE - 1% -1% (62.434,209.00) (62,345,228.00) (966.149,442.00) (0.27) (148,583,252.00) (148,629,564.00) 666.861,053.00 0.25 -1% -1% 3% T 2) Kindly provide interpretation for the above vertical analysis of the income statement. | HORIZONTAL ANALYSIS - Cash Flow Statement 2020 2019 Amount Amount Percent 1,013,412,622 -18% 1,231,502,943 2,051,127,090 1,128,196,981 45% CASH FLOWS FROM OPERATING ACTIVITIES Income (loss) before income tax Adjustments to reconcile income before income tax to net cash flows: Depreciation and amortization Interest expense Retirement expense Loss on stores closures and disposals of property and equipment and other assets 535,902, 141 83,881,848 549,866,677 65.911,077 -3% 27% 219,832,803 60,403,364 264% (106,392 946 -112% 0 13,148, 422 19,694,157 44,607, 228 4.249.976 392,940 (3,730,966) (7,307,158) (26, 157,099) 999,298,651 -574% 13% -94% (9.402,379) 3.759,307 7.056.917 0 0 (20,469,580) 3,833,362,470 28% -74% 2,654,465 (72,151.061) -104% 590,146,995 383,827,470 (573,690, 134) (114,273,856) -203% -436% (379,736,705) 9.937.500 415287 1.606.543.663 11.568,066 (6,314.414) (18,644,240) (257,692,698) 1,335,440,377 1,054,946,814 (298,353) (13.905.553) 4.113.990,327 8,057,398 (9.885.000) (3,124,640) (333.127.845) 3,775,910,240 -136% -3431% -103% -61% 44% -36% 497% -23% -65% Share in net loss (earnings) of an associate and joint venture Provision for inventory obsolescence Provision (reversal) for ECL Unrealized foreign exchange losses - net Loss on derecognition of franchise cost Gain on sale on interest in joint venture Gain on remeasurement of right-ofane, aseets and lease liabilities Interest income Operating income before working capital changes Decrease increase) in Trade and other receivables Merchandise inventories Prepayments and other current assets Increase (decrease) in: Trade and other payable Deferred revenue . Tenant deposits Net cash generated from operations Interest received Contributions Benefits paid Income taxes paid, including creditable withholding tax Net cash flows provided by operating activities ae CASH FLOWS FROM INVESTING ACTIVITIES Proceeds from disposal of property and equipment Acquisitions of property and equipment Payment of franchise cost and software Cash receipts from amounts owed by related parties Cash receipts (payments) of: Security deposits and construction bonds Other noncurrent assets Dividends received from investment in an associate Proceeds from sale of interests in joint ventures Net cash flows used in investing activities CASH FLOWS FROM FINANCING ACTIVITIES . Short-term loans payable Principal portion of lease liabilities Long-term debt Interest Dividends payment Stock grant settlement Purchase of treasury shares Net cash flows provided by (used in) financing activities EFFECT OF EXCHANGE RATE CHANGES ON CASH NET INCREASE IN CASH CASH AT BEGINNING OF YEAR CASH AT END OF YEAR 1.888.037 (436,726,993) (3.243,725 (960.963.076) (16,161,936) -55% -80% 86,411.627 (4,723,481) -1929% (19.422.410 40% (27,276,694) 44,022,859 5.480,966 (329,443,923) (1.001.220.903) -67% (2,800,000,000) (295,117,840) (284,306.666) (535,543,122) (5.655,000,000) (1.0RR, 308, 169 (450,973,334) (548,618,081) (49.957.284 -50% -73% -37% -2% (12.789.110) 1,807,243,262 (1.823.510) 2.811,416,206 2.492.459.933 5.303.876.139 (10.545.460) (2.640,902,328) (1.738,000) 131,999,009 2.360,460,924 2,492,459,933 21% -168% 5% 2030% 6% 113% 3) Kindly provide interpretation for the above horizontal analysis cash flow statement.|

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access with AI-Powered Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Corporate Finance A Focused Approach

Authors: Michael C. Ehrhardt, Eugene F. Brigham

6th edition

1305637100, 978-1305637108

Students also viewed these Accounting questions