ValteraTools CFO services
  1. Valtera
  2. Tools
  3. NPV and IRR calculator
Business · Investment

Investment Calculator: NPV and IRR

Enter the initial investment, the discount rate and cash flows by year. The calculator works out the project's NPV, IRR and payback period.

Updated:
₼
%
Cost of capital or required return
Annual net cash flow
Net present value (NPV)
0₼
  • Internal rate of return (IRR)—
  • ROI (total)—
  • Simple payback—
  • Discounted payback—

Cumulative cash flow

What the metrics mean

NPV = −I + Σ CFₜ ÷ (1 + r)ᵗ IRR: the rate at which NPV = 0 ROI = (Σ CF − I) ÷ I
  • NPV > 0: the project earns more than the required return. Among several projects, the one with the higher NPV is better.
  • If IRR is higher than the discount rate, the project is worthwhile. Compare it with the loan interest rate too.
  • Payback period shows how many years it takes to recover the investment. The discounted version accounts for the time value of money.

Example

New equipment costs 100,000 ₼, with expected net cash flows of 30, 40, 45, 35 and 25 thousand ₼ over 5 years. At a 15% discount rate, NPV is 18,362 ₼ and IRR is 22.6%. The investment pays back in 2.7 years, or 3.7 years on a discounted basis.

For cash flow, use the project's actual cash receipts and payments (including taxes), not profit. Depreciation is not a cash outflow. If you finance the project with a loan: loan calculator.

Frequently asked questions

How do I choose the discount rate?

Use the company's cost of capital: the loan interest rate, the return the owner expects and the project risk. Choose a higher rate for a riskier project.

What if NPV is negative?

The project does not pay off at the chosen rate. Recheck costs, prices and timing, or compare it with alternative projects.

Why is IRR not shown?

IRR does not exist when all cash flows are positive or all are negative. Enter the initial investment and at least one positive cash flow.

Let us run the numbers

Valtera keeps the books and tax records of small and mid-sized companies and, as an outsourced CFO, takes responsibility for revenue growth and cash flow.