In: Finance
Brawn Industries is considering an investment project that has the following cash flows:
YEAR CASH FLOW
0
-1,000
1
400
2 300
3
500
4 400
The company's WACC is 10%.
What is the projects regular payback, IRR, and NPV? (You must show
your work)
Group of answer choices
Project | |||||
Year | Cash flow stream | Cumulative cash flow | |||
0 | -1000 | -1000 | |||
1 | 400 | -600 | |||
2 | 300 | -300 | |||
3 | 500 | 200 | |||
4 | 400 | 600 | |||
Payback period is the time by which undiscounted cashflow cover the intial investment outlay | |||||
this is happening between year 2 and 3 | |||||
therefore by interpolation payback period = 2 + (0-(-300))/(200-(-300)) | |||||
2.6 Years | |||||
Project | |||||
IRR is the rate at which NPV =0 | |||||
IRR | 0.212249384 | ||||
Year | 0 | 1 | 2 | 3 | 4 |
Cash flow stream | -1000 | 400 | 300 | 500 | 400 |
Discounting factor | 1 | 1.212249 | 1.469549 | 1.781459 | 2.159573 |
Discounted cash flows project | -1000 | 329.9651 | 204.1443 | 280.6688 | 185.2218 |
NPV = Sum of discounted cash flows | |||||
NPV Project = | 1.38284E-06 | ||||
Where | |||||
Discounting factor = | (1 + IRR)^(Corresponding period in years) | ||||
Discounted Cashflow= | Cash flow stream/discounting factor | ||||
IRR= | 21.22% | ||||
Project | |||||
Discount rate | 0.1 | ||||
Year | 0 | 1 | 2 | 3 | 4 |
Cash flow stream | -1000 | 400 | 300 | 500 | 400 |
Discounting factor | 1 | 1.1 | 1.21 | 1.331 | 1.4641 |
Discounted cash flows project | -1000 | 363.6364 | 247.9339 | 375.6574 | 273.20538 |
NPV = Sum of discounted cash flows | |||||
NPV Project = | 260.43 | ||||
Where | |||||
Discounting factor = | (1 + discount rate)^(Corresponding period in years) | ||||
Discounted Cashflow= | Cash flow stream/discounting factor | ||||