69
Course Overview and Objectives
Meet Your Instructor
What is Included?
Before You Begin...
About the Pre-work Section
Project Evaluation Criteria
Excel Layout
Basic Functions
Common Math Functions
Time Value of Money
Finance Functions
Investment Evaluation- NPV & IRR
Participant Contact Exchange
Before Your First Zoom Class (Please read)
Monday, March 3, 2025 from 12pm-1pm ET - Join Zoom here!
Session 1 Materials
Wednesday, March 5, 2025 from 12pm-1pm ET - Join Zoom here!
Session 2 Materials
Monday, March 10, 2025 from 12pm-1pm ET - Join Zoom here!
Session 3 Materials
Course Introduction
Understanding Real Estate Pro Forma
Reviewing Offering Memorandums - Hotel Conversion to Multifamily
Reviewing Offering Memorandums - Office
Investment Cycle
Elements of a Pro Forma
Setting the Stage and Starting Assumptions
Cash Flows
Internal Rate of Return (IRR)
Introduction to Pro Forma' in Summary
Concept Check
Concept Check Answers
Financial Metrics - NPV and IRR
Financial Metrics - Time Value of Money
Financial Metrics - Investment Evaluation
A Review of Key Terms
Working in Excel - Present Value and Discount Rate
Net Present Value
Working in Excel - Rates of Return
Buy and Hold Example
Introducing the Multifamily Example
How to Set-up a Pro Forma
Calculating Uses of Funds
Sources of Funds
Sources and Uses of Funds in Summary
Financing Assumptions
Debt Information and Data Validation
Amortization Table - The Principal
Amortization Table - Calculating Payment and Ending Balance
Amortization Table - Customizations
Calculating Effective Gross Income
Calculating NOI and Before Tax Unlevered Cash Flow
Debt Service Payment
Summarizing the Pro Forma
Acquisition Cash Flow & Before Tax Unlevered Cash Flow
Disposition Cash Flow - Considerations When Estimating Property Value
Disposition Cash Flow - Cap Rates and Capitalization Method
Calculating Disposition Cash Flow
Leveraged Analysis
Financial Metrics Revisited
Calculating Financial Metrics: NPV and IRR
Calculating Financial Metrics: Equity Multiple, Cash-on-Cash, DSCR
Bonus: Demonstration of the Transpose Function
Scenario Analysis
Sensitivity Analysis and Conditional Formatting
Test Your Knowledge
Pro Forma I: Excel Modeling Quiz
Your Thoughts
Thank You
69
Course Overview and Objectives
Meet Your Instructor
What is Included?
Before You Begin...
About the Pre-work Section
Project Evaluation Criteria
Excel Layout
Basic Functions
Common Math Functions
Time Value of Money
Finance Functions
Investment Evaluation- NPV & IRR
Participant Contact Exchange
Before Your First Zoom Class (Please read)
Monday, March 3, 2025 from 12pm-1pm ET - Join Zoom here!
Session 1 Materials
Wednesday, March 5, 2025 from 12pm-1pm ET - Join Zoom here!
Session 2 Materials
Monday, March 10, 2025 from 12pm-1pm ET - Join Zoom here!
Session 3 Materials
Course Introduction
Understanding Real Estate Pro Forma
Reviewing Offering Memorandums - Hotel Conversion to Multifamily
Reviewing Offering Memorandums - Office
Investment Cycle
Elements of a Pro Forma
Setting the Stage and Starting Assumptions
Cash Flows
Internal Rate of Return (IRR)
Introduction to Pro Forma' in Summary
Concept Check
Concept Check Answers
Financial Metrics - NPV and IRR
Financial Metrics - Time Value of Money
Financial Metrics - Investment Evaluation
A Review of Key Terms
Working in Excel - Present Value and Discount Rate
Net Present Value
Working in Excel - Rates of Return
Buy and Hold Example
Introducing the Multifamily Example
How to Set-up a Pro Forma
Calculating Uses of Funds
Sources of Funds
Sources and Uses of Funds in Summary
Financing Assumptions
Debt Information and Data Validation
Amortization Table - The Principal
Amortization Table - Calculating Payment and Ending Balance
Amortization Table - Customizations
Calculating Effective Gross Income
Calculating NOI and Before Tax Unlevered Cash Flow
Debt Service Payment
Summarizing the Pro Forma
Acquisition Cash Flow & Before Tax Unlevered Cash Flow
Disposition Cash Flow - Considerations When Estimating Property Value
Disposition Cash Flow - Cap Rates and Capitalization Method
Calculating Disposition Cash Flow
Leveraged Analysis
Financial Metrics Revisited
Calculating Financial Metrics: NPV and IRR
Calculating Financial Metrics: Equity Multiple, Cash-on-Cash, DSCR
Bonus: Demonstration of the Transpose Function
Scenario Analysis
Sensitivity Analysis and Conditional Formatting
Test Your Knowledge
Pro Forma I: Excel Modeling Quiz
Your Thoughts
Thank You