If you own a property and receive rental income from it, use this calculator to determine the return on your investment.
If you like idea of using real estate for financial leverage, this is the perfect tool for you. Financial leverage is investing with borrowed capital. In the present context it refers to buying a property with a home loan for rental income and associated tax benefits. For the first 1-3 years returns would be very low (negative). After a few years returns will be approximately equal to the actual appreciation in the property price. This calculator gives the annual return for 30 years. It allows the user to account for periods in which the property was vacant.
How does it work? The calculator takes into account all possible expenses and tax deductions associated with a property, in addition to the rent received and a (reasonable) rate of appreciation of the property. Since rental income cannot be assumed to be constant, you will need to indicate how many months in a year the property was occupied. The corresponding rent also has to be entered.
Payments/Expenses: These include the EMI (if applicable), all costs associated with the purchase (stamp duty, registration, VAT, service tax etc.), interior decoration costs, monthly society charges (or maintenance) that appreciates at some rate, municipal taxes (property, water and sewage) and home insurance premium. Tax from rental income is also accounted for.
Receipts/deductions: These include the entire interest component of the EMI as a tax deduction and of course the (post-tax) rent received. If there is a loss from the property, it is assumed to be adjusted against other taxable income in the same financial year.
Have I missed out any expense? Do let me know.
Output: The compounded annual growth rate (CAGR) is determined using Excels XIRR function, each year, for 30 years. For calculating CAGR, value of the property at the end of each year is taken as the final amount received from the investment after deducting the home loan balance.
The rate of appreciation of property value is crucial to the calculation. If you do not assume a realistic rate, results will reflect that. So is rental income for that matter.
- Should not be used for self-occupied property. Value of such property is (ground) zero!
- The calculator assumes all initial costs (payment to the builder, stamp duty, registration charges, and interiors) are made on the same date!
- The EMI payment (and hence tax deduction) is also assumed to start only when the apartment if fully furnished and read for rent.
- You could specify a gap (in months) between initial costs and start of EMI payment.
- Points 3 and 4 may sound quite impractical since things never ever pan out this way. However, I am reasonably convinced that the return calculation (especially after 5 years or so) will not be affected too much because of this. If you are not convinced let me know, I will happy to explain why I think so.
- The entire EMI is treated as an expense, not just the interest component.
If you don't wish to enter rent for each year and would only like to see a projection of returns for a given rent, this is the one for you:
- Subramoney coaxed me into making this calculator. I thank him for several useful suggestions.
- Parag Rijwani, Assistant Professor, Nirma Institute of Management for pointing out errors and for suggesting the simpler version.
- Financial Leverage in Real Estate
- The Changed Model of Real Estate Returns
Buy our New Book!You Can Be Rich With Goal-based Investing A book by P V Subramanyam (subramoney.com) & M Pattabiraman. Hard bound. Price: Rs. 399/- and Kindle Rs. 349/-. Read more about the book and pre-order now!