How to Analyse Your Real Estate Portfolio Data and Find Underperforming Properties

Most property investors manage their portfolio one deal at a time. They know whether last month's rent arrived from property number three, but they do not know whether property number three is their best or worst performer relative to the capital it represents.

Portfolio-level analysis changes that. When you look at all your properties in one view, you can see which ones are earning their keep, which ones have appreciated and should be sold, and which ones are quietly dragging down your average yield.

The five numbers in a portfolio analysis

Portfolio value — the current market or book value of all properties combined. This is your total capital deployed in real estate.

Average property price — total portfolio value divided by number of properties. Useful for understanding whether your portfolio is concentrated in high-value assets or spread across many lower-value ones.

Average yield — annual rental income divided by property value, expressed as a percentage. This is the most important number in a buy-to-let portfolio. A 6% yield means for every ₦1,000,000 (or £1,000 or $1,000) of property value, you receive ₦60,000 per year in rent before costs.

Property type breakdown — how much of your portfolio value is in apartments, houses, commercial, land, and other categories. Different property types behave differently in different market conditions.

Individual property yield ranking — which specific properties are above and below your portfolio average. This is where the actionable insight lives.

What a good yield looks like

Yield benchmarks vary by market:

• Lagos (Nigeria): Well-located apartments in Lekki, Ikoyi, or VI typically yield 4-7%. Properties on the island tend to have lower yields (high capital values relative to rents) while mainland properties often yield more.
• UK: Residential yields average 4-6% across most cities. Student accommodation and HMOs (houses of multiple occupancy) can yield 8-10% but require more active management.
• US: Single-family homes in growth cities yield 3-5%. Multi-family properties in secondary markets can yield 6-9%.

A yield below 3% usually means either the property has appreciated significantly since purchase (making the current yield low relative to current value) or the rent is below market rate.

How to export your property data as CSV

You do not need a sophisticated property management system to do this analysis. A simple spreadsheet works.

Create a CSV with one row per property and these columns:
- property_id or address
- property_type (Apartment, House, Commercial, Land, etc.)
- property_value — current market value or purchase price
- annual_rent — total annual rental income
- area or location
- listing_date or acquisition date

That is the minimum. BizScope will detect the real estate dataset type automatically from your column names and calculate yield for every property where both value and rent are present.

What BizScope shows you

When you upload a property portfolio CSV, BizScope switches to real estate analysis mode. It shows:

• Total portfolio value and property count
• Average property price and average yield
• Property type breakdown (how portfolio value is distributed across types)
• Price band distribution (how many properties fall in each value range)

The health score uses portfolio-specific components: average yield vs benchmark, portfolio value trend over time (if listing dates are present), and portfolio diversification across property types.

Alerts fire when average yield drops below 3%, when a single property type dominates more than 70% of portfolio value, or when there is no diversification across areas.

Finding your underperformers

The most useful analysis is sorting your properties by yield. Properties at the bottom of the yield table are candidates for review.

For each underperforming property, ask:
- Is the rent below market rate? If so, can you renegotiate at the next tenancy renewal?
- Has the property appreciated significantly, making the yield low relative to current value? If so, does it make sense to sell and redeploy the capital into a higher-yielding asset?
- Is the property vacant or only partially occupied? If so, what is the time to full occupancy?

Properties at the top of the yield table are worth understanding too. What makes them strong performers? Location, property type, tenant quality, lease structure? Those patterns are worth replicating when you next acquire.

Portfolio concentration risk

The same concentration risk that affects a sales business affects a property portfolio. If 60% of your portfolio value is in a single property type (say, commercial offices) or a single location (say, one neighbourhood in one city), a shock to that market affects most of your portfolio at once.

The property type breakdown chart shows this instantly. If one segment dominates, that is a conversation worth having before your next acquisition — diversifying into a different type or location reduces your exposure to any single market event.

One property that changed the math

A common scenario: an investor has eight properties. Seven are performing well. One — purchased in a less liquid market or at the top of a cycle — has appreciated very little, requires ongoing maintenance, and yields only 2.3%.

Without portfolio-level analysis, the investor may not even notice this property is the weakest link. The rent arrives each month, so it feels fine. But when you see the yield table, that property stands out immediately.

Selling it and redeploying the capital into a property yielding 5-6% could increase total portfolio income by 10-15% with the same capital base.

That decision only becomes visible when you look at all the data together.

Upload your property portfolio CSV at bizscope.space — free, no account needed, analysis in under 30 seconds.