The Illiquidity Trap

What it costs to sell your equity investments at Year 7 to buy a home

Published · 10 min read

Paper 1 of the finfire.org research series


The question

A 30-year-old investor in India has Rs 50 lakh invested in equity and puts Rs 1 lakh a month into equity funds. At Year 7, they can buy a Rs 1 crore home. To do that they sell equities to pay 20% down payment, 6% for stamp duty, registration charges and buffer. After that, part of the monthly SIP component is used to fund EMI. This is the 'buyer' persona in this paper.

We compare this with a twin 'renter' who keeps renting and stays fully invested all through the tenure.

The question is: How much wealth is lost (if any)? Will the home ever catch up? What yearly price growth would the home need to win by the Year 27? And what would be the impact on retirement plans?

The short answer

The home does not catch up. Not surprising though. But, it's also not really a trap or as drastic as it sounds.

At Year 27 (age 57) the buyer is Rs 2.92 crore behind, which is 9.1% of the renter's net worth. The buyer reaches financial independence about one year later.

That is the only real cost. To close the gap by Year 27, the home would need to grow about 9.23% a year (4.02% after inflation). We have assumed 5.5% home growth in this paper.

You can always try this scenario with your own numbers and with additional nuances. See "Try this scenario yourself" section below.

Continue reading if you are still interested.


Assumptions and Method

  1. The investor is aged 30, lives in India, has a family of 3 and is the only earner. Income and expenses have not been modelled (not really needed as well for this purpose); Rs 1 lakh a month is the surplus money.
  2. Start with Rs 50 lakh invested (all of it cost). SIP is Rs 1 lakh a month, flat. Equity earns 12% a year (monthly rate 1.12^(1/12) - 1, about 0.949%, not 1%).
  3. Path A - renter rents and keeps investing every month. Path B - buyer buys a Rs 1 crore home at the end of Year 7 (month 84).
  4. Down payment 20% (Rs 20 lakh) plus 6% costs (Rs 6 lakh) = Rs 26 lakh, paid by selling equities.
  5. The sale needs to be grossed up so that Rs 26 lakh is left after tax. Tax is 12.5% plus 4% cess (13%) on the gain share of the sale (average cost), after the Rs 1.25 lakh yearly exemption. The tax is gone for good.
  6. Loan: Rs 80 lakh, 8.5% fixed, 20 years. EMI turns out to be about Rs 69,426 a month.
  7. New tax regime. No home-loan interest deduction and no 80C, so Path B gets no tax refund. The old regime will be a side test.
  8. From month 85(after 7 years), Path B invests Rs 1 lakh + rent saved - EMI. The rent saved starts at Rs 25,000 a month (3% of Rs 1 crore a year) and grows 5% a year.
  9. The home grows 5.5% a year (3% to 10% tested). Upkeep costs are off. The home is held (not sold).
  10. Inflation is 5% for "today's money" figures. Will be interesting to see net worth at Year 27, before any exit tax. Also at year 30 looks like.
  11. Liquid-portfolio numbers come from the calculator's own engine. The loan, rent, tax and property arithmetic is added around it.
  12. The SIP changes once a year, at the start of each plan year, not every month.

1. The Year-7 shock

At Year 7, the portfolio is worth Rs 2.393 crore. With cost of Rs 1.34 crore, 44% of it is purely gain.

In order to fund Rs 26 lakh, the buyer must sell Rs 27.41 lakh. Tax incurred being Rs 1.41 lakh. Net portfolio falls to Rs 2.119 crore.

Note: Tax is small amount. But Rs 26 lakh reduction in portfolio is the real loss. Because it stops compounding.

Bar chart of the Year-7 sale. The portfolio is Rs 239 lakh before and Rs 212 lakh after; Rs 27.4 lakh is taken out, of which Rs 1.4 lakh is tax that is lost for good.
Figure 1. Portfolio before, cash taken out, and portfolio after at Year 7. Source: charts/03_year7_shock_data.csv.

2. No crossover

Path A, the renter, ends Year 27 with Rs 32.29 crore. While, Path B, the buyer, ends with Rs 29.36 crore: Rs 26.44 crore in equities + Rs 2.92 crore home (fully repaid loan).

The gap is Rs 2.92 crore. It is narrowest right after the purchase (Rs 7.5 lakh at month 85) and then keeps widening thereafter. At Year 30 the gap grows to Rs 4.48 crore.

But if you look at the investments alone, the gap looks even more larger. Buyer's liquid portfolio is Rs 5.84 crore (18%) less.

Line chart of net worth. The renter and buyer move together until the purchase at Year 7, then the buyer falls behind and ends Year 27 about Rs 2.9 crore short. A dashed line shows the buyer would only catch up if the home grew 9.2% a year.
Figure 2. Net worth of the renter (A) and the buyer (B). The dashed line shows B if the home rose 9.2% a year. Source: charts/01_networth_A_vs_B_data.csv.
Line chart of liquid portfolios only. The buyer's portfolio stays below the renter's from Year 7 on, and the shaded gap widens to about Rs 5.8 crore at Year 27.
Figure 3. Liquid portfolio only. The shaded area is the liquid wealth the home costs. Source: charts/02_liquid_A_vs_B_data.csv.

If everything were sold at Year 27, with equity tax, property tax and a 2% sale cost, A has Rs 28.58 crore and B has Rs 26.00 crore. The gap is Rs 2.58 crore.

3. Where the gap comes from

We build Path B one cost at a time, starting from Path A. Each step changes the Year-27 gap (in Rs crore):

StepChange in gap
Lost compounding on the Rs 26 lakh+2.51
LTCG tax+0.14
EMI taken out of the SIP+6.39
Rent saved, added back to the SIP-3.19
Home value counted-2.92
Gap at Year 272.92

The EMI is the big cost. The Rs 69,426 EMI is more than two-thirds of the Rs 1 lakh SIP, so Path B's SIP drops to about Rs 55,600 a month in Year 8. Rent saved and the home's value win back most of it, but not all.

The order of the steps changes the split a little. For example, rent saved looks bigger after the EMI has been taken out.

Waterfall chart of the Year-27 gap. Lost compounding adds 2.5 crore and the EMI taking money from the SIP adds 6.4 crore, while rent saved takes off 3.2 crore and the home's value takes off 2.9 crore, leaving a gap of 2.9 crore. A last bar shows the old-regime deduction would cut the gap by 0.4 crore.
Figure 4. How the Year-27 gap builds up. The last bar is the old-regime variant (Section 24(b) deduction), which shrinks the gap by Rs 0.44 crore to Rs 2.48 crore. Source: charts/04_waterfall_year27_gap_data.csv.
Line chart adding one cost of buying at a time. Each step lowers the liquid portfolio below the renter's line; the dashed line is the buyer's net worth including the home, which ends close to the renter's.
Figure 5. Each line adds one cost of buying. T0 to T4 show the liquid portfolio only. The dashed T5 line is net worth including the home. Source: charts/05_ladder_T0_to_T5_data.csv.

The EMI hurts most early on because interest comes first. In the first loan year, about Rs 6.7 lakh of the roughly Rs 8.3 lakh paid is interest. Over 20 years the interest adds up to Rs 87 lakh.

Stacked bar chart of the Rs 80 lakh loan. Each year's payment is the same, but interest is most of it in the early years and shrinks to a sliver by year 20.
Figure 6. Interest and principal paid each year on the Rs 80 lakh loan. Source: charts/06_loan_interest_vs_principal_data.csv.
Bar chart of the buyer's monthly SIP: the base SIP of Rs 1 lakh, minus the EMI, plus rent saved. The resulting SIP starts near Rs 56,000 a month and rises slowly, then jumps once the EMI ends after Year 27.
Figure 7. Where Path B's monthly SIP comes from: base SIP, minus EMI, plus rent saved. The SIP jumps when the EMI ends. Source: charts/07_pathB_sip_bridge_data.csv.

4. How fast must the home grow?

To catch up with the renter by Year 27, the home must grow 9.23% a year (nominal), or 4.02% after 5% inflation. That means a home worth Rs 5.84 crore at Year 27, against Rs 2.92 crore in the base case.

This depends on how well equities do. Higher equity returns make the home's job harder:

Equity returnBreak-even home growth (nominal)Real
10%7.54%2.42%
12%9.23%4.02%
14%10.94%5.65%

The buying year matters less. At 12% equity, break-even is 9.40% if the home is bought at Year 3, 9.23% at Year 7 and 8.98% at Year 12. In every case we tested, break-even stayed below 11.3%.

Line chart of the home growth needed to break even by Year 27. It rises with equity returns, from about 7.5% at 10% equity to about 11% at 14%, and is far above the 5.5% assumed in the base case.
Figure 8. Home growth needed to match the renter at Year 27, by equity return and purchase year. Source: charts/08_breakeven_vs_equity_cagr_data.csv.

The heat map shows the Year-27 gap across both rates. At 12% equity the buyer comes out ahead only at 10% home growth (Rs 0.89 crore ahead, from month 116). At 8% equity the buyer is ahead from about 6% growth.

Heat map of the Year-27 gap by home growth and equity return. The renter is ahead almost everywhere; the buyer wins only where home growth is high and equity returns are low, such as 10% growth with 12% equity or 6% growth with 8% equity.
Figure 9. Year-27 gap (A minus B) by home growth and equity return. Orange: renter ahead. Purple: buyer ahead. Source: charts/09_heatmap_gap_year27_data.csv.

Year-27 gap by home growth, at 12% equity (Rs crore):

Home growth3%4%5%6%7%8%10%
Gap4.043.653.192.631.971.18-0.89

5. Retirement

Both paths pass their FIRE numbers well before Year 27, so the gap measures wealth, not a failed plan.

Here the renter's FIRE number includes rent, and the buyer's does not. Spending is Rs 1.5 lakh a month in today's money, growing 5% a year.

At Year 27 (age 57), income from the liquid portfolio at a 3.5% withdrawal rate:

At 4%, it is Rs 10.8 lakh for A and Rs 8.8 lakh for B. At Year 30 the portfolios are Rs 45.8 crore (A) and Rs 37.9 crore (B).

The 3.5% FIRE number at Year 27 is Rs 19.2 crore for A and Rs 16.9 crore for B. Both portfolios are 1.6 to 1.9 times those numbers.

Age at which each path first reaches FIRE:

Withdrawal ratePath APath BDelay from buying
3.5%49.750.71.0 year
4%47.948.80.9 year

6. What changes the answer

A rising SIP changes the picture most. If the SIP grows 8% a year in both paths, the EMI stays fixed while income-linked saving grows. The gap is still Rs 2.91 crore, but it is only 5.5% of A's net worth (Rs 53.2 crore against Rs 50.3 crore). The FIRE delay shrinks to 0.1 to 0.2 years.

Other changes, with the Year-27 gap (base case: Rs 2.92 crore):

ChangeGap (Rs crore)Break-even growth
Equity return 10%1.367.54%
Equity return 14%5.0510.94%
Loan rate 7.5%2.47
Loan rate 9.5%3.40
Buffer 5%2.82
Buffer 7%3.03
Down payment 30%3.15
Upkeep costs on (0.5% a year)3.469.70%
Old regime, Section 24(b) deduction2.488.80%
Old regime, with 80C as well2.158.45%

Three points stand out:


Limits of this study


Try this scenario yourself

These links load the calculator with the same inputs. (Links marked Pro use Pro features.)

  1. Path A, the renter. Loads Rs 50 lakh start, Rs 1 lakh SIP, 12%, 27 years. Year-27 corpus: Rs 32.29 crore. Open
  2. Path A with the Year-7 sale. Same plan with Rs 19.48 lakh (today's money) taken out in Year 8. After inflation that is the Rs 27.41 lakh sale. Year-27 corpus: Rs 29.64 crore. This shows the shock before the EMI. Open
  3. Path B's liquid portfolio (approximate, Pro). Adds the reduced SIP, held in two-year blocks because the page allows 10 schedule rows. It matches the exact base-case portfolio to 0.02%. Year-27 corpus: about Rs 26.44 crore. Open
  4. Renter with an 8% yearly SIP step-up (Pro). Year-27 corpus: Rs 53.23 crore, in line with the step-up result above. Open
  5. Renter at 10% equity. Year-27 corpus: Rs 21.86 crore. Open
  6. Both paths on one graph, with Compare (Pro). Open link 3, open "Saved plans (Pro)", type the name Path B and press Save. Then open link 1. Under "Compare (Pro)", press "Pin this plan (create a baseline plan to compare)". Now pick Path B in the Saved plans list and press Open. The chart draws Path A as a dashed line (pinned) and Path B as the solid line, and a table under the answer sets the two side by side: Rs 32.29 crore against about Rs 26.45 crore at Year 27, a gap of Rs 5.84 crore.

What the links cannot do. The loan, the home's value and net worth are not calculator fields yet, so they cannot be loaded. We used our internal scripts to model this part for now. Compare links 1 to 3 to see the lost compounding and the SIP cut. Then change the equity return, the SIP or the step-up to test your own case.


This paper is for education, not personal financial advice. Results come from model assumptions, not forecasts.