$1,050 – $1,200

Building a Financial Model (for a Real Estate Development Project)

Event Information

Share this event

Date and Time

Location

Location

The Marquee Group

56 Temperance Street

Suite 200

Toronto, ON M5H 3V5

Canada

View Map

Refund Policy

Refund Policy

Refunds up to 7 days before event

Event description

Description

This advanced hands-on course reviews real estate project development concepts and focuses on the skills required to design and create a model to help finance professionals evaluate a real estate development investment. Using a mixed-use development case study, the course reviews concepts including model design, logic, project timing and various financing structures.

Topics Include
Design and Structure a Real Estate Development Project Model

  • Design and layout the model clearly and logically
  • Modeling various project phases
  • Design a powerful scenario manager with advanced controls
  • Construct financial statements and schedules for Construction timing, CAPEX, Revenues, etc.
  • Calculate various important metrics including Net Operation Income, Cash Flow for Debt Service, Levered and Unlevered Free Cash Flow


Incorporate Advanced Capital Structure Features

  • Construction Loans and take out
  • Mortgage, Interest-only and Mezzanine debt structures
  • Revolving credit facility with a cash sweep
  • Create “flags” to monitor leverage and covenants


Sensitize and Evaluate the Project

  • Explore model optimization and self-auditing techniques
  • Evaluate a project’s returns using Net Present Value (“NPV”) and Levered and Unlevered Internal Rate of Return (IRR)
  • Set up sensitivity analysis and create a strong summary page to display the results


Who Will Benefit

This seminar is designed for anyone who wants to improve their financial modeling skills and to create robust, flexible and dynamic models for real estate development projects.

Eligible for CFA & CPA professional development hours.


Date & Time
Wednesday February 27 & Thursday February 28, 2019
8:30 am to 5:00 pm
Lunch will be provided


Special Instructions

  • Attendees must bring their own laptop with access to Excel.
  • Attendees should have a solid grasp of basic accounting fundamentals and proficiency with Excel prior to attending.


Registration Deadlines

Early Payment Pricing: $1050 + tax (if registration paid by February 13, 2019)

Regular Pricing: $1200 + tax (registration closes on February 22, 2019)


*Please note that student pricing is available. To obtain a 40% discount, please email a scanned copy or photo of your student ID that clearly shows your name and expiration date to info@marqueegroup.ca. Once we confirm your status as a current full-time student, we will provide you with a student discount code.

Share with friends

Date and Time

Location

The Marquee Group

56 Temperance Street

Suite 200

Toronto, ON M5H 3V5

Canada

View Map

Refund Policy

Refunds up to 7 days before event

Save This Event

Event Saved