Investment Example

There are a number of factors that you should consider when calculating the possible yield of a property investment. These are described in the following:

Financing

Because of the possibility of financing most of the purchase with a mortgage, even a modest increase in the value of the property will return a significant yield on the equity invested. If you assume that the rent covers exactly 100% of the total costs of owning the property, a property with 75% financing will thus return a yield on equity of four times the annual increase in the property values. This is because the equity invested only accounts for 25% of the property value while 75% of the value has been covered with a mortgage. If the property value thus increases by 8% in a year, the return on equity would be 32%.

Interest Rates

Another important factor is the level of interest rates. The question is here whether the current interest rates will be maintained. However, it is possible – if you expect interest rates to rise – to choose a fixed interest rate mortgage that will lock the interest rate at the current level for up to five years (followed by variable interest). This is only slightly more expensive that a mortgage with variable interest from the outset. You can thus lock in the interest at a relatively low level for those years where the outstanding mortgage is at its highest level in terms of outstanding repayments.

Exchange Rate Risk

There is no exchange risk in connection with the mortgaging of the property. The mortgage is denominated in Pound Sterling and an increase in the value of the Pound against your local currency will thus not only lead to an increase in the value of the mortgage (to your disadvantage), but also to an increase in the value of the property (to your advantage). Conversely, a decline in the value of the Pound against your local currency will mean a decrease in the value of the mortgage (to your advantage) and a decrease in the value of the property (to your disadvantage).

Only the net equity in the property may thus be influenced by exchange rate fluctuations.

Rental Income

For calculation purposes, we currently expect that the rental income will cover 80% of mortgage payments and operating costs in Year 1 and that it will rise gradually to exceed 100% in Year 10.   

If taking out an interest-only mortgage, the rental income should fully cover both mortgage interest and operating costs already from Year 1.

Vacant Periods - ‘Voids’

An additional factor is the possible waiting time in connection with the search and selection of new tenants and/or the time needed for major repairs or improvements to the property. This can be anything from no months per year (if the tenant extends his tenancy) to, for instance, three months per year (if a new tenant must be found and the rent demanded by the owner is relatively high). It is obviously important to minimise the vacant periods since no rent will be earned when the property stands empty.

In the calculation below a provision for vacant periods has been included in the amount under the heading ‘Other Expenses”.

Buying and Selling Costs

Finally, it is necessary to take Buying and Selling Costs into account. In the calculations below, the Buying Costs have been distributed evenly over the chosen ownership period of 25 years under the heading ‘Other Costs’.

The Selling Costs depend in part upon the value of the property at the time of sale.

Sample Calculations

Below are shown two sample calculations for a typical property where the above factors have been taken into consideration. Currently, it may be possible to achieve lower financing costs than shown below. However, we have used an average mortgage rate of 6% in our calculations as we prefer to estimate conservatively. For comparison, the Association of Residential Letting Agents (ARLA) is currently using 5.50% p.a. as their calculation basis (Source: themovechannel.com, 1st October 2003).

The calculations are based on the following premises:

  • Rents rise with inflation

  • Other costs rise with inflation

  • The parameter percentages are the effective annual rates that are achieved over the full calculation period of 25 years

The first example operates with an annual property appreciation of 4%:

Sample Calculation for Investment in a British Residential Property
(all amounts in £)

Parameters:

Accumulated Interest 6,0%  per annum
Mortgage Period 25  years
Mortgage Amount 75.000  £
Purchase Price 100.000  £
Property Appreciation 4,0%  per annum
Inflation 2,5%  per annum

  Year   Rental
  Income  
  Interest     Other
  Costs  
Property
  Appreciation  
Annual
  Net Profit  
Annual
  Net Profit
as % of
Initial
  Investment 
  Property  
Value
1 6.000 4.500 3.000 4.000 2.500 10,0% 104.000
2 6.150 4.418 3.075 4.160 2.817 11,3% 108.160
3 6.304 4.331 3.152 4.326 3.147 12,6% 112.486
4 6.461 4.239 3.231 4.499 3.491 14,0% 116.986
5 6.623 4.141 3.311 4.679 3.850 15,4% 121.665
6 6.788 4.038 3.394 4.867 4.223 16,9% 126.532
7 6.958 3.928 3.479 5.061 4.612 18,4% 131.593
8 7.132 3.812 3.566 5.264 5.018 20,1% 136.857
9 7.310 3.688 3.655 5.474 5.441 21,8% 142.331
10 7.493 3.557 3.747 5.693 5.882 23,5% 148.024
11 7.681 3.419 3.840 5.921 6.342 25,4% 153.945
12 7.873 3.272 3.936 6.158 6.822 27,3% 160.103
13 8.069 3.116 4.035 6.404 7.322 29,3% 166.507
14 8.271 2.951 4.136 6.660 7.845 31,4% 173.168
15 8.478 2.776 4.239 6.927 8.389 33,6% 180.094
16 8.690 2.591 4.345 7.204 8.958 35,8% 187.298
17 8.907 2.394 4.454 7.492 9.551 38,2% 194.790
18 9.130 2.186 4.565 7.792 10.170 40,7% 202.582
19 9.358 1.965 4.679 8.103 10.817 43,3% 210.685
20 9.592 1.731 4.796 8.427 11.492 46,0% 219.112
21 9.832 1.483 4.916 8.764 12.198 48,8% 227.877
22 10.077 1.220 5.039 9.115 12.934 51,7% 236.992
23 10.329 941 5.165 9.480 13.703 54,8% 246.472
24 10.588 645 5.294 9.859 14.507 58,0% 256.330
25 10.852 332 5.426 10.253 15.347 61,4% 266.584

This can be illustrated as follows:


In case the annual property appreciation reaches 8%, the calculation will look as follows:

Sample Calculation for Investment in a British Residential Property
(all amounts in £)

Parameters:

Accumulated Interest 6,0% per annum
Mortgage Period 25 years
Mortgage Amount 75.000 £
Purchase Price 100.000 £
Property Appreciation 8,0% per annum
Inflation 2,5% per annum

  Year   Rental
  Income  
  Interest     Other  
Costs
Property
  Appreciation  
Annual
  Net Profit  
Annual
Net Profit
as % of
Initial
  Investment  
  Property  
Value
1 6.000 4.500 3.000 8.000 6.500 26,0% 108.000
2 6.150 4.418 3.075 8.640 7.297 29,2% 116.640
3 6.304 4.331 3.152 9.331 8.152 32,6% 125.971
4 6.461 4.239 3.231 10.078 9.069 36,3% 136.049
5 6.623 4.141 3.311 10.884 10.054 40,2% 146.933
6 6.788 4.038 3.394 11.755 11.111 44,4% 158.687
7 6.958 3.928 3.479 12.695 12.246 49,0% 171.382
8 7.132 3.812 3.566 13.711 13.465 53,9% 185.093
9 7.310 3.688 3.655 14.807 14.774 59,1% 199.900
10 7.493 3.557 3.747 15.992 16.181 64,7% 215.892
11 7.681 3.419 3.840 17.271 17.693 70,8% 233.164
12 7.873 3.272 3.936 18.653 19.317 77,3% 251.817
13 8.069 3.116 4.035 20.145 21.064 84,3% 271.962
14 8.271 2.951 4.136 21.757 22.941 91,8% 293.719
15 8.478 2.776 4.239 23.498 24.960 99,8% 317.217
16 8.690 2.591 4.345 25.377 27.131 108,5% 342.594
17 8.907 2.394 4.454 27.408 29.467 117,9% 370.002
18 9.130 2.186 4.565 29.600 31.979 127,9% 399.602
19 9.358 1.965 4.679 31.968 34.682 138,7% 431.570
20 9.592 1.731 4.796 34.526 37.591 150,4% 466.096
21 9.832 1.483 4.916 37.288 40.721 162,9% 503.383
22 10.077 1.220 5.039 40.271 44.090 176,4% 543.654
23 10.329 941 5.165 43.492 47.716 190,9% 587.146
24 10.588 645 5.294 46.972 51.620 206,5% 634.118
25 10.852 332 5.426 50.729 55.824 223,3% 684.848

The British property market rose by some 25-30% in 2002 (depending upon the index used). At a rise of 27% and with financing of 75% of the property value, the investment would have given a return of 108% on equity in 2002 alone, provided that the financing and operating costs of the property were fully covered by the rent.

It is, of course, unlikely that prices will rise steadily by 27% per year over the next 25 years. However, it is worth noting that British property prices actually increased 26-fold in the period 1969-2002   (See Factors). A high return on equity is thus a very real possibility.

And extended spreadsheet can be downloaded from here so that you may experiment with the consequences of different economic scenarios and price rises. Sheet 2 of the spreadsheet uses the same structure as the above calculations whereas Sheet 1 contains a number of additional calculations.

 

To the Top

Read about Buying Costs