Nine rental units later, I have learned the hard way that a cap rate on paper and a cap rate after renovation are two completely different numbers. Last year I looked at a duplex listed with an 8.1% cap rate, but by the time I finished budgeting for a new roof and rewiring, my real number had dropped to 5.4%. That gap is exactly why I never make an offer until I have run both calculations side by side.
I built a simple two-column system years ago: before-renovation cap rate and after-renovation cap rate, with every yen of repair cost accounted for. It sounds basic, but skipping this step is how landlords end up buying a property that looks good on a spreadsheet and bleeds cash for the first three years. I keep both columns in the same worksheet I use for every one of my 9 properties, so I can compare a new deal against what actually happened on the last four renovations I finished.
Why the Listing Cap Rate Almost Always Lies
ud83duded2 RECOMMENDED ON AMAZON US
Real Estate Investment Books
The books that changed how I think about money, leverage, and long-term wealth.
The cap rate an agent hands you is calculated on current rent and current condition, not on what the building actually needs. On a 1998-built apartment building I bought two years ago, the listing showed a 7.8% cap rate based on 12,000,000 yen in annual rent against a 154,000,000 yen price. What the listing did not mention was 40-year-old plumbing and a water heater that had already failed inspection. I always treat the listed number as a marketing figure, not a decision-making one. Agents are not trying to deceive anyone; they simply pull the figure straight from the current rent roll, and current rent roll almost never reflects what an inspection will turn up once you start pulling up flooring or opening an access panel behind the water heater.
My Before Number: Net Operating Income Minus the Obvious
ud83duded2 RECOMMENDED ON AMAZON US
Financial Calculators for Investors
Run yield and cash-flow calculations in seconds u2014 worth every yen on your first deal.
Before I even think about renovation, I calculate a realistic before cap rate using net operating income, not gross rent. I subtract property management fees (typically 5% here), fixed asset tax, insurance, and a 3% vacancy allowance from gross rent, then divide by purchase price. For that same 154,000,000 yen building, my adjusted NOI came to 9,200,000 yen, giving me a before cap rate of about 6.0% instead of the advertised 7.8%. That 1.8 percentage point gap is my starting cushion before renovation costs even enter the picture.
Building the Renovation Budget Line by Line
This is where most investors guess, and guessing is how budgets blow up. I break every renovation into four categories and price each one from actual contractor quotes, not rough estimates:
- Structural and safety items: roof, plumbing, wiring, foundation cracks
- Systems that affect tenant retention: water heaters, air conditioning, insulation
- Cosmetic upgrades that raise achievable rent: flooring, kitchen fixtures, exterior paint
- A contingency line of 15% on top of the total, because something always turns up once the walls are open
On that 154,000,000 yen building, the four categories added up to 9,800,000 yen, contingency included. Because I do about 70% of the labor myself, that figure would have been closer to 15,000,000 yen if I had hired everything out to a contractor.
Recalculating the After Cap Rate
ud83duded2 RECOMMENDED PRODUCTS
Investment Analysis Templates
Spreadsheet analysis is the difference between a good deal and a disaster.
Once I have a renovation total, I do two things at once: estimate the rent increase the work will support, and add the renovation cost to my effective purchase price. In this case, new plumbing and updated units let me raise rent from 12,000,000 to 13,600,000 yen annually, and my adjusted NOI rose to 10,500,000 yen. Dividing that by the new effective basis of 163,800,000 yen (purchase price plus renovation) gave me an after cap rate of 6.4%, actually higher than my before number. That is the pattern I look for before signing anything.
The Break-Even Test I Run on Every Deal
Before finalizing, I run one more check: how many years of the higher rent it takes to recover the renovation spend, assuming none of it gets rolled into the sale price. On this project, the extra 1,600,000 yen a year in rent against a 9,800,000 yen renovation budget gave a payback period of about 6 years, well inside the 10-year window I use as my personal cutoff for any capital improvement. If a renovation pushes payback past that line, I either negotiate the purchase price down or walk away, no matter how good the after cap rate looks on paper. I learned this the expensive way on an early purchase where the after cap rate looked excellent at 7.1%, but the payback period on a full plumbing replacement stretched past 13 years once I priced in the actual pipe run length, and by then two other repairs had already eaten into the cash I had set aside.
What I Do When the Numbers Don’t Improve Enough
Not every deal survives this process. I passed on a triplex last spring because the after cap rate only moved from 5.2% to 5.5%, not enough to justify eight weeks of construction and financing risk. When that happens, I go back to the seller with the renovation quotes in hand and ask for a price reduction equal to the gap, which has worked on three separate purchases so far. If they will not move, I walk. There is always another building coming up for sale.
Running the before and after numbers side by side, with real contractor quotes instead of guesses, is the single habit that has kept every one of my 9 properties cash-flow positive since I started self-managing 15 years ago. It takes an extra afternoon of spreadsheet work, but it has saved me from at least two bad purchases I can think of.
Property Cash Flow Calculator + Complete Guide
The exact Excel spreadsheet I use for every property purchase decision u2014 5-year projection, yield calculation, and break-even analysis included.
ud83cudfe0 More from DIY Father
15 years of landlord experience u00b7 3 apartment buildings u00b7 DIY renovations that saved millions of yen. Browse all articles at diytosan.com






