Question
1) For each quarter of data, decompose AMCs ROE into the following component ratios; Net Profit Margin, Total asset turnover, Return on assets, Financial leverage,
1) For each quarter of data, decompose AMCs ROE into the following component ratios; Net Profit Margin, Total asset turnover, Return on assets, Financial leverage, Return on equity
Return on Equity Decomposition:
ROE = Net Profit Margin * Total Asset Turnover * Financial Leverage
= (Net Income/ Revenues) * (Revenues / Assets) * (Total Assets / Total Shareholder Equity)
2) AMC has traditionally had 3 revenue streams: Admissions; Food and Beverage; and Other Theater. For each quarter, compute the Gross Margin percentages for Admissions and Food and Beverage. Note, explicitly, the assumptions you made in making your calculations.
3) Create common-size income statements (by quarter) for AMC (a common-size income statement takes each item on the income statement and divides it by that periods total revenues).
AMC Holdings-Quarterly Income Statements (in millions except Share and per share amounts Three Months Ended 31-Mar 2017 30. 30-Sep 2017 31-Dec 2017 ... 2018 30-Sep 2018 31-Dec 2018 31-Mar 2019 30.Jun 2019 30-Sep 2019 31-Dec 2019 31-Mar 2020 30-Sep 2017 ... 2020 2018 2020 $751.40 384 $817.30 3979 62.2 1.283.40 $781 40 3741 66.8 1. 202.30 $758.50 $897.30 5614 415 63.8 102.5 1 178.70 1.414.30 $875.00 405.8 102.8 1.383.60 S8 96.30 445.8 100.4 1.442.50 $862.30 435.1 115.9 1,413.30 $731.50 3688 100.1 1.200.40 $195.50 492.5 118.1 1.506.10 5797.30 420 99.5 1 316.30 $877.00 438 1324 1.447.70 $568.00 238.1 25.4 941.5 $0.90 0.4 17.6 18.9 $62.90 29.1 27.5 119.5 1.221.40 379.8 2717 420.7 60.6 3648 60.7 459 68.7 425.5 662 471.4 72.2 3783 63.6 433.5 58.9 365.3 61.5 482.5 76.4 416.8 672 434.5 73.6 45 26.6 2.8 363.9 182.6 329.2 1998 383.2 200.7 4117 2113 411.9 129.7 494.5 1997 400.5 203.7 1.654.70 -14.6 402.8 242 437.4 245.9 419 288.7 427.4 2412 356.9 237,8 114.3 224.1 192.1 214.3 40.4 4.7 43 18.1 4.2 3.3 3.2 4.7 43 0.2 1.8 11.5 45.1 5.6 32.8 32.7 345 1253 5.5 78.9 98.7 144.8 43.6 44.2 180.5 43 137.7 43.4 180.2 46.2 113 43.2 112 37.5 112. 26.1 112.9 33.2 122.5 133.3 25.4 119.7 135.2 139.4 123.5 1.228.00 1.273.70 1352.30 13.8 1326.00 1243.30 1.221.80 - 19.5 1 180.00 -43 1344.40 70.4 1.234.10 -33.7 1.400.60 105.5 1.296.00 20.8 843 1.404.30 43.4 1.85 1.90 2.927.80 -1.986.10 55.4 490.5 -471.6 195.9 794.9 -675.4 109.9 89.7 -21.9 Admissions Food and beverage Other theatre Total revenues Operating costs and expenses Film exhibition costs Food and beverage costs Operating expense excluding depreciation and amortization below Rent General and administrative Merger, acquisition and transaction costs Other, excluding depreciation and amortization below Depreciation and amortization Impairment of long-lived assets, definite and indefinite-lived intangible assets and goodwill Operating costs and expenses Operating income Other expense income Other expense income Interest expense Corporate borrowings Capital and financing lease obligations Non-cash NCMexhibitor service agreement Equity in Income loss of non-consolidated entities Investment income Total other expense Earningsloss) before income taxes Income tax provision (benefit Netearningslos Earningsless) per share attributable to AMC Entertainment Holdings Basic Duted Average shares outstanding Basic in thousands Diluted in thousands Dividends declared per basic and diluted common Share 1.1 -0.6 0.7 1.2 2.2 54.1 - 165.6 - 23.4 -1.3 26.9 -66 125 617 51.1 10.8 54.3 59.6 10.3 60.B 10.6 601 10.7 62.2 74.1 9 10.3 29.8 713 2.1 10.2 74.2 2.1 10.1 73.2 12 10.1 38.1 29.8 74.1 16 10 713 1.6 79.6 15 101 82.B 14 10.1 10.5 10.4 10.3 2.3 -5.3 56.2 -0.8 -9.2 $8.40 195 0.6 256.6 -286.1 -109.6 ($176.50 18 13.9 - 16.6 13 56 56.3 -503 141 - 17.6 290.5 ($42.70) ($276.40) 9 -5.2 87.5 22.4 4.7 $17.70 - 13 - 12.7 -0.7 1.2 701 574 -83.7 19.6 171 -2.6 11.1 0.4 $22.20 ($100.40) $170.50 -6.5 -16.1 90.8 - 124.5 5.7 ($130 20 - 10.2 -2.1 50.7 54.8 5.4 $49.40 -7.5 -0.5 75.8 -55 -64 2.9 2.7 9.4 9.08 122 -46.9 -2.108.10 -33.4 68.2 ($13.50) $2.175.30 12.4 -13 95.7 -5673 -6.1 10.6 -4.1 225.B -9012 $561 20 -905.8 $0.07 $0.07 ($1.35 ($1.35 $0.33) $0.33) ($2.19) ($2.19) $20.38) $0.14 50.14 50.17 $0.17 (50.82) ($0.82) $1.42 $0.92 $1.25 $1.25 $0.48 $0.17 $0.53) $0.53 ($0.14) $0.17) $20 38 $5.38) ($5.38) $8.41) $8.41 121 358 121,401 131 166 131 166 131,077 131,077 128 246 128 246 128.046 128.046 128089 128 105 123, 126 120.621 123, 126 130.105 108.783 108.785 103 845 135.528 103.850 103.850 108.882 103,282 104 245 104 245 104.315 104. 319 107,695 107 695 $0.20 50.20 50.20 $0.20 50.20 $0.20 $1.55 50.20 $0.20 50.20 50.20 $0.20 50.03 Consolidated Balance Sheets Three Months Ended 31-Mar 2017 30 Jun 2017 30-Sep 2017 31-Des 2017 31-Mar 2013 30 Jun 2018 30-Sep 2018 31-Dec 2018 31-Mar 2019 30 Jun 2019 30-Sep 2019 31-Dec 2019 31-Mar 2020 30-Jun 2020 30-Sep 2020 $299.80 $190.50 10.7 228.5 $100.40 10.2 157.5 $265.00 10.5 2542 $498.00 10.4 70.7 $417.90 10.9 97. 125.8 $313.10 S 127.80 $250.00 $310.00 $300.90 $316.40 $333.30 $313.30 $184.60 6.5 116 11 11 107 10.6 144.8 153.8 128.9 2715 157.1 179.1 155.2 259.5 193.8 221.4 110.5 30 54.4 130.5 211.7 223.7 226.3 202.5 204.1 203.9 187 1978 162.6 891 622.3 622 872.4 738.1 340.9 686.5 7813 551.6 3,162.20 3254 3244.5 3.115.50 5.091.30 3.028.10 3,028.60 3,039.60 2.500.80 4.309.20 362.6 329.4 380.5 378 3853 3593 352.1 199 4.523.70 4932.2 4889.5 4931.70 4944 20 4.830.70 4.820.30 4.788.70 4.787.90 105.4 204.7 2222 289 28.2 28.2 29.5 28.6 31 595.1 5091 5447 475.9 505.9 438.6 4383 505.5 493.7 $9.940.00 $9.811.70 59910.70 59.805.20 59,685.70 59,531.30 $9,363.00 $9,495.00 $13.473.20 160.3 130.2 143.4 115.2 100.6 82.3 590 448.7 673.1 5518 579.7 608.6 2.613.90 2.581.40 2.649.20 4.602.30 2.417.50 2.332.50 4.798.90 4,794.90 4.796.00 4.602.30 4.555.30 4.475.80 197.6 193.9 1953 175.1 1743 164.5 4.763.00 4.693.30 4.729.10 2.938.00 2.988.40 2.674.40 31.1 30.7 70.1 0.6 0.6 520.4 537.9 503 450.2 455.8 419.8 $13.514.90 $13,281.30 $13.575.30 $11. 238.30 $11.271.60 $10.575.20 ASSETS Current assets Cash and equivalents Restricted cash Receivables, net Assets held for sale Other current assets Total current assets Property, net Operating lease right-of-use assets.net Intangible assets, net Goodwill Deferred tax asset Other long-term assets Total assets LIABILITIES ANDSTOCKHOLDERS EQUITY Ourrent liabilities Accounts payable Acerved expenses and other liabilities Deferred revenues and income Current maturities of corporate borrowings Current maturities of finance lease abilities Current maturities of operating lease liabilities Current maturities of apital and financing leaz Total current abilities Corporate borrowings Capital and financinglease obligations Operating lease abilities Exhibitor services agreement Deferred tax liability Other long-term abilities Total abilities Stockholders equity: Cas A common stock 8.01 Par valve Ces 5 common stock (5.01 par valve Additional paldinapital Treasury stock Accumulated other comprehensive income loss Accumulated earnings deficit) Total stockholders equity Total liabilities and stockholders equity $510.40 330.7 2945 103.2 477.8 289.B 292.6 86.2 459.1 337.4 284.6 89.1 $569.50 3511 401 87.7 $45420 348.3 332.9 86.6 $535.80 $395.10 312.2 387.1 3112 293.2 842 $452.50 378.5 414.8 15.2 $382.80 342.4 370.1 15.2 11.6 570.7 S423.20 317.8 369.8 21.4 10.9 570.8 $361.50 338. 3475 21.4 10 563.1 $543.30 3246 449.2 20 10.3 585.8 $337.10 263 400.3 20 10.2 581.5 $436.10 257.5 406.1 20 10 5815 $376.90 268. 400.9 20 10.5 511 1.238.00 4 180.00 613.1 1146.6 4249.1 599.1 11802 4277.4 594.4 1,409.40 4.220.10 578.9 1.222.20 4.244.10 573.1 1243.40 4.202.60 536.8 1.158.40 4840.30 516.7 1328.10 4.707.30 493.2 1.933.20 4 733.40 9.5 4.913.30 549.7 1.692.80 4.737.70 117 4 526,60 5616 45.8 1882 12.169.70 5384 47.4 530.9 49.6 903.8 7,692.70 553.3 25.6 725.5 7.338.30 545.9 45.9 746.6 7834.2 571.4 443 963 7.561.50 1.711.20 5.498.00 83.9 4.744.40 5463 43.2 220 12.347.00 5677 443 980.7 8108. 10 158820 5.303.80 842 4 909.40 542 43.4 240.6 13.211.60 575 48.5 937.5 7,500.40 1713.90 1.647.20 4 713.10 4.710.10 109.4 29.5 4.252.00 4.857.60 557.7 5533 51.7 49.8 192 190 12. 189.80 12.098.00 1.612.10 5.020.80 85 4.784.30 550.4 47.7 212 123 12.3 564 41.6 963.1 8,097.30 195.9 12.461 80 7485. 1.1 0.6 0.5 05 0.5 0.5 0.5 0.5 0.5 0.6 0.8 0.B 0.B 0.5 0.5 0.5 2.237.80 2240.3 2240 2.241.60 2.242.90 2.247.00 1994.50 1998.4 2.001.70 - 17.2 -482 -482 -56.4 -56.4 -56.4 -56.4 -4.4 72.1 105.8 125.6 140.5 33.5 25 5.5 -19.4 366.5 163.6 94.5 -207.9 -251.7 -255.5 -710.6 - 550.9 -623.4 2,600.60 2476.7 2424.4 2.112.40 2.084.30 1969.90 1.254.50 1397.60 1.303.50 $9.940.00 $9.811.70 59.910.70 59.805.90 $9,585.70 $9.531.80 $9,363.00 $9.495.80 $13.473.20 0.5 0.5 0.5 0.5 0.5 0.5 0.5 0.5 0.5 0.5 0.5 0.5 2.006.80 2,008.90 2.001.00 2.003.60 2.007 30 2.125.00 -56.4 -56.4 -56.4 -56.4 -56.4 - 56.4 - 28.6 -119.6 -63.6 -4.387.00 -597.7 -6735 -7062 -2.902.60 -3.463.70 -2.370.00 1325.10 1 183.30 1. 214.00 -1.074.00 -1.575.40 -2.335.40 $13.514.90 $13,281.30 $13.675.30 $11238.30 $1127150 S 10.575.20 Statement of Cash Flows Operating Cash Flow 12/31/2017 12/31/2018 12/31/2019 TTM 558,700 523,200 579.000 -402.800 110.000 -184 100 -30.500 Net Income from Continuing Operations Operating Gains Losses Gain Loss On Sale of Business Gain Loss On Investment Securities Earnings Losses from Equity Investments Pension And Employee Benefit Expense Deprecation Amortization Depletion Deferred Tax Asset impairment Charge Stock based compensation Other non-cash items Change in working capital Change in Receivables Change in Payables And Acer ued Expense Change in Payable Change in Accrued Expense Change in Other Current Assets Cash Flow from Continuing Operating Activities -2.500 5.400 -2,600 -3.900 600 538 800 157 800 251 500 5,700 -142.100-3,656.800 -2.200 168 300 0 - - 5.300 118.500 2.700 53,200 1.700 1.200 450.000 472.600 -33,700 24.500 34.300 2.132.100 4.400 2.400 89.500 117,700 135,800 350.400 700 72.200 104.200 156. 300 104.300 84.300 -500 72.000 30.900 101.400 579.000 -111.400 -40.000 1.100 537,300 -6,400 29.800 14800 38.300 -17,700 -200 - 17.100 -85,600 62.500 -400 523,200 99,700 -5,000 -36.600 13.300 34,700 -21,400 18 300 558,700 402.300 Investing Cash Flow -965 200 -317 200 - 515 100 -322.500 Capital Expenditure Reported Net Business Purchase And Sale Purchase of Business Sale of Business Net Other Investing Changes Cash Flow from Continuing investing Activities -625,800 -496,400 -583,500 98.200 158.000 -965,200 -576,300 196.900 0 208 300 62,200 -518 100-325.900 -21.500 -9.500 - 11.300 0 23.500 12.900 -516.100 -322.500 -317 200 Financing Cash Flow 492 300 -194.800 - 112.000 1,042.500 54.200 54 200 525.900 525.900 0 - 15,600 1,043,600 - 15.500 1,043,600 0 2.300 Netissuance Payments of Debt Net Long Term Debt Issuance Net Short Term Debt Issuance Common Stock Issuance Common Stock Payments Cash Dividends Paid Common Stock Dividend Paid Net Other Financing Charges Cash Flow from Continuing Financing Activities 616.800 - 34,000 - 104.500 -104.600 -445.400 -258 100 -258 100 -17.00 -194.800 - 34 100 -25.000 - 34 100 -25.000 - 13.200 21.100 - 112.900 1,042.500 492 300 End Cash Position Changes in Cash 310,000 35,800 524.000 11.200 275,500 - 50.000 427,300 317,200 Trailing 12 months
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started