Our client is a developer and operator of retirement villages with over 30 villages under development or management and plans to grow the portfolio over the next decade.
The client required a tool to consolidate their existing village development models to test multiple operational scenarios and various funding options. The model was needed to support a process to refinance their balance sheet and provide funding for future growth. Model requirements included:
Working closely with the founders and their advisors, Forecast prepared a detailed 10-year monthly forecasting model that accurately reflected the structure of the industry and the client’s business. We created an intermediary DataBook to consolidate the individual village files which then exported data into the new corporate file. The inclusion of a scenario handler within the model was critical for testing future assumptions on development timing, market price and demand movements, and various funding options.
Forecast presented the model directly to potential lenders and investors with the final result being a large debt and equity investment by a leading superannuation fund.
We continue to support the client to add model functionality and has incorporated changes such as: