In: Finance
Hi,
Can you please solve this correctly?
With interest at 10%, what is the benefit-cost ratio for this government project?
Initial Cost | $205454 |
Additional costs at the end of year 1 and year 2 | $34758/year |
Benefits at end of year 1 and year 2 | $0/year |
Annual benefits at end of year 3 through year 10 | $103447/year |
Enter your answer as follow: 12.34
Benefit cost ratio = sum of the present value of the benefits associated with a project / sum of the present value of the costs associated with a project. | |||||||||||||||
Calculation of sum of the present value of the benefits associated with a project | Calculation of sum of the present value of the benefits associated with a project | ||||||||||||||
Year | Benefits | Discount factor @ 10% | Present Value | Year | Costs | Discount factor @ 10% | Present Value | ||||||||
0 | $0.00 | 1 | $0.00 | 0 | $205,454.00 | 1 | $205,454.00 | ||||||||
1 | $0.00 | 0.909091 | $0.00 | 1 | $34,758.00 | 0.909091 | $31,598.18 | ||||||||
2 | $0.00 | 0.826446 | $0.00 | 2 | $34,758.00 | 0.826446 | $28,725.62 | ||||||||
3 | $103,447.00 | 0.751315 | $77,721.26 | 3 | $0.00 | 0.751315 | $0.00 | ||||||||
4 | $103,447.00 | 0.683013 | $70,655.69 | 4 | $0.00 | 0.683013 | $0.00 | ||||||||
5 | $103,447.00 | 0.620921 | $64,232.45 | 5 | $0.00 | 0.620921 | $0.00 | ||||||||
6 | $103,447.00 | 0.564474 | $58,393.13 | 6 | $0.00 | 0.564474 | $0.00 | ||||||||
7 | $103,447.00 | 0.513158 | $53,084.67 | 7 | $0.00 | 0.513158 | $0.00 | ||||||||
8 | $103,447.00 | 0.466507 | $48,258.79 | 8 | $0.00 | 0.466507 | $0.00 | ||||||||
9 | $103,447.00 | 0.424098 | $43,871.63 | 9 | $0.00 | 0.424098 | $0.00 | ||||||||
10 | $103,447.00 | 0.385543 | $39,883.30 | 10 | $0.00 | 0.385543 | $0.00 | ||||||||
Sum of the present value of the benefits associated with a project | $456,100.92 | Sum of the present value of the costs associated with a project | $265,777.80 | ||||||||||||
Benefit cost ratio = $4,56,100.92 / $2,65,777.80 = 1.72 | |||||||||||||||