Cash Flow Analysis for Japanese Rental Properties: A Practical Worksheet

Before I make an offer on any property, I run it through the same cash flow analysis template I’ve refined over twelve years of landlording. I’ll share the complete worksheet here with real numbers from a property I evaluated last year (and ultimately passed on). Use this as a starting point for your own analysis.

Section 1: Gross Income

Start with the raw income potential, then apply realistic adjustments.

• Listed monthly rent (per unit): 55,000 yen u00d7 6 units = 330,000 yen/month
• Annual gross rent at 100% occupancy: 3,960,000 yen
• Vacancy adjustment (90% occupancy assumed): u00d7 0.90 = 3,564,000 yen
• Other income (parking, storage, bike fees): + 120,000 yen
• Effective Gross Income (EGI): 3,684,000 yen

A note on vacancy rates: 10% is my standard assumption for well-located properties in mid-size cities. For properties in areas with high competition or declining population, I use 15-20%. Never assume 0% vacancyu2014that’s a fantasy number.

Section 2: Operating Expenses

This is where most investors underestimate. Be ruthless about including every real cost.

• Property management fee (if using a management company, 5% of EGI): 184,200 yen
• Fixed asset tax (u56fau5b9au8cc7u7523u7a0e + u90fdu5e02u8a08u753bu7a0e): 180,000 yen (obtain from seller or estimate from listing)
• Building and fire insurance: 65,000 yen
• Earthquake insurance: 28,000 yen
• Common area utilities (hallway lighting, water for shared spaces): 36,000 yen
• Routine maintenance and minor repairs: 120,000 yen
• Capital expenditure reserve (1% of building value annually): 160,000 yen (for a 16 million yen building)
• Tenant-finding advertising costs (amortized across expected tenure): 90,000 yen
• Accounting/professional fees: 60,000 yen
• Total Operating Expenses: 923,200 yen

Section 3: Net Operating Income and Debt Service

• Net Operating Income (NOI) = EGI u2212 Operating Expenses: 3,684,000 u2212 923,200 = 2,760,800 yen
• NOI Margin: 74.9% (reasonable; 65-75% is typical for well-managed properties)

Now add financing costs:

• Loan amount: 28 million yen (asking price 35 million yen, down payment 7 million yen)
• Interest rate: 2.1% variable
• Loan term: 25 years
• Annual debt service (principal + interest): approximately 1,440,000 yen

• Before-tax Cash Flow = NOI u2212 Debt Service: 2,760,800 u2212 1,440,000 = 1,320,800 yen
• Cash invested: 7,000,000 yen (down payment) + 2,800,000 yen (acquisition costs at 8%) = 9,800,000 yen
• Cash-on-Cash Return: 1,320,800 u00f7 9,800,000 = 13.5%
• Debt Service Coverage Ratio (DSCR): 2,760,800 u00f7 1,440,000 = 1.92 (excellentu2014anything above 1.3 is good)

Why I Passed on This Propertyu2014and What It Teaches

The numbers above look solid. Why did I pass? Because when I checked the actual rent roll, two of the six units were occupied by tenants paying 45,000 yen (not 55,000 yen as advertised). The seller was using potential market rent, not actual current rents. Adjusted analysis:

• Corrected annual gross rent at 90% occupancy: 3,276,000 yen (vs. 3,564,000 yen)
• Corrected NOI: 2,472,800 yen
• Corrected Before-tax Cash Flow: 1,032,800 yen
• Corrected Cash-on-Cash Return: 10.5%

Not terrible, but the asking price was set assuming the higher rents. When I submitted a revised offer reflecting actual rents, the seller refused to negotiate. So I walked. This happens. Trust the worksheet, not the marketing materials.

同じカテゴリの記事を読む

8棟自主管理の経験から書いた関連記事 — まとめて読むと理解が深まります

▸ English

Kitchen2 Vol.20: Cushion Floor Laying

▸ Bathroom DIY

Bathroom Renovation Vol.4: Floor Demolition Pt.1

▸ English

Apt.1 2F Japanese Room: 2nd Ceiling Repair Vol.5

▸ English

Self-Managing vs. Using a Property Management Company in Japan

▸ Bathroom DIY

Bathroom Renovation Vol.9: Cushion Floor Installation

▸ English

Kitchen Vol.29: Built-in Dishwasher Install u2014 DIY Dad’s Renovation