Development Appraisal Software vs Spreadsheets: Which Is Right for Your Housing Organisation?
The Case for Spreadsheets
Spreadsheets deserve a fair hearing. An organisation appraising one or two schemes a year, with an experienced development finance officer who built the model and understands its logic, can run a well-constructed Excel appraisal successfully. Excel's flexibility to model unusual structures, add bespoke assumptions and format outputs for different audiences is genuinely useful.
Cost is the other advantage. Most organisations already hold Excel licenses through existing Microsoft subscriptions, so there is no separate procurement, no implementation project and no new training for staff who already know the tool.
These advantages weigh less as an organisation runs more schemes in parallel, manages a pipeline rather than individual sites, and has to account for its appraisal decisions to a board, a funder or a regulator.
Where Spreadsheets Break Down
Error Rate
Research on operational spreadsheets consistently finds errors in most of the models examined. Raymond Panko of the University of Hawaii, reviewing field audits of real organisational spreadsheets, reported that the more rigorous recent audits found errors in at least 86% of spreadsheets examined (Panko), and in a later summary that audits of 88 spreadsheets found errors in 94% (Panko). Louise Pryor's review of the same body of work puts the share containing significant errors at roughly 80% to 90%, while noting that studies define a significant error differently (Pryor).
The Spreadsheet Engineering Research Project at Dartmouth's Tuck School of Business audited 50 operational spreadsheets and found errors in 0.8% to 1.8% of formula cells. A follow-up study of 25 spreadsheets from five organisations found that many errors had no effect on results, while some had substantial impacts on key outputs (Powell, Lawson and Baker). Most of this research dates from the late 1990s and 2000s.
The practical point for social housing is the size of the margin for error. The 2025 report Making Social Rent Homes Viable finds that the capital value of Social Rent homes falls well below their total development cost, so viability depends on grant and cross-subsidy assumptions being right. A broken link, a misallocated cost or a wrong sensitivity input can move a scheme from viable to unviable on paper, or the reverse.
No native audit trail
Grant-funded delivery has to be documented. Homes England's Capital Funding Guide expects an annual compliance audit of a sample of schemes by an independent auditor, and requires providers to keep a comprehensive scheme file holding all relevant documents for each scheme (Capital Funding Guide, chapter 6). Boards approving schemes need the version of the appraisal they approved to be preserved. Spreadsheet version history, where it exists at all, depends on how and where each file is stored rather than on the appraisal process, and file names such as "ProposalV3_FINAL_JuneREVISED.xlsx" are a naming convention rather than an audit trail.
Scaling across a portfolio
Appraising 15 live schemes in Excel usually means 15 separate workbooks, each of which has to use the same assumptions and model structure before their outputs can be consolidated by hand. A development director who needs a cross-portfolio view at short notice depends on every file having been kept consistent.
Tenure Complexity
Schemes commonly combine several affordable tenures with open market sale. The National Planning Policy Framework defines affordable housing to include Social Rent, Affordable Rent, discounted market sales housing and other routes to ownership such as shared ownership and rent to buy (NPPF, Annex 2). Modelling that mix in Excel means either one large multi-sheet model that is fragile to edit, or separate files per tenure reconciled by hand.
Key-person dependency
A bespoke model is usually understood fully only by the person who built it. When that person leaves, goes on extended leave or cannot be reached, the organisation inherits a model it cannot confidently change.
What Purpose-Built Development Appraisal Software Provides
The argument for dedicated software rests on removing the specific failure modes above: inconsistent formulas, manual consolidation, missing history and key-person risk. A good Excel model can match it on individual calculations. Software reduces formula and consolidation errors; the quality of the inputs remains the appraiser's responsibility. The examples below describe Proval Vantage, SDS's development appraisal software, as SDS describes it on its product page.
A standard calculation engine
Every appraisal runs on the same calculations, so schemes are comparable and nobody can quietly overwrite a formula in one copy. SDS's G-Cloud listing describes real-time errors and warnings on data input, alongside configurable functions for organisations that need bespoke calculations (G-Cloud listing).
Viability, cashflow and risk in one model
Proval models scheme viability, cashflow and risk in a single appraisal, with grant and subsidy assumptions built in. Its earlier version, ProVal LS, was reported at launch to support an unlimited number of property types and mixed tenures in the same appraisal; Vantage keeps the same calculations and methodology.
Sensitivity and scenario testing
Users can stress-test a scheme against changes in grant, build cost or sales price and see where the viability threshold sits. Outputs follow a consistent format, so a board reviewing several schemes in one meeting compares like with like.
Central storage and governance
Proval stores every appraisal centrally, with one version of each scheme and access governed by user permissions, and that it centralises the assumptions, defaults and overrides behind each appraisal.
Long-term projections
Proval projects cashflow up to 100 years ahead, which lets organisations test a scheme's long-term performance against their business plan as well as its development-phase viability.
Link to project delivery
Once a scheme is approved, its appraisal figures carry into Sequel, SDS's project management platform, as the baseline budget and milestones the scheme is managed against. Delivery starts from the numbers the board signed off, without rekeying.
The Hidden Costs of Spreadsheet Appraisals
The license saving on spreadsheets is visible; the staff time is harder to see. Building and maintaining bespoke models, finding and fixing errors, consolidating portfolio data and reformatting outputs for different audiences all draw on the same development and finance teams that are expected to grow the pipeline.
When to Switch
The best time to move from spreadsheets is before a problem forces the change. Common triggers include:
- a growing programme with several appraisals live at once;
- a Homes England compliance audit or a board governance review;
- the departure of the development finance officer who owns the Excel model;
- a near miss, where a spreadsheet error was caught before it influenced a material decision.
ProVal Vantage runs in the browser on SDS's Nova Suite, so there is no local installation. SDS provides structured training delivered by TAP-accredited trainers, and the software is available through the G-Cloud framework.