
Understand underwriting a real estate deal by analyzing historical and current performance to determine if a potential acquisition meets investors' return expectations, using the trailing 12 months and rent rule.
Analyze the offering memorandum walk-through for a multifamily asset, highlighting the table of contents, investment highlights, and property overview. See how unit mix, amenities, and rent details inform valuation.
Use a quick analysis to weed out unsuitable multifamily deals, applying the direct cap method to estimate value from net operating income and a market capitalization rate.
Determine the discount rate, or hurdle rate, as the minimum required return using the weighted average cost of capital, including debt and equity costs.
Build a ten-year discounted cash flow forecast for a multifamily investment, projecting revenue, expenses, capex, and unlevered cash flows on an annual basis to estimate value.
Set growth assumptions and build a dynamic model to project pro forma cash flows and then compute IRR, equity multiple, and net present value for multifamily investments.
Explain real versus nominal returns and how inflation affects long-term multifamily real estate investments, noting that nominal quotes may overstate gains.
Apply time value of money to real estate underwriting by comparing present values of cash flows, using a simple example: today's $100 vs future $110 at 8%.
Explore a simple partnership waterfall model detailing gp and lp splits, promoter structure, and levered cash flows to determine net returns and irrs.
Welcome to the Multifamily Real Estate Underwriting mastery course. If you are new to real estate investment underwriting and would like to develop working knowledge and skills so that you can quickly begin underwriting properties, then you are in the right place. This course is going to focus on steps of the underwriting process beginning with receiving an offering memorandum, T-12, and rent foll all the way up to the point of deciding whether to send an LOI to a seller. While I will provide you with some useful Excel formulas, the focus of this course is going to be on understanding of both conceptual and applied underwriting for multifamily versus “building Excel models from scratch.” For those of you more adept with using Microsoft Excel, you can deconstruct the completed model in the final lesson and create your own from scratch using concepts taught in this course.
You will find the format of this course consists of both video and written text lectures that have many downloadable files you can use for practice.
This course is divided into the following lessons:
· Lesson 1: Overview and Valuation Basics
· Lesson 2: Deal Underwriting: Quick Analysis
· Lesson 3: DCF (Income Approach)
· Lesson 4: Real Estate Debt
· Lesson 5: Partnership Cash Flows