Real Estate Value: Let or Sell | Rent or Buy

Real Estate­ Value: Let or Sell and Rent or Buy

Your partner for real estate valuation.

Call Now
Management Consulting

Are you considering letting or selling a property, or renting or buying? I am a management consultant specializing in business valuation and would like to explain the valuation of real estate to you. Estimating future necessary investments may be the job of a civil engineer, but the mathematics of valuing companies and real estate are identical.

Unfortunately, I see time and again that wrong decisions are made when buying and selling real estate. These are decisions with considerable consequences. The following explanations are intended to help prevent wrong decisions. The aim is for you to understand how the value of a real estate property is determined.

Call Now

Value and Price of Real Estate

It is important that a distinction is made between value and price in a real estate valuation. Unfortunately, these two words are often confused. The decision value is subjective (dependent on the individual) and takes into account the individual decision field (e.g., taxes, loss carryforwards, alternative investments, withdrawal preferences, etc.) and is the most significant value that characterizes the limit of advantageousness.

The benefit of the future cash flow is discounted to the present using a calculation interest rate (endogenous marginal interest rate).

In addition to the decision value, there is an arbitration value (umpire value), which an independent appraiser can calculate from the decision values of the parties involved. Argumentation values are values used to influence negotiations, which can be based on more or less plausible procedures.

Two other values should be mentioned. The liquidation value (sale of all assets) is considered the lower value limit in business valuation. The reconstruction value is more significant in the context of real estate valuation and corresponds to the new construction of the property, including land acquisition. In business valuation, it corresponds to a new foundation.

The price, on the other hand, is the amount paid in a transaction. It regularly deviates from the decision value.

The well-known capitalized earnings method according to ImmoWertV does not actually calculate values but market prices based on market data. The transformation factor is the property interest rate. Roughly speaking, it works like this:

  • Properties a, b, and c are sold.
  • An expert committee calculates a property interest rate from the sales.
  • This property interest rate is used (adjusted for the specific property) for the value calculation (better price calculation) of property d.

However, the property interest rate is a kind of "black box" that implies a lot of data and should not be used for investment decisions. Why? It implies the overall development of relevant factors (yield curve, inflation, population, economy, etc.).

In a property bubble, the property interest rate tends to fall further and further. A low interest rate causes property prices and values to rise massively. Since the property interest rate is derived from market data, the capitalized earnings method according to ImmoWertV justifies inappropriately high prices during property bubbles. The situation is different with the functional valuation theory and the closely related original capitalized earnings method (Hering, 2017; Hering, 2021; Matschke & Brösel, 2013; Toll, 2011; Walochnik, 2021).

Explanations of the capitalized earnings method in various forms, including according to ImmoWertV, can be found on the linked page on the capitalized earnings method. The capitalized earnings method according to ImmoWertV has its justification within the legal scope of application.

Below you can see a graph that shows how strongly the interest rate influences the real estate value. If a perpetual annuity is discounted at an interest rate of 10%, the value is 120,000 monetary units (MU). At an interest rate of 5%, it is already 240,000 MU, and at an interest rate of 1%, it is 1,200,000 MU.

Figure 1: Discounting a Perpetual Annuity

Discounting Perpetual Annuity

Source: own presentation.

Letting or Selling Real Estate?

This section explores the question of when it is worthwhile to let and when to sell real estate. The examples are abstracted from real-life circumstances so that they are easy to understand. Complex calculations (progressive taxes, loss carryforwards, etc.) are not considered in these explanations.

Mr. Immanuel Biele lives alone and has an annual gross salary of 50,000 monetary units (MU) and rents out a property for 12,000 MU per year. Both are taxed at a rate of 30%. The necessary living expenses amount to 10,000 MU. Investments at the bank can be made at 5%. Investments are taxed at 25%, so the net interest rate is 0.05*(1-0.25) = 3.75%. (Formulas for net interest rates can be found in Schneeloch et al. (2020).)

In the base case, there is no inflation; in the variation, there is growth (inflation) of 2%. Salary, living costs, and rent develop in line with inflation (indexation).

Immanuel Biele is faced with the question of whether to continue renting out his property or to sell it. To do this, he seeks his decision value. This is the value at which the advantageousness reverses.

Letting Real Estate

In the case of letting without inflation, Mr. Biele has a salary of 50,000 MU and rental income of 12,000 MU. Living expenses amount to 10,000 MU. After taxation and deduction of essential living expenses, he has (50,000+12,000)*(1-0.3) - 10,000 = 33,400 MU per year at his free disposal (withdrawal). He uses this particularly for leisure activities and vacations.

Table 1: Letting Real Estate without Growth

DescriptionYear 1Year 2Year 3Year ...
Salary500005000050000...
Rental Income120001200012000...
Tax-18600-18600-18600...
Living Expenses-10000-10000-10000...
Withdrawal-33400-33400-33400...

Source: own presentation.

The case is similar to the above case with the addition that his salary, rental income, and living expenses are adjusted for inflation.

Table 2: Letting Real Estate with Growth

DescriptionYear 1Year 2Year 3Year ...
Salary500005100052020...
Rental Income120001224012484.8...
Tax-18600-18972-19351.44...
Living Expenses-10000-10200-10404...
Withdrawal-33400-34068-34749.36...

Source: own presentation.

Selling Real Estate

Mr. Biele is considering selling his property. An expert in the valuation of real estate and companies tells him that at a value (decision value) of at least 224,000 MU, he can achieve the same withdrawal stream as when renting. To clarify, he provides the following financial plan.

The calculation interest rate (endogenous marginal interest rate) is 0.05*(1-0.25)=0.0375. As a perpetual annuity, this equally results in 120,000*(1-0.3)/0.0375 = 224,000 MU.

(The rent was taxed at 30%; capital earnings are only taxed at 25%. The net result of the rental income 12,000*(1-0.3) and the interest income (11,200*(1-0.25)) is the same amount of 8,400 MU.)

Table 3: Real Estate Value Calculation excl. Growth and Taxes

DescriptionYear 1Year 2Year 3Year ...
Salary500005000050000...
Interest Income112001120011200...
Tax-15000-15000-15000...
Tax on Interest-2800-2800-2800...
Living Expenses-10000-10000-10000...
Withdrawal-33400-33400-33400...
Capital/Bank Investment224000224000224000...

Source: own presentation.

In the following case, the appraiser takes into account inflation and thus price increases. The decision value, i.e., the value at which the advantageousness between sale and letting turns, is 480,000 MU. In this case, too, the appraiser provides a financial plan for the valuation of real estate and companies.

The calculation interest rate (endogenous marginal interest rate) is 0.05*(1-0.25)=0.0375. As a perpetual annuity with growth, this equally results in 120,000*(1-0.3)/(0.0375-0.02) = 480,000 MU.

Table 4: Real Estate Value Calculation incl. Growth and Taxes

DescriptionYear 1Year 2Year 3Year ...
Salary500005100052020...
Interest Income240002448024969.6...
Tax-15000-15300-15606...
Tax on Interest-6000-6120-6242.4...
Living Expenses-10000-10200-10404...
Withdrawal-33400-34068-34749.36...
Capital/Bank Investment480000489600499392...

Source: own presentation.

The examples show that in a real estate valuation, the withdrawal stream must at least correspond to the initial situation. Then the amount is sought, which must minimally be obtained to achieve this withdrawal stream. In technical terms, this is once the base program and then the valuation program. Of course, in the real world, much more information must flow into the valuation, such as progressive taxes, loss carryforwards, risk, etc.

What is particularly significant is what is done with the money after the sale. Is it invested at a low interest rate at a bank? Is the money invested in shares on the capital market? Is the sale used to pay off a high-interest loan? The decision value depends on the individual situation (alternative investment). Figure 2 shows the effect of the alternative investment again. The higher the alternative interest rate in the above case, the lower the decision value when selling the property. You can also conclude that a sale without alternative use is pointless (interest rate of 0%).

Figure 2: Discounting Investment Alternative Sale

Real Estate Value Sale Interest

Source: own presentation.

Renting or Acquiring Real Estate?

This section explores the question of when it is worthwhile to rent and when to acquire real estate. The examples are abstracted from real-life circumstances so that they are easy to understand. Complex calculations (progressive taxes, loss carryforwards, etc.) are not considered in these explanations.

Mr. Immanuel Biele lives alone and has an annual gross salary of 50,000 MU. This is taxed at a rate of 30%. The necessary living expenses amount to 10,000 MU. In addition, he can either rent a property for 12,000 MU per year or acquire one for a currently unknown price. Specifically, he can either rent one side of a semi-detached house or acquire the other side.

In the base case, there is no inflation; in the variation, there is growth (inflation) of 2%. Salary, living costs, and rent develop in line with inflation (indexation).

Investments at the bank can be made at 5%. Investments are taxed at 25%, so the net interest rate is 0.05*(1-0.25) = 3.75%. (Formulas for net interest rates can be found in Schneeloch et al. (2020).)

There are further case distinctions with loans. In the first case group, unlimited loans can be taken out at 10%. In the other case group, an installment loan (annuity loan) over 10 years can be taken out at 10% and is tied to the acquisition price (mathematically through a restriction in a linear program). The loan can be represented as a cash flow as follows:

Without inflation: [1, -0.1627, -0.1627, -0.1627, -0.1627, -0.1627, -0.1627, -0.1627, -0.1627, -0.1627, -0.1627]

With inflation: [1, -0.1509, -0.154, -0.157, -0.1602, -0.1634, -0.1666, -0.17, -0.1734, -0.1768, -0.1804]

Mr. Biele is faced with the question of whether to rent or acquire a property. To do this, he seeks his decision value. This is the value at which the advantageousness reverses.

Renting Real Estate

In the case of renting without growth (inflation), Mr. Biele has a salary of 50,000 MU. He pays 15,000 MU in taxes. The necessary living costs amount to 10,000 MU, and the rent is 12,000 MU per year. Net, he has 50,000 - 15,000 - 10,000 - 12,000 = 13,000 MU at his disposal (withdrawal). He uses this particularly for leisure activities and vacations.

Table 5: Renting Real Estate without Growth

DescriptionYear 1Year 2Year 3Year ...
Salary500005000050000...
Tax-15000-15000-15000...
Living Expenses-10000-10000-10000...
Rent-12000-12000-12000...
Withdrawal-13000-13000-13000...

Source: own presentation.

The case is similar to the above case with the addition that his salary, living expenses, and rent are adjusted for inflation.

Table 6: Renting Real Estate with Growth

DescriptionYear 1Year 2Year 3Year ...
Salary500005100052020...
Tax-15000-15300-15606...
Living Expenses-10000-10200-10404...
Rent-12000-12240-12484.8...
Withdrawal-13000-13260-13525.2...

Source: own presentation.

Acquiring Real Estate

In the case of acquiring real estate, two groups of cases will be presented. This is followed by a few variations in tables.

In the first case group (extreme case), only the loan interest (no annuity loan) and no repayment are paid.

In the second case group, an annuity loan is taken out in the amount of the acquisition price. Further loans are avoided by Mr. Biele.

Note: The following explanations do not apply to a real estate acquisition for investment purposes, i.e., for letting. In that case, taxes on the rental income would need to be considered.

Acquiring Real Estate - Interest Payment Only

In the extreme case, Mr. Biele only pays the interest. An expert in the valuation of real estate and companies tells him that at a value (decision value) of a maximum of 120,000 MU, he can achieve the same withdrawal stream as when renting. To illustrate, he provides the following financial plan. It becomes clear that he only pays the interest amounting to 12,000 MU without ever repaying.

The calculation interest rate (endogenous marginal interest rate) is 0.1. Calculated as a perpetual annuity, this results in 120,000/0.1 = 120,000 MU.

Table 7: Acquiring Real Estate without Growth (Extreme Case Only Interest Payment)

DescriptionYear 1Year 2Year 3Year ...
Salary500005000050000...
Tax-15000-15000-15000...
Living Expenses-10000-10000-10000...
Property Acquisition-12000000...
Interest-12000-12000-12000...
Repayment000...
Withdrawal-13000-13000-13000...
Loan120000120000120000...

Source: own presentation.

In the variation, the appraiser takes into account inflation and thus price increases. The decision value, i.e., the value at which the advantageousness between purchase and rent turns, is 150,000 MU. In this case too, the appraiser provides a financial plan for the valuation of real estate and companies. Only the interest is paid, and the loan increases annually so that the interest can just be serviced. (After all, purchasing power and the saved rent increase.)

Table 8: Acquiring Real Estate with Growth (Extreme Case Only Interest Payment)

DescriptionYear 1Year 2Year 3Year ...
Salary500005100052020...
Tax-15000-15300-15606...
Living Expenses-10000-10200-10404...
Property Acquisition-15000000...
Interest-15000-15300-15606...
Repayment000...
Withdrawal-13000-13260-13525.2...
Loan150000153000156060...

Source: own presentation.

Acquiring Real Estate - Annuity Loan

Mr. Immanuel Biele takes out a loan from his bank in the amount of the acquisition price. The loan (annuity loan) has an interest rate of 10% and is repaid over 10 years. After that, he wants to remain debt-free.

An expert in the valuation of real estate and companies tells him that with a maximum value (decision value) of 73,734.81 MU, he can achieve the same withdrawal stream as when renting. He provides him with the following financial plan for clarification.

The calculation interest rate (endogenous marginal interest rate) is 0.1.

The value of 73,734.81 MU can also be calculated using the formula for the present value factor bwf(i,n) = ((1+i)^n - 1)/((1+i)^n * i). This results in 12,000 * 6.14 = 73,734.81 MU. If Mr. Biele were to allow unlimited indebtedness, as in the extreme case, he could discount the saved rental payments after paying off the loan. The endogenous marginal interest rate is the loan interest rate of 0.1. The value is (12,000/0.1) * (1+0.1)^(-10) = 46,265.19 MU. Together this results in 46,265.19 + 73,734.81 = 120,000 MU. This is the value from the extreme case.

(For mathematicians: The marginal price was calculated using a linear program in two ways. Once by taking out an annuity loan, which was tied to the acquisition price, and once through a restriction in year 10, which prevents further debt. In the first case, the dual value of the liquidity restriction in t=1 corresponds to the present value factor of 6.14. In the second case, the endogenous marginal interest rate of 0.1 can be calculated using the dual values of the liquidity restriction.)

Table 9: Acquiring Real Estate without Growth (Annuity Loan 10 Years)

PositionYear 1Year 2Year 3Year ...
Salary500005000050000...
Tax-15000-15000-15000...
Living Expenses-10000-10000-10000...
Property Acquisition-73734.8100...
Interest-7373.48-6910.83-6401.91...
Repayment-4626.52-5089.17-5598.09...
Withdrawal-13000-13000-13000...
Loan73734.8169108.2964019.11...

Source: own presentation.

In the following case (annuity loan), the appraiser takes into account inflation and thus the price increase. The decision value, i.e., the value at which the advantageousness between purchase and rent turns, is 79,503.73 MU. In this case too, the appraiser provides a financial plan for the valuation of real estate and companies. The annuity loan is repaid.

The calculation interest rate (endogenous marginal interest rate) is 0.1.

The value of 79,503.73 MU can also be calculated using the formula for the present value factor with growth bwfg(i,g,n) = (1 - (1+g)^n * (1+i)^(-n)) / (i - g). This results in 12,000 * 6.63 = 79,503.73 MU. If Mr. Biele were to allow unlimited indebtedness, as in the extreme case, he could discount the saved rental payments after paying off the loan. The endogenous marginal interest rate is the loan interest rate of 0.1. The value is (12,000 * 1.02^10)/(0.1 - 0.02) * (1+0.1)^(-10) = 70,496.27 MU. Together this results in 70,496.27 + 79,503.73 = 150,000 MU. This is the value from the extreme case.

(For mathematicians: The marginal price was calculated using a linear program in two ways. Once by taking out an annuity loan, which was tied to the acquisition price, and once through a restriction in year 10, which prevents further debt. In the first case, the dual value of the liquidity restriction in t=1 corresponds to the present value factor of 6.63. In the second case, the endogenous marginal interest rate of 0.1 can be calculated using the dual values of the liquidity restriction.)

Table 10: Acquiring Real Estate with Growth (Annuity Loan 10 Years)

DescriptionYear 1Year 2Year 3Year ...
Salary500005100052020...
Tax-15000-15300-15606...
Living Expenses-10000-10200-10404...
Property Acquisition-79503.7300...
Interest-7950.37-7545.41-7075.95...
Repayment-4049.63-4694.59-5408.85...
Withdrawal-13000-13260-13525.2...
Loan79503.7375454.1170759.52...

Source: own presentation.

Figure 3: Discounting Acquisition - Unlimited Credit and Annuity Loan

Real Estate Value Acquisition InterestReal Estate Value Annuity Loan

Source: own presentation.

Acquiring Real Estate Variations

Now the examples can be extended and modified as desired. The values calculated below can no longer be determined alternatively with the above formulas, and a linear or nonlinear program (base program and valuation program) must be set up according to functional valuation theory.

First follows a variation with 10,000 MU equity from Mr. Biele. Why do the values change? In the base case of renting (base program), the withdrawal stream increases by the interest on equity (possibly corrected by a growth discount). This increased withdrawal stream must also be achieved in the case of acquisition (valuation program). In the case of acquisition (valuation program), however, it is worthwhile not to invest the money but to avoid the expensive repayment of 10%. Additionally, the loan volume can be increased. (In the end, more interest is serviced, but there is no longer a low-interest investment.) The values below just allow the same withdrawal stream as in the base program. (The decision value is the maximum acceptable acquisition price at which the advantageousness reverses.)

Table 11: Variation Acquisition with Equity

CaseWithout GrowthWith Growth
Acquisition: Maximum Acceptable Acquisition Price (Unlimited Debt)126250.0157812.5
Acquisition: Maximum Acceptable Acquisition Price (Present Value)81430.5988344.3

Source: own presentation.

In a further variation, Mr. Biele waives 50% of his non-compulsory consumption (withdrawal) for 10 years, both when renting and acquiring.

In the case of renting (base program), he can invest the money and receive interest. He saves up to year 10 and receives compound interest.

In the case of acquisition (valuation program), two case groups are presented. Once, he and his bank allow unlimited indebtedness. Alternatively, the property is paid off within 10 years.

Table 12: Variation Acquisition and Rent with and without Growth and 50% Withdrawal Waiver for 10 Years

CaseWithout GrowthWith Growth
Rent: Savings in Year 1063099.8576836.95
Acquisition: Maximum Acceptable Acquisition Price (Unlimited Debt)143547.02182930.16
Acquisition: Maximum Acceptable Acquisition Price (Present Value)106404.72118914.13

Source: own presentation.

As you can see, there is not "the" one universally valid value for everyone. The decision value depends on the valuation subject and his situation. Nevertheless, it can be simplified. The approximation is made using the original capitalized earnings method, which is a simplification of functional valuation theory and is less complicated.

References