The client, a Private Equity firm, wanted the TresVista team to work with the CFO and the business development head of the client’s real estate portfolio company to prepare a cash flow model as a part of their annual business plan, to track current and future performance. The client primarily wanted the team to create an assumptions section, cash flow statement, funding details, and a valuation summary for four types of assets which included land sales, hospitality, build to sell and build to lease assets. Moreover, the team was also required to perform a two-level roll-up, where a summary tab was created for each project which was further rolled up into ‘Sources & Uses’, ‘CAPEX Summary’, and ‘Annual Cash Requirements’ tabs.
To prepare a consolidated real estate cash flow model that performs a two-level roll-up to track and analyze its future performance-making outputs in such a way that it can be presented directly to the board on updating the assumptions.
The TresVista Team followed the following process:
The major hurdles faced by the TresVista team were:
The team overcame these hurdles by maintaining constant communication with the client over calls that gave the team a good background about the project and helped in understanding what type of calculations and uses they desired for the model. The client also provided the master schedule for their land sales and off-plan development which had granular information related to the projects which supported the output.
The model built by the TresVista team was dynamic with numerous options to give the client the flexibility to change inputs according to their preferences. The team also built a land rate calculator based on the down payment and payment plan with the help of a macro and goal seek function. Moreover, the team added a switch for leasing projects, wherein the land could either be selected as an upfront injection or it could be leased out over the years with the NPV remaining the same in both cases.