How to use the Investment Return Calculator
- 1
Choose Investment or Investment-linked Policy. For a policy, analyse guaranteed, illustrated or actual / surrender values separately. - 2
Choose the present-value date, required annual return and inflation assumption. The present-value date must be on or before every cash flow. - 3
Add dated investments / premiums and receipts. Use the recurring-payment helper for regular contributions. Enter separate costs only if they are not already included. - 4
Exclude tax, enter tax / credits on their payment dates, or use a custom rate on the taxable portion you enter. Policy mode supports manual tax or no tax; it does not determine tax exemptions. - 5
If the investment is still held, enter its remaining or surrender value and valuation date. Leave this zero when the schedule already contains the full sale or maturity receipt. - 6
Review returns, NPV, year-wise cash flows and sensitivity. Save up to four comparison snapshots and download the PDF report.
Investment return, XIRR and NPV formulas
Net cash flow = receipts − investments − separate costs − tax
XNPV = Σ [net cash flow / (1 + discount rate)^(days / 365)]
XIRR = annual effective rate at which XNPV equals zero
Total ROI = total net profit / (investments + separate costs)
Real XIRR = (1 + after-tax XIRR) / (1 + inflation) − 1
FV of net receipts = PV of net receipts × (1 + discount rate)^(last-date days / 365)
Worked investment example
Invest ₹1,00,000 on 1 April 2026. Receive ₹10,000 annually for five years, with ₹1,00,000 principal repaid alongside the final receipt. At an entered 20% tax on the ₹10,000 annual income, each net income receipt is ₹8,000. XIRR is approximately 10% before tax and 8% after tax; leap years cause a small date-weighting difference. Only ₹10,000 of the final ₹1,10,000 receipt is entered as taxable. This demonstrates custom-rate arithmetic, not tax rules for a particular investment.
