Real Estate & REIT Modeling teaches you how to model property development and acquisitions, and how to project and value real estate investment trusts (REITs).
The program is based on case studies of an office development & sale, a hotel acquisition & renovation, and a REIT operating model and valuation for AvalonBay Communities, where we use real SEC filings and equity research from banks like Citi and JP Morgan to support the numbers.
You’ll start with a crash-course on real estate development and REITs, and then move into the office development and hotel acquisition case studies, where you’ll learn how to estimate a property’s size, financial performance, and returns to investors.
After that, we’ll jump into a detailed 3-statement model for AvalonBay with support for their different real estate segments, and conclude with a full valuation, including the usual methodologies as well as real estate-specific ones such as the Net Asset Value (NAV) model.
What do you get when you sign up for the course?
✓Prerequisites: Excel & Financial Modeling Fundamentals or equivalent (this is an advanced course).
✓Lessons cover property development and acquisitions, key real estate terminology and metrics, how a REIT’s financial statements differ, and REIT valuation.
✓63 videos total (24 hours of footage).
✓7 quick reference guide PDFs on key topics – from key terms and accounting through property modeling, REIT financial statements, and valuation.
✓Overview lessons cover real estate key terms, how to model an apartment complex, how a REIT operates, and how to link properties and REITs.
✓Office Development & Sale lessons teach you how to estimate building size, hard costs and soft costs, project the financial statements of a property, build debt and equity draw schedules, calculate the sale proceeds, and allocate investor returns using a waterfall schedule, factoring in developer promotes.
✓Hotel Acquisition & Renovation lessons cover how to project a hotel’s financial statements, estimate the impact of property renovation, and calculate returns based on the purchase price, selling cap rate, and capital structure.
✓REIT Operating Model videos teach you how to project a REIT’s rental income and net operating income (NOI) from same-store properties, development/redevelopment, acquisitions, and dispositions; you’ll also learn how to create a complex debt schedule, link and project the statements, and calculate FFO, AFFO, and dividends issued.
✓REIT Valuation lessons cover public comps, precedent transactions, and the Discounted Cash Flow Analysis (DCF) and Dividend Discount Model (DDM) for REITs, as well as real estate-specific models such as the Net Asset Value (NAV) and Replacement Cost methods.
✓You receive instant access when you sign up because everything is delivered online – no shipping charges or physical products to worry about.
✓Free lifetime updates and support.
Full Course Price: $247
Here’s a bonus for you!!
If you enroll to this program through this page, you will get :
✓PowerPoint Pro Program to create M& A Pitch Books ($ 47) absolutely FREE!!!
Click on Sign Up Now to register.
