Real Estate Returns Calculator

Published: July 10, 2013 at 5:46 am

Last Updated on

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.

Note:

  1. Should not be used for self-occupied property. Value of such property is (ground) zero!
  2. The calculator assumes all initial costs (payment to the builder, stamp duty, registration charges, and interiors) are made on the same date!
  3. The EMI payment (and hence tax deduction) is also assumed to start only when the apartment if fully furnished and read for rent.
  4. You could specify a gap (in months) between initial costs and start of EMI payment.
  5. 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.
  6. The entire EMI is treated as an expense, not just the interest component.

Download the Feb 2017 Real Estate Returns Calculator

 July 2013 Real Estate Returns Calculator (old version)

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:

July 2013 (simpler version) Real Estate Returns Calculator(old version)

 Credits:

  • 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.

Pune Investor Workshop Feb 26th, 2017

The second Pune workshop will be held on Feb 26th, 2017. You can register for this via this link

Join our 1500+ Facebook Group on Portfolio Management! Losing sleep over the market crash? Don't! You can now reduce fear, doubt and uncertainty while investing for your financial goals! Sign up for our lectures on goal-based portfolio management and join our exclusive Facebook Community. The 1st lecture is free! Did you miss out on the lockdown discount? You can still avail it! Follow instructions in the above link!

You Can Be Rich Too With Goal-Based Investing

The best book ever on Finanical Freedom Planning. Go get it now!

Your first investment should be buying this book

The (nine online) calculators are really awesome and will give you all possible insights

Thank you, readers, for your generous support and patronage.

Amazon Hardcover Rs. 319.99. 20% OFF

Kindle at Amazon.in (Rs. 244.30)

Google Play Store (Rs. 244.30)

Now just Rs. 307 use love10 to get additional 10% OFF.   at Infibeam

If you use a mobikwik wallet, and purchase via infibeam, you can get up to 100% cashback!!

  • Ask the right questions about money
  • get simple solutions
  • Define your goals clearly with worksheets
  • Calculate the correct asset allocation for each goal.
  • Find out how much insurance cover you need, and how much you need to invest with nine online calculator modules
  • Learn to choose mutual funds qualitatively and quantitatively.

More information is available here: A Beginner’s Guide To Make Your Money Dreams Come True!

What Readers Say

Also Available At

Bookadda Rs. 371. Flipkart Rs. 359

Amazon.com ($ 3.70 or Rs. 267)

Google Play Store (Rs. 244.30)

Do share if you found this useful
Share your thoughts on this topic at the  Reddit freefincal_user_forum

Reach your financial goals like a pro! Join our 1600+ Facebook Group on Portfolio Management! You can now reduce fear, doubt and uncertainty while investing for your financial goals! Sign up for our lectures on goal-based portfolio management and join our exclusive Facebook Community. The 1st lecture is free!
Want to check if the market is overvalued or undervalued? Use our market valuation tool (will work with any index!) or you buy the new Tactical Buy/Sell timing tool!
About the Author Pattabiraman editor freefincalM. Pattabiraman(PhD) is the founder, managing editor and primary author of freefincal. He is an associate professor at the Indian Institute of Technology, Madras. since Aug 2006. Connect with him via Twitter or Linkedin Pattabiraman has co-authored two print-books, You can be rich too with goal-based investing (CNBC TV18) and Gamechanger and seven other free e-books on various topics of money management. He is a patron and co-founder of “Fee-only India” an organisation to promote unbiased, commission-free investment advice. He conducts free money management sessions for corporates and associations on the basis of money management. Previous engagements include World Bank, RBI, BHEL, Asian Paints, Cognizant, Madras Atomic Power Station, Honeywell, Tamil Nadu Investors Association. For speaking engagements write to pattu [at] freefincal [dot] com
About freefincal & its content policy Freefincal is a News Media Organization dedicated to providing original analysis, reports, reviews and insights on developments in mutual funds, stocks, investing, retirement and personal finance. We do so without conflict of interest and bias. We operate in a non-profit manner. All revenue is used only for expenses and for the future growth of the site. Follow us on Google News Freefincal serves more than one million readers a year (2.5 million page views) with articles based only on factual information and detailed analysis by its authors. All statements made will be verified from credible and knowledgeable sources before publication. Freefincal does not publish any kind of paid articles, promotions or PR, satire or opinions without data. All opinions presented will only be inferences backed by verifiable, reproducible evidence/data. Contact information: letters {at} freefincal {dot} com (sponsored posts or paid collaborations will not be entertained)
Connect with us on social media
Our publications

You Can Be Rich Too with Goal-Based Investing

You can be rich too with goal based investingPublished by CNBC TV18, this book is meant to help you ask the right questions, seek the right answers and since it comes with nine online calculators, you can also create custom solutions for your lifestyle! Get it now. It is also available in Kindle format.
Gamechanger: Forget Startups, Join Corporate & Still Live the Rich Life You Want Gamechanger: Forget Start-ups, Join Corporate and Still Live the Rich Life you wantThis book is meant for young earners to get their basics right from day one! It will also help you travel to exotic places at low cost! Get it or gift it to a young earner

Your Ultimate Guide to Travel

Travel-Training-Kit-Cover-new This is a deep dive analysis into vacation planning, finding cheap flights, budget accommodation, what to do when travelling, how travelling slowly is better financially and psychologically with links to the web pages and hand-holding at every step. Get the pdf for Rs 199 (instant download)
Free android apps