In: Finance
Gio's Restaurants is considering a project with the following expected cash flows: . If the project's appropriate discount rate is 11 percent, what is the project's discounted payback period?
YEAR |
PROJECT CASH FLOW |
||
0 |
−$240240 |
million |
|
1 |
100100 |
million |
|
2 |
6060 |
million |
|
3 |
100100 |
million |
|
4 |
100100 |
million |
Computation of discounted payback period | |||||||
year | Cash flow | PVIF @ 11% | Present value | Cumulative present value | |||
0 | -240240 | 1 | (240,240) | (240,240) | |||
1 | 100100 | 0.900901 | 90,180 | (150,060) | |||
2 | 6060 | 0.811622 | 4,918 | (145,141) | |||
3 | 100100 | 0.731191 | 73,192 | (71,949) | |||
4 | 100100 | 0.658731 | 65,939 | (6,010) | |||
Since, cumulative present value if not positive at the end of the project duration (4 year) | |||||||
Therefore project will not have any discounted payback period. | |||||||
answer = Undeterminable | |||||||