Course curriculum

    1. Welcome & What We Will Cover

    2. Who This Course Is For

    3. About The Instructor & Student Success Stories

    4. Download Me First!

    1. The Property Cash Flow Statement Overview

    2. Effective Gross Revenue - Part 1

    3. Effective Gross Revenue - Part 2

    4. Operating Expenses

    5. Net Operating Income (NOI)

    6. Capital Expenses

    7. Debt Service

    8. Purchase, Sale, & Financing Metrics

    9. Unlevered & Levered Cash Flow

    10. A Note About Income Taxes

    1. Setting Expectations

    2. Real Estate Financial Modeling 101 & Dynamic Modeling

    3. Absolute & Mixed References

    4. Custom Formatting

    5. Drop-Down Lists

    6. Real Estate Financial Modeling Color Codes

    7. Gridlines & The "Steak Sauce" Cell

    1. Navigating Worksheets & Workbooks

    2. Controlling Columns & Rows

    3. Text Formatting

    4. Font Style

    5. Borders

    6. Alignment

    7. Excel Function Shortcuts

    8. Copy, Paste, & Paste Special

    1. IF Statements

    2. AND & OR

    3. SUMIF & SUMIFS

    4. COUNTIF & COUNTIFS

    5. AVERAGEIF & AVERAGEIFS

    6. VLOOKUP & HLOOKUP

    7. INDEX & MATCH

    8. Weighted Averages (Using SUMPRODUCT)

    9. CAGR (Using RATE)

    10. ROUND, ROUNDUP, & ROUNDDOWN

    11. DATEDIF

    12. YEARFRAC & EOMONTH

    13. PV

    14. FV

    15. NPER

    16. RATE

    17. PMT

    1. GPR, Vacancy, & Credit Loss

    2. Percentage Rent

    3. The Pro Rata Share

    4. NNN Reimbursements

    5. FSG Reimbursements

    6. MG Reimbursements

    7. BYS Reimbursements

    8. The Operating Expense Ratio

    9. Renewal Probability Modeling

    10. Cash Flow Modeling With Renewal Probability

    11. Leasing Commissions

    12. Tenant Improvement (TI) Allowances

About this course

  • Free
  • 111 lessons
  • 9.5 hours of video content

Discover your potential, starting today

Enroll today