On-Demand Event
Course Summary:

Building on the introductory pro forma modeling with Excel course, or your own basic understanding of pro forma modeling, this course moves beyond your understanding of a basic property acquisition pro forma by introducing Excel functions and processes that can be used to analyze a property that needs renovation or major capital improvement. The project will take you through a case that will ask you to model initial financing using a transitional loan, and once income stabilizes, you will model financing with a permanent loan.

Each session starts with a conceptual discussion of the task at hand and you will receive instructions on how to complete the task. At the end of the course, you will have a pro forma model that is designed to analyze a value-added project. This model is yours to keep and may be modified (such as in the advanced pro forma course) to include more advanced features, such as a waterfall structure for modeling investment returns.

Course Summary:Building on the introductory pro forma modeling with Excel course, or your own basic understanding of pro forma modeling, this course moves beyond your understanding of a basic property acquisition pro forma by introducing Excel functions and processes that can be used to analyze a property that needs renovation or major capital improvement. The project will take you through a case that will ask you to model initial financing using a transitional loan, and once income stabilizes, you will model financing with a permanent loan.

Each session starts with a conceptual discussion of the task at hand and you will receive instructions on how to complete the task. At the end of the course, you will have a pro forma model that is designed to analyze a value-added project. This model is yours to keep and may be modified (such as in the advanced pro forma course) to include more advanced features, such as a waterfall structure for modeling investment returns.

Details
Type

On-Demand Course

Experience Level

Intermediate

RELATED
Reading List

Summer Issue 2021 of Urban Land

The 2021 Summer Issue of Urban Land is now available for ULI members. The cover topic is "Airport Connections: Development Ties Travel, Logistics, and Cyberspace." Other topics include: "Best Practices: Global Awards for Excellence," "ULI Global Chai...
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: Real Estate – Cities – People

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.
Topics
Finance & Investment Development

Pro Forma II: A Value Add Pro Forma

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