Could someone please tell me what to do with this question? Does this mean that I have to do an NPV? Is there anything else I have to do? Thanks

Excel

10 marks. Value Disney using the discounted free cash flow methodology (Max 1 page) i. Assume that Disney's 1. Cost of Equity is 10% 2. Cost of Debt is 1% higher than 12-month US Treasuries 3. Tax rate is 25% ii. Please clearly state your assumptions iii. Please do your FCF forecast from 2020-2021 and then calculate a terminal value The date is November 7, 2019 (do not use data after that date) unless otherwise specified. e.g. don't include the pandemic in your analysis unless otherwise specified. 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