Real Estate & REIT Modeling – Brian DeChesare

This is advanced training, designed for both new and experienced professionals. The Real Estate and REIT Modeling course is perfect for you if:

• You already know the fundamentals of accounting, valuation, and financial modeling, and now you’re ready to drill down into the details and gain the the know-how that sets you apart as an industry expert –with an in-depth understanding of how the real estate industry works.
• You’re interviewing with Real Estate groups – at banks, PE firms, hedge funds, real estate operating companies, real estate developers, REITs, or other real estate-related firms, and you want to impress your prospective employer by being the exact candidate they are looking for.
• You’re about to start working in a Real Estate group, or you’ve just transferred into one and you need to get up to speed quickly. You’d rather learn on your own time, so that you can impress on the job and move up the ladder quickly.
• You’re an experienced real estate professional and you’re now transitioning into investment banking, private equity, or other related roles.

When you interview for these roles at investment banks, there are certain questions you’ll always be asked…

• How much do you know about accounting? Do you know how it’s different for real estate? You’ll able to tell them just how much you know and answer an emphatic and sincere: “YES.”
• Can you walk me through how you would value a property, a portfolio of properties, or an entire REIT? You’ll know exactly how to demonstrate what they want to see – because you will have already practiced all of those in the course.
• What are the key factors that impact a REIT’s valuation and financial performance? You’ll be able to describe them with ease and understanding.
• “How would you describe your financial modeling skills?” Your hands-on experience will shine through – you’ll be able to confidently recount the skills you’ve learned in the course, because those are the exact skills they’re looking for.Your confident answers to these questions along with the evidence you’ll present of the case study you completed will set you apart from everyone else in the interview room and put you in prime position to land lucrative internships and jobs at investment banks, private equity firms, and hedge funds.We’ve designed the course from the ground up to help you gain functional mastery of this highly-specialized material as quickly as humanly possible.With BIWS Real Estate and REIT Modeling you’ll learn by practicing with a case study of a REIT operating model and valuation for Avalon Bay Communities, and case studies on property development and renovation. We use real SEC filings and equity research from banks like Citi and JP Morgan to support the numbers:
• Detailed 3-statement model for Avalon Bay with support for all their different real estate segments; full valuation, including the usual methodologies as well as real estate-specific ones such as the Net Asset Value (NAV) model.
• Real Estate Development Lessons cover property development and acquisitions, key real estate terminology and metrics, and how to set up the construction timeline and funding sources, and analyze acquisitions and renovations.

• 113 videos total (45 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 and 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 promotions .
• 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 Funds From Operations (FFO), Adjusted Funds From Operations (AFFO), and dividends issued.
• REIT Valuation lessons cover public comps, precedent transactions, 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.The information is so detailed and thorough that most of our customers are from top-ranked universities, investment banks, and business schools.Once you’ve completed the training, here’s what you can immediately add to your resume or CV:Real Estate & REIT Modeling (Breaking Into Wall Street)
  Online Financial Modeling Training Program
• Completed real estate development model for office complex, with waterfall returns modeled for multiple equity investor classes and different developer promote levels
• Built model for hotel renovation and created sensitivity tables to determine optimal level of renovation funding relative to potential upside in IRR
• Created 3-statement projection model over 5 years for Avalon Bay [AVB], leading residential REIT; based model on segment-by-segment buildup for same-store, development/redevelopment, acquisitions, and dispositions
• Valued Avalon Bay [AVB] using public comps and precedent transactions and metrics and multiples such as FFO and AFFO, as well as Net Asset Value (NAV) model; also completed Levered DCF and Dividend Discount Model, and learned concept behind Replacement Value methodologyYou can print out your models from this course and demonstrate your working knowledge during interviews, describing exactly what you learned in the training.Doing this will impress bankers, who will immediately understand that you possess real working knowledge that comes from experience working with real companies and case studies.