A Worked Example
The calculator above starts with these inputs. They are assumptions chosen for illustration, not figures for any business or for Hyderabad: an outlay of Rs 100 lakh today, then inflows of Rs 20 lakh, Rs 30 lakh, Rs 35 lakh, Rs 40 lakh and Rs 45 lakh at the end of each of the next five years, discounted at 12%.
| Year | Cash flow | Present value | Cumulative, undiscounted | Cumulative, discounted |
|---|---|---|---|---|
| 0 | −Rs 1,00,00,000 | −Rs 1,00,00,000 | −Rs 1,00,00,000 | −Rs 1,00,00,000 |
| 1 | Rs 20,00,000 | Rs 17,85,714 | −Rs 80,00,000 | −Rs 82,14,286 |
| 2 | Rs 30,00,000 | Rs 23,91,582 | −Rs 50,00,000 | −Rs 58,22,704 |
| 3 | Rs 35,00,000 | Rs 24,91,231 | −Rs 15,00,000 | −Rs 33,31,473 |
| 4 | Rs 40,00,000 | Rs 25,42,072 | Rs 25,00,000 | −Rs 7,89,401 |
| 5 | Rs 45,00,000 | Rs 25,53,421 | Rs 70,00,000 | Rs 17,64,020 |
- Net present value: Rs 17,64,020
- Internal rate of return, the rate at which the NPV is zero: 18.04%
- Payback, undiscounted: 3.38 years; discounted: 4.31 years
- Profitability index, present value of inflows over the outlay: 1.176
How the Rate Moves the Result
On the same cash flows the NPV is Rs 24,53,322 at 10%, Rs 17,64,020 at 12% and Rs 11,30,669 at 14%. At the IRR of 18.04% it is Rs -501, close to zero. Each year's cash flow is divided by (1 + rate) raised to the year, so the later flows move most.
NPV, IRR and Payback
NPV is a rupee amount at a rate you choose. IRR is the rate that makes the NPV zero, so it does not depend on your choice of rate but says nothing about size: a small project can have a high IRR and a small NPV. Payback counts the years until the cumulative inflows cover the outlay and ignores everything after that. When two projects exclude each other and differ in size or timing, NPV and IRR can rank them differently.
What Is Not Specific to Hyderabad
Everything above. The cash flows belong to the project, and the discount rate is yours to choose; a common choice for a company is its own weighted average cost of capital, which the WACC calculator works out. Nothing in the law that does differ by state, such as stamp duty or professional tax, enters a net present value.
The figures above are computed by the calculator's function for the stated inputs. This page explains the arithmetic; it is not investment advice.