In: Finance
A project has the following cash flow.
Years |
Costs |
Benefits |
0 |
$10,000 |
0 |
1 |
$1,000 |
$5,000 |
2 |
$1,000 |
$5,000 |
3 |
$2,000 |
$6,000 |
4 |
$20,000 |
$3,000 a) Find net present value b) Discounted Benefit-Cost Ratio c)Net discounted Benefit-Cost Ratio discount ratio is 10% |
Year | Cost | Benefits | Total | DF | PV |
0 | $ -10,000.00 | $ - | $ -10,000.00 | 1 | $ -10,000.00 |
1 | $ -1,000.00 | $ 5,000.00 | $ 4,000.00 | 0.900901 | $ 3,603.60 |
2 | $ -1,000.00 | $ 5,000.00 | $ 4,000.00 | 0.811622 | $ 3,246.49 |
3 | $ -2,000.00 | $ 6,000.00 | $ 4,000.00 | 0.731191 | $ 2,924.77 |
4 | $ -20,000.00 | $ 3,000.00 | $ -17,000.00 | 0.658731 | $ -11,198.43 |
NPV | $ -11,423.57 |
Year | Cost | Benefits | Total | DF | PV | DV Benefit | DV costs | |
0 | $ -10,000.00 | $ - | $ -10,000.00 | 1 | $ -10,000.00 | $ - | $ -10,000.00 | |
1 | $ -1,000.00 | $ 5,000.00 | $ 4,000.00 | 0.900901 | $ 3,603.60 | $ 4,504.50 | $ -900.90 | |
2 | $ -1,000.00 | $ 5,000.00 | $ 4,000.00 | 0.811622 | $ 3,246.49 | $ 4,058.11 | $ -811.62 | |
3 | $ -2,000.00 | $ 6,000.00 | $ 4,000.00 | 0.731191 | $ 2,924.77 | $ 4,387.15 | $ -1,462.38 | |
4 | $ -20,000.00 | $ 3,000.00 | $ -17,000.00 | 0.658731 | $ -11,198.43 | $ 1,976.19 | $ -13,174.62 | |
NPV | $ -11,423.57 | $ 14,925.96 | $ 26,349.53 | |||||
Ratio | 0.566460213 | |||||||
Net benefits cost ratio | -0.43353979 |