eco assignment

profileshazuanzhe
Costbenefitanalysis1.xlsx
Home>Business & Finance homework help>Economics homework help>eco assignment

Sheet1

Year Cost Benefit B-C Discounted Discount rate
0 10,000,000.00 0 (10,000,000.00) (10,000,000.00) 0.05
1 50,000.00 1,000,000.00 950,000.00 904,761.90
2 600,000.00 1,150,000.00 550,000.00 498,866.21
3 1,150,000.00 1,322,500.00 172,500.00 149,011.99
4 1,700,000.00 1,520,875.00 (179,125.00) (147,366.58)
5 2,250,000.00 1,749,006.25 (500,993.75) (392,541.71)
6 2,800,000.00 2,011,357.19 (788,642.81) (588,497.41)
7 3,350,000.00 2,313,060.77 (1,036,939.23) (736,933.35)
8 3,350,000.00 2,660,019.88 (689,980.12) (467,005.70)
9 3,350,000.00 3,059,022.86 (290,977.14) (187,566.46)
10 3,350,000.00 3,517,876.29 167,876.29 103,061.48
11 3,350,000.00 4,045,557.74 695,557.74 406,678.20
12 3,350,000.00 4,652,391.40 1,302,391.40 725,220.26
13 3,350,000.00 5,350,250.11 2,000,250.11 1,060,775.34
14 3,350,000.00 5,350,250.11 2,000,250.11 1,010,262.23
15 3,350,000.00 5,350,250.11 2,000,250.11 962,154.50
16 3,350,000.00 5,350,250.11 2,000,250.11 916,337.62
17 3,350,000.00 5,350,250.11 2,000,250.11 872,702.50
18 3,350,000.00 5,350,250.11 2,000,250.11 831,145.23
19 3,350,000.00 5,350,250.11 2,000,250.11 791,566.89
20 3,350,000.00 5,350,250.11 2,000,250.11 753,873.23
NPV (2,533,493.64)