Payback Period Calculator for Rental Property

1. Short answer

The payback period is the number of years of cash flow it takes to return the equity you put in. Not as a flat division, but counted year by year until the running total is full.

Payback period = the year in which cumulative cash flow catches up with your equity

On the apartment that runs through these metric pages, bought without financing, that takes 23.59 years with 2% rent indexation. With no indexation it is 29.78 years. Those six years are the entire reason for counting cumulatively.

2. What the payback period is, and what it is not

The payback period answers one question: when do I have my money back? It says nothing about what the property yields afterwards and nothing about what it is worth on sale. That is the definition, not a shortcoming. For the full picture you need IRR or the equity multiple, both of which do count the exit.

It is not a return figure either. A short payback means your money comes back quickly, not that the return is high. The return on equity page shows the same apartment at 5.27%, of which 4.38 percentage points come from an assumed rate of capital growth. Those 4.38 points do not shorten the payback by a single day, because no cash arrives.

What BRIX Calc does. The rental calculator counts cumulatively across the multi-year cash flow projection and interpolates inside the year in which the threshold falls. That is deliberately not equity divided by year one cash flow. The flat division is only right when every year delivers exactly the same amount, which no rental property does: rent indexes, the fixed-rate period expires, and on an annuity the split between interest and principal shifts every year.

Payback only exists for rentals. A development project has no ongoing cash flow to count against, because the proceeds arrive in one go at sale. For that kind of project the IRR or the duration itself is the answer.

3. The formula, component by component

What has to come back: your equity. Total investment less the loan. On this apartment the total investment is € 329,740. Note that acquisition costs are inside that figure: running the calculation on the purchase price alone understates the equity by more than € 44,000 and therefore makes the payback look far shorter than it is.

What comes in: annual cash flow. NOI less interest less principal, per year, from the multi-year projection. That is the same measure the cash flow page sets out. Principal counts as an outflow here, because the money leaves your account even though it builds equity.

The count. Add each year until the total reaches the equity. When the threshold falls mid-year, the shortfall is divided by that year's cash flow, so the answer carries a decimal rather than rounding to whole years.

Two edge cases. With no equity there is nothing to earn back. With permanently negative cash flow the counter never fills; the tool then shows a dash rather than a number, because zero years and never are not the same thing.

4. Worked example

The same renovated 75 m² apartment, this time bought without financing. That is the cleanest starting point: everything the property produces then reaches you.

With 2% rent indexation the counter fills like this:

The threshold falls in year 24: after 23 years the counter stands at € 319,429 and € 10,311 is still missing.

Payback = 23 + (329,740 − 319,429) ÷ 17,463 = 23.59 years

The second row is the point of this page. Six years of difference sit entirely in an assumption about rent growth, not in the building. Compare the payback of two properties without knowing which indexation rate was used, and you are comparing two assumptions.

Sensitivity. Drop indexation to 1% and the payback stretches to 26.19 years. Add € 1,000 a year of operating costs and it becomes 25.43 years. A euro less cost weighs exactly as much here as a euro more rent.

5. What financing does to it

A loan shrinks your equity, which ought to shorten the payback. On this property it does the opposite:

Equity falls by 60% and the payback nearly triples. The reason is simple: the property returns 3.36% on total investment (net initial yield) and the loan costs 5.0%. Every borrowed euro then removes more cash flow than it saves in equity. Leverage only works in your favour while the return sits above the interest rate, and here it does not.

The bottom row is not an error. On an annuity the annual cash flow is negative, so the cumulative counter never fills and the calculator shows a dash. The property does build equity through principal repayment, as the cash-on-cash page and the return on equity page set out; it is simply not money you get back.

6. What counts as a good payback period?

There is no norm, and the number travels badly between markets because it is a direct function of the local rent-to-price relationship and of prevailing mortgage rates. Indicative ranges, not published data:

A US investor reading "24 years" hears a poor deal; a Dutch investor hears a normal one. Neither is wrong, because the rent-to-price relationship and the tax treatment behind those rents differ.

The bottom category is not automatically a bad project, but it is a project whose entire return hangs on the exit value. Always run a scenario alongside it in which the value stands still for ten years. If nothing is left, capital growth is not an addition to your return, it is the whole of it.

7. Three mistakes that distort the number

Using the purchase price instead of equity. On this property that is € 44,740, which is four years of payback. Acquisition costs are money you spent and therefore money that has to come back.

Counting principal repayment as income. It builds equity, but it is not cash you can spend. Count it anyway and the payback on this property suddenly becomes finite while in reality you top it up every month.

Reading payback next to a DSCR covenant. DSCR tests whether the rent carries the loan, at one moment. Payback is about your own money across many years. A project can show a comfortable DSCR and still never pay back, exactly as in the table above.

8. Run your own numbers

Enter your own equity, cash flow and indexation rate above. You will see immediately what indexation does to the answer and how far the flat division sits from it. To have the cash flow itself calculated, including financing, voids and operating costs, the BRIX Calc rental calculator models the whole term.

9. Frequently asked questions

Do sale proceeds count towards the payback period?

No. Payback looks purely at ongoing cash flow. A property you never sell still has a payback period, and a property you sell at a profit after five years still has one of 23.59 years. To weigh the exit, use the equity multiple or IRR.

Why is the payback longer with a loan rather than shorter?

Because interest removes more cash flow than the smaller equity makes up for. That happens as soon as the interest rate sits above the return on total investment. Here that is 5.0% against 3.36%, so every extra euro of debt works against the payback. On a property yielding above its interest rate the effect reverses.

Why does BRIX Calc sometimes show a dash instead of a figure?

With structurally negative cash flow the cumulative counter never reaches the equity. Showing a zero would read as "paid back immediately", the opposite of what is happening. Adjust the rent, the costs or the financing first.

Does it apply to a development project?

No. There is no ongoing cash flow to count against: everything arrives at sale. To see how long your money is tied up in that kind of project, use the duration and the equity IRR, which does carry time in the formula.