NPV & IRR Calculator

NPV & IRR Calculator

Popular AI Skill PRO

Enter Calculation

Formula

NPV=−Initial+∑t=1nCFt(1+Rate100)t\text{NPV} = -\,\text{Initial} + \sum_{t=1}^{n} \frac{{{\text{CF}_t}}}{\left(1 + \dfrac{\text{Rate}}{100}\right)^{t}}
Show calculation steps (2)
  1. Internal Rate of Return (IRR)

    0=−Initial+∑t=1nCFt(1+IRR)t0 = -\,\text{Initial} + \sum_{t=1}^{n} \frac{{{\text{CF}_t}}}{\left(1 + \text{IRR}\right)^{t}}

    IRR is the rate r that makes NPV = 0; solved numerically by bisection. CF_t = the t-th cash flow (year 1..n).

  2. Net Profit (nominal)

    Net Profit=∑t=1nCFt−Initial\text{Net Profit} = \sum_{t=1}^{n} {{\text{CF}_t}} - \text{Initial}

    Sum of all cash inflows minus the initial investment, ignoring discounting.

Usage stats

Advertisement

Results

Internal Rate of Return (IRR)
16.34%
annual rate that makes NPV = 0
NPV at discount rate 1,307.29
Total cash inflows 14,000
Net profit (undiscounted) 4,000

Report an error on this page

What is the NPV & IRR Calculator?

This tool evaluates the profitability of an investment or project. Net Present Value (NPV) discounts every future cash flow back to today's value using a chosen discount rate, then subtracts the initial investment. Internal Rate of Return (IRR) is the single discount rate at which the NPV becomes exactly zero — effectively the project's break-even annual yield.

How to use it

Enter the initial investment (the outflow at year 0), then list the cash inflows for each subsequent year separated by commas. Provide a discount rate to compute NPV. A positive NPV means the project adds value; an IRR above your required return (hurdle rate) means it is worth pursuing.

NPV curve crossing zero at the internal rate of return
IRR is the discount rate where the NPV curve crosses zero.

The formula explained

NPV sums each cash flow divided by (1 + r) raised to the power of the year. Year 0 is the negative initial investment. IRR has no closed-form solution, so the calculator uses bisection to find the rate that drives NPV to zero.

$$\text{NPV} = -\,\text{Initial} + \sum_{t=1}^{n} \frac{\text{CF}_t}{\left(1 + \dfrac{\text{Rate}}{100}\right)^{t}}$$

$$0 = -\,\text{Initial} + \sum_{t=1}^{n} \frac{\text{CF}_t}{\left(1 + \text{IRR}\right)^{t}}$$

Advertisement

Worked example

Initial investment = 10,000; cash flows = 3,000, 4,200, 6,800; discount rate = 10%.

$$\text{NPV} = -10{,}000 + \frac{3{,}000}{1.1} + \frac{4{,}200}{1.1^2} + \frac{6{,}800}{1.1^3} = -10{,}000 + 2{,}727.27 + 3{,}471.07 + 5{,}109.69 \approx \mathbf{1{,}308.04}$$ Solving for IRR gives roughly 15.2%, comfortably above the 10% discount rate, so the project is financially attractive.

Cash flow timeline with arrows discounted back to present value
Each future cash flow is discounted back to year 0 to compute NPV.

FAQ

What does a negative NPV mean? The project returns less than your discount rate — it destroys value at that required return.

Why might IRR be misleading? Projects with alternating positive and negative cash flows can have multiple IRRs, and IRR ignores the scale of investment, so always check NPV too.

What discount rate should I use? Typically your weighted average cost of capital (WACC) or required rate of return.

Last updated:

Most popular in Financial

View all Financial calculators