Building a Bridge - 5

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.

5) What is the Net Present Value of this construction project?

-$0.55 million $0.55 million $10 million $53.91 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

Use the following Excel spreadsheet to solve for the Net Present Value of the construction project.

  • Key in A2: 4 and A3: 5; highlight A2:A3 and drag down to A14
  • Key in B2: -10; B3: =B2 highlight B3 and drag to B14
  • Key in B5: 4
  • Key in C2: 1/1.05^A2
  • Key in D2: B2*C2
  • Highlight C2:D2 and drag it to C14:D14
  • Key in D15: SUM(D2:D14)

Alternatively, just key in:

  • D16: =NPV(5%,-10,-10,-10,4,4,4,4,4,4,4,4,4,4)

The answer is $ 0.55 \boxed{-\$0.55} million.

Venture Hi
Mar 25, 2015

NPV buiding bridge= 10/(1+1.05)+10/(1+1.05)^2+10/(1.05)^3=27.23 million ( cost) NPV from toll=NPV=4/(1+0.05)^4+4/(1+0.05)^5+4/(1.05)^6+4/(1.05)^7+4/(1.05)^8+4/(1+0.05)^9+4/(1+0.05)^10+4/(1.05)^11+4/(1.05)^12+4/(1.05)^13=26.68 million ( revenue) lost= 27.23-26.68=.55

0 pending reports

×

Problem Loading...

Note Loading...

Set Loading...