Introduction
  • What We Will Cover
  • How To Take This Course
  • About The Instructor & This Course
  • DOWNLOAD ME FIRST!
  • Disclaimer
Advanced Excel Formulas & Functions
  • Advanced Formulas & Functions - Overview
  • Naming Cells
  • Naming Cells Exercise & Solution
  • Dynamic INDEX(MATCH())
  • Dynamic INDEX(MATCH()) Exercise & Solution
  • IF(ISNUMBER(SEARCH()))
  • IF(ISNUMBER(SEARCH())) Exercise & Solution
  • &
  • & Exercise & Solution
  • Partial COUNTIF
  • Partial COUNTIF Exercise & Solution
  • YEARFRAC
  • YEARFRAC Exercise & Solution
  • Sort & Filters
  • Sort & Filters Exercise & Solution
  • Dynamically Return Unique Values
  • Consolidated Unit Mix Exercise - Part 1
  • Consolidated Unit Mix Exercise - Part 2
  • Consolidated Unit Mix Exercise - Part 3
  • MOD(ROW())
  • MOD(ROW()) Exercise & Solution
  • TRANSPOSE & Array Functions
  • TRANSPOSE & Array Functions Exercise & Solution
Advanced Real Estate Deal Analysis
  • Advanced Deal Analysis Introduction
  • Break-Even Occupancy
  • Break-Even Occupancy Exercise & Solution
  • Break-Even Occupancy - AVERAGE & MAX
  • Dual-Metric Data Tables
  • Dual-Metric Data Tables Exercise & Solution
  • Best-Base-Weak Case Scenario Analysis
  • Best-Base-Weak Case Scenario Analysis Exercise & Solution
  • Dynamic Next Buyer Analysis
  • Next Buyer Analysis - Implied Cap Rate & Purchase Price
  • Next Buyer Analysis - Purchase Price & Closing Costs
  • Next Buyer Analysis - Cash Flow Before Debt Service
  • Next Buyer Analysis - Sale Proceeds, Costs of Sale, & Net Unlevered Cash Flows
  • Next Buyer Analysis - Dynamic Unlevered IRR Using OFFSET
  • Next Buyer Analysis - Unlevered Equity Multiple
  • IRR Partitioning
  • IRR Partitioning Exercise - CF Net of Sale Proceeds
  • IRR Partitioning Exercise - Sale Proceeds
  • IRR Partitioning Exercise - Partitioning The IRR
  • Hold-Sell Analysis
  • Hold-Sell Analysis Exercise - Reversion Year CF
  • Hold-Sell Analysis Exercise - Unlevered CF & IRR
  • Hold-Sell Analysis Exercise - Levered Reversion Year CF
  • Hold-Sell Analysis Exercise - Levered CF & IRR
  • Hold-Sell Analysis Exercise - Dynamic Optimal Sale Year
Advanced Revenue & Expense Modeling
  • Advanced Revenue & Expense Modeling - Introduction
  • Lease-Up Modeling
  • Lease-Up Modeling Exercise - GPR
  • Lease-Up Modeling Exercise - % of Lease-Up Complete
  • Lease-Up Modeling Exercise - Dynamic General Vacancy
  • Lease-Up Modeling Exercise - Operating Expenses
  • Lease-Up Modeling Exercise - Capital Reserves
  • Renovation Premium Modeling
  • Renovation Premium Modeling - % of Renovation Complete
  • Renovation Premium Modeling - GPR
  • Renovation Premium Modeling - Varying Vacancy Rates
  • Renovation Premium Modeling - Straight-Line Renovation Costs
  • Commercial Lease Roll-Over Modeling
  • Commercial Lease Roll-Over Modeling - In-Place Lease Rent
  • Commercial Lease Roll-Over Modeling - New & Renewal Lease Rent
  • Commercial Lease Roll-Over Modeling - Tenant Improvement Allowances
  • Commercial Lease Roll-Over Modeling - Leasing Commissions
  • Varied Annual Growth Rates
  • Varied Annual Growth Rates Exercise - Market Rent Growth
  • Varied Annual Growth Rates Exercise - Vacancy
Advanced Cash Flow Modeling
  • Advanced Cash Flow Modeling Introduction
  • Annual & Quarterly CF Roll-Up
  • Annual CF Roll-Up Exercise - Part 1
  • Annual CF Roll-Up Exercise - Part 2
  • Quarterly CF Roll-Up Exercise
  • Working Capital Accounts
  • Working Capital Exercise - Initial Contributions
  • Working Capital Exercise - Balance & Distributions
  • Fixed & Variable Expense Modeling
  • Fixed & Variable Expense Modeling Exercise - Introduction
  • Fixed & Variable Expense Modeling Exercise - Expense Build-Out
  • Property Tax Reversion Resets
  • Property Tax Reversion Resets Exercise - Year 1
  • Property Tax Reversion Resets Exercise - Years 2-11
Advanced Debt & Equity Modeling
  • Advanced Debt & Equity Modeling - Introduction
  • Floating-Rate Debt
  • Floating-Rate Debt - Transposing Index Rates
  • Floating-Rate Debt - Loan Payments
  • Refinance Modeling
  • Refinance Modeling Exercise - Acquisition Loan Month 0
  • Refinance Modeling Exercise - Acquisition Loan Payments & Payoff