Illustration for Payback Period Formula Explained With Worked Examples - DigiToolkit

Payback Period Formula Explained With Worked Examples

Understand the payback period formula, including uneven cash flows and discounted payback, with step-by-step examples in Indian rupees.

Quick Answer: The payback period formula is initial investment divided by annual net cash inflow when inflows are equal. When inflows vary, use full years before recovery plus the unrecovered amount divided by the next year cash flow. The discounted version first converts each inflow to present value, so it gives a longer and more realistic answer.

Key takeaways:

  • Equal inflows: Payback = Initial investment / Annual net cash inflow.
  • Uneven inflows: Payback = Years before recovery + (Unrecovered cost / Cash flow in recovery year).
  • Discounted payback uses present value of each inflow, so it is always longer than simple payback.
  • Discounted payback = Years before recovery + (Unrecovered discounted cost / Discounted cash flow in recovery year).
  • Use simple payback as a quick screen and discounted payback when money is tied up for years.

A formula is just a short way of writing down what you would do anyway. The payback period formula answers one question: how long until the money I put in comes back to me?

In this guide we break the formula into its parts, show the three versions you will meet, and work through Indian examples with every step of arithmetic written out. If you want to skip the manual work, our payback period calculator does the same sums in seconds.

The Basic Payback Period Formula

When your investment brings the same cash every year, the formula is simple.

Payback period = Initial investment / Annual net cash inflow

The two parts mean the following:

Term Meaning Example
Initial investment All upfront spending, including installation and non-refundable taxes Rs 8,00,000 for a packaging machine
Annual net cash inflow Extra cash earned each year after running costs Rs 2,00,000 per year
Payback period Time to recover the investment 4 years

Worked example: equal inflows

Sunita owns a small spice business in Kochi. She buys an automatic packaging machine for Rs 8,00,000. It saves labour and reduces wastage, adding Rs 2,00,000 a year in net cash.

Payback period = Rs 8,00,000 / Rs 2,00,000 = 4 years.

If she wants the answer in months, she can multiply by 12: 4 x 12 = 48 months. She can also divide by the monthly inflow: Rs 2,00,000 / 12 = Rs 16,667 per month (rounded), and Rs 8,00,000 / Rs 16,667 is about 48 months. Both ways match.

The Formula for Uneven Cash Flows

Real businesses rarely earn the same amount each year. Sales ramp up, costs change and seasons matter. For this case, you track a running total and use the following formula.

Payback period = A + (B / C)

  • A = the last full year before the investment is fully recovered
  • B = the amount still not recovered at the end of year A
  • C = the cash inflow during the year in which recovery happens

Worked example: uneven inflows

Arjun is setting up a small coaching centre in Jaipur. Furniture, projector, deposit and interiors cost Rs 6,00,000. He expects the net cash inflows below.

Year Net cash inflow Cumulative inflow Still to recover
1 Rs 1,00,000 Rs 1,00,000 Rs 5,00,000
2 Rs 1,50,000 Rs 2,50,000 Rs 3,50,000
3 Rs 2,00,000 Rs 4,50,000 Rs 1,50,000
4 Rs 2,50,000 Rs 7,00,000 Recovered

Recovery happens in year 4. So A = 3, B = Rs 1,50,000, and C = Rs 2,50,000.

Payback period = 3 + (Rs 1,50,000 / Rs 2,50,000) = 3 + 0.6 = 3.6 years.

Convert the 0.6: 0.6 x 12 = 7.2 months. Arjun recovers his money in about 3 years and 7 months. This formula quietly assumes that cash arrives evenly through the recovery year, which is a fair approximation for most small projects.

Key takeaway: The uneven formula is just a running total with one extra step. Find the year the total crosses your investment, then take the leftover amount as a fraction of that year inflow.

Discounted Payback Period Formula

The simple formula treats Rs 1,00,000 received in year 5 as equal to Rs 1,00,000 received today. In real life, that is not true. Money today can earn interest, and inflation reduces what future rupees can buy.

Discounted payback fixes this by converting each future cash flow into its present value before adding them up.

Present value = Cash flow / (1 + r)^n

Here r is the discount rate (as a decimal) and n is the year number. Many investors use their loan interest rate or the return they could earn elsewhere, such as a bank fixed deposit, as a starting discount rate. After this step, you apply the same recovery method:

Discounted payback = A + (B / C), where all the amounts are discounted values.

Worked example: discounted payback

Take an investment of Rs 10,00,000 in a small flour mill in Indore. It brings Rs 3,00,000 a year for five years. We assume a discount rate of 10 percent for this illustration.

First, the simple payback: Rs 10,00,000 / Rs 3,00,000 = 3.33 years.

Now discount each inflow:

Year Cash inflow Discount factor at 10% Present value Cumulative PV
1 Rs 3,00,000 0.9091 Rs 2,72,727 Rs 2,72,727
2 Rs 3,00,000 0.8264 Rs 2,47,934 Rs 5,20,661
3 Rs 3,00,000 0.7513 Rs 2,25,394 Rs 7,46,055
4 Rs 3,00,000 0.6830 Rs 2,04,904 Rs 9,50,959
5 Rs 3,00,000 0.6209 Rs 1,86,276 Rs 11,37,235

The cumulative present value crosses Rs 10,00,000 in year 5. So A = 4, B = Rs 10,00,000 – Rs 9,50,959 = Rs 49,041, and C = Rs 1,86,276.

Discounted payback = 4 + (Rs 49,041 / Rs 1,86,276) = 4 + 0.26 = 4.26 years.

That is almost a full year longer than the simple answer of 3.33 years. The gap grows when the discount rate is higher or the payback is longer. If you also want to know how much value the project adds in total, check the NPV calculator, which sums these same present values and subtracts the cost.

Simple vs Discounted Payback at a Glance

Point Simple payback Discounted payback
Time value of money Ignored Included
Extra input needed None Discount rate
Result for same project Shorter (3.33 years above) Longer (4.26 years above)
Best for Quick screening of small buys Larger or longer projects

Benefits of Knowing the Formula

When you know the formula, you are not dependent on any tool. You can check a salesperson claim on the spot. If a supplier says a machine pays for itself in a year, you can test it in a minute.

The formula also makes you list your assumptions. To fill in the numbers, you must decide what the costs and inflows really are. That alone improves decisions. And because the arithmetic is light, you can run many what-if cases, such as a lower sales figure or a higher power tariff.

Challenges and Limitations

  • No view beyond payback. Two projects with the same payback may have very different lives.
  • Simple version ignores timing value. That can make slow projects look better than they are.
  • Discount rate is a judgement call. Choose 8 percent or 12 percent and the discounted answer shifts.
  • Forecast risk. Every input is an estimate. A small change in annual inflow moves the answer a lot.
  • Residual value is missed. Resale value of a machine or a property does not appear in the formula.

For a view of the project overall return rate, the IRR calculator is a good companion.

Common Mistakes

  • Dividing by profit instead of cash flow. Accounting profit may include depreciation, which is not a cash outflow.
  • Using the wrong year in the fraction. The denominator is the inflow of the recovery year, not the previous one.
  • Forgetting to discount every year. In discounted payback, each year uses its own factor with n equal to the year number.
  • Rounding too early. Round only at the end, or small errors pile up.
  • Counting the subsidy twice. If you reduce the investment by a subsidy, do not also add it as an inflow.
  • Comparing different units. Do not divide a yearly inflow into a monthly cost without converting.

Best Practices

  • Write the formula down first. Label A, B and C so you do not mix numbers.
  • Pick the discount rate openly. State it, and test a rate above and below it.
  • Check with a table. A cumulative table catches mistakes that a single formula hides.
  • Use net, after-tax cash where relevant. Ask your chartered accountant how tax and depreciation affect your cash.
  • Run a tool check. Compare your manual answer with the calculator to confirm.
  • Document assumptions. A one-line note beside each input saves arguments later.

Conclusion

There are three formulas to remember. For equal inflows, divide cost by yearly inflow. For uneven inflows, add the years before recovery to the leftover cost divided by the recovery year inflow. For discounted payback, do the same after turning each cash flow into present value.

Start with the simple version to screen ideas, then switch to the discounted one for the shortlisted projects. Whichever you use, keep your inputs honest and your arithmetic written out.

FAQs

What is the formula for payback period?
For equal annual inflows, payback period equals initial investment divided by annual net cash inflow. For uneven inflows, it equals the full years before recovery plus the unrecovered amount divided by the cash flow in the recovery year.

What is discounted payback period?
It is the time needed to recover the investment when each future cash inflow is first converted to present value using a discount rate. Because later rupees are worth less, it is always longer than the simple payback period.

Which discount rate should I use?
Use the rate that reflects your cost of money or the return you could earn on a similar-risk alternative. Many small investors start with their loan rate or a fixed deposit rate and then test a few higher rates.

Why is my discounted payback longer than simple payback?
Simple payback treats all rupees as equal in value. Discounted payback shrinks future inflows to their present value, so it takes more time for the total to reach your investment.

Can I use the formula for monthly cash flows?
Yes. Divide the investment by the monthly net cash inflow to get payback in months. For uneven monthly flows, build a month-by-month cumulative table.

What if the investment is never recovered?
Then the project has no payback period within the forecast. That is a warning sign, and you should re-check your inflow estimates or drop the project.

Leave a Reply

Your email address will not be published. Required fields are marked *