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.

This course will build on your basic understanding of pro forma modeling with Excel to walk you through the creation of a pro forma value-add project. Your work will be structured into three parts:

Introduction to Necessary Concepts
The Renovation and Lease-up Stage
The Stabilization Stage

By the end of the course, you will have a pro forma model that is designed to analyze a value-added project.

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.

This course counts towards the Pro Forma Fundamentals Certificate.