Description

Event Details:

• Dates: May 05, May 07, May 09, 2025 (3 Sessions)

• Time: 8:30 – 11:00 AM PST (7.5 Total Hours)

• Location: Live Video Conference

This intensive course offers an in-depth exploration of proforma modeling tailored specifically for multifamily rental properties. Participants will engage with advanced financial concepts, learning to construct, analyze, and interpret proforma models that accurately reflect the complexities of rental developments. Through practical exercises and real-world case studies, attendees will enhance their proficiency in forecasting, valuation, and investment analysis, equipping them to make informed decisions and optimize project outcomes.

New for this session: The course will also include an overview of CMHC financing, 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.

• Collaborative group discussions and Q&A segments to address specific challenges and scenarios.

Certificate:

Participants will receive a Certificate of Completion upon finishing the course.

Continuing Education Credits:

This course may be eligible for Continuing Education credits—contact us if you require supporting documentation.