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 (REIT) Modeling

You don't have access to this course, but you can purchase it below.

Real Estate (REIT) Modeling

  •   49 Lessons
  •   8h 31m
  •   43,432 Students

This REIT modeling course is ideal for investment banking, equity research, and real estate professionals with a focus on REITs. Trainees build financial and valuation models for a REIT the way it's done on the job.

Course Objective

At completion, trainees will have developed a comprehensive REIT model from scratch

First, we will learn about the REIT industry’s unique drivers and challenges. We will then build REIT financial and valuation models from scratch, using a step-by-step approach for an actual company, BRE Properties. Along the way, we will cover real estate modeling best practices for same store properties, acquisitions, developments, and dispositions. In addition, we model and deconstruct critical REIT profit metrics like FFO, AFFO, and CAD. Part 2 dives into valuation modeling, with a focus on the Net Asset Value (NAV) approach.

This course is used to train new hires at:

What You Will Learn

  • In-depth REIT industry profile, drivers, terminology, tax advantages and structure (UPREIT’s and DOWNREIT’s)
  • Segment-level modeling (same store properties, acquisitions, developments, and dispositions)
  • REIT sector-specific drivers and forecasting best practices
  • Common REIT valuation approaches including Net Asset Value (NAV), comparable company and transaction analyses, and discounted cash flow (DCF) analysis
  • Modeling REIT-specific metrics and ratios – funds from operations (FFO) and adjusted funds from operations (AFFO / CAD)

Course Samples

Modeling the Income Statement, Part 1
Modeling CIP and Accum. Depreciation
REIT Operating Modeling Template

Course Highlights

Step-By-Step Modeling Instruction

Wall Street Prep’s Real Estate (REIT) Modeling Course delivers step-by-step lessons through videos, readings, ready-to-use restructuring financial and valuation models and exercises using a real case study.

Real World “On the Job” Investment Banking Training

The Real Estate (REIT) Modeling Self Study program bridges the gap between academics and the real world and equips trainees with the practical financial skill set needed to succeed on the job. 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 (SEC filings, research reports, etc.) in order to build complex Real Estate (REIT) models the way they would on the job.

Support Center

Upon enrollment, students gain 24-month free access to Wall Street Prep’s Online Support Center, where they receive answers to questions, free downloads, and important updates.

Prerequisites

This course does not assume a prior background in Real Estate (REIT) Modeling. However, those who enroll should have an 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.

Course TOC

Chapter 1: REIT Industry Overview
1. Welcome to REIT Modeling 0:27
2. REIT Industry Overview, Part 1 15:17
3. Course Downloads Files
4. REIT Industry Overview, Part 2 18:19
Chapter 2: Modeling A REIT's Income Statement
5. Modeling the Income Statement, Part 1 9:15
6. Modeling the Income Statement, Part 2 16:38
7. Modeling the Income Statement, Part 3 6:03
Chapter 3: Understanding & Modeling REIT's Segments
8. REIT Segments: Same Store Sales, Part 1 10:42
9. REIT Segments: Same Store Sales, Part 2 11:12
10. REIT Segments: Same Store Expenses and NOI 6:51
11. REIT Segments: Lease Ups, Renovations & Acquisitions 13:58
12. REIT Segments: Dispositions & Discontinued Ops, Part 1 8:29
13. REIT Segments: Dispositions & Discontinued Ops, Part 2 4:12
14. Modeling Segments: Same Store Properties 21:32
15. Modeling Segments: Acquisitions 8:32
16. Modeling Segments: Dispositions 14:35
17. Modeling Segments: Discontinued Ops and Dispositions Cleanup 9:08
18. Modeling Segments: Development 1:54
Chapter 4: Ancillary Income & Non-Operating Items
19. Modeling Ancillary and Other Income 11:18
20. Modeling Non-Operating Income and Finishing the Income Statement 15:47
Chapter 5: Understanding the REIT Balance Sheet
21. Understanding the Balance Sheet: Assets and A/P 16:07
22. Understanding the Balance Sheet: Non-Debt Liabilities 19:55
23. Understanding the Balance Sheet: Debt 7:02
Chapter 6:Modeling the REIT Balance Sheet
24. Modeling Real Estate Assets 15:51
25. Modeling CIP and Accum. Depreciation 11:28
26. Modeling Other Assets 3:04
27. Modeling Non-Debt Liabilities and Equity 11:31
28. Modeling Non-Revolver Debt 4:51
29. Balance Sheet Cleanup 5:10
Chapter 7: Cash Flow Statement & Model Cleanup
30. Understanding the Cash Flow Statement 17:09
31. Modeling the Cash Flow Statement 18:43
32. Pre-Revolver Model Cleanup 2:37
Chapter 8: The Revolver, Interest Expense & Circularity
33. Understanding the Revolver 9:40
34. Modeling the Revolver 9:43
35. Understanding Interest Expense 8:43
36. Modeling Interest Expense 18:52
37. Understanding Circularity 5:10
38. Handling Circularity in a Model 5:16
Chapter 9: Modeling Future Developments
39. Understanding a REIT's Developments 12:37
40. Modeling Developments, Part 1 11:24
41. Modeling Developments, Part 2 11:43
42. Modeling Developments, Part 3 & Finishing the Model 9:09
Chapter 10: Funds from Operations (FFO) & CAD
43. Understanding EBITDA, FFO and CAD 9:18
44. Modeling EBITDA, FFO and CAD 18:15
Chapter 11: REIT Valuation & the NAV Model
45. Introduction to REIT Valuation & NAV 17:47
46. NAV Modeling, Part 1 4:00
47. NAV Modeling, Part 2 21:29
48. The End 0:22
REIT Modeling Review
49. REIT Modeling Review Quiz

Course Agenda

REIT overview
  • Industry profile
  • Industry drivers and terminology
  • Tax advantages of REIT’s
  • REIT basics
  • The structure of REIT’s (UPREIT’s and DOWNREIT’s)
Modeling REIT financial statements
  • The financials of REIT’s as compared to other companies
  • Working with press releases, financial filings, and historical data
  • GAAP vs. Non-GAAP presentation of REIT financial data
  • Sector-specific  drivers and forecasting best practices
  • Forecasting Funds from operations (FFO), adjusted funds from operations (AFFO / CAD)Modeling same store properties
  • Impact of Modeling acquisitions, developments and dispositions on the three financial statements
  • Discontinued operations
  • REIT balance sheet forecasting Completed properties, CIP and land under development
  • Building a REIT cash flow statement
NAV modeling
  • Step-by-step modeling: Net Asset Value (NAV)
  • Common adjustments to NAV
  • Arriving at implied cap rates
  • Common NAV pitfalls and implicit assumptions

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.