How to Build a Cash Flow Simulation: Making Investment Decisions from the Break-Even Point

Why a Cash Flow Simulation Is Essential

When evaluating a real estate investment, some people make gut decisions like "the gross yield is high, so it's a buy" or "it's a good location, so it'll be fine." However, the most important element of any investment decision is a cash flow simulation based on concrete numbers.

A cash flow simulation involves itemizing the income from a property and the expenses incurred, then calculating the actual cash flow remaining in hand. This clarifies the following:

• Whether the property truly generates profit
• How much vacancy the property can tolerate (the break-even point)
• How cash flow changes over the long term
• The extent of risk if unexpected events occur

This article explains the basics of building a cash flow simulation and how to use it for investment decisions.

Basic Structure of a Cash Flow Simulation

A cash flow simulation is divided into two major components: income and expenses. Accurately estimating each item is the prerequisite for a reliable simulation.

Income Items

Rental Income (Monthly x 12 Months)

This is the primary income source. Research comparable property rents in the area and set a realistic rate. Rather than using the seller's "projected rent" as-is, independently verify market rates.

Common Area Fees / Management Fees

Common area fees collected from tenants are included as income. Set them in balance with actual common area management costs.

Parking Revenue

If the property has on-site parking, include that rental income. For suburban properties, parking availability directly impacts occupancy rates, making it a significant income source.

Other Income

Key money, renewal fees, vending machine revenue, and other non-rent income may be added. However, since key money and renewal fees are not guaranteed income, it is safer to estimate conservatively or exclude them from the simulation.

Expense Items

Expenses are divided into "operating costs" and "loan repayments."

Operating Costs (Running Costs)

| Item | Guideline | |------|------| | Management fees | Approximately 3-5% of rental income | | Repair reserves | Approximately 5-10% of rental income | | Property tax / City planning tax | Varies by property (use the annually notified amount) | | Fire insurance / Earthquake insurance | Depends on policy details | | Tenant recruitment costs (advertising) | Approximately 1-2 months' rent upon turnover | | Restoration costs | Incurred upon tenant departure | | Other (utilities, communications, transportation) | Varies by property |

Total operating costs are generally estimated at 20-30% of rental income. This ratio is called the Operating Expense Ratio (OPR).

Loan Repayment Amount

When using financing, calculate the monthly loan repayment. The repayment amount is determined by the loan principal, interest rate, and repayment period. With level-payment amortization, monthly payments remain constant; with equal principal repayment, payments gradually decrease.

The Break-Even Point (BEP) Concept

The Break-Even Point (BEP) is the occupancy rate at which income exactly equals expenses. In other words, it is the line below which the property goes into the red.

Calculating the Break-Even Point

The BEP occupancy rate can be estimated with the following formula:

BEP Occupancy Rate = (Operating Costs + Loan Repayments) / Gross Rental Income at Full Occupancy x 100

For example, if annual gross rental income at full occupancy is 6 million yen, operating costs are 1.5 million yen, and annual loan repayments are 3.5 million yen:

BEP Occupancy Rate = (1.5 million yen + 3.5 million yen) / 6 million yen x 100 = approximately 83%

This means the property goes into the red if occupancy drops below 83%. For a 10-unit apartment, cash flow turns negative if more than 2 units remain vacant at any time.

BEP Evaluation Criteria

The higher the BEP occupancy rate, the higher the investment risk. General guidelines are:

• BEP 70% or below: Comfortable margin. Can withstand moderate vacancy increases
• BEP 70-80%: Standard. Manageable with proper management
• BEP 80-90%: Somewhat tight. Requires thorough vacancy countermeasures
• BEP 90% or above: High risk. One vacant unit could cause a deficit

When making investment decisions, compare the BEP occupancy rate with the average occupancy rate for the area. If the BEP exceeds the area's average occupancy rate, you may want to reconsider the investment.

Key Points for Long-Term Simulation

Real estate investment is a long-term endeavor. It is important to project cash flows not just at the time of purchase, but 5, 10, and 20 years out.

Factor In Rent Decline

As a building ages, rents generally trend downward. Include an assumed annual rent decline rate in your long-term simulation. While decline rates vary by property type and area, assuming a 0.5-1% annual decline is a prudent approach.

Set Realistic Vacancy Rates

Assuming "full occupancy at all times" is unrealistic. Set an annual vacancy rate and reflect it in your income projections. Single-occupant properties typically have higher turnover and thus higher vacancy rates, while family-oriented properties tend to be lower.

Account for Major Repairs

Major repairs are expected at predictable intervals: exterior painting around years 10-15, roof waterproofing around year 20, and plumbing replacement around years 25-30. Including these costs in your long-term simulation enables more realistic cash flow projections.

Simulate Interest Rate Changes

If you have a variable-rate loan, simulate scenarios where interest rates rise. Understanding how cash flow changes if rates increase by 1-2% from current levels is essential.

Validate with Three Scenarios

For accurate investment decisions, we recommend simulating the following three scenarios:

Optimistic Scenario

• Low vacancy rate assumption (e.g., 5%)
• No rent decline
• Minimal repair costs
• Interest rates remain unchanged

Standard Scenario

• Average vacancy rate assumption (e.g., 10-15%)
• Rent declines 0.5% annually
• Planned repair costs occur
• Interest rate +0.5% from current levels

Pessimistic Scenario

• High vacancy rate assumption (e.g., 20-25%)
• Rent declines 1% annually
• Unexpected repairs occur
• Interest rate +1.5% from current levels

The critical point is to confirm that even the pessimistic scenario does not result in a deficit (or that any deficit falls within acceptable limits). An investment that only profits under the optimistic scenario should be considered high-risk.

Commonly Overlooked Items in Simulations

Here are items beginners often miss when building cash flow simulations.

Acquisition Costs

Acquisition costs of approximately 7-10% of the property price (brokerage fees, registration costs, acquisition tax, stamp duty, loan origination fees, etc.) are incurred. Calculate yield based on the "total investment amount" including these costs.

Tenant Turnover Costs

Each time a tenant moves out, restoration costs, lost rent during vacancy, and new tenant recruitment costs are incurred. These costs add up especially for single-occupant properties with frequent turnover.

Tax Impact

Even if the cash flow simulation shows a positive figure, after deducting income tax and resident tax on real estate income, the net amount may decrease significantly. Practice simulation that accounts for after-tax cash flow concepts.

Dead Cross Timing

As loan repayment progresses, the principal repayment portion increases while the deductible interest portion decreases. When depreciation deductions also end, book profits rise and the tax burden surges — this is known as a "dead cross." Always check for this timing in your long-term simulation. For details, see What Is a Dead Cross?.

Summary

A cash flow simulation is the foundation for decision-making in real estate investment. Whether you can make decisions based on numbers rather than intuition is what separates successful investors from the rest.

Start by listing all income and expense items and calculating the break-even point. Then run long-term simulations across three scenarios to verify whether the investment can withstand even the pessimistic case.

A simulation is not a one-time exercise. After acquisition, regularly compare actual results with projections, and when discrepancies arise, analyze the causes and apply improvements. This ongoing practice is the key to long-term investment success.