How to calculate net present value of a project

Net present value (NPV) is calculated by summing the present values of all future cash flows of a project and subtracting the initial investment. This method applies when evaluating mutually exclusive projects or determining the absolute profitability of an investment under a known, constant discount rate.

The setup

Identify the initial investment C0C_0, the projected cash flows CtC_t for each period tt, and the discount rate rr per period.

The steps

  1. Identify the initial cash outflow at t=0t=0. 2. Calculate the present value of each future cash flow using the formula PV=Ct/(1+r)tPV = C_t / (1+r)^t. 3. Sum the present values of all future cash flows. 4. Subtract the initial investment from the sum of the discounted cash flows to find the NPV.

Checking the result

Verify that higher discount rates yield lower NPVs. Ensure that cash flows occurring further in the future contribute proportionally less to the total present value than near-term cash flows.

Common errors

Using the wrong discount rate, misaligning cash flows with their respective time periods, or forgetting to include the initial investment as a negative value at time zero.

Worked example

Calculate the NPV of a project requiring an initial investment of \10,000,yielding, yielding $3,000inyear1,in year 1,$4,000inyear2,andin year 2, and$5,000inyear3.Thediscountrateisin year 3. The discount rate is10%$ per year.

NPV=C0+t=13Ct(1+r)tNPV = -C_0 + \sum_{t=1}^{3} \frac{C_t}{(1+r)^t} NPV=10000+3000(1+0.10)1+4000(1+0.10)2+5000(1+0.10)3NPV = -10000 + \frac{3000}{(1+0.10)^1} + \frac{4000}{(1+0.10)^2} + \frac{5000}{(1+0.10)^3} NPV=10000+30001.1+40001.21+50001.331NPV = -10000 + \frac{3000}{1.1} + \frac{4000}{1.21} + \frac{5000}{1.331} NPV=10000+2727.27+3305.79+3756.57NPV = -10000 + 2727.27 + 3305.79 + 3756.57 NPV=10000+9789.63NPV = -10000 + 9789.63 NPV=210.37NPV = -210.37

FAQ

Run your own problem

References: Principles of Corporate Finance (Brealey, Myers, Allen) · OpenStax Principles of Finance Chapter 9

See also