CT’s Senior Associate Consultant, Phil Newsam, shares 10 tips on business plan modelling for housing organisations using Brixx.
Campbell Tickell has worked with over 50 organisations to prepare or validate their business plan models. We are a Brixx partner and in this article Phil Newsam a senior associate at Campbell Tickell sets out some practical guidance and top tips for modelling business plans using Brixx.
Top 10 tips
- Plan ahead: set up a timetable that details what you need and who will provide it. Include time for modelling, reconciliations, internal review, stress testing and, reporting to the executive team and the board. Make sure everyone knows what they are to provide and by when.
- Start from what you know: the approved budget, the opening balance sheet, the loans register as at March/start of your financial year, units as per the Statistical Data Return (SDR) to the regulator, the asset management system, etc. Make sure the final output is aligned to these within a reasonable tolerance. If there are differences, provide an explanation to the regulator when you upload the Financial Forecast Return (FFR).
- Use Brixx functionality as much as possible: for instance interest calculations and non-utilisation fees. Where possible, model variable costs for each of your main property tenures in terms of cost per unit so that these reduce if you have any property disposals.
- If you are modelling intended savings, put these in separate objects so they are visible and you can easily dis-enable them. Use the comments box to provide notes on the object and any different assumptions such as inflation.
- When you change an object, look at the reports to make sure it is doing what you want it to do. This will be important in modelling the 7% rent increase cap in England for 2023/24. The local inflation object can be used to model stock where the rent cap does not apply.
- Keep a running total of the impact of your main changes on the key metrics – maybe year one surplus, year two surplus and closing cash or loans.
- Take care around year-end timing differences on development handovers, if these are material. If the units are already in your opening balances, select this as an option in your development scheme object so that units and rents are not added again. For shared ownership developments, you can model a sales profile of units that have already been handed over.
- Write a Brixx report to do your loan covenant calculations and headroom on each. But be aware that this is not possible for covenants where the gearing ratio does not allow inclusion of properties under construction, or to check the average of interest cover over three years.
- Before you finish, turn off inflation and drill down in the reports to see whether the results are what you expect.
- Once you have a base case that the board has approved, save it as the approved base case and purge history, so that it’s easy to spot any changes since approval.
Most important make sure you give yourself plenty of time to check your model. The impact of the rent cap, with costs increasing faster than income, is likely to take you closer to your loan covenants and golden rules. You will need to check that your plan stacks up and is deliverable.
Join Campbell Tickell’s stress testing masterclasses in March:
London Stress Testing Masterclass (Thursday 2nd March)
Manchester Stress Testing Masterclass (Thursday 9th March)
To discuss further, do feel free to contact Helen Routledge on: helen.routledge@campbelltickell.com
