NPV Calculator

Calculate net present value to evaluate investment profitability and project viability

About the NPV Calculator

The Net Present Value (NPV) calculator is a fundamental tool in capital budgeting and corporate finance used to determine the profitability of an investment or project. By calculating the difference between the present value of cash inflows and the present value of cash outflows over a specific period, users can assess whether a venture will generate value or result in a loss. This tool is essential for business owners, financial analysts, and individual investors who need to compare the viability of multiple projects while accounting for the time value of money.

The core principle behind NPV is that a dollar today is worth more than a dollar in the future due to its potential earning capacity. Financial professionals use this calculator to adjust future revenues and expenses to their current value, allowing for an apples-to-apples comparison. Whether you are evaluating a corporate expansion, the purchase of new machinery, or a real estate acquisition, calculating the NPV helps in making data-driven decisions that align with your required rate of return. It moves beyond simple payback periods by incorporating the specific cost of capital and the duration of the project.

Formula

NPV = [Σ (Ct / (1 + r)^t)] - C0

The formula represents the sum of the present values of all future cash flows minus the initial investment. Ct is the net cash inflow-outflow during a single period t, r is the discount rate or return that could be earned in alternative investments, t is the number of time periods, and C0 is the initial investment cost at time zero. Each future cash flow is divided by (1 + r) raised to the power of the period number to discount it back to its value in today's terms.

Worked examples

Example 1: A logistics company invests $100,000 in a new software system expected to generate $40,000 in savings annually for three years with a discount rate of 8%.

Year 0 Cash Flow: -$100,000\nYear 1: $40,000 / (1 + 0.08)^1 = $37,037.04\nYear 2: $40,000 / (1 + 0.08)^2 = $34,293.55\nYear 3: $40,000 / (1 + 0.08)^3 = $31,752.49\nSum of PV of Cash Flows: $37,037.04 + $34,293.55 + $31,752.49 = $103,443.08\nNPV: $103,443.08 - $100,000 = $3,443.08

Result: $3,443.08. The investment is profitable because the NPV is positive and exceeds the cost of capital.

Common use cases

A business owner deciding whether to purchase a $50,000 piece of equipment that will save $15,000 annually in labor costs.
An investor comparing two different rental properties with different purchase prices and projected monthly rents.
A corporate finance team determining if a new product line development project meets the company's 10% hurdle rate.
A non-profit evaluating the long-term financial sustainability of a funded social program versus its initial setup costs.

Pitfalls and limitations

Using an arbitrary discount rate can lead to highly inaccurate and misleading results.
Failing to account for maintenance costs or taxes in the cash flow projections overstates NPV.
NPV does not account for the size of the project, making it difficult to compare a small high-return project with a massive low-return project.
Overestimating future cash inflows due to optimism bias is a common cause of failed project investments.

Frequently asked questions

what does it mean if npv is positive

A positive NPV indicates that the projected earnings, generated by a project or investment in present dollars, exceed the anticipated costs. This generally suggests the investment is profitable and worth pursuing.

how to choose discount rate for npv

The discount rate represents the cost of capital or the required rate of return. It accounts for the time value of money and the risk profile of the project, essentially telling you what future cash is worth today.

is a negative npv always bad

A negative NPV suggests that the investment will result in a net loss when adjusted for the time value of money. It doesn't necessarily mean the project loses cash, but rather that it fails to meet the required rate of return.

difference between npv and irr for business projects

NPV provides the dollar value of profit, while IRR provides the percentage rate of return. NPV is generally considered more reliable for comparing mutually exclusive projects of different scales.

how to account for inflation in npv calculation

Inflation is usually factored into the discount rate. If your cash flow projections are in real dollars, use a real discount rate; if they are in nominal dollars, use a nominal discount rate.