Zoom Session 5B
Design Review - Learning Together Faculty will facilitate a show-and-tell with Boot Camp participants, providing live feedback on design decisions that can either save on cost or increase building quality and revenue. Participants should send Faculty PDF scans of their drawings so we have the ability to markup together.
Sprint #6: Detailed Financials
Session 6A
Building a Custom Pro Forma in Excel This session is about giving participants the confidence and financial literacy to edit and build their own pro forma in Excel. Using a template sheet, we review definitions, assumptions, and calculations. This allows participants to model the specifics of their building type and use without being confined to the introductory two-page pro forma used in earlier sessions. session will be This recorded so that participants can review it at whatever pace or repetition that makes it click.
Modeling Multi-Year Cash Flow The static pro forma gives an upfront glimpse into the viability of a project. A multi-year cash flow is required to understand how much a building can earn over time and how the deal evolves. Faculty will walk through a multi-year cash flow on an example spreadsheet. This session will be recorded so that participants can review it at whatever pace or repetition that makes it click.
Sprint Homework:
- Fill out static pro forma in Excel
- Generate 4 different copies of the pro forma for different scenarios
- Create 2 financing and deal structure scenarios.
- Does this change the viability or strategy of your project?
- When do you want partners in and when do you want them out?
- How does your deal structure impact your ability to recycle your equity back into your farm?
Zoom Session 6B
Live Q & A + Financial Strategies After participants have had a chance to play around with their own numbers, they can clarify any confusion with Faculty or discuss the outcomes of their spreadsheets.
Faculty will also go deeper into the different levers you can pull to modify your deal. Faculty discuss how changing your assumptions or inputs will affect the outputs of your pro forma. Likewise, how will various decisions affect your multi-year cash flow? Faculty describe common exit strategies and the idea of “reinvesting in the farm.”