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

2023 Winter Issue of Urban Land

The 2022 Winter issue of Urban Land is now available for ULI members. The cover topic is "Exacting Standards: Outlook for property and development in 2023 ." Other topics include "Best Practices: Global Awards for Excellence," "Fall Meeting: Dallas D...
Events Library

2022 ULI Fall Meeting—Industry Insights and Trends Sessions The Responsible Property Investment Council

Fifty Shades of Green: Today’s Specialty Financing Vehicles for ESG Strategies  To enhance the understanding and application of green financing, including but not limited to C-PACE; and learn about evaluating the effectiveness and impact on underwrit...
Video

Financing Decarbonization: The Great Real Estate Investment Opportunity of the Decade? - 2022 Fall Meeting

This panel will share their experiences in financing net zero buildings, and in building low- and lower-carbon real estate funds. Net zero projects and funds are unlocking new sources of capital—often with better rates and terms—but building toward n...
Topics
Finance & Investment Development

Pro Forma II: A Value Add Pro Forma

Register

Featured Content Pillars

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