« Which are the best performing tax-saving ELSS mutual funds in March 2024? What are the portfolio and tax related things that you must do in March 2024? »

How to correctly calculate returns from an under construction flat?

Posted on 03 Mar 2024
Author: Sayan Sircar

Tags: Calculator ; Real Estate

4 mins read
📢Join 2400+ readers on WhatsApp and get new post notifications!

This article gives an easy-to-use calculator for knowing the returns from buying and later selling an under-construction property.

How to correctly calculate returns from an under construction flat?

📚 Topics covered:

How to calculate returns from a real-estate investment?
How to use the calculator?
Case 1: Held until possession without home loan
Case 2: Held until possession with home loan
Case 3: Sold before registration

How to calculate returns from a real-estate investment?

Real estate investors who have invested in under-construction properties need a way to correctly calculate the return from their investments since

the builder is paid at different points of time and not all at once
stretched out payment plans allow you to pay a small amount now and the rest later
home loans can be taken today and only a small amount of might be paid in the moratorium period (only interest and no principal) to enhance returns

For this purpose we have created an easy-to-use calculator for calculating your overall returns when you sell the asset.

We have used the concept of Extended Internal Rate of Return (XIRR) to calculate the final returns since money is paid on different dates in an irregular fashion.

How to use the calculator?

We will use Google sheets to create a simple calculator for this calculation. There is a link to download a pre-filled copy of the Google sheet via the button below.

Important: You must be logged into your Google Account on a laptop/desktop (and not on a phone) to access the sheet.

This calculator is in the “house-sale-return” tab.

We will show a few cases below. In each case we will consider a house purchased for ₹1 crore where the construction takes place over multiple years.

A home loan of 75% of the house value is taken, if applicable, for 15 years at 9%. The EMI for such a loan is 1%: EMI Calculator: know your EMI per lakh to easily know how much total EMI you have to pay.

For simplicity, we have assumed that the final sale price is post tax.

To understand how to calculate your returns from your real estate investment:

Did you know that we have a private Facebook group which you can join for free and ask your own questions? Please click the button below to join.

Case 1: Held until possession without home loan

In this case, the investor makes payments to the builder out of their own funds, takes possession, pays for registration, interiors and other costs. The property is sold after some time.

Returns From An Under Construction Flat When Held Until Possession Without Home Loan

The final return is quite sensitive to the final sale price as we can see below:

Sensitivities of Returns From An Under Construction Flat When Held Until Possession Without Home Loan

Case 2: Held until possession with home loan

This case is the same as the one above but 75% of the price is paid via home loan. For the period before registration, only interest is paid on the home loan. EMI starts once registration is done.

Returns From An Under Construction Flat When Held Until Possession With Home Loan

Case 3: Sold before registration

In this case, the investor sells off the property before hand-over and registration is complete. There are significant savings since registration, interiors etc. are not done. The house is sold at a 30% premium to the allotment price and the investor makes an excellent return.

Returns From An Under Construction Flat When Sold Before Registration .

What's next? You can join the Arthgyaan WhatsApp community

You can stay updated on our latest content and learn about our webinars. Our community is fully private so that no one, other than the admin, can see your name or number. Also, we will not spam you.

To understand how this article can help you:

If you have a comment or question about this article

The following button will open a form with the link of this page populated for context:

If you liked this article, please leave us a rating

The following button will take you to Trustpilot:

Discover an article from the archives

Worked out case studies for goal-based investing

Case study: how can this middle-aged investor with two children plan for retirement and children's goals?

This article shows how a single-income middle-aged couple with two small children reach their retirement and children’s goals.
Case study: can this double income single kid family reach FIRE at 50?

This article shows how a double-income couple with a 2-year old reach their FIRE dream at the age of 50.
Case study: how a family in their mid-30s with a newborn kid can FIRE and invest in real estate?

This article shows how a double-income couple with a newborn child can invest for their future goals of FIRE and real-estate investment.
Case study: how this double income recently married family can perform DIY goal-based investment planning

This article shows how a young just-married couple can invest for future goals using the Arthgyaan goal-based investing tool.
Case Study: How should couples in their 40s with a new baby plan their financial future?

Did you welcome a bundle of joy in your 40s? This article will discuss ways of planning the child’s (and your’s financial future)
Case study: how this double income single kid family can perform DIY goal-based investment planning

This article shows how a very typical salaried couple with one child can invest for future goals using the Arthgyaan goal-based investing tool.

Previous and next articles:

<p>This post sifts through 43 options to find the best performing ELSS funds for the 3-year period ending before March 2024.</p>

Tax Mutual Funds

Which are the best performing tax-saving ELSS mutual funds in March 2024?

This post sifts through 43 options to find the best performing ELSS funds for the 3-year period ending before March 2024.

Published: 2 March 2024

10 MIN READ

<p>This article gives you the list of things you must do in March regarding taxes and improving your portfolio returns.</p>

Tax Mutual Funds

What are the portfolio and tax related things that you must do in March 2024?

This article gives you the list of things you must do in March regarding taxes and improving your portfolio returns.

Published: 6 March 2024

6 MIN READ

Latest articles:

<p>This article helps you get NPS NAV data via an easy to use API so that you can easily calculate, using Excel or Google Sheets, how much money you have in NPS.</p>

Market Data NPS

How to use Arthgyaan API to get NPS NAV to calculate your NPS corpus value?

This article helps you get NPS NAV data via an easy to use API so that you can easily calculate, using Excel or Google Sheets, how much money you have in NPS.

Published: 5 May 2024

3 MIN READ

<p>This article shows how quickly you can pay off your home loan, and even save a lot of interest, by increasing your EMI steadily year-on-year.</p>

House Purchase Loans

How much time and interest do you save if you pay off your home loan using a step-up EMI?

This article shows how quickly you can pay off your home loan, and even save a lot of interest, by increasing your EMI steadily year-on-year.

Published: 1 May 2024

4 MIN READ

Topics you will like:

Asset Allocation (21) Basics (8) Behaviour (12) Budgeting (12) Calculator (25) Case Study (6) Children (17) Choosing Investments (40) FAQ (12) FIRE (13) Gold (22) Health Insurance (5) House Purchase (30) Insurance (16) International Investing (12) Life Stages (2) Loans (18) Market Data (8) Market Movements (17) Mutual Funds (46) NPS (8) NRI (19) News (18) Pension (8) Portfolio Construction (53) Portfolio Review (27) Reader Questions (8) Real Estate (7) Research (5) Retirement (38) Review (15) Risk (6) Safe Withdrawal Rate (5) Set Goals (28) Step by step (15) Tax (59)

Next steps:

1. Email me with any questions.

2. Use our goal-based investing template to prepare a financial plan for yourself.

Don't forget to share this article on WhatsApp or Twitter or post this to Facebook.

Discuss this post with us via Facebook or get regular bite-sized updates on Twitter.