Tabellab
Intermediate

Real Estate Investment Analysis

Analyse a 12-unit apartment building from NOI to IRR, plus rent vs buy, with every formula checked on a live spreadsheet. Educational only, not investment advice.

7 lessons 7 labs 1.7 h Certificate

The first lesson is free — no account needed.

About this course

Real estate investment analysis in Excel, worked through on one 12-unit apartment building. You calculate NOI and the cap rate, a mortgage and amortisation, cash flow and cash-on-cash return, DSCR and the maximum loan, build a rental property pro forma, measure IRR and the equity multiple over a 5-year hold, and compare renting with buying. The course is educational and is not investment advice.

Lessons

  1. NOI & cap rateLab14 minFree
  2. Mortgage & amortisationLab14 min Pro
  3. Cash flow & cash-on-cash returnLab14 min Pro
  4. DSCR & maximum loanLab14 min Pro
  5. Rental property pro formaLab15 min Pro
  6. 5-year hold: IRR & equity multipleLab16 min Pro
  7. Rent vs buyLab15 min Pro