Skip to content

Investment ROI calculator

Full hold period cash flow, equity build and exit after tax.

The deal

Rs

Rs 2.5 crore

Rsa month
7 years

Finance

30% · Rs 75 lakh
14.25%
20 years

Growth and exit

8.00%

Long run average near 8.0%.

7.00%
6.0%
2.5%
Total return over 7 years69.6%

Rs 6,266,130 of profit on Rs 9,000,000 invested, which is 7.84% a year compounded.

  • Annualised7.84%
  • IRR5.56%
  • Equity multiple1.70x
  • Capital gain after taxRs 1.78 crore
  • Loan paid downRs 18.55 lakh
  • Cash inRs 9,000,000Deposit plus Rs 1,500,000 of buying costs
  • Year one cash on cash-19.57%-Rs 1,761,658
  • Net proceeds at exitRs 26,129,043Sale at Rs 4.28 crore
  • Cash flow paybackNot within the holdWhen rent alone returns your capital

Cumulative position

-Rs 1.99 crore-Rs 41.86 lakhRs 1.15 croreRs 2.72 croreRs 4.28 crore01234567
  • Cumulative cash flow
  • Equity in the property
  • Property value
Years held

Cash versus leverage

Same property
  • Cash purchaseRs 26,500,000 in, Rs 754,759 year one82.3%
  • 20% depositRs 6,500,000 in, -Rs 2,140,173 year one59.7%
  • 30% depositRs 9,000,000 in, -Rs 1,761,658 year one69.6%
  • 40% depositRs 11,500,000 in, -Rs 1,383,142 year one75.2%
  • 50% depositRs 14,000,000 in, -Rs 1,004,626 year one78.8%

Borrowing lifts the return on your own money while the property grows faster than the interest rate, and cuts it just as sharply when it does not.

What you get at exit

Sale priceRs 42,845,607
Selling costs-Rs 1,071,140
Capital gains tax0.0%-Rs 0
Loan to redeem-Rs 15,645,424
Net proceedsRs 26,129,043

Year by year

YearRent collectedCosts and taxMortgageCash flowEquity
Year 1Rs 1,214,400Rs 326,448Rs 2,649,610-Rs 1,761,658Rs 9,666,453
Year 2Rs 1,299,408Rs 349,299Rs 2,649,610-Rs 1,699,501Rs 12,018,238
Year 3Rs 1,390,367Rs 373,750Rs 2,649,610-Rs 1,632,994Rs 14,572,010
Year 4Rs 1,487,692Rs 399,913Rs 2,649,610-Rs 1,561,830Rs 17,346,035
Year 5Rs 1,591,831Rs 427,907Rs 2,649,610-Rs 1,485,686Rs 20,360,360
Year 6Rs 1,703,259Rs 457,860Rs 2,649,610-Rs 1,404,211Rs 23,637,007
Year 7Rs 1,822,487Rs 489,910Rs 2,649,610-Rs 1,317,033Rs 27,200,183
Rent does not cover the costs
You need Rs 302,254 a month to break even on running costs and the mortgage. At Rs 110,000 you are funding the gap from your own pocket while you wait for capital growth.
What is not in here
No allowance for a major refurbishment, a change in tax rules, or a period with no tenant beyond the vacancy rate you set. Model the deal at a lower growth rate before you commit.
Return69.6%7.84% a year

About this calculator

Model a rental hold year by year, compare buying in cash against using leverage, and see the annualised return once selling costs and capital gains tax are paid. Capital gains tax follows the holding period table for plots, houses and flats. Capital gains tax applies the annual exemption and the residential property rates.

Capital gains rules change often. Confirm the rate that applies to your holding period before you sell.

Investment ROI calculator | Jagaan