- English
- 中文 (Chinese)
- français (French)
- Deutsch (German)
- 日本語 (Japanese)
- Español (Spanish)
Introduction to Pro Forma Excel Modeling
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.
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.
The course is eight hours long, delivered in four two-hour modules. It is available in a convenient on-demand format.
Foundational
Beginning Professional
Featured Content Pillars
- Innovation in der Entwicklungspraxis
- Erfolgreiche Städte und Regionen gestalten
- Wohnungsbau und Kommunen
- Immobilienfinanzierung und -investitionen
- Nachhaltigkeit und Wirtschaftsleistung