In: Finance
A firm with a current value (cost) of $800 and will return $1,000 next year. The firm also has a potential project that costs $500 and will return $550 next year, but the firm does not have the money to invest and must raise it from outside investors. However, outside investors mistakenly believe the firm will be worth $820 in one year without the project and $13,030 with the project. For simplicity, assume a zero discount rate. Does the project have a positive NPV? Acting on behalf of existing shareholders, should you take the project?
| A | B | C | D | E | F | G | H | I | J | K | L |
| 2 | |||||||||||
| 3 | NPV calculation: | ||||||||||
| 4 | NPV of the project is present value of future cash flows discounted at required rate of return less the initial investment. | ||||||||||
| 5 | |||||||||||
| 6 | Year | 0 | 1 | ||||||||
| 7 | Free Cash Flow (FCF) | ($500) | $550 | ||||||||
| 8 | Required rate of return (i) | 0% | |||||||||
| 9 | (P/F,i,n) for each year | 1.00 | =1/((1+$D8)^E6) | ||||||||
| 10 | Present Value of cash flows = FCF*(P/F,i,n) | $550.00 | |||||||||
| 11 | Present value if future cash flows | $550.00 | =SUM(E10:I10) | ||||||||
| 12 | |||||||||||
| 13 | NPV for Project | =Present value fo future cash flows - Initial investment | |||||||||
| 14 | =$550-$500 | ||||||||||
| 15 | $50 | =D11+D7 | |||||||||
| 16 | |||||||||||
| 17 | Hence NPV of the project is | $50 | |||||||||
| 18 | |||||||||||
| 19 | A project with positive NPV add value to the firm. | ||||||||||
| 20 | Since the NPV of the project is positive therefore the project should be accepted by the shareholders. | ||||||||||
| 21 | |||||||||||