fin-550 calc
vashurov13
3-1cals1.xlsx3-1 Question 1
| Assignment 3-1, Question 1 | |||||||
| 1a. Calculate the value of the stock today: | |||||||
| 1. Calculate the PV of the dividends paid during the supernatural growth period: | |||||||
| $ | % | $ | |||||
| D1= | 1.15 | x | 1.15 | = | 1.3225 | ||
| D2= | $1.32 | x | 1.15 | = | $1.52 | ||
| D3= | $1.52 | x | 1.13 | = | $1.72 | ||
| D4= | $1.72 | x | 1.06 | = | $1.82 | ||
| PV of Dividends = | 1.1808035714 | + | $1.21 | + | $1.22 | ||
| 1.3225 | 1.5209 | ||||||
| 1.12 | 1.12^2 | etc | |||||
| 2. Find the PV of Turbo's stock price at the end of Year 3: | |||||||
| P3^ = | ____D4____ | = | __ _D3(1+g)______ | ||||
| rs-g | rs-g | ||||||
| = | H12/(1.12-.06) | ||||||
| = | 30.3617345833 | ||||||
| PV of P3^ = | = | 30.3617345833 | |||||
| PV of P3^ | 30.36 | ||||||
| 1.12^3 | |||||||
| 3. Sum the two components to find the value of the stock today: | |||||||
| Value of current stock (P0) = | $3.62 | + | 21.6108829658 | = | $25.23 | ||
| 1b. Calculate P1^ and P2^. | |||||||
| P1^ = | $1.36 | + | $1.37 | + | 24.20 | = | $26.93 |
| P2^ = | $1.53 | + | 27.1086915923 | = | $28.64 | ||
| 1c. Calculate the dividend yields and capital gains yield for Years 1, 2, and 3. | |||||||
| Year | Dividend Yield | + | Capital Gains Yield | = | Total Return | ||
| 1 | $1.3225/$25.23 ≈ 5.24% | + | ($26.93 - $25.23) / $25.23 ≈ 6.74% | ≈ | 12% | ||
| 2 | 5.65% | + | 6.35% | ≈ | 12.00% | ||
| 3 | 6.36% | + | 5.64% | ≈ | 12.00% |
3-1 Question 2
| Assignment 3-1, Question 2 | ||
| Dividend, D | = | $ 5.00 |
| market price Sp | = | $ 50.00 |
| rps | = | 10% |
3-1 Question 3
| Assignment 3-1, Question 3 | |||||
| 3a. Calculate McCaffrey's value of operations. | |||||
| Vop = | FCF(1+g) | = | 100000*(1+7%)/(11%-7%) | = | $ 2,675,000 |
| WACC - g | |||||
| 3b. Calculate the company's total value. | |||||
| Total Value = | Value of Operations | + | Value of nonoperating assets | ||
| = | $ 2,675,000 | + | $ 325,000.00 | = | $ 3,000,000.00 |
| 3c. Calculate the estimated value of common equity. | |||||
| Value of equity = | Total value | - | Value of debt | ||
| = | $ 3,000,000.00 | - | 1,000,000.00 | = | $ 2,000,000.00 |
| 3d. Calculate the estimated per-share stock price. | |||||
| Price per share = | Value of Equity | ÷ | Number of Shares | ||
| = | $ 2,000,000.00 | ÷ | $ 50,000.00 | = | 40.00 |
5-2 Question 1
| Assignment 5-2, Question 1 | |||||||||||
| a. | |||||||||||
| Net Present Value (NPV): | |||||||||||
| NPVx = | -$10,000 | + | $ | + | $ | + | $ | + | $ | = | $ |
| NPVy = | -$10,000 | + | $ | + | $ | + | $ | + | $ | = | $ |
| Internal Rate of Return (IRR): | |||||||||||
| To solve for each project's IRR, find the discount rates that equate each NPV to zero: | |||||||||||
| IRRx | = | % | |||||||||
| IRRy | = | % | |||||||||
| Modified Internal Rate of Return (MIRR): | |||||||||||
| To obtain each project's MIRR, begin by finding each project's terminal value (TV) of cash inflows: | |||||||||||
| TVx | = | $6,500 (1.12)^3 | + | $ | + | $ | + | $1,000 | = | $ | |
| TVy | = | $ | + | $ | + | $ | + | $3,500 | = | $ | |
| Now, each project's MIRR is the discount rate that equates the PV of the TV to each project's cost, $10,000: | |||||||||||
| MIRRx | = | % | |||||||||
| MIRRy | = | % | |||||||||
| Profitability Index (PI): | |||||||||||
| To obtain each project's PI, divide its present value of future cash flows by its initial cost. The PV of future cash flows can be found from the NPV calculated earlier: | |||||||||||
| PVx | = | NPVx | + | Cost of X | |||||||
| = | $ | + | $10,000 | = | $ | ||||||
| PVy | = | NPVy | + | Cost of Y | |||||||
| = | $ | + | $ | = | $ | ||||||
| PIx | = | PVx | ÷ | Cost of X | |||||||
| = | $ | ÷ | $ | = | |||||||
| PIy | = | PVy | ÷ | Cost of Y | |||||||
| = | $ | ÷ | $ | = |
