Cash Flow Analysis for Rental Properties: A Step-by-Step Guide
Cash flow is the single most important metric for rental property investors. A property with positive cash flow pays for itself from day one — your tenants cover the mortgage, charges, and taxes, with money left over. A property with negative cash flow drains your savings every month.
This guide walks you through cash flow analysis step by step, with real formulas you can apply to any listing.
What Is Cash Flow?
Cash flow is simple:
Monthly cash flow = Monthly income - Monthly expenses
- Positive cash flow: The property generates more income than it costs. Money flows INTO your pocket.
- Negative cash flow: The property costs more than it generates. Money flows OUT of your pocket.
- Break-even: Income equals expenses. The property costs you nothing but generates no profit.
Step 1: Estimate Monthly Rental Income
Your rental income depends on the property type, location, and rental strategy.
Traditional Long-Term Rental
The most common approach. Estimate monthly rent based on:
By bedroom count (rough estimate):
Monthly rent = Number of rentable bedrooms × Average rent per bedroom
Average rent per bedroom varies by city:
- Paris: €550-750/bedroom
- Lyon: €400-550/bedroom
- Marseille: €350-500/bedroom
- Berlin: €450-600/bedroom
- Madrid: €400-550/bedroom
By surface area (more precise):
Monthly rent = Surface area × Average rent per m²
Furnished Rental
Furnished rentals typically command a 15-25% premium over unfurnished. They also benefit from favorable tax treatment in France (LMNP regime).
Colocation (Shared Rental)
Renting by the room to individual tenants often yields 20-40% more than renting the entire apartment to one tenant. More management work, but significantly better returns.
Colocation revenue = (Total rooms - 1) × Average room rent
We subtract 1 room because one room is typically the shared living area.
Step 2: Calculate Total Acquisition Cost
The true cost of buying isn't just the listing price:
Total acquisition cost = Listing price × Multiplier
Typical multipliers by country:
- France (old property): × 1.08 (7-8% notary fees)
- France (new build): × 1.03 (2-3% notary fees)
- Spain: × 1.10-1.13 (taxes + notary)
- Germany: × 1.07-1.15 (varies by state)
- UK: × 1.02-1.05 (stamp duty varies)
Don't forget to add renovation costs if applicable:
Total cost = (Listing price × Multiplier) + (Surface × Renovation cost per m²)
Step 3: Calculate Monthly Loan Payment
The loan payment is usually the largest monthly expense. Use the PMT formula:
Monthly payment = PMT(monthly rate, number of months, loan amount)
The PMT Formula Explained
PMT = P × [r(1+r)^n] / [(1+r)^n - 1]
Where:
P = Loan principal (total acquisition cost minus down payment)
r = Monthly interest rate (annual rate ÷ 12)
n = Total number of monthly payments (years × 12)
Example Calculation
Property: €250,000 apartment in Lyon
- Total acquisition cost: €250,000 × 1.08 = €270,000
- Down payment: €27,000 (10%)
- Loan amount: €243,000
- Interest rate: 3.3% annually → 0.275% monthly
- Term: 25 years → 300 months
Monthly payment = €243,000 × [0.00275 × (1.00275)^300] / [(1.00275)^300 - 1]
Monthly payment ≈ €1,187
Step 4: Add Monthly Expenses
Beyond the loan payment, include:
| Expense | Typical Amount | Notes |
|---|---|---|
| Co-ownership charges | €100-400/month | Check the listing |
| Property tax | €50-200/month | Varies by city and size |
| Property insurance | €15-30/month | Landlord insurance |
| Management fees | 0-8% of rent | If using a property manager |
| Vacancy provision | 5-8% of rent | Assumes 1 month/year empty |
| Maintenance reserve | 3-5% of rent | For repairs and upkeep |
Simplified Monthly Expenses
For quick analysis:
Total monthly expenses = Loan payment + Charges + (Rent × 15%)
The 15% covers vacancy, maintenance, insurance, and miscellaneous costs.
Step 5: Calculate Cash Flow
Monthly cash flow = Monthly rent - Loan payment - Charges - Other expenses
Key Metrics Summary
| Metric | Formula | Good Target |
|---|---|---|
| Gross yield | (Annual rent / Price) × 100 | > 5% |
| Net yield | (Annual rent - Expenses) / Total cost × 100 | > 3.5% |
| Cash flow | Monthly rent - All expenses | > €0 |
| Cash-on-cash return | Annual cash flow / Down payment × 100 | > 8% |
Common Mistakes
- Forgetting acquisition costs: Always use total cost (price × 1.08), not just listing price
- Overestimating rent: Use conservative estimates based on actual rental listings
- Ignoring vacancy: Budget 5-8% for empty months
- Using gross yield only: Gross yield ignores expenses — a 7% gross yield can still have negative cash flow
Want to filter properties by cash flow automatically? Try FilterWise free — AI-powered analysis that calculates yield and cash flow for every listing.