BENERU
Cash flow and yieldsPublished Updated

How do I calculate whether a property can cover its loan repayments on its own?

BENERU writes for readers who live in Japan. Taxes, loans and the other rules described here are those of Japan, and they assume a resident of Japan.
This page is a translation of the Japanese original. If the two differ, the Japanese original prevails.

2 people have answered. Each answerer sees it differently.

RitaSharp-tongued debugger

Yeah yeah, it's Rita. Oh, good question. The choice of the word "cover" already sounds like someone who gets it a little. That's a compliment.

But let me nitpick just one thing. The part that says "on its own." That's important. You mean whether it can make the repayments with only the money the property earns, without adding a single yen of your salary, right? Right. Miss this and you can say "it's covering itself" while you're actually plugging the hole with your salary. The bank looks at whether you can repay including your salary. What you look at is whether the property can repay on its own. You're looking at different sheets.

Let's sort it out once. You only use 2 numbers.

The first is the cash left over. The money the property actually earns after subtracting vacancies and operating expenses from the rent. As a formula: "annual rent × (1 − vacancy rate) − annual expenses."

The second is the loan constant, the one called K%. "Annual principal-and-interest repayment ÷ loan amount." It's not the interest rate. The interest rate is only about interest; it doesn't include principal repayment. Even at the same interest rate, K% goes up if the loan term is shorter. Lots of people mix these up, seriously.

Then, if the yield — the property's earning power divided by the total investment — exceeds K%, in theory it covers itself. This difference is the original definition of the yield gap. The "yield − interest rate" you often see online is the simplified version. Get it?

Let's do it in numbers. All assumptions. A whole apartment building priced at ¥50 million, ¥53.5 million including acquisition costs. ¥5 million a year at full occupancy, 10% vacancy, and cash left over after expenses of ¥3.486 million a year. Borrowing ¥45 million at 2% interest over 30 years, the annual repayment is about ¥1.996 million. K% is about 4.44%. Dividing the cash left over by the total investment gives about 6.52%, so the difference is about 2.08 percentage points. That works out to about ¥1.49 million a year left in hand.

Hmm, so it covers itself, you thought? Stop right there.

If you end here, you're just a calculator. The real point starts here.

Whether it covers itself is decided not in normal years but by whether it covers itself in a bad year. The stress I apply is 3 at once. Worsen the vacancy rate by 10 percentage points. Raise the interest rate by 1%. Repairs cost ¥1 million a year.

One at a time, even if only vacancies worsen, about ¥1.04 million a year is left. Interest rate alone, about ¥1.21 million. Repairs alone, about ¥490,000. Each of them alone is still in the black.

But when all 3 come at once, the cash left over falls to about ¥2.036 million, and the repayment at 3% rises to about ¥2.277 million. A deficit of about ¥240,000 a year. When a bad year comes, this property doesn't cover itself unless you add ¥240,000 from your salary. That's the precise answer.

So is it a bad property? No, not necessarily. For how many years can you bear ¥240,000 a year out of pocket? Is the principal properly going down during that time? If you check that against your own wallet and can accept it, then it becomes a judgment of "buying with full awareness." Conversely, if you bought without doing this calculation, that's not a judgment, it's a prayer.

By the way. It's probably best not to expect much that the simulation in a sales brochure will go as far as this triple stress. If there's a company that does show it, that's a point you can properly give them credit for.

Conclusion. Whether a property covers itself on its own is seen from the difference between "cash left over ÷ total investment" and "K%." Then, whether that difference remains after the triple stress. If it doesn't, how many years can you bear the deficit? Only after going that far can you say "it covers itself." OK?

You know Pacific saury — some years they're full of fat, some years they're thin. Plan your menu on a good year's price and your dinner table gets stuck in a thin year. Properties are the same. Plan your menu not on a good year's numbers but on a bad year's numbers.

Jamie GooInvestor in training

Hey, it's Jamie! That's exactly the question where I still think I should have done the calculation before buying!

I picked my first studio unit from a yield ranking on a property website. The No. 1 unit had a gross yield of 8%. ¥12 million, with rent of ¥80,000 a month. ¥960,000 a year ÷ ¥12 million is 8%. That's high for a second-hand studio unit! I decided on almost that alone. For the loan, I borrowed ¥11.5 million at 2.4% interest over 35 years, and the monthly repayment was about ¥40,500 (an assumption). With rent of ¥80,000, nearly double comes in. I thought it would obviously cover itself.

First, I'd forgotten to count the money going out every month. With a condominium unit, the management fee and repair reserve fund go out of the rent every month. For my unit, that was ¥15,000 a month combined. The fee to the property management company was 5% of rent, ¥4,000. What reaches me is ¥61,000. From that, the ¥40,500 repayment. If fixed asset tax is ¥50,000 a year, that's about ¥4,200 a month. What's left is about ¥16,000. Much thinner than the impression of 8%.

The real pitfall came after that. The tenant moved out after 1 year. When I put out the next listing, the market rate was ¥68,000 a month. ¥80,000 was a rent the previous tenant had settled on years before. The 8% in the ranking had been calculated on that rent. On top of that, it stayed vacant for 2 months until the next tenant was found.

Recalculating with the new rent: from ¥68,000, subtract ¥15,000 for the management fee and repair reserve fund, the ¥3,400 fee, the ¥40,500 repayment and about ¥4,200 of fixed asset tax, and what's left is about ¥4,900. During the 2 vacant months, rent was zero, and just the money going out was about ¥60,000 a month, so I paid about ¥120,000 over 2 months from my salary. At a surplus of ¥4,900 a month, it worked out to a little over 2 years to win back that ¥120,000!

During those 2 months, I bought just 1 of the cheapest croquettes in the Koiwa shopping street every night on my way home. The lady at the shop learned my face, and being asked "Just 1 today?" was hard!

You can't tell from a ranking position whether a property covers itself on its own. Whether the current rent matches the market, what goes out every month, and what you pay with in a vacant month. I learned those 3 things in my own bank account after buying.

3 things I'd tell myself back then.

  • Put the rent used in the ranking's yield side by side with the rent of similar units listed nearby
  • Write the management fee, repair reserve fund, management company's fee, fixed asset tax and repayment one line each in a monthly table, and look at what's left after subtracting them from rent
  • Count the money going out in a vacant month, and decide before buying how many months' worth to keep on hand

By the way, the lady at the croquette shop still asks me "Just 1 today?" Even though I can buy 2 now!

Read a little deeper