NPV / Contract ROI Calculator | Metricon by Alle’s ClinX
Procurement → NPV Calculator
Procurement · Finance

NPV / Contract ROI
Calculator

Evaluate multi-year contracts and lease-vs-buy decisions using discounted cash flow. Real money, real time value.

NPV = −I₀ + Σ [ CFₜ ÷ (1+r)ᵗ ]
Contract Setup
Tooling, transition, advance payment
Your organisation’s hurdle rate
Annual Cash Flows (₹)
Used for years 5 through end of contract

Net Present Value

NPV
Internal Rate of Return
Payback period
Sum of discounted CFs
Total undiscounted CFs
Enter values above
Adjust inputs to see recommendation.
Mathematics
Discounted Cash Flow Formula
NPV = −I₀ + Σ [ CFₜ ÷ (1 + r)ᵗ ] for t = 1 to n
I₀
Initial Investment
Upfront cost at time zero
CF
Cash Flow
Annual benefit or saving in each period
r
Discount Rate
WACC — time cost of capital
t
Time Period
Year number from contract start
NPV
Net Present Value
Value created in today’s rupees
IRR
Internal Rate
Return rate — compare against WACC
Nominal vs Discounted Cash Flows
Time-value erosion by year
Cumulative NPV Over Contract Life
When the investment crosses break-even
Auto-Generated
Finance Memo
Run the calculator above to generate your memo.
Deep Dive

The Time Value of Money in Procurement Decisions

Procurement8 min read

A five-year contract at ₹10L per year is not worth ₹50L. Discounted at your cost of capital, it is worth measurably less — because money received in year five is worth less than money received today. This is not accounting convention. It is economic reality, and every multi-year procurement decision that ignores it is mispriced.

Why Undiscounted Comparisons Mislead

When a procurement team compares two five-year contracts by their total nominal cost, they are implicitly assuming money has the same value in year five as in year one. This assumption is always wrong — and it systematically biases decisions toward contracts with higher upfront costs and lower future obligations, or toward long-term commitments that appear cheaper in nominal terms but are more expensive in present-value terms.

“A cheaper supplier over five years is not cheaper if their savings are back-loaded and your cost of capital is 12%. NPV is the only honest comparison.”

NPV in Procurement Practice

NPV analysis is mandatory for: any contract exceeding 3 years or ₹25L total value, all lease-vs-buy decisions, any decision involving upfront investment against future savings, and supply chain finance or early payment discount evaluations.

For payment terms specifically, NPV quantifies the precise value of a cash flow difference. Extending payment terms from net-30 to net-60 on ₹10Cr of spend is worth approximately ₹82L in present-value terms at a 10% discount rate — a number that procurement should capture as a working capital improvement in its ROI calculation.

IRR vs NPV: Which to Use

NPV shows the absolute rupee value created. IRR shows the effective annual return. When comparing two projects of similar scale, use NPV. When comparing against your cost of capital hurdle rate, use IRR. When they conflict, NPV is the more reliable criterion — IRR can produce multiple solutions for non-conventional cash flow patterns.

The Inflation Question

Use nominal cash flows with a nominal discount rate, or real cash flows with a real discount rate. Never mix the two. For Indian procurement, nominal rates are typically easier to source and verify. The Government of India 10-year bond yield plus a risk premium is a defensible starting point for any organisation without a published WACC.

Gold Standard

DCF
Discounted Cash Flow — required for all multi-year decisions

NPV History

1930s
Irving Fisher formalises time value of money
1950s
DCF adopted as capital budgeting standard
1970s
NPV becomes standard in lease-vs-buy analysis
Today
Required for all procurement contracts above 3 years

IRR Warning

IRR can produce multiple solutions for non-conventional cash flows (mixed positive/negative). When in doubt, use NPV — it is always unambiguous.

Key Insight

Payment term extension from net-30 to net-60 on ₹10Cr spend = ₹82L present-value benefit at 10% WACC. Quantify it. Report it.

Common Questions
FAQ
Use your organisation’s WACC if available — typically 10–15% for Indian companies. If unavailable, use the Government of India 10-year bond yield plus a risk premium appropriate to the supplier risk. For internal hurdle rates, use your organisation’s stated minimum acceptable return on investment.
Any contract exceeding 3 years or ₹25L total value should have NPV analysis. Lease-vs-buy decisions always require it. Any decision involving upfront investment (tooling, setup, transition) against future cost savings requires NPV to correctly account for the time cost of capital.
NPV shows the absolute rupee value created in today’s money. IRR shows the effective annual return rate. Use NPV to choose between similar-scale options. Use IRR to compare against your cost of capital hurdle rate. When they conflict, NPV is the more reliable criterion.
Either use nominal cash flows with a nominal discount rate (which includes inflation), or real cash flows with a real rate (which excludes inflation). Be consistent — mixing nominal and real rates is one of the most common errors in procurement financial analysis.