background
Welcome to Wall Street Prep! Use code at checkout for 15% off.
Wharton & Wall Street Prep Certificates
Now Enrolling for May 2024 for May 2024
:
Private EquityReal Estate Investing
Buy-Side InvestingFP&A
Wharton & Wall Street Prep Certificates:
Enrollment for May 2024 is Open
Wall Street Prep

Real Estate Financial Modeling

You don't have access to this course, but you can purchase it below.
Wall Street Prep Certification Program

Real Estate Financial Modeling

  •   9 Courses
  •   20h 1m
  •   76,643 Students

Everything you need to build and interpret real estate finance models. This is the same training program we deliver to the world's leading real estate private equity firms.

Learn to Build a Real Estate Financial Model Step-By-Step

Get 20+ Hours of Video Content + Reusable Real Estate Excel Model Templates

Get lifetime access to step by step online video training as well as industry-grade reusable real estate excel templates for modeling acquisitions and developments for multifamily, office, retail, industrial properties, including JV & Waterfall Modeling.

Learn From Real Estate Practitioners

Led by real estate private equity expert Aaron Hancock, you'll not only learn modeling best practices across the different real estate property types, you'll learn how real estate investors actually evaluate opportunities.

Enhance Your Real Estate Credentials

Designed for professionals and students pursuing careers in real estate private equity as well as operators, developers, lenders, individual investors. Enrollment includes the option of sitting for the Real Estate Financial Modeling Certification. Those who successfully pass the exam can present their achievement on their resumes and LinkedIn (see below).

This program has everything you need to build and interpret real estate finance models. All major real estate "food groups" are covered, including Multifamily, Office, Retail, and Industrial.

Who is This Program For?

This course is designed for individual investors as well as students and professionals pursuing careers in:

  • Acquisitions
  • Development
  • Private Equity
  • Asset Management
  • Brokerage
  • Lending

A 360° Real Estate Financial Modeling Program

This course begins with the foundations of real estate finance and excel best practices, adding complexity piece by piece. By the end of the program, learners will build complete, industrial grade multifamily, office, retail and industrial models, including in depth treatment of the modeling of revenues, operating expenses, capital improvements, debt, and joint venture waterfalls

  • Real estate financial modeling best practices
  • Real estate investment and development theory
  • How to utilize historical financials to build a multifamily acquisition model
  • How to utilize Argus outputs to build a commercial acquisition model
  • How to build a real estate development model
  • How to model a debt schedule
  • How to model a joint venture waterfall

What's Included

Each module builds sequentially towards a complete understanding of the Real Estate model building process

12 Lessons
0h 54m

Introduction to Real Estate Modeling

 12 Lessons  0h 54m

Section 1 of our Real Estate Financial Modeling Program. This course provides an introduction to the function of real estate financial models, the challenges presented by bespoke approaches, and Wall Street Prep’s approach to teaching Real Estate Financial Modeling. We will begin with a review of efficiency and formatting fundamentals that will be ...

Section 1 of our Real Estate Financial Modeling Program. This course provides an introduction to the function of real estate financial models, the challenges presented by bespoke approaches, and Wall ...

Section 1 of our Real Estate Financial Modeling Program. This course provides an introduction to the ...

1
View Course TOC
67 Lessons
3h 35m

Operating Cash Flow

 67 Lessons  3h 35m

Section 2 of our Real Estate Financial Modeling Program. Real estate is all about cash flow. This module will cover cash flow builds for multifamily and commercial property types. We will build the foundations of revenues and expenses and finish with a discussion on the importance of net operating income. Each section will begin with the characteri ...

Section 2 of our Real Estate Financial Modeling Program. Real estate is all about cash flow. This module will cover cash flow builds for multifamily and commercial property types. We will build the fo ...

Section 2 of our Real Estate Financial Modeling Program. Real estate is all about cash flow. This mo ...

2
View Course TOC
22 Lessons
1h 19m

Non-Operating Cash Flow

 22 Lessons  1h 19m

Section 3 of our Real Estate Financial Modeling Program. Although real estate is valued based on operating cash flow, non-operating cash flows are integral to business plans. This module will cover leasing costs for commercial properties, capital improvements and costs associated with buying and selling a property. After detailed discussions of the ...

Section 3 of our Real Estate Financial Modeling Program. Although real estate is valued based on operating cash flow, non-operating cash flows are integral to business plans. This module will cover le ...

Section 3 of our Real Estate Financial Modeling Program. Although real estate is valued based on ope ...

3
View Course TOC
27 Lessons
2h 9m

Debt & Levered Cash Flow

 27 Lessons  2h 9m

Section 4 of our Real Estate Financial Modeling Program. Real estate is a highly levered asset class and an understanding of leverage is critical for any real estate investor. This module will serve as a primer on real estate debt, covering everything from different ways to finance an acquisition, to key terms in loan documents and how to model an ...

Section 4 of our Real Estate Financial Modeling Program. Real estate is a highly levered asset class and an understanding of leverage is critical for any real estate investor. This module will serve a ...

Section 4 of our Real Estate Financial Modeling Program. Real estate is a highly levered asset class ...

4
View Course TOC
22 Lessons
2h 1m

Joint Ventures & Waterfalls

 22 Lessons  2h 1m

Section 5 of our Real Estate Financial Modeling Program. The waterfall is infamously part of most real estate interview modeling tests. This module introduces joint ventures and the theory behind waterfalls. After introducing key terminology and reinforcing the underlying theory, considerable time will be spent on a step-by-step walkthrough of how ...

Section 5 of our Real Estate Financial Modeling Program. The waterfall is infamously part of most real estate interview modeling tests. This module introduces joint ventures and the theory behind wate ...

Section 5 of our Real Estate Financial Modeling Program. The waterfall is infamously part of most re ...

5
View Course TOC
26 Lessons
2h 31m

Summarizing & Analyzing the Model

 26 Lessons  2h 31m

Section 6 of our Real Estate Financial Modeling Program. Real estate financial models are tools for projecting the cash flows of a potential investment. The cash flow projections alone are not enough to analyze a potential investment. This module will cover how to summarize the outputs of a model to form the basis of an analysis by discussing key m ...

Section 6 of our Real Estate Financial Modeling Program. Real estate financial models are tools for projecting the cash flows of a potential investment. The cash flow projections alone are not enough ...

Section 6 of our Real Estate Financial Modeling Program. Real estate financial models are tools for ...

6
View Course TOC
41 Lessons
3h 12m

Development Modeling

 41 Lessons  3h 12m

Section 7 of our Real Estate Financial Modeling Program. Real estate can be bought or built. Up to this point, the course has been focused on buying property. This module will unpack the differences and similarities in modeling a development and an acquisition. Development specific topics such as construction budgets and lease-up will be covered as ...

Section 7 of our Real Estate Financial Modeling Program. Real estate can be bought or built. Up to this point, the course has been focused on buying property. This module will unpack the differences a ...

Section 7 of our Real Estate Financial Modeling Program. Real estate can be bought or built. Up to t ...

7
View Course TOC
14 Lessons
1h 35m

Office Building Acquisition Case Study

 14 Lessons  1h 35m

Section 8 of our Real Estate Financial Modeling Program. Building well-formatted and extensive models is the name of the game for those working for institutional firms or preparing materials for a potential investor. But, many situations – whether a modeling test or first pass at a potential personal investment – necessitate building a model quickl ...

Section 8 of our Real Estate Financial Modeling Program. Building well-formatted and extensive models is the name of the game for those working for institutional firms or preparing materials for a pot ...

Section 8 of our Real Estate Financial Modeling Program. Building well-formatted and extensive model ...

8
View Course TOC
15 Lessons
2h 45m

Multifamily Building Development Case Study

 15 Lessons  2h 45m

Section 9 of our Real Estate Financial Modeling Program. Building well-formatted and extensive models is the name of the game for those working for institutional firms or preparing materials for a potential investor. But, many situations – whether a modeling test or first pass at a potential personal investment – necessitate building a model quickl ...

Section 9 of our Real Estate Financial Modeling Program. Building well-formatted and extensive models is the name of the game for those working for institutional firms or preparing materials for a pot ...

Section 9 of our Real Estate Financial Modeling Program. Building well-formatted and extensive model ...

9
View Course TOC

Get the Real Estate Financial Modeling Certification

Learners are eligible to earn Wall Street Prep's globally recognized Real Estate Financial Modeling Certification. The certification is earned by successfully completing the final exam from the program's 7 individual courses. ("Case study" courses do not include a final exam). These online assessments can be taken any time after enrollment in the program.

Course Samples

watch video
Course Introduction
watch video
Real Estate Model Structure
watch video
Multifamily Revenue Build: Historical Financials
watch video
Modeling Acquisition & Sale
watch video
Amortization Table Practice
watch video
Building the First Hurdle
watch video
Modeling the Transaction Summary
watch video
Lease-up & Timing Assumptions
watch video
RE Model Template (Values Only)

Real Estate Financial Modeling Package Highlights

Intuitive, Self-Paced and Comprehensive

Wall Street Prep's Real Estate Financial Modeling Package is intuitive and self-paced. Using a combination of videos, Excel model templates and financial reports, this course teaches students and professionals how to build, analyze, and interpret Real Estate financial models in a step-by-step fashion at their own pace. The program utilizes a case study format, as students follow their tutorial guide alongside the Excel model templates, and are directed to the appropriate external documents in order to build comprehensive models the way the way it's done on the job.

Support Center

Upon enrollment, students gain free and unlimited access to Wall Street Prep's Online Support Center, where they receive answers to questions, free downloads, and important updates from a support staff comprised entirely of experienced former investment bankers.

Private Online Tutoring (Additional Fee Applies)

Want a little extra attention? Live video-chat tutoring is available with experienced real estate professionals (additional fee applies). In addition, your tutoring sessions enable you and your tutor to share models, a virtual whiteboard and any other files via an integrated web and phone platform that enhances the learning experience.

Prerequisites

The program assumes a basic introductory knowledge of accounting (e.g. interaction of balance sheet, cash flow, and income statement) and proficiency in Excel. Students with no prior background in Accounting should enroll in the Accounting Crash Course. Students with limited experience using Excel should enroll in the Excel Crash Course.

Learner Feedback

Earn CPE Credits with WSP Online Courses

Wall Street Prep is registered with the National Association of State Boards of Accountancy (NASBA) as a sponsor of continuing professional education on the National Registry of CPE Sponsors. State boards of accountancy have final authority on the acceptance of individual courses for CPE credit. Complaints regarding registered sponsors may be submitted to the National Registry of CPE Sponsors through its website: www.nasbaregistry.org.

The Wall Street Prep Quicklesson Series

7 Free Financial Modeling Lessons

Get instant access to video lessons taught by experienced investment bankers. Learn financial statement modeling, DCF, M&A, LBO, Comps and Excel shortcuts.