Horizontal Analysis

Download as xlsx, pdf, or txt
Download as xlsx, pdf, or txt
You are on page 1of 1

MCDO JFC

Percentage
2018 2017 Peso Change
Change
Income Statement
Total Revenue ### ### -35,143,164,000 -3.09%
Revenue ### ### -35,143,164,000 -3.09%
Other Revenue, Total - - - -
Cost of Revenue, Total 537,558,000,000.00 608,882,036,000.00 -71,324,036,000 -11.71%
Gross Profit 566,265,000,000.00 530,084,128,000.00 36,180,872,000 6.83%
Total Operating Expenses 640,636,500,000.00 662,190,907,000.00 -21,554,407,000 -3.26%
Selling/General/Admin. 115,531,500,000.00 115,990,840,000.00 -459,340,000 -0.40%
Expenses, Total
Research & Development - - - -
Depreciation / Amortization - - - -
Interest Expense (Income) – - 7,974,750,000.00 - 13,795,124,000.00 5,820,374,000 -42.19%
Net Unusual
OperatingExpense (Income) - 4,478,250,000.00 - 48,886,845,000.00 44,408,595,000 -90.84%
Other Operating Expenses, - - - -
Total
Operating Income 463,186,500,000.00 476,775,257,000.00 -13,588,757,000 -2.85%
Interest Income (Expense), Net - 51,565,500,000.00 - 46,930,373,000.00 -4,635,127,000 9.88%
Non-Operating
Gain (Loss) on Sale of Assets - - - -
Other, Net - 1,275,750,000.00 - 1,941,499,000.00 665,749,000 -34.29%
Net Income Before Taxes 410,345,250,000.00 427,903,385,000.00 -17,558,135,000 -4.10%
Provision for Income Taxes 95,382,000,000.00 133,818,692,000.00 -38,436,692,000 -28.72%
Net Income After Taxes 314,963,250,000.00 294,084,693,000.00 20,878,557,000 7.10%
Minority Interest - - - -
Equity in Affiliates - - - -
U.S. GAAP Adjustment - - - -
Net Income Before 314,963,250,000.00 294,084,693,000.00 20,878,557,000 7.10%
Extraordinatory
Total Items
Extraordinary Items - 3,937,500,000.00 - 34,937,000,000.00 30,999,500,000 -88.73%
Net Income 311,025,750,000.00 259,147,693,000.00 51,878,057,000 20.02%
Total Adjustments to Net Income - - - -
Income Available to Common 314,963,250,000.00 294,084,693,000.00 20,878,557,000 7.10%
ExludingAdjustment
Dilution Extraordinary Items - - - -
Diluted Net Income 311,025,750,000.00 259,147,693,000.00 51,878,057,000 20.02%
Diluted Weighted Average Shares 41,244,000,000.00 40,701,605,000.00 542,395,000 1.33%
Diluted EPS Excluding 401,100,000.00 360,849,300.00 40,250,700 11.15%
Extraordinary
DPS – Common Items
Stock Primary 219,975,000.00 191,155,300.00 28,819,700 15.08%
Issue
Diluted Normalized EPS 396,375,000.00 319,424,000.00 76,951,000 24.09%

Balance Sheet
Total Current Assets 212,793,000,000.00 265,880,552,000.00 -53,087,552,000 -19.97%
Cash and Short Term 54,474,000,000.00 122,968,258,000.00 -68,494,258,000 -55.70%
Investments
Cash - - - -
Cash & Equivalents 45,465,000,000.00 122,968,258,000.00 -77,503,258,000 -63.03%
Short Term Investments 9,009,000,000.00 - 9,009,000,000 -
Total Receivables, Net 128,178,750,000.00 98,632,142,000.00 29,546,608,000 29.96%
Accounts Receivables – 128,178,750,000.00 98,632,142,000.00 29,546,608,000 29.96%
Trade, NetInventory
Total 2,682,750,000.00 2,934,708,000.00 -251,958,000 -8.59%
Prepaid Expenses 25,835,250,000.00 41,320,489,000.00 -15,485,239,000 -37.48%
Other Current Assets, Total 1,622,250,000.00 24,955,000.00 1,597,295,000 6400.70%
Total Assets ### ### 35,445,333,000 2.10%
Property/Plant/Equipment, ### ### 78,847,097,000 7.04%
Total – Net ### ### 124,640,376,000 6.82%
Property/Plant/Equipment,
Accumulated Total – ### ### -45,793,279,000 6.47%
Gross
Depreciation,
Goodwill,Total
Net 122,403,750,000.00 118,770,827,000.00 3,632,923,000 3.06%
Intangibles, Net - - - -
Long Term Investments 63,147,000,000.00 62,537,230,000.00 609,770,000 0.98%
Notes Receivable – Long - - - -
TermOther Long Term Assets, Total 125,002,500,000.00 119,559,405,000.00 5,443,095,000 4.55%
Other Assets, Total - - - -
Total Current Liabilities 156,108,750,000.00 144,269,846,000.00 11,838,904,000 8.21%
Accounts Payable 63,414,750,000.00 46,156,768,000.00 17,257,982,000 37.39%
Payable/Accrued - - - -
Accrued Expenses 80,524,500,000.00 82,960,402,000.00 -2,435,902,000 -2.94%
Notes Payable/Short Term - - - -
DebtCurrent Port. Of LT - - - -
Debit/Capital Leases
Other Current Liabilities, Total 12,169,500,000.00 15,152,676,000.00 -2,983,176,000 -19.69%
Total Liabilities ### ### 200,905,453,000 10.86%
Total Long Term Debt ### ### 157,291,526,000 10.67%
Long Term Debt ### ### 157,291,526,000 10.67%
Capital Lease Obligations - - - -
Total Debt ### ### 157,291,526,000 10.67%
Deferred Income Tax 63,813,750,000.00 55,869,254,000.00 7,944,496,000 14.22%
Minority Interest - - - -
Other Liabilities, Total 199,778,250,000.00 175,947,723,000.00 23,830,527,000 13.54%
Total Equity ### ### -165,460,120,000 101.44%
Redeemable Preferred Stock, - - - -
TotalPreferred Stock – Non - - - -
Redeemable,
Common Net
Stock, Total 871,500,000.00 828,506,000.00 42,994,000 5.19%
Additional Paid-In Capital 387,240,000,000.00 352,983,484,000.00 34,256,516,000 9.70%
Retained Earnings ### ### 238,626,822,000 9.89%
(Accumulated Deficit)
Treasury Stock – Common ### ### -410,111,646,000 14.54%
ESOP Debt Guarantee - - - -
Unrealized Gain (Loss) - - - -
Other Equity, Total ### ### -28,274,806,000 26.01%
Total Liabilities & Shareholders’ ### ### 35,445,333,000 2.10%
EquityCommon Shares
Total 40,272,750,000.00 39,633,531,000.00 639,219,000 1.61%
Outstanding
Total Preferred Shares Outstanding - - - -

Percentage
2018 2017 Peso Change
Change
Income Statement
Total Revenue 161,199,390,000.00 131,576,550,000.00 29,622,840,000 22.51%
Revenue 161,199,390,000.00 131,576,550,000.00 29,622,840,000 22.51%
Other Revenue, Total - - - -
Cost of Revenue, Total 133,894,710,000.00 107,658,140,000.00 26,236,570,000 24.37%
Gross Profit 27,304,680,000.00 23,918,410,000.00 3,386,270,000 14.16%
Total Operating Expenses 153,383,790,000.00 124,906,900,000.00 28,476,890,000 22.80%
Selling/General/Admin. 18,946,310,000.00 16,811,410,000.00 2,134,900,000 12.70%
Expenses, Total
Research & Development - - - -
Depreciation / Amortization 542,770,000.00 437,350,000.00 105,420,000 24.10%
Interest Expense (Income) – - - - -
Net Unusual
OperatingExpense (Income) - - 2,110,000.00 2,110,000 -100.00%
Other Operating Expenses, - - - -
Total
Operating Income 7,815,600,000.00 6,669,650,000.00 1,145,950,000 17.18%
Interest Income (Expense), Net - 594,800,000.00 - 492,430,000.00 -102,370,000 20.79%
Non-Operating
Gain (Loss) on Sale of Assets - - - -
Other, Net 3,269,790,000.00 2,162,290,000.00 1,107,500,000 51.22%
Net Income Before Taxes 10,490,580,000.00 8,339,510,000.00 2,151,070,000 25.79%
Provision for Income Taxes 2,719,250,000.00 1,666,930,000.00 1,052,320,000 63.13%
Net Income After Taxes 7,771,340,000.00 6,672,580,000.00 1,098,760,000 16.47%
Minority Interest 558,550,000.00 436,540,000.00 122,010,000 27.95%
Equity in Affiliates - - - -
U.S. GAAP Adjustment - - - -
Net Income Before 8,329,880,000.00 7,109,120,000.00 1,220,760,000 17.17%
Extraordinatory Items
Total Extraordinary Items - - - -
Net Income 8,329,880,000.00 7,109,120,000.00 1,220,760,000 17.17%
Total Adjustments to Net Income - - - -
Income Available to Common 8,329,880,000.00 7,109,120,000.00 1,220,760,000 17.17%
Exluding Extraordinary Items
Dilution Adjustment - - - -
Diluted Net Income 8,329,880,000.00 7,109,120,000.00 1,220,760,000 17.17%
Diluted Weighted Average Shares 1,103,350,000.00 1,094,670,000.00 8,680,000 0.79%
Diluted EPS Excluding 7,550,000.00 6,490,000.00 1,060,000 16.33%
Extraordinary
DPS – Common Items
Stock Primary 2,570,000.00 3,320,000.00 -750,000 -22.59%
Issue Normalized EPS
Diluted 7,550,000.00 6,490,000.00 1,060,000 16.33%

Balance Sheet
Total Current Assets 42,738,200,000.00 37,141,020,000.00 5,597,180,000 15.07%
Cash and Short Term 24,169,120,000.00 22,520,870,000.00 1,648,250,000 7.32%
Investments
Cash 23,285,920,000.00 21,107,470,000.00 2,178,450,000 10.32%
Cash & Equivalents - 21,148,250,000.00 -21,148,250,000 -100.00%
Short Term Investments 883,200,000.00 1,413,400,000.00 -530,200,000 -37.51%
Total Receivables, Net 4,862,740,000.00 4,017,470,000.00 845,270,000 21.04%
Accounts Receivables – 4,411,020,000.00 3,534,860,000.00 876,160,000 24.79%
Trade, NetInventory
Total 8,812,170,000.00 6,835,510,000.00 1,976,660,000 28.92%
Prepaid Expenses 3,100,890,000.00 2,238,040,000.00 862,850,000 38.55%
Other Current Assets, Total 1,793,280,000.00 1,529,110,000.00 264,170,000 17.28%
Total Assets 113,851,820,000.00 89,783,900,000.00 24,067,920,000 26.81%
Property/Plant/Equipment, 26,693,990,000.00 20,893,810,000.00 5,800,180,000 27.76%
Total – Net 57,391,670,000.00 47,143,320,000.00 10,248,350,000 21.74%
Property/Plant/Equipment,
Accumulated Total – - 30,697,680,000.00 - 26,249,510,000.00 -4,448,170,000 16.95%
Gross
Depreciation,
Goodwill,Total
Net 14,395,720,000.00 9,050,220,000.00 5,345,500,000 59.06%
Intangibles, Net 17,434,340,000.00 6,680,020,000.00 10,754,320,000 160.99%
Long Term Investments 4,401,050,000.00 8,371,610,000.00 -3,970,560,000 -47.43%
Notes Receivable – Long 295,060,000.00 308,820,000.00 -13,760,000 -4.46%
TermOther Long Term Assets, Total 7,893,470,000.00 7,338,400,000.00 555,070,000 7.56%
Other Assets, Total - - - -
Total Current Liabilities 34,184,530,000.00 26,694,600,000.00 7,489,930,000 28.06%
Accounts Payable 13,094,680,000.00 10,877,670,000.00 2,217,010,000 20.38%
Payable/Accrued - 25,505,150,000.00 -25,505,150,000 -100.00%
Accrued Expenses 12,656,330,000.00 12,216,550,000.00 439,780,000 3.60%
Notes Payable/Short Term - - - -
DebtCurrent Port. Of LT 5,193,050,000.00 1,216,220,000.00 3,976,830,000 326.98%
Debit/Capital Leases
Other Current Liabilities, Total 3,240,470,000.00 2,384,160,000.00 856,310,000 35.92%
Total Liabilities 65,488,270,000.00 49,001,260,000.00 16,487,010,000 33.65%
Total Long Term Debt 21,372,250,000.00 14,901,050,000.00 6,471,200,000 43.43%
Long Term Debt 21,372,250,000.00 14,901,050,000.00 6,471,200,000 43.43%
Capital Lease Obligations - - - -
Total Debt 26,565,300,000.00 16,117,270,000.00 10,448,030,000 64.83%
Deferred Income Tax 3,512,250,000.00 1,188,990,000.00 2,323,260,000 195.40%
Minority Interest 1,554,600,000.00 1,799,340,000.00 -244,740,000 -13.60%
Other Liabilities, Total 4,864,640,000.00 4,417,260,000.00 447,380,000 10.13%
Total Equity 48,363,550,000.00 40,782,640,000.00 7,580,910,000 18.59%
Redeemable Preferred Stock, - - - -
TotalPreferred Stock – Non - - - -
Redeemable,
Common NetStock, Total 1,088,040,000.00 1,101,660,000.00 -13,620,000 -1.24%
Additional Paid-In Capital 8,638,440,000.00 7,503,200,000.00 1,135,240,000 15.13%
Retained Earnings 38,145,230,000.00 31,999,210,000.00 6,146,020,000 19.21%
(Accumulated Deficit)
Treasury Stock – Common - 180,510,000.00 - 180,510,000.00 0 0.00%
ESOP Debt Guarantee - - - -
Unrealized Gain (Loss) - 6,760,000.00 -6,760,000 -100.00%
Other Equity, Total 672,350,000.00 352,320,000.00 320,030,000 90.84%
Total Liabilities & Shareholders’ 113,851,820,000.00 89,783,900,000.00 24,067,920,000 26.81%
EquityCommon Shares
Total 1,085,530,000.00 1,086,620,000.00 -1,090,000 -0.10%
Outstanding
Total Preferred Shares Outstanding - - - -

You might also like