Real Estate IRR Calculation: TRNC Example
Short answer: The internal rate of return (IRR) in real estate is a metric that converts all cash flows, from the money you pay on the purchase date to the amount you receive on the sale date, into a single annual return rate. Unlike gross rental yield, it accounts for purchase and sale costs, vacant months, the holding period and when the money is committed. This is the fairest way to compare a home in Northern Cyprus (TRNC) with different projects or alternatives such as deposits.
This article is prepared for investors who do not settle for rental yield percentages and instead ask, “what does this investment actually earn me on an annual basis?” Rather than making you memorise a formula, we present a method that allows you to make your own calculation with a spreadsheet. If you would also like to see how annual net rent is calculated, you can start with our Cyprus rental yield calculation guide.
What is the internal rate of return in real estate, and why does it matter?
The internal rate of return is the interest rate that makes the present value of all cash inflows and outflows of an investment equal to zero. In simpler terms: if you had deposited your money into an account paying interest at this rate, you would withdraw the same amounts on the same dates and reach the same result.
In residential investment, gross yield divides one year’s rental income by the price; net yield deducts expenses, but still measures only a single year. Neither can capture three important points:
- Entry and exit costs: VAT, stamp duty, title deed transfer fee, lawyer’s fee; withholding tax and commission on sale.
- Capital appreciation: A significant part of the gain is realised only on the day of sale.
- Timing: Money being committed in instalments when buying off-plan, and rent starting years later.
IRR brings all three into the same calculation. That is why “6% rental yield” and “2% annual total return” can describe the same apartment; both are correct, but the second is the one to use for decision-making.
What data do you need for the calculation?
A good IRR calculation starts with an accurate cash flow table. Create one row for each year and enter the money paid out of your pocket as negative, and the money entering your pocket as positive.
| Time | Item | Sign | Where to find it? |
|---|---|---|---|
| Year 0 | Price + VAT + stamp duty + title deed fee + lawyer + furniture | Negative | Contract and the lawyer’s cost breakdown |
| From year 1 to sale | Rent collected − tax − dues − management − maintenance − insurance | Positive (or negative) | Realistic rent and expense assumptions |
| When buying off-plan | Instalments, balance on delivery and VAT | Negative | Payment plan |
| Sale year | Sale price − withholding tax − commission − lawyer | Positive | Scenario-based sale assumption |
For current rates on purchase costs, you can review our articles on taxes and costs when buying a home in the TRNC, and for the sale side, tax when selling a home in the TRNC. Sources mention rates between 2.8% and 4% for sale withholding tax for individual sellers; in the example below, we stayed on the cautious side and used 4%.
Example: Ready apartment held for 7 years
The figures below are examples and do not represent the price or rent of any project. The purpose is to show the method.
Assumptions: Ready new 1+1 apartment, price 120,000 £. Turkish citizen, first immovable property; VAT 5% (6,000 £), stamp duty 0.5% (600 £), title deed transfer fee at the temporary tariff 4% (4,800 £), lawyer 2,000 £. Total outflow: 133,400 £. Annual net rent 3,500 £ (after deducting tax, dues, management and vacancy). Sale at the end of year 7; withholding tax 4%, commission 3% and lawyer 1,500 £ as sale costs.
| Annual Sterling appreciation | Year 7 sale price | Amount remaining from sale after costs | Total gain over 7 years | Internal rate of return (annual) |
|---|---|---|---|---|
| 0% | 120,000 £ | 110,100 £ | +1,200 £ | approximately 0.1% |
| 2% | 137,842 £ | 126,693 £ | +17,793 £ | approximately 2.0% |
| 4% | 157,912 £ | 145,358 £ | +36,458 £ | approximately 3.8% |
Total gain is calculated by adding 7 years of rent (24,500 £) to the amount remaining from the sale and deducting the 133,400 £ paid on the first day. The same apartment’s gross rental yield appears to be 6%, assuming monthly rent of 600 £. In the scenario with no capital appreciation, the fact that IRR falls almost to zero shows that purchase and sale costs consume a large part of the 7-year rental income.
How is it calculated in a spreadsheet?
- Enter the years (from 0 to 7) in column A, and the net cash flow for that year in column B: year 0 −133,400; years 1–6 3,500; year 7 3,500 + the amount remaining from the sale.
- In an empty cell, enter =İÇ_VERİM_ORANI(B1:B8) in Turkish Excel, and =IRR(B1:B8) in the English version and in Google Sheets.
- If payments are made on irregular dates (instalments, interim costs), add a date column and use the XIRR function; its Turkish Excel equivalent is AİÇVERİMORANI.
- Put assumptions in separate cells; change the appreciation rate, rent and sale year to see how much the result moves.
How does the holding period change IRR?
Purchase and sale costs are one-off; as the holding period extends, these costs are spread over more years and IRR rises. Selling in a short period means trying to cover the same costs with only a few years of rent.
| Scenario (2% annual appreciation) | Total gain | Internal rate of return |
|---|---|---|
| 3-year holding period | −5,969 £ | approximately −1.6% |
| 7-year holding period | +17,793 £ | approximately 2.0% |
| 10-year holding period | +36,140 £ | approximately 2.7% |
The same apartment, with the same rent and the same appreciation, moves from a loss to a reasonable return solely because the sale year changes. This table explains why short-term buy-and-sell plans often end in disappointment. When making the same calculation with your own budget, note the first year in which IRR exceeds zero; this is your break-even holding period and shows the shortest limit of your exit plan. We also discussed how costs erode appreciation through the break-even rate in our article on home price growth in Cyprus.
The impact of timing when buying off-plan
When buying off-plan, because money is committed in instalments and rent starts after delivery, IRR is sensitive to both the price difference and the delivery date. The example below uses the same 7-year horizon.
Assumptions: The same type of apartment off-plan for 110,000 £; total 122,450 £ with costs. Payments: year 0 45,000 £, year 1 33,000 £, on delivery (year 2) 44,450 £. Delivery value 120,000 £, then 2% annual appreciation; 3,500 £ net rent from year 3 onward; sale at the end of year 7 with the same sale costs.
- On-time delivery: Total gain over 7 years is approximately 16,765 £, IRR approximately 2.3%.
- If delivery is delayed by 1 year: One year of rent is lost and the final payment shifts by one year; total gain is approximately 13,265 £, IRR approximately 1.8%.
As seen, the IRR advantage of buying off-plan depends on the assumed price difference and on-time delivery; a one-year delay can eliminate its advantage over a ready apartment. You can also measure the hidden cost of the payment plan using the same method; we showed this calculation through the cash discount in our article on instalment home payment plans in Cyprus.
Common mistakes in IRR calculations
IRR is a powerful tool, but with incorrect inputs it produces very convincing wrong results. Pay attention to the following:
- Entering gross rent into cash flow: Rent entered without deducting tax, dues, management and vacant months inflates IRR by several points.
- Forgetting sale costs: Withholding tax is calculated on the sale price approved at the title deed office; it can arise even in a loss-making sale.
- Relying on a single scenario: Run at least three appreciation scenarios (0%, moderate, optimistic).
- Confusing exchange rate with appreciation: Make the calculation in Sterling; the increase in TL terms is largely exchange rate movement.
- Ignoring personal use: If you use the home yourself for part of the year, reflect the lost rent for that period in cash flow; consider the usage value separately.
What should you compare IRR with?
Compare the rate you find with alternatives in the same currency and with similar risk. Comparing the IRR of a Sterling-based home with a TL deposit interest rate is comparing apples and oranges; because a significant portion of TL interest compensates for the depreciation of the TL. According to the TRNC Statistical Institute data, consumer prices in the TRNC increased by 35.02% in September 2026 compared with the same month of the previous year; every comparison made in TL must account for this inflation (TRNC Statistical Institute).
When you compare residential IRR with a low-risk return in Sterling, the difference shows the premium you receive for the property’s lack of liquidity, management burden and price uncertainty. If this premium is small, the usage value of the home and your personal goals become more decisive in the decision.
Frequently asked questions
What is a good internal rate of return in real estate?
There is no single correct rate; IRR should be assessed together with alternative returns in the same currency and the risk of the investment. In a Sterling-based residential investment, the part above low-risk Sterling returns is the compensation for lack of liquidity and management burden. In our example calculations, reasonable assumptions produced an annual range of 2–4%; this is not a forecast or guarantee.
What is the difference between IRR and rental yield?
Rental yield compares the rent of a single year to the price. IRR converts all cash flows, from the total money paid on the purchase date to the amount you receive on sale, into a single annual rate together with their timing. Only IRR reflects costs, capital appreciation and the holding period.
How is IRR calculated in Excel?
Write each year’s net cash flow one under the other; the first row should be the total purchase cost with a negative sign, and the last row should be rent plus the amount remaining from the sale. Use the İÇ_VERİM_ORANI function in Turkish Excel, and the IRR function in the English version and in Google Sheets. For payments with irregular dates, XIRR, or AİÇVERİMORANI in Turkish, gives a more accurate result.
Why does IRR fall if I sell in a short period?
Because purchase and sale costs are one-off, and in a short period enough rent or appreciation does not accumulate to cover these costs. In our example, when the same apartment was sold in 3 years, IRR fell into negative territory, while when it was held for 10 years it rose to approximately 2.7%. The holding period is one of the variables that affects IRR the most.
How should I handle exchange rate differences in the IRR calculation?
If the home is bought and sold in Sterling, make the calculation in Sterling. A significant part of the increase measured in TL is the movement of Sterling against the TL, and mistaking this for the return on the property is misleading. If you save in TL, evaluate the exchange rate effect as a separate currency position.
If you would like to build the cash flow for your own apartment together and see the IRR under different scenarios, you can contact the Akol Global team.
This article is for informational purposes only; it does not replace legal, tax or financial advice. Last updated: October 2026.