Example — built from one CSV upload

Portfolio tracker preview

This is exactly what you see after dropping a spreadsheet of your properties into DealLens — five example holdings, valued and stress-tested automatically. No formulas, no manual updates.

Portfolio value

£1,466,000

5 properties

Total equity

£481,150

67.2% portfolio LTV

Monthly cash flow

£964

£11,573 per year

Average net yield

4.52%

6.27% gross

Capital growth

£193,000

15.2% since purchase

Rent roll / mo

£7,655

Return on equity

2.41%

Cash flow vs equity

Cash-on-cash return

3.55%

On £325,850 cash invested

Rent earned to date

£61,404

Across current tenancies

Needs attention

3

Underperforming properties

The upload that produced this

A plain spreadsheet export — DealLens matches your column names automatically.

AddressPrice paidCurrent valueMonthly rentMortgageRate
42 Holloway Road, London£385,000£452,000£2,150£288,7505.4%
8 Beechwood Avenue, Manchester£215,000£268,000£1,425£161,2504.79%
17 Kirkstall Lane, Leeds£265,000£279,000£1,650£225,2506.19%
3 Marine Parade, Brighton£240,000£262,000£1,180£192,0006.45%
56 Cardigan Street, Birmingham£168,000£205,000£1,250£117,6004.29%

4 properties are missing optional detail from that spreadsheet

The questionnaire fills the gaps a basic CSV never has — deposit, stamp duty, fees, EPC, tenancy and mortgage terms. Every question is optional and you can come back whenever the paperwork is to hand.

Underperformance alerts

  • 42 Holloway Road, LondonNet yield below 5% target
  • 8 Beechwood Avenue, ManchesterNet yield below 5% target
  • 17 Kirkstall Lane, LeedsLTV above 80%
  • 3 Marine Parade, BrightonNegative monthly cash flow; Net yield below 5% target

Your holdings

42 Holloway Road, London

Spreadsheet

N7 8JL · Flat · 2 bed

Net yield below 5% target
Value

£452,000

Equity

£163,250

63.9% LTV

Cash flow / mo

£230

Net yield

4.06%

Cash-on-cash

2.06%

on £133,950

Growth

£67,000

17.4%

8 Beechwood Avenue, Manchester

Spreadsheet

M20 3QT · Terraced house · 3 bed

Net yield below 5% target
Value

£268,000

Equity

£106,750

60.2% LTV

Cash flow / mo

£468

Net yield

4.98%

Cash-on-cash

10.45%

est. cash in

Growth

£53,000

24.7%

17 Kirkstall Lane, Leeds

Spreadsheet

LS6 3DX · Semi-detached house · 4 bed

LTV above 80%
Value

£279,000

Equity

£53,750

80.7% LTV

Cash flow / mo

£47

Net yield

5.20%

Cash-on-cash

1.42%

est. cash in

Growth

£14,000

5.3%

3 Marine Parade, Brighton

Spreadsheet

BN2 1TL · Flat · 1 bed

Negative monthly cash flowNet yield below 5% target
Value

£262,000

Equity

£70,000

73.3% LTV

Cash flow / mo

-£335

Net yield

3.19%

Cash-on-cash

-8.38%

est. cash in

Growth

£22,000

9.2%

56 Cardigan Street, Birmingham

Spreadsheet

B4 7SB · Terraced house · 3 bed

Value

£205,000

Equity

£87,400

57.4% LTV

Cash flow / mo

£554

Net yield

5.70%

Cash-on-cash

13.19%

est. cash in

Growth

£37,000

22.0%

Upload your own spreadsheet in seconds

The portfolio tracker is included in Portfolio. Drop in your CSV and every figure above is calculated for you.

Get Portfolio£19.99/mo