Building a Bridge - 3

You are the project manager of a construction company. You are considering building a bridge across the river. You estimate that the construction project will take 3 years, with $10 million due each year. Upon completion of the project, the tolls collected from the bridge will be valued at $4 million per year. It is estimated that the bridge will last for 10 years, before it will need to be replaced. The cost of dismantling the bridge will be offset by the price of the reclaimed materials.

Assume that the discount rate is 5% per year. The Net Present Value is calculated in the 0th year.

3) What is the Net Present Value of the cost of constructing the bridge?

$27.21 million $27.23 million $30 million $25.9 million

This section requires Javascript.
You are seeing this because something didn't load right. We suggest you, (a) try refreshing the page, (b) enabling javascript if it is disabled on your browser and, finally, (c) loading the non-javascript version of this page . We're sorry about the hassle.

2 solutions

Chew-Seong Cheong
Mar 26, 2015

We can use Excel spreadsheet to solve for the Net Present Value of the cost of constructing the bridge.

Key in the following:

  • A2: 1; A3: 2; A4: 3
  • B2: 10
  • C2: 1/1.05^A2
  • D2: B2*C2
  • Highlight B2:D2 and drag down to copy to B4:D4
  • D5: SUM(D2:D4)

Or just key in:

  • D6: NPV(5%,10,10,10)

The answer is 27.23 \boxed{27.23} million.

Venture Hi
Mar 25, 2015

NPV= 10/(1+1.05)+10/(1+1.05)^2+10/(1.05)^3

0 pending reports

×

Problem Loading...

Note Loading...

Set Loading...