Could someone give me some tips or some bullet points? Do I just have to do something like EV/EBITDA, LTM EBITDA or anything else?
Here are some excel sheets.
10 marks. Value Disney using the comparables methodology (Max 1 page) 4 B E Sep-30-2017 102.74 Disney Sep-29-2018 113.03 Share price ($) Sep-28-2019 146.93 Earnings per share ($) 5.69 8.36 6.64 Common shares outstanding (millions) Market value of equity ($millions) Book value of equity ($millions) Book value per share ($) Market to book ratio Total enterprise value ($millions)* Enterprise value / revenue Enterprise value / EBITDA Enterprise value / EBIT Price / Earnings 1,578 162,124 41,315 26.18 3.9 188,852 3.4 11.3 13.5 18.1 1,507 170,336 48,773 32.36 3.5 193,607 3.3 10.8 13.0 13.5 1,666 244,785 88,877 53.35 2.8 302,231 4.3 18.8 25.3 22.1 3-month Treasury Bill yield 6-month Treasury Bill yield 12-month Treasury Bill yield 1.05% 0.42% 0.58% 2.14% 2.31% 2.58% 1.76% 1.85% 1.78% Real U.S. GDP Growth (year-over-year) 2.22% 2.86% P/E Ratios: S&P 500 NASDAQ Composite 23.7 49.8 21.3 19.2 21.7 31.5 A B Disney Sep-29-2018 Sep-28-2019 Sep-30-2017 Cash flow from operating activities: Net Income Depreciation & Amortization Change in Working Capital Other Operating Activities Cash from Operation 8.980.0 2,782.0 (266.0) 847.0 12,343.0 12,598.0 3,011.0 (502.0) (812.0) 14,295.0 11,054.0 4,160.0 23.0 (8,631.0) 6,606.0 (3,623.0) (4,465.0) (4,876.0) Cash from investing acitvities: Capital Expenditure Sale of Property, Plant, & Equipment Cash Acquisitions Other Investing Activities Cash from Investing (417.0) (71.0) (4,111.0) (1,881.0) 710.0 (5,636.0) (9,901.0) 10,659.0 (4,118.0) 3,677.0 318.0 Cash flow from financing activities: Increase (Decrease) in Debt Issuance of Common Stock Repurchase of Common Stock Total Dividends Paid Other Financing Activities Cash from Financing 3,703.0 276.0 (9,368.0) (2,445.0) (1,125.0) (8,959.0) (2,583.0) 210.0 (3,577.0) (2,515.0) (378.0) (8,843.0) (2.895.0) (2,190.0) (1,090.0) Foreign Exchange Rate Adjusted Net Change in Cash 31.0 (696.0) (25.0) (209.0) (98.0) 1,300.0 Disney Sep-30-2017 Sep-29-2018 Sep-28-2019 55,137.0 59,434.0 69,570.0 Total Revenue 30,191.0 24,946.0 8,176.0 32,726.0 26,708.0 8,860.0 42,018.0 27,552.0 11,438.8 2,782.0 3,011.0 4,160.0 Cost Of Goods Sold Gross Profit Selling General & Admin Expenses R & D Expenses Depreciation & Amortization Other Operating Expenses (Income) Operating Income (EBIT) Net Interest Exp. Other Non-Operating Income (Expenses) Other Unusual Items Income Tax Expense Earnings Of Discontinued Operations Net Income to Company Minority Int. in Earnings Net Income 13,988.0 (412.0) 320.0 (108.0) (4,422.0) 14,837.0 (574.0) (102.0) 568.0 (1,663.0) 11,953.2 (980.0) (103.0) 3073.8 (3,031.0) 613.0 11526.0 (472.0) 11,054.0 9366.0 (386.0) 8.980.0 13066.0 (468.0) 12,598.0 Weighted Avg. Diluted Shares Out. (mil) Dividends per Share 1,578.0 $1.62 1,507.0 $1.72 1,666.0 $1.76 A B Disney Sep-30-2017 Sep-29-2018 Sep-28-2019 ASSETS Cash & Short-term Investments Accounts Receivables Inventory Prepaid Exp. and Other Current Assets Total Current Assets 4,017.0 8,633.0 2,651.0 588.0 15,889.0 4,150.0 9,334.0 2,706.0 635.0 16,825.0 5,418.0 15,481.0 6,246.0 979.0 28,124.0 Gross Property, Plant, & Equipment Less Accumulated Depreciation Net Property, Plant, & Equipment Long-term Investments Goodwill and Other Intangibles Other Long-Term Assets Total Assets 57,443.0 (29,037.0) 28,406.0 3,202.0 38,421.0 9,871.0 95.789.0 60,304.0 (30,764.0) 29,540.0 2,899.0 38,081.0 11,253.0 98,598.0 64,018.0 (32,415.0) 31,603.0 3,224.0 103,508.0 27,525.0 193,984.0 17,942.0 LIABILITIES Accounts Payable Accrued Expenses Other Current Liabilities Total Current Liabilities 6,305.0 1,819.0 8,699.0 16,823.0 6,503.0 2,189.0 8,163.0 16,855.0 8,237.0 26,179.0 Interest Bearing Debt Other Non-Current Liabilities Total Liabilities 21,891.0 10,923.0 49,637.0 18,089.0 9,699.0 44,643.0 43,471.0 21,482.0 91,132.0 Total Common Equity 41,315.0 48,773.0 88,877.0 Minority Interest 4,837.0 5,182.0 13,975.0 Total Equity 46,152.0 53,955.0 102,852.0 Total Liabilities And Equity 95.789.0 98,598.0 193,984.0 10 marks. Value Disney using the comparables methodology (Max 1 page) 4 B E Sep-30-2017 102.74 Disney Sep-29-2018 113.03 Share price ($) Sep-28-2019 146.93 Earnings per share ($) 5.69 8.36 6.64 Common shares outstanding (millions) Market value of equity ($millions) Book value of equity ($millions) Book value per share ($) Market to book ratio Total enterprise value ($millions)* Enterprise value / revenue Enterprise value / EBITDA Enterprise value / EBIT Price / Earnings 1,578 162,124 41,315 26.18 3.9 188,852 3.4 11.3 13.5 18.1 1,507 170,336 48,773 32.36 3.5 193,607 3.3 10.8 13.0 13.5 1,666 244,785 88,877 53.35 2.8 302,231 4.3 18.8 25.3 22.1 3-month Treasury Bill yield 6-month Treasury Bill yield 12-month Treasury Bill yield 1.05% 0.42% 0.58% 2.14% 2.31% 2.58% 1.76% 1.85% 1.78% Real U.S. GDP Growth (year-over-year) 2.22% 2.86% P/E Ratios: S&P 500 NASDAQ Composite 23.7 49.8 21.3 19.2 21.7 31.5 A B Disney Sep-29-2018 Sep-28-2019 Sep-30-2017 Cash flow from operating activities: Net Income Depreciation & Amortization Change in Working Capital Other Operating Activities Cash from Operation 8.980.0 2,782.0 (266.0) 847.0 12,343.0 12,598.0 3,011.0 (502.0) (812.0) 14,295.0 11,054.0 4,160.0 23.0 (8,631.0) 6,606.0 (3,623.0) (4,465.0) (4,876.0) Cash from investing acitvities: Capital Expenditure Sale of Property, Plant, & Equipment Cash Acquisitions Other Investing Activities Cash from Investing (417.0) (71.0) (4,111.0) (1,881.0) 710.0 (5,636.0) (9,901.0) 10,659.0 (4,118.0) 3,677.0 318.0 Cash flow from financing activities: Increase (Decrease) in Debt Issuance of Common Stock Repurchase of Common Stock Total Dividends Paid Other Financing Activities Cash from Financing 3,703.0 276.0 (9,368.0) (2,445.0) (1,125.0) (8,959.0) (2,583.0) 210.0 (3,577.0) (2,515.0) (378.0) (8,843.0) (2.895.0) (2,190.0) (1,090.0) Foreign Exchange Rate Adjusted Net Change in Cash 31.0 (696.0) (25.0) (209.0) (98.0) 1,300.0 Disney Sep-30-2017 Sep-29-2018 Sep-28-2019 55,137.0 59,434.0 69,570.0 Total Revenue 30,191.0 24,946.0 8,176.0 32,726.0 26,708.0 8,860.0 42,018.0 27,552.0 11,438.8 2,782.0 3,011.0 4,160.0 Cost Of Goods Sold Gross Profit Selling General & Admin Expenses R & D Expenses Depreciation & Amortization Other Operating Expenses (Income) Operating Income (EBIT) Net Interest Exp. Other Non-Operating Income (Expenses) Other Unusual Items Income Tax Expense Earnings Of Discontinued Operations Net Income to Company Minority Int. in Earnings Net Income 13,988.0 (412.0) 320.0 (108.0) (4,422.0) 14,837.0 (574.0) (102.0) 568.0 (1,663.0) 11,953.2 (980.0) (103.0) 3073.8 (3,031.0) 613.0 11526.0 (472.0) 11,054.0 9366.0 (386.0) 8.980.0 13066.0 (468.0) 12,598.0 Weighted Avg. Diluted Shares Out. (mil) Dividends per Share 1,578.0 $1.62 1,507.0 $1.72 1,666.0 $1.76 A B Disney Sep-30-2017 Sep-29-2018 Sep-28-2019 ASSETS Cash & Short-term Investments Accounts Receivables Inventory Prepaid Exp. and Other Current Assets Total Current Assets 4,017.0 8,633.0 2,651.0 588.0 15,889.0 4,150.0 9,334.0 2,706.0 635.0 16,825.0 5,418.0 15,481.0 6,246.0 979.0 28,124.0 Gross Property, Plant, & Equipment Less Accumulated Depreciation Net Property, Plant, & Equipment Long-term Investments Goodwill and Other Intangibles Other Long-Term Assets Total Assets 57,443.0 (29,037.0) 28,406.0 3,202.0 38,421.0 9,871.0 95.789.0 60,304.0 (30,764.0) 29,540.0 2,899.0 38,081.0 11,253.0 98,598.0 64,018.0 (32,415.0) 31,603.0 3,224.0 103,508.0 27,525.0 193,984.0 17,942.0 LIABILITIES Accounts Payable Accrued Expenses Other Current Liabilities Total Current Liabilities 6,305.0 1,819.0 8,699.0 16,823.0 6,503.0 2,189.0 8,163.0 16,855.0 8,237.0 26,179.0 Interest Bearing Debt Other Non-Current Liabilities Total Liabilities 21,891.0 10,923.0 49,637.0 18,089.0 9,699.0 44,643.0 43,471.0 21,482.0 91,132.0 Total Common Equity 41,315.0 48,773.0 88,877.0 Minority Interest 4,837.0 5,182.0 13,975.0 Total Equity 46,152.0 53,955.0 102,852.0 Total Liabilities And Equity 95.789.0 98,598.0 193,984.0
