Find out how long a finance or technology investment takes to pay for itself. Enter the cost and yearly savings, and see simple and discounted payback, NPV and five-year ROI side by side.
Same net cash inflow every year. Payback is simply investment divided by annual inflow.
Savings usually ramp up as the new process beds in. The cumulative method finds the year you cross zero and works out the fraction of that year.
Your inputs stay in your browser. Nothing is stored.
The payback period is the time it takes for an investment's net cash inflows to add up to what you spent. With the same inflow every year, divide the investment by the annual inflow. With uneven inflows, add them up year by year until the total crosses the investment.
Everything you spend up front to get the project live. Take it from the vendor quote, the implementation SOW and your capex approval note.
Example: licence, rollout and training for close automation = ₹1.2 croreYearly savings plus any extra income, minus running costs such as subscription renewals. Build it from the business case, using payroll, audit fee and vendor cost lines in your P&L.
Example: ₹60 lakh saved a year less ₹15 lakh renewal = ₹45 lakhThe return your money could earn elsewhere, used for discounted payback and NPV. Most teams use their weighted average cost of capital from treasury or the annual budget.
Example: WACC of 12% a yearFast and easy to explain. It ignores the time value of money and anything that happens after payback.
Investment ÷ annual inflowAdd inflows each year until you pass zero, then take the fraction of the payback year still needed.
Years before + (shortfall ÷ next year's inflow)Discount each inflow first, so later savings count for less. Always longer than simple payback.
Inflow ÷ (1 + rate)year, then cumulative| Initial investment | ₹1,20,00,000 |
| Net cash inflow per year | ₹45,00,000 |
| Discount rate | 12% |
| Discounted payback | 3 years 5 months |
| Simple payback | 2 years 8 months |
There is no single right number. It depends on how fast the technology changes, how risky the savings are and how much cash the business can tie up. These ranges reflect how finance teams typically screen projects.
| Investment type | Typical target | Why |
|---|---|---|
| Finance automation (close, reconciliation, AP) | Under 2 years | Savings come from hours and errors you can measure from the first quarter |
| ERP upgrade or replacement | 3 to 5 years | Large rollout cost and benefits that build slowly |
| Other SaaS and IT tools | 12 to 24 months | Short contracts and fast obsolescence push teams to recover cost quickly |
| Plant and machinery | 3 to 7 years | Long asset life spreads the return |
| Rooftop solar and energy efficiency | 4 to 6 years | Steady savings over a 20-year life |
Indicative screening ranges, not rules. Use payback alongside NPV and ROI before you decide.
Get a one-page summary with simple and discounted payback, NPV, five-year ROI and the year-by-year cash flow.
Payback has only two levers: spend less up front or bring the savings forward. Most of the gain comes from the second one.
Automate the reconciliation or close task that eats the most hours first. Early savings shorten payback far more than later ones.
Go live entity by entity. Each phase starts paying back while the next one is still being configured.
Include audit fee reductions, avoided hires, fewer write-offs and faster collections, not only hours saved.
Annual billing in arrears or milestone-linked fees cut the upfront investment and the time to recover it.
Baseline close days and hours before go-live so you can prove the savings, not just estimate them.
A project with a slightly longer payback can still win on NPV. Use both before you rank options.
Divide the initial investment by the annual net cash inflow. For example, ₹1.2 crore divided by ₹45 lakh a year gives 2.67 years, or 2 years 8 months. If inflows change each year, add them up until the total matches the investment.
Track cumulative cash flow year by year. Note the last year where it is still negative, then add the remaining shortfall divided by the next year's inflow. A shortfall of ₹15 lakh with ₹60 lakh coming next year adds 0.25 years.
For even flows use =investment/annual_inflow, for example =B1/B2. For uneven flows, build a cumulative column, then use =years_before_payback + ABS(last_negative_cumulative)/next_year_inflow. Excel has no built-in payback function.
It is payback calculated on discounted cash flows. Each year's inflow is divided by (1 + discount rate) raised to the year number before adding them up. It is always longer than simple payback because later savings are worth less today.
Payback tells you how quickly you get your money back. ROI tells you how much you earn in total, as a percentage of the cost. A project can have a quick payback but low ROI if savings stop early, so look at both.
Shorter payback means less risk and faster cash recovery, but it ignores everything after payback. A platform with a 2.5-year payback and strong savings for 7 years may beat a tool with a 1-year payback that is replaced in year 3.