Pro Forma Excel Modeling I
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.
Instructor
The course is eight hours long, delivered in four two-hour modules. It is available in a convenient on-demand format.
On-Demand Course
Foundational
Beginning Professional