On-Demand Event
Course Summary:

In this course, you will learn to create a basic multifamily investment pro forma. This course is designed for those who have not completed a pro forma from scratch.

You will begin with an overview of financial modeling, and the course introduces/reviews a variety of Excel functions that are commonly used in building pro formas. Starting from a blank spreadsheet, you will receive step-by-step instructions in building the components of a financial model, including uses and sources of funds, mortgage amortization, cash flow projections, and property reversion.

By the conclusion of the last session, you will have completed your own investment pro forma.

Course Summary:In this course, you will learn to create a basic multifamily investment pro forma. This course is designed for those who have not completed a pro forma from scratch.

You will begin with an overview of financial modeling, and the course introduces/reviews a variety of Excel functions that are commonly used in building pro formas. Starting from a blank spreadsheet, you will receive step-by-step instructions in building the components of a financial model, including uses and sources of funds, mortgage amortization, cash flow projections, and property reversion.

By the conclusion of the last session, you will have completed your own investment pro forma.

Details
Format

The course is eight hours long, delivered in four two-hour modules. It is available in a convenient on-demand format.

Type

On-Demand Course

Experience Level

Foundational

Career Stage

Beginning Professional

RELATED
Reading List

Urban Land's Best of 2020 Reading List

In a year that brought many challenges, these articles were among the most popular with ULI members for all of 2020. Presented by Owen Thomas, ULI Global Chairman.
Podcast

ULI Germany: Immobilien - Städte - Menschen

Real Estate – Cities – People: The ULI Germany podcast with designers of the built environment, movers and shakers in the real estate industry and personalities who shape our cities.
Report

Emerging Trends in Real Estate®: Asia Pacific 2021

Throughout 2020, the success of government efforts across Asia Pacific to contain the spread of COVID-19 has helped limit its impact on local real estate markets. At the same time, however, there is a sense that asset values have been propped up by a...
Topics
Finance & Investment Development

Pro Forma Excel Modeling I

Register

Featured Content Pillars

  • Housing and Communites
  • Real Estate Finance and Investment
  • Sustainability and Economic Performance
  • Innovation in Development Practice
  • Shaping Successful Cities and Regions