Commercial Office Residual Development Appraisal (One-Pager)

Commercial Real Estate Properties, Development, Financial Model, Real Estate

Break-Even, Budgeting, Cap Rate (Capitalization Rate), Cap Table, Cash Flow Analysis, Cash Flow Projections, Discount Rate, Excel, Financial Analysis, Financial Model, Financial Modeling, Financial modelling, Financial Ratios, Forecast, Forecasting, Gross Yield, IRR (Internal Rate of Return), Net Yield, NPV (Net Present Value), Pricing Analysis, Profitability Analysis, Property Appraisals, Property Valuation, Real Estate Valuation, Rental Income, Sensitivity Analysis, Valuation

A quick, RICS-aligned read on whether an office development opportunity stacks up. Use it on site walks to pressure-test an asking price, on the train to triangulate a bid, in a meeting to flex a yield assumption, or as the first-cut filter before committing time and budget to a full cashflow model. The model solves for profit and a full suite of return metrics across a comprehensive UK cost build.

What’s Inside

Valuation
– Multi-floor capitalisation schedule supporting up to six floors with individual NIA and ERV per sq ft per floor
– Configurable NIA:GIA efficiency ratio driving total NIA, void holding costs, and £ psf metrics
– Single Net Initial Yield capitalising aggregate Gross ERV
– Net Development Value calculated using the RICS gross-up convention

Cost stack
– Site acquisition: two-band non-residential SDLT formula, buyer’s agent fee, legal fees
– Construction: Shell & Core, CAT A fit-out, external works, other costs (all on GIA), with a contingency loading
– Professional fees: architect, structural / civil, M&E, project manager, QS, planning consultant, CDM — all driven off construction cost
– Planning and statutory: CIL, S106 / S278, application fees, Building Regs / warranties, EPC / BREEAM / sustainability
– Incidentals: surveys, site investigation, enabling works / demolition, utilities, insurance, other
– Letting and disposal: letting agent and legal fees, investment sale agent and legal fees, void holding cost (£ psf NIA p.a.) over the post-PC void period, rent-free incentive cost
– Development finance: Loan-to-Cost facility on the pre-finance cost base (including land), reference rate plus margin, Average Drawn Balance % to reflect realistic profile drawdown, compound interest over the construction loan period, plus arrangement, exit and monitoring fees

Outputs
– Return metrics: Total Project Cost, Profit, Profit on Cost, Profit on GDV, Equity Multiple, IRR (entry/exit) — all wrapped in negative-equity guards that return “N/A” rather than nonsense numbers in stress scenarios
– Residual Land Value side-table: target-profit back-solve with RLV, RLV per sq ft GIA, current land input, and a live headroom / overpayment flag
– Cost summary table showing each block in £, as a percentage of NDV, and per sq ft of GIA
– Two two-way sensitivity tables (5×5 symmetric, base case in the centre column): Construction Cost vs Acquisition Price, and ERV vs Exit Yield — each displaying IRR and equity multiple in a single cell
– Loan-period vs development-period validation warning
– £ psf metrics running down the right-hand column throughout the cost stack

How It’s Built

Yellow cells are inputs; everything else calculates. Work top-down: project details, site and areas, floor schedule, capitalisation, then down through the cost blocks. The RLV side-table sits directly under Site Acquisition so you see the implied land value and headroom against your input price as you flex the rest of the appraisal. The two sensitivity tables update live as you change inputs, so you can stress-test a deal without re-running anything. Every input has a guidance note in the right-hand column. Print-ready as a single page.

Building this from scratch in Excel takes time even for a competent modeller. This model gives you a clean, transparent, formula-level appraisal off the shelf, with the methodology choices that matter — compound finance interest on a drawn-balance basis, negative-equity guards, symmetric sensitivities — already made correctly. Buy it once, use it on every office opportunity that crosses your desk.

Important Note

This is a development appraisal, not a Red Book valuation. It uses the residual technique to produce a return analysis at a known or target land cost. It is not a substitute for a formal RICS Red Book valuation and should not be relied upon for transactional, financing, accounting, regulatory, or statutory purposes without independent professional verification. Disclaimer included in the workbook.

This is a one-page residual appraisal. It is not a time-series discounted cashflow model. It is used as a first hurdle for quick comparisons.

You must log in to submit a review.