In: Finance
How do we justify this discount rate? Why are these the numbers? Thank you.
DISNEY CORPORATION PROSPECTIVE FINANCIAL STATEMENT AFTER ACQUISITION | |||||||||||||||||||
INCOME STATEMENT | BALANCE SHEET ACQUISITION PROSPECT | ||||||||||||||||||
$ | millions | current assets | $ | million | |||||||||||||||
revenue | $55,137.00 | cash & cash equivalent | $4,017.00 | ||||||||||||||||
cost of revenue | $30,306.00 | receivable | $7,826.00 | ||||||||||||||||
gross profit | $24,831.00 | inventories | $1,373.00 | ||||||||||||||||
sales, general and administrative | $8,176.00 | deferred income tax | $0.00 | ||||||||||||||||
restrcuturing, merger & acquisition | $98.00 | prepaid expenses | $445.00 | ||||||||||||||||
other operating expenses | $2,684.00 | other current assets | $2,228.00 | ||||||||||||||||
Total operating expenses | $10,958.00 | Total current assets | $15,889.00 | ||||||||||||||||
operating income | $13,873.00 | noncurrent asset | |||||||||||||||||
interest expense | $507.00 | gross property, plant & equipment | $57,443.00 | ||||||||||||||||
other income(expense) | $422.00 | accumulated depreciation | -$29,037.00 | ||||||||||||||||
income before tax | $13,788.00 | net property, plant & equipment | $28,406.00 | ||||||||||||||||
provision for income tax | $4,422.00 | equity & other investment | $3,202.00 | ||||||||||||||||
net income from contribution | $9,366.00 | goodwill | $31,426.00 | ||||||||||||||||
others | -$386.00 | intangibel assets | $14,476.00 | ||||||||||||||||
Net income | $8,980.00 | other long term assets | $2,390.00 | ||||||||||||||||
Total noncurrent assets | $79,900.00 | ||||||||||||||||||
current liabilities | |||||||||||||||||||
NOTE | short termdebt | $6,172.00 | |||||||||||||||||
The financial statement account for possibility of acquisition of Century Fox probably late 2018 or | account payable | $6,490.00 | |||||||||||||||||
early 2019 | accrued liabilities | $2,365.00 | |||||||||||||||||
stakeholder equity shifted from | deferred revenues | $4,568.00 | |||||||||||||||||
Total current liabilities | $19,595.00 | ||||||||||||||||||
quotation review of stock price changes | noncurrent liabilities | ||||||||||||||||||
prevailing price $100.35 closing by 1.72% equating to $104.96 | long term debt | $19,119.00 | |||||||||||||||||
deferred tax liabilities | $4,480.00 | ||||||||||||||||||
discount count rate estimation at 14.50% | pensions and other benefits | $3,281.00 | |||||||||||||||||
minority interest | $3,689.00 | ||||||||||||||||||
potential change = (0.145 + 1)^1 * 100.35= 114.9 | other long term liabilities | $621.00 | |||||||||||||||||
Total noncurrent liabilities | $31,190.00 | ||||||||||||||||||
Total liabilities | $50,785.00 | ||||||||||||||||||
stockholders equity | |||||||||||||||||||
common stock | $36,248.00 | ||||||||||||||||||
retained earnings | $72,606.00 | ||||||||||||||||||
treasury stock | -$64,011.00 | ||||||||||||||||||
accummulated other components | -$3,528.00 | ||||||||||||||||||
Total stockholders equity | $41,315.00 | ||||||||||||||||||
Total liabilities and stockholders equity | $92,100.00 | ||||||||||||||||||
Year | Value | DPSt or Terminal value (TVt) | Calculation | Present value at 14.50% | |||||||||||||||
0 | DPS01 | 1.56 | |||||||||||||||||
1 | DPS1 | 1.77 | = 1.56 × (1 + 13.25%) | 1.54 | |||||||||||||||
2 | DPS2 | 2 | = 1.77 × (1 + 13.13%) | 1.52 | |||||||||||||||
3 | DPS3 | 2.26 | = 2.00 × (1 + 13.00%) | 1.50 | |||||||||||||||
4 | DPS4 | 2.55 | = 2.26 × (1 + 12.87%) | 1.48 | |||||||||||||||
5 | DPS5 | 2.87 | = 2.55 × (1 + 12.75%) | 1.46 | |||||||||||||||
5 | Terminal value (TV5) | 184.89 | = 2.87 × (1 + 12.75%) ÷ (14.50% – 12.75%) | 93.94 | |||||||||||||||
Intrinsic value of Disney's common stock (per share) | $101.45 | ||||||||||||||||||
Current share price | $100.35 |
The discount rate estimation is based upon the cost of capital of the company. This is given to be 14.5%
The year 1 dividend = $1.77 calculated as D0*(1+13.25%) meaning the dividend grows at a rate of 13.25% in the first year. This is discounted back to present value using the formula D1/(1+r)^1
The year 2 dividend = $2 calculated as D1*(1+13.13%) meaning the dividend grows at a rate of 13.13% in the second year. This is discounted back to present value using the formula D2/(1+r)^2
The year 3 dividend = $2.26 calculated as D2*(1+13%) meaning the dividend grows at a rate of 13% in the third year. This is discounted back to present value using the formula D3/(1+r)^3
The year 4 dividend = $2.55 calculated as D3*(1+12.87%) meaning the dividend grows at a rate of 12.87% in the 4th year. This is discounted back to present value using the formula D4/(1+r)^4
The year 5 dividend = $2.87 calculated as D4*(1+12.75%) meaning the dividend grows at a rate of 12.75% in the 5th year. This is discounted back to present value using the formula D5/(1+r)^5
Intrinsic value of the stock is calculated as D6/(k-g)
Since g= 12.75%
Intrinsic value= 2.87*(1+12.75%)/(14.5%-12.75%) = $184.89. This is discounted as Intrinsic value/ (1+r)^5
Sum of all the discounted values of cash flows is the price of the stock.