Financial Modelling Mastermind Session: Lease Event Integration Unpacked

Hey, everyone! We just wrapped up an amazing Financial Modelling Mastermind session and I couldn't wait to share the highlights with you. Alongside Maria Wiedner, Carson Fung of Goldstone Real Estate, and Carl Hermelin or Ingka (Ikea), we delved deep into the final touches of our financial model. Our main focus? Integrating different lease event types to give a complete view of cash flow dynamics. Let's jump right in!

Financial Modelling Mastermind Session: Lease Event Integration Unpacked

Hey, everyone! We just wrapped up an amazing Financial Modelling Mastermind session and I couldn't wait to share the highlights with you. Alongside Maria Wiedner, Carson Fung of Goldstone Real Estate, and Carl Hermelin or Ingka (Ikea), we delved deep into the final touches of our financial model. Our main focus? Integrating different lease event types to give a complete view of cash flow dynamics. Let's jump right in!


Setting the Scene

During this session, Maria, Carson and Carl, and I discussed various lease event types like indexation leases, step-up rents, and open market rent reviews. Here’s a rundown of the valuable insights and steps we took to integrate these lease events into a unified financial model.


Indexation Leases: Building the Base

Maria kicked things off by discussing indexation leases. These leases adjust rental payments based on a predefined index, like the Consumer Price Index (CPI). This ensures that rental income keeps up with inflation, providing a stable revenue stream. It's like having a built-in safety net for your investments to hedge against inflation.


Step-Up Rents: Climbing the Ladder

Next, we modelled  step-up rents. These leases feature predetermined rent increases at specific intervals. Step-Up rents are contractual increases that should be modelled accurately, since the idea is that the initial rent is only a fraction of the ERV (estimated rental value) and that over a specific period of time, the rent will ‘step up’ to ERV level. Open Market Rent Reviews: Staying Competitive

Carl took us through open market rent reviews, which adjust rental payments based on current market rates. This keeps rents competitive and in line with market conditions. By integrating these reviews into our model, we can account for market fluctuations, making our financial projections more dynamic and realistic. It's like having a crystal ball for market trends.


Bringing It All Together: A Holistic Approach

With a clear understanding of each lease event type, we moved on to the integration process. Our goal? To create a cohesive financial model that accurately reflects the interplay between different lease events. Here’s our step-by-step approach:


  • Data Collection: We gathered data for each lease event type, including historical CPI figures, step-up rent schedules, and market rent benchmarks.


  • Model Framework: We built a flexible model framework to accommodate various lease events, creating separate modules for indexation leases, step-up rents, and open market rent reviews.


  • Integration: We combined the modules into a single model, ensuring interconnected calculations for each lease event type. This helped us capture the cumulative impact on cash flows.


  • Validation: Finally, we validated our model by comparing its outputs with actual market data, ensuring the accuracy and reliability of our financial projections.


Conclusion: A Comprehensive Financial Model

By the end of the session, we had successfully integrated different lease event types into our financial model. This holistic approach gave us a comprehensive view of cash flow dynamics, enabling us to make informed decisions and optimise our investment strategies.

As we move forward, it's essential to continually refine and update our model to reflect changing market conditions. This way, we stay ahead of the curve and maximise the value of our real estate investments.

Thank you for joining us in this Financial Modelling Mastermind session. Stay tuned for more insights and practical tips on navigating the complexities of financial modelling. See you next time!

Share on

Posted on Jul 5, 2024 by Anouk Khan