Description

Event Details:

• Dates: Self-paced, 90 day access.

• Duration: 7.5 Total Video Hours

• Material: Session slideshows, takeaway PDFs and proforma excel model templates.

This intensive workshop offers an in-depth exploration of proforma modeling tailored for multifamily rental properties. You will learn to interpret, analyze, and build your own proforma models that accurately reflects the complexity of your rental development projects. Through practical exercises and real-world case studies, you will learn core proforma concepts such as revenue forecasting, cap rate and price valuation, sensitivity analysis, profit analysis and more.

Bonus Recording: The course will also include an overview of CMHC financing’s rental program, with a focus on how to underwrite rental development projects using CMHC’s criteria. This session will be led in collaboration with a certified CMHC mortgage broker, offering practical insights into the application and approval process as well as how CMHC financing impacts your proforma assumptions.

Key Learning Outcomes:

1. Master Core Components of Rental Proforma Modeling:

   • Develop a comprehensive understanding of proforma structures specific to multifamily rental projects.

   • Identify and analyze key financial metrics, including Net Operating Income (NOI), Internal Rate of Return (IRR), Cash-on-Cash Return, and more.

2. Conduct Detailed Revenue and Expense Analysis:

   • Assess rental income projections, considering factors such as market demand, occupancy rates, and rent escalation.

   • Evaluate operating expenses, including property management, maintenance, taxes, and insurance, to determine their impact on overall project feasibility.

3. Explore Financing Structures and Strategies:

   • Examine various financing options, including traditional mortgages, mezzanine debt, and equity partnerships.

   • Understand the implications of different capital structures on project returns and risk profiles.

4. Analyze Sensitivity and Risk Assessment:

   • Perform sensitivity analyses to evaluate how changes in key assumptions affect project viability.

   • Identify potential risks and develop mitigation strategies to safeguard investment returns.

5. Apply Advanced Excel Modeling Techniques:

   • Build dynamic and flexible proforma models using advanced Excel functions and tools.

   • Incorporate scenario analysis, data validation, and error-checking mechanisms to enhance model reliability.

6. Interpret and Present Proforma Results:

   • Translate complex financial data into clear, actionable insights for stakeholders.

   • Prepare professional reports and presentations that effectively communicate project feasibility and investment potential.

Who Should Attend:

• Real estate developers focusing on multifamily rental projects.

• Financial analysts and consultants specializing in real estate investments.

• Investment professionals seeking to deepen their understanding of rental development economics.

• Urban planners and architects interested in the financial aspects of rental development.

Prerequisites:

• A foundational knowledge of real estate development processes and financial principles.

• Proficiency in Microsoft Excel or similar spreadsheet software.

Course Format:

• Interactive lectures led by industry experts.

• Hands-on modeling sessions with real-world case studies.

• Recorded group discussion and Q&A segments

Certificate:

Only live workshops are eligible for a Certificate of Completion. Please contact us for more information.

Continuing Education Credits:

Only live workshops are eligible for Continuing Education Credits. Please contact us for more information.