Formula used
The calculator first computes the reducing-balance home-loan EMI. It then models monthly EMI-sized withdrawals from the investment corpus under a smooth net-return case and a stress-first case. The required-return output is a simple annual withdrawal-yield screen, while ending-corpus outputs use monthly compounding and withdrawals. Tax, cost and exit-load effects are represented only by the user-entered annual drag.
Example calculation
For a Rs 1 crore home, Rs 20 lakh down payment, Rs 80 lakh loan at 8% for 20 years and Rs 80 lakh SWP corpus, the EMI is about Rs 66,900. A 12% gross return may cover that EMI in a smooth illustration, but a bad first year can materially reduce the ending corpus.
How to use this calculator
- Enter the property price, down payment, loan rate and loan tenure.
- Enter the corpus you would use for the monthly SWP.
- Set a gross return and a conservative annual drag for costs and tax effects.
- Enter a negative first-year return and a post-stress recovery assumption.
- Compare the steady and stress-first ending corpus, then size a separate EMI reserve.
Important assumptions
- Investment returns are scenario assumptions, not forecasts or guarantees.
- The home-loan rate and EMI are held constant even though floating rates may reset.
- Withdrawals occur monthly and return drag is a simplified proxy, not a tax calculation.
- Property appreciation, stamp duty, registration, maintenance and rent are excluded.
Common mistakes to avoid
- Treating 12% as a fixed return.
- Comparing gross investment return with loan rate without tax, fees and risk.
- Ignoring a market fall early in the withdrawal period.
- Investing the entire liquidity buffer while also taking a large loan.
What this stress test answers
This is not a simple 12% minus 8% comparison. It calculates the actual EMI, the annual withdrawal pressure on the corpus, a smooth-return ending value and a bad-first-year ending value.
Why 12% return and 8% loan does not create a guaranteed 4% profit
Loan interest is contractual and calculated on a reducing balance. Investment return is uncertain, uneven and affected by withdrawals, tax and costs. The difference between headline percentages is therefore not risk-free arbitrage.
Sequence risk is the key failure mode
The same average return can produce very different outcomes when withdrawals are running. A large fall near the beginning can cause permanent damage because units are sold before recovery.
Use an EMI reserve
The reserve output shows the cash required to keep a chosen number of EMIs outside the market. It is separate from a household emergency fund and does not remove investment risk.