Net Present Value Calculator · Calculation guide

Compare dated future receipts and payments in today's money.

Calculation guide

For business owners exploring costs, cash flow or valuation scenarios.

Keep revenue, cost and time periods consistent. Profit margin divides by revenue; markup divides by cost. Discounted cash flows are scenario assumptions, and terminal growth must be below the discount rate. Payback uses linear interpolation within the recovery period. Customer lifetime value uses the entered finite horizon, retention, margin and discount assumptions. No valuation or business outcome is guaranteed. Negative cash flows represent money paid out; positive flows represent money received. Include the final valuation as a positive flow if relevant. IRR uses equal periods; XIRR discounts actual calendar-day differences using ACT/365F. Nonconventional sign-change patterns are reported as potentially ambiguous instead of silently choosing one root. NPV uses the entered discount rate.

NPV=Σ CF_t/(1+r)^((date_t−date₀)/365)

Inputs

Annual interest / discount rate

Effective annual discount rate used to express future cash flows in today’s value.

Date

Date on which this payment or receipt occurs, entered as YYYY-MM-DD.

Amount

Amount for this calculation or dated cash flow. Where negative amounts are allowed, negative means paid out and positive means received.

Worked example

InputValue
Annual interest / discount rate10%

Cash flows

DateAmount
2026-01-01-100,000
2027-01-0160,000
2028-01-0160,000

Formula:

NPV=Σ CF_t/(1+r)^((date_t−date₀)/365)

Net present value = 4132.23140495867

Time years = 0.00000000000000; Cash flow = -100000.000000000; Present value = -100000.000000000; Cumulative value = -100000.000000000

Time years = 2.00000000000000; Cash flow = 60000.0000000000; Present value = 49586.7768595041; Cumulative value = 4132.23140495867

ResultValue
Net present value4,132.231405

Interpreting the result

Sum of dated cash flows discounted to the earliest entered date using actual days over 365.

How each input affects this example

Each row starts from the worked example and changes one input.

InputOriginal inputNew inputAffected resultOriginal resultNew result
Annual interest / discount rate10%11%Net present value4,132.2314052,751.400049
Date (row 1)2026-01-012026-01-02Net present value4,132.2314054,159.426357
Amount (row 1)-100,000-90,000Net present value4,132.23140514,132.231405
Net Present Value Calculator →