ROI Calculator
Measure the return on any procurement investment. Calculate ROI percentage, Net Present Value with time-discounting, and the exact point at which the investment pays for itself — so you can build a financially rigorous business case.
ROI is the ratio of total net benefit to investment cost, expressed as a percentage. It does not account for the time value of money — ₹1 received in year 5 is treated the same as ₹1 received today.
NPV corrects for this by discounting future cash flows at your organisation’s cost of capital (hurdle rate). A positive NPV means the investment creates value beyond your required rate of return. A negative NPV means the investment destroys value at that discount rate, even if nominal ROI appears positive.
Payback period is the simplest metric — the number of years until cumulative net returns equal the initial investment. It ignores cash flows after the payback date and does not discount. Use it as a liquidity indicator, not a value measure.
History of ROI as a Decision Framework
Return on Investment as a formal metric traces its origins to the DuPont Corporation in 1919, where F. Donaldson Brown developed the DuPont Analysis — a decomposition of ROI into profit margin and asset turnover — to evaluate divisions of the newly acquired General Motors. This framework became the dominant management accounting tool for most of the 20th century.
NPV as a capital budgeting tool gained academic grounding through the work of economists Irving Fisher and John Maynard Keynes in the early 20th century, but was popularised in corporate finance through Joel Dean’s seminal 1951 text “Capital Budgeting,” which established it as the theoretically correct method for investment appraisal.
In procurement, ROI analysis became standard practice in the 1990s as organisations began treating procurement as a value centre rather than a cost function. The shift from purchase-price-only evaluation to total value assessment — driven partly by strategic sourcing methodologies developed at McKinsey and AT Kearney — embedded ROI thinking into supplier selection and contract evaluation processes globally.
How the Calculator Works
The calculator models cash flows year by year. Annual net cash flow = Annual Returns − Annual Operating Costs. The cumulative sum of net cash flows over the horizon, minus the initial investment, gives total net benefit and nominal ROI.
For NPV, each year’s net cash flow is divided by (1 + discount rate)^year. This “discounts” future cash flows — money received further in the future is worth less in today’s terms. The sum of all discounted cash flows minus the investment is the NPV. If NPV > 0, the investment is financially justified at your discount rate.
Payback period is calculated by tracking cumulative undiscounted returns year by year and identifying when they first exceed the initial investment. The chart shows this visually as the point where the cumulative return line crosses the investment line.
How to Use This Tool
Step 1. Define “investment” as the total upfront cost: purchase price, implementation, one-time setup, training. For procurement, this includes the cost of running the tender process itself if significant.
Step 2. Define “annual returns” as quantifiable value: cost savings versus current baseline, revenue enabled by the purchase, or avoided future spend. Be conservative — procurement ROI cases frequently overstate returns.
Step 3. Set the discount rate to your organisation’s weighted average cost of capital (WACC), a standard hurdle rate (typically 8–15% for private firms in India), or a mandated rate from your finance function.
Step 4. Review NPV before ROI. An investment with impressive headline ROI can have a negative NPV if cash flows are heavily back-loaded. Copy the memo and attach it to your business case or spend approval request.