Home Loan vs Mutual Fund

Mirror the cashflows — down payment ⇄ lumpsum, EMI ⇄ SIP, rental ⇄ SWP — adjusted for the seven real-estate frictions

← Back to Tools ⬇ Download as Excel Workbook
Read this first · How the cashflow mirror works
Both paths are sized to produce the same monthly disposable cashflow for living expenses. The house owner consumes the net rent they receive (rent − vacancy − maintenance). The MF investor withdraws an equivalent SWP from their fund every month to maintain identical lifestyle cash. In pre-rental years, when the house owner pays maintenance with no rent, the MF investor invests an equivalent extra-SIP for parity.

House net worth = property value − outstanding loan. Rent is consumed, not reinvested, which is why the "Cum Net Rent Received" column shows a simple sum and exactly matches "Cum SWP" at every year. The two are mirror images of the same monthly cashflow.

Property & Loan

₹1Cr
30%
8.5%
20 yrs

Real Estate Frictions

7%
3.0%
Yr 2
7%
0.8%
10%
6%

Rent and maintenance grow at this rate (independent of property appreciation).

Mutual Fund Settings

11%

Use the CAGR you'd quote a client. NAV-based MF returns are already net of the fund's expense ratio.

12.5%
20 yrs

Comparison held over the chosen horizon. Both sides marked-to-market at horizon end (capital gains paid).

🏠 House Cashflows

Down Payment (one-time)
Stamp Duty + Registration
Monthly EMI
Monthly Rental (gross)
Rental Starts
Monthly Maintenance

📈 MF Mirror Cashflows

Initial Lumpsum (= Down Payment)
Monthly SIP (= EMI)
Monthly SWP (= Net Rental)
SWP Starts
Expense Ratio Drag
Stamp Duty Equivalent Invested

Verdict at 20-year horizon

House — Net Worth at Exit
Property value + rental reinvested − outstanding loan − taxes
Mutual Fund — Net Worth at Exit
Lump + SIP grown − SWP drawn − expense ratio − LTCG
Difference (MF − House)
Positive = MF wins

Net Worth Over Time

Year-by-Year Comparison

Yr House Value Loan Bal. Cum Net Rent Received House Net MF Value Cum. SWP MF Net Δ (MF − House)

See Also