| 25 |
Hrs
Mins
Secs
5
30
50
|
| SEGMENTS | DURATION |
In this class, commercial lender and investor Beckie Lambert shows you how to analyze a commercial real estate deal the way experienced lenders and investors do. You will learn why financial statements are the foundation of every investment decision, how income statements, balance sheets, rent rolls, and budget-versus-actual reports work together, and why timely, accurate bookkeeping matters for residential and commercial properties alike. Through hands-on practice problems built from real properties, you will calculate EBIDA and the debt service coverage ratio (DSCR), learn what separates a green-light deal from a yellow- or red-light one, and discover how to trustify a seller's numbers by checking expense ratios, property taxes, insurance, and loan terms against independent sources. Next, you will dissect a large multifamily syndication line by line to spot unrealistic rent growth, understated expenses, undisclosed fees, and the incentives behind them. You will learn to read a sources and uses table, calculate cash-on-cash return and breakeven occupancy, understand capital calls and dilution, and use market cap rates to estimate what a property should really sell for. The class closes with stress testing: modeling best, likely, and worst cases and testing interest rates, loan terms, rents, occupancy, and exit cap rates, so you know where a deal breaks before you commit capital and can underwrite with a true margin of safety.
Take this Pre-Assessment to see how much you already know on this topic.
Meet Beckie Lambert and explore the core parts of a financial statement, why a single year of numbers isn't enough, and the hidden risks of buying a seller's business instead of the real estate.
Understand how often you should produce financial statements, what really determines their accuracy, and how poor bookkeeping can affect a property's value, financing, and appeal to investors.
Explore software for building property financials, why passive investors should expect regular reporting, and a framework for pinpointing what is really causing a struggling property to lose money.
Learn what the debt service coverage ratio reveals about a property's ability to pay its loan, why real estate investors use EBIDA instead of EBITDA, and how lenders separate strong ratios from weak ones.
Walk through your first hands-on DSCR calculation using a sample financial statement, including which items to add back, how to match the debt period, and why lenders want a full year of financials.
Work two more practice financials to sharpen your DSCR skills, learn when depreciation belongs in the calculation, and consider what a borderline ratio means for whether a deal is worth pursuing.
Analyze a real property's financials with gross rents, rental loss, and amortization, and discover why the top-line rent figure can mislead buyers and how a smaller loan can flatter a DSCR.
The instructor shows you how to trustify a seller's financials by adding percentages, spotting expenses that look too low, and verifying taxes, insurance, and expense ratios with outside sources.
Rerun the same deal with corrected expenses to see how the picture changes, then explore why submarkets, reverse incentives, and the integrity of your partners matter as much as the math.
Review a smaller apartment property's simplified financials and learn what subsidized rent, unusually high utilities, and existing lease terms should prompt you to investigate before you invest.
Move from math to decision-making as you explore the questions to ask before buying into an existing project, including why partners need capital and how commercial loan maturities work.
Begin dissecting a large multifamily syndication, compare historical results with the general partners' projections, and see why replacement reserves and shrinking debt payments deserve a closer look.
Uncover an expense missing from the projections, understand how the way general partners are paid shapes their incentives, and judge whether projected tax, rent, and insurance changes are realistic.
Use expense percentages and a six-year projection to test the general partners' assumptions, and learn which patterns in rents, advertising, and turnover costs signal overly optimistic numbers.
Learn to read a sources and uses table, understand what loan-to-value and acquisition fees reveal about a deal, and see how cash-on-cash return shows what investors may actually earn.
Tally the ways general partners can get paid on a syndication, then learn how breakeven occupancy measures downside risk and what happens when a partner won't answer a capital call.
Review key principles for trustifying a deal, including market expense ratios, asset types and classes, and why every investment needs two exit strategies, plus a refresher on EBIDA and DSCR.
Learn how to stress test a deal under best, likely, and worst-case scenarios, and see why financials tell only half the story until you tour the property and study its competition.
Understand what a capitalization rate measures, how to find the market cap rate for a property, and how rearranging the formula shows whether you're overpaying or paying a fair price.
Apply cap rates to the syndication's projected sale, compare its assumptions with current market conditions, and finish tallying what the general partners stand to earn versus the investors.
Explore the major variables worth stress testing, then walk through an interest rate sensitivity spreadsheet that shows when a deal's debt coverage and cash flow slip into the danger zone.
Understand how amortization, interest-only periods, loan maturity timing, and prepayment penalties can reshape a deal, and why refinancing during a remodel or lease-up can create unexpected risk.
Walk through rent and exit cap rate stress tests, learn the red flags that signal a thin margin of safety, and adopt a conservative underwriting mindset that protects your capital and investors.
Take this quiz to see how much you have learned about this topic.
Take this quiz to see how much you have learned about this topic.