Wall Street Prep – Real Estate (REIT) Modeling

Description of Real Estate (REIT) Modeling

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.

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.

What You’ll Learn In Real Estate (REIT) Modeling

• 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)

Content:

Chapter 1: REIT Industry Overview

1. Welcome to REIT Modeling
2. REIT Industry Overview, Part 1
3. Course Downloads
4. REIT Industry Overview, Part 2

Chapter 2: Modeling A REIT’s Income Statement

5. Modeling the Income Statement, Part 1
6. Modeling the Income Statement, Part 2
7. Modeling the Income Statement, Part 3

Chapter 3: Understanding & Modeling REIT’s Segments

8. REIT Segments: Same Store Sales, Part 1
9. REIT Segments: Same Store Sales, Part 2
10. REIT Segments: Same Store Expenses and NOI
11. REIT Segments: Lease Ups, Renovations & Acquisitions
12. REIT Segments: Dispositions & Discontinued Ops, Part 1
13. REIT Segments: Dispositions & Discontinued Ops, Part 2
14. Modeling Segments: Same Store Properties
15. Modeling Segments: Acquisitions
16. Modeling Segments: Dispositions
17. Modeling Segments: Discontinued Ops and Dispositions Cleanup
18. Modeling Segments: Development

Chapter 4: Ancillary Income & Non-Operating Items

19. Modeling Ancillary and Other Income
20. Modeling Non-Operating Income and Finishing the Income Statement

Chapter 5: Understanding the REIT Balance Sheet

21. Understanding the Balance Sheet: Assets and A/P
22. Understanding the Balance Sheet: Non-Debt Liabilities
23. Understanding the Balance Sheet: Debt

Chapter 6:Modeling the REIT Balance Sheet

24. Modeling Real Estate Assets
25. Modeling CIP and Accum. Depreciation
26. Modeling Other Assets
27. Modeling Non-Debt Liabilities and Equity
28. Modeling Non-Revolver Debt
29. Balance Sheet Cleanup

Chapter 7: Cash Flow Statement & Model Cleanup

30. Understanding the Cash Flow Statement
31. Modeling the Cash Flow Statement
32. Pre-Revolver Model Cleanup

Chapter 8: The Revolver, Interest Expense & Circularity

33. Understanding the Revolver
34. Modeling the Revolver
35. Understanding Interest Expense
36. Modeling Interest Expense
37. Understanding Circularity
38. Handling Circularity in a Model

Chapter 9: Modeling Future Developments

39. Understanding a REIT’s Developments
40. Modeling Developments, Part 1
41. Modeling Developments, Part 2
42. Modeling Developments, Part 3 & Finishing the Model

Chapter 10: Funds from Operations (FFO) & CAD

43. Understanding EBITDA, FFO and CAD
44. Modeling EBITDA, FFO and CAD

Chapter 11: REIT Valuation & the NAV Model

45. Introduction to REIT Valuation & NAV
46. NAV Modeling, Part 1
47. NAV Modeling, Part 2
48. The End
49. REIT Modeling Review

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.

Sale Page: Wall Street Prep – Real Estate (REIT) Modeling

When will I receive my course?

You will receive a link to download your course immediately or within 1 to 21 days. It depends on the product you buy, so please read the short description of the product carefully before making a purchase.

How is my course delivered?

We share courses through Google Drive, so once your order is complete, you'll receive an invitation to view the course in your email.

To avoid any delay in delivery, please provide a Google mail and enter your email address correctly in the Checkout Page.

In case you submit a wrong email address, please contact us to resend the course to the correct email.

How do I check status of my order?

Please log in to MMOCourse account then go to Order Page. You will find all your orders includes number, date, status and total price.

If the status is Processing: Your course is being uploaded. Please be patient and wait for us to complete your order. If your order has multiple courses and one of them has not been updated with the download link, the status of the order is also Processing.

If the status is Completed: Your course is ready for immediate download. Click "VIEW" to view details and download the course.

Where can I find my course?

Once your order is complete, a link to download the course will automatically be sent to your email.

You can also get the download link by logging into your mmocourse.hk account then going to Downloads Page.