[LIVE] Introduction to Pro Forma Excel Modeling - January 2021

Includes a Live Event on 01/07/2021 at 12:00 PM (EST)

Online: Live Course

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.

Overview

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.


This course counts toward the Pro Forma Fundamentals Certificate and the Real Estate 101 Certificate.

Learning Objectives

Upon completion of this course, students will be able to:

·       Create a multifamily investment pro forma from scratch.

·       Understand how valuation and investment decisions are made.

·       Manage all the basic terminology and concepts of a basic pro forma.

·       Understand basic financial concepts like cash flows and amortization.

Curriculum

The course is made up of four modules:

Module 1: Overview of Financial Modeling

  • Components of a Financial Model
  • Review of Excel Functions

Module 2: Projection of Future Cash Flows: the Pro Forma

  • Operating Cash Flows
  • Terminal Cash Flows

Module 3: Mortgage Financing

  • Mortgage Amortization
  • Underwriting

Module 4: Financial Modeling and Decision-Making

  • Valuation and Net Present Value (NPV)
  • Internal Rate of Return (IRR)
    Cash-on-Cash Return


ULI Learning is provided by the Urban Land Institute.

Topics

  • Finance and Investment
  • Pro Forma Modeling

Experience Level

  • Foundational

This course is designed for beginning-level participants looking for foundational information and insights.

Career Stage

  • Beginning Real Estate Professionals

This course is designed for those considering a career in real estate, new to real estate, or changing from one industry area to another.

Course Format

The course is five hours long, delivered in five one-hour live webinars. You will need a computer with Microsoft Excel for this course.

Course dates: January 7, 12, 14, 19, 21

Time: 12:00 - 1:00 pm EDT

Charles Tu

Interim Associate Dean for Graduate Programs and Daniel F. Mulvihill Professor of Commercial Real Estate at The University of San Diego School of Business

Charles Tu is the interim associate dean for graduate programs and Daniel F. Mulvihill Professor of Commercial Real Estate at the University of San Diego School of Business. Before coming to USD, he taught real estate and finance courses at George Washington University and Cal State Fullerton, where he received the Outstanding Teacher/Scholar Award in 2002. Tu is dedicated to conducting applied research that helps improve real estate and business decision-making. His research agenda covers a variety of topics, including housing valuation, smart growth and the new urbanism, commercial mortgage backed securities (CMBS), real estate investment trusts (REITs), multifamily housing and retail shopping centers.

Tu has published articles in leading academic journals, and the findings of his research have been cited in major newspapers such as The Wall Street JournalWashington Post and Atlanta Journal-Constitution.

Tu earned his Ph.D. and M.B.A in Finance and Investments from the George Washington University, and his BS in Mechanical Engineering from National Chao-Tung University.  He also received the Chartered Financial Analyst (CFA) designation in 2000.  

Pricing

  • ULI Members: $395.00
  • ULI Members (Government/NonProfit/Academic): $350.00
  • Non-Members: $525.00
Components visible upon registration.