Home insulation without a single payback promise: test several scenarios

Each comparison column should refer to an identified building and a clearly defined scope of work.

Record the project expenditure, expected annual energy saving and method of valuing that saving as separate inputs. Add a date and a basis for each figure: a quotation, a measurement or an assumption requiring checking. Do not compare a net amount in one column with a tax-inclusive amount in another.

Start with one complete set of inputs. Use the same period and accounting scope for annual costs. If some renovation work is required regardless of insulation improvements, state whether the assessment covers the whole project or additional expenditure relative to another solution.

For the first test, change only the construction cost and keep savings fixed. For the second, restore the initial inputs and change savings alone. This reveals which variable moves the result. Changing two inputs together makes their individual effects harder to distinguish.

Give the tested range a reason. Differences between comparable quotations or uncertainty about the work area can identify useful checks. Do not automatically add and subtract ten per cent from every item as though all inputs were equally precise. Distinguish an evidenced range from an illustrative stress test.

With positive expenditure and positive constant annual savings, simple payback is expenditure divided by annual savings. As an arithmetic illustration only, savings that are 20% lower make this period 25% longer, not 20% longer. This follows from dividing by 0.8; it is not a prediction for a particular home.

If a test produces zero or negative cost savings, do not report an ordinary positive payback period. Mark that there is no payback under this simplified calculation. That does not automatically remove other reasons for renovating, such as necessary repairs; those objectives require a separate assessment.

After the individual tests, build scenarios that combine several changes. Give them descriptive names, such as “more extensive substrate repairs”. Explain which assumptions change and why they could occur together. Do not increase construction costs and energy savings merely to produce a preferred result.

A column combining every favourable assumption is not a budget plan, and an adverse column is not a certain event. Do not assign percentage probabilities without a separate basis. Several results show dependence on the inputs; they do not by themselves establish how often an outcome will occur.

Mark inputs whose reasonable variation changes the conclusion most. The next step may be a more accurate survey, a completed cost estimate or a review of energy assumptions. This directs attention to an important unknown. Adding decimal places to the result does not replace missing evidence.

Before choosing a contractor, record the assumptions under which you accept the solution and the changes that require recalculation. A new quotation, a concealed substrate defect or a change in heated floor area can invalidate an earlier comparison. Keep the previous spreadsheet version so the reason for a changed decision remains visible.

Summarise the range of results and the main unresolved assumptions. Simple payback does not automatically account for changing maintenance costs, different service lives or the time value of money. Where these determine the choice, compare costs over an agreed study period rather than repeatedly rounding a single number of years.