Property Valuation Yield Calculation Check

A property valuation yield calculation check is rarely difficult in isolation. The risk sits in the gaps between figures: the adopted rent differs from the rent in the schedule, a comparable is analysed on a different area basis, or the stated yield does not produce the capital value in the conclusion. Each figure may look plausible. Read together, they may not reconcile.

For a secured lending report, that matters. The valuer may have soundly selected the adopted yield and reached a well-supported opinion of Market Value, but a visible inconsistency gives a reviewer a reason to question the evidence trail. A quick calculation check before issue is therefore not a substitute for valuation judgement. It is a way of confirming that the judgement is expressed consistently throughout the report.

Start with the valuation equation, not the stated yield

The basic income capitalisation check is familiar:

Capital value = annual rent ÷ yield

If a property is valued at £1,200,000 on an adopted annual rent of £84,000, the simple initial yield is 7.00 per cent. If the report instead states 6.75 per cent, the same rent implies a value of approximately £1,244,444. That is a difference of £44,444 before costs, purchaser's costs or any adjustment for a term certain are considered.

This does not mean the valuation must be wrong. It may be a net initial yield calculation, a term and reversion model, or a figure rounded at different stages. The point is that the report should make the basis clear enough for a reader to follow. A calculation that cannot be replicated from the stated inputs invites an avoidable query.

The first check is therefore simple: identify the rent and yield actually adopted in the narrative, then calculate the indicated capital value. Compare it with the final valuation figure, not just the figure in the valuation rationale. Where the difference is intentional, explain it in the report.

Property valuation yield calculation check: use the right inputs

The most common reconciliation issue is not arithmetic. It is using a rent, area or yield that belongs to a different part of the analysis.

Market rent, passing rent and adopted income

A report may refer to a passing rent of £96,000 per annum, an estimated rental value of £84,000 per annum and an adopted rent of £88,000 per annum after allowing for a rent-free period or lease event. All three figures can be legitimate. They cannot be used interchangeably in a yield calculation.

Consider a multi-let industrial property where the headline passing rent is £150,000 per annum. One unit is let at £18 per sq ft, materially above current market tone. The valuer may sensibly capitalise a sustainable income of £138,000 per annum. A conclusion of £1,840,000 reflects a 7.50 per cent yield on the sustainable income, not a 7.50 per cent yield on the passing rent. If the report presents £150,000 as the adopted rent without qualification, the apparent yield becomes 8.15 per cent.

The audit question is straightforward: does every reference to rent distinguish passing income from market rent and the rent used in the valuation? This includes the executive summary, tenancy schedule, valuation rationale and comparable analysis.

Gross, net and equivalent yields

A stated yield is only meaningful when its definition is clear. A gross initial yield, net initial yield and equivalent yield answer different questions. Purchaser's costs, void costs, non-recoverable expenditure, rent-free periods and lease incentives can all change the relationship between income and capital value.

For example, a retail investment bought for £950,000 at a passing rent of £70,000 shows a simple gross yield of 7.37 per cent. Once acquisition costs are included, the net initial yield is lower. If a report states 7.37 per cent as a net initial yield, the calculation will not reconcile unless the price or rent has been adjusted.

This is particularly relevant where comparable transactions are quoted on a net initial yield basis while the subject analysis is expressed as a gross figure. The numerical gap may be small, but it can make the adopted yield appear out of step with the evidence when it is simply based on a different convention.

Area basis and rental rate

Floor areas create another route to a distorted yield. A rent calculated using net internal area should not be carried into an analysis based on gross internal area without a clear conversion or explanation. The same applies where a comparable includes ancillary accommodation, car parking or a site area that is not reflected in the subject property.

Take an office suite of 5,000 sq ft NIA at £20 per sq ft, producing £100,000 per annum. If the report later refers to 5,500 sq ft and repeats the £20 rate, it implies £110,000 per annum. At a 6.50 per cent yield, that changes the indicated value by more than £150,000. A transposed area figure may look like a minor drafting error. In a capitalisation calculation, it is not.

Test the conclusion against the comparable evidence

Comparable evidence should support the yield adopted, but the check should go beyond asking whether the percentage falls within a range. A 6.25 per cent comparable and a 6.75 per cent adopted yield may be entirely reasonable if the subject has a shorter unexpired term, weaker tenant covenant, inferior location or greater reletting risk. The report needs to show that reasoning consistently.

Read the comparable schedule alongside the narrative. Check the transaction date, price, stated rent, area, unexpired term and yield. Then ask whether the yield is recalculated from the report's own figures. A comparable described as sold for £2,000,000 with rent of £130,000 per annum cannot show a 6.00 per cent simple yield. It indicates 6.50 per cent before costs. The source material may have used a different rent, reflected purchaser's costs or included a separate asset. If so, record the basis rather than leaving the discrepancy unexplained.

The same discipline applies to lease terms. A yield adopted for a 12-year unexpired term should not be justified by comparables with five years unexpired unless the adjustment is articulated. A report can contain accurate individual data points yet still create a contradictory story about risk.

Check calculations where they appear in the report

Yield errors are often introduced after the valuation has been completed. The final figure is amended, perhaps following a discussion with a colleague or a late comparable, but the summary, valuation rationale and appendix retain the earlier calculation. Under time pressure, this is an understandable version-control problem.

A useful review follows the figure across the whole document. Search for the capital value, adopted rent, rental rate, yield and floor area. Check each occurrence against the final analysis. Pay particular attention to the following:

• the valuation summary and headline conclusion;
• the valuation rationale and any sensitivity commentary;
• comparable tables and transaction analyses;
• tenancy schedules, lease summaries and rental calculations; and
• appendices, where an earlier spreadsheet export can survive a late revision.

Do not rely only on matching numbers. Check units and labels as well. A yield shown as 0.065 in one table and 6.5 per cent elsewhere is fine if formatted correctly. A rate of £65 per sq m that has been copied into a £ per sq ft analysis is not.

Build a repeatable review around exceptions

For a single straightforward investment, a manual calculation may take less than a minute. The value of a structured review becomes clearer across a portfolio, a valuation team or a lender panel. The objective is not to revalue the property. It is to flag exceptions that deserve the valuer's attention before issue.

A document-level audit can compare the final Market Value with every repeated capital figure, identify rents that do not match the tenancy schedule, recalculate stated yields and identify area inconsistencies between comparable evidence and the subject analysis. It can also read the narrative as one document, rather than treating each table or section in isolation.

That is the role WriteUp is designed to support. It reviews draft RICS valuation reports in one to two minutes and flags figures that do not reconcile, including capital values, rents, floor areas, yields and lease terms. The surveyor remains responsible for assessing each finding, the evidence and the conclusion. The benefit is a second pair of eyes on the repetitive cross-checking, particularly where a report has changed several times before it leaves the desk.

A yield calculation should be easy for a lender reviewer to retrace from the report. When it is not, pause at the point of difference, identify the input being used and decide whether the report needs correction or a clearer explanation. That small discipline protects the work already done to reach a considered valuation opinion.