Strategic Modelling vs the traditional spreadsheet
Excel spreadsheets can only take your financial and strategic modelling so far. The various limitations outlined below show just how vulnerable traditional spreadsheet methods can be. Lack of agility and scalability, human error and slow consolidation processes can mean frustrating financial processes that often result in the inevitable output of errors – damaging confidence and potential loss of opportunity.
Finance departments are having to work harder to make complex reports work, when with HousingBrixx; you don’t even have to think about it.
Understanding of time and accounting behaviours
Your financial models need to represent multiple forecasts and scenario breakdowns in the time frames you want. HousingBrixx allows you to to do this effortlessly, without breaking any formulas or compromising the integrity of your numbers.
Being able to plan, forecast, budget and report are fundamental functions for finance departments, with the outcome being a set of sound decisions and direction on financial strategy. Our strategic modelling solution allows you to view all these reports collaboratively, whereas in a spreadsheet environment, these functions are multiple exchanges of data and files, stored in separate spreadsheet formats that are difficult to be seen together.
Understanding of best practise modelling methods
Unlike spreadsheets, the only variable factor which the user can control are the inputs. With around 300 objects within the HousingBrixx system, they form intelligent, non-breakable ‘building blocks’ that can be modified to the frequency, duration, title and date that has meaning to you. Spreadsheets do not have this lock-down secure approach inherently built in and are therefore vulnerable to corruption.
Comprehensive audit history and flexibility
Can you see the whole picture and how you have got to the results, at each stage? HousingBrixx can log a comprehensive history of who has performed what and when – an important audit requirement in financial processes.
Using standard components, each housing association has the flexibility to build a bespoke model of their business within the strategic modelling tool to best suit its needs, including adding reports as needed.
Development Brixx is a strategic modelling software designed especially for development appraisals. The best way to make a strategic plan is to have a flexible model of your business. It allows development teams to construct complex long term models, which can be imported into the long term financial plan in a single click.
Development Modelling allows you to get answers to key development questions:
• What are the financial metrics for this development in terms of NPV and IRR?
• When will a scheme generate positive cash flow?
• Will delaying developments allow for more schemes to be undertaken without breaking covenants?
Using spreadsheets is complex and error prone, and we had little confidence in presenting the forecasts to the Board. Now, it’s a different story – and furthermore on a hosted platform, HousingBrixx is easy to use with all updates taken care of for us through the service provided by Castleton.
Head of Finance and Resources at Blackpool Housing Company
Blackpool Housing Company Ltd (BHC) is a unique and dynamic regeneration company, established and wholly owned by Blackpool Council. Formed in the Autumn of 2015, Blackpool Housing Company has set itself the ambitious task of making a critical intervention in the private rented market across the inner areas of the...