← chenzooModel Standards →

Interactive Excel Course · Self-Paced

Rialto Speedrun

Excel for the private-credit real-estate analyst — senior mortgages, bridge, mezz, and construction loans. You already know the finance. This makes you fast, efficient, and audit-proof in the spreadsheet: minimum time, maximum-quality, institution-grade output.

Start Module 1 →Jump to Capstone

The loop

  1. 1. Work the annotated Example workbook.
  2. 2. Build the Assignment (hero cells blanked).
  3. 3. Watch Self-Check grade you live (✓).
  4. 4. Confirm against the Answer Key.

Cell color convention

  • Blue = input / assumption
  • Black = formula / calculation
  • Green = link to another sheet
  • Red = warning / failed check

The Modules

Sequenced from keyboard speed to a full underwrite

  1. 00
    Cheat Sheetreference
    Workbook.xlsx
  2. 01
    Navigation Speed20–30 min
    Example workbook.xlsxAssignment workbook.xlsxAnswer key.xlsx
  3. 02
    Core Formulas30–40 min
    Example workbook.xlsxAssignment workbook.xlsxAnswer key.xlsx
  4. 03
    Financial Functions40–50 min
    Example workbook.xlsxAssignment workbook.xlsxAnswer key.xlsx
  5. 04
    Loan Cash-Flow Model60–75 min
    Example workbook.xlsxAssignment workbook.xlsxAnswer key.xlsx
  6. 05
    NOI & Debt Sizing45–60 min
    Example workbook.xlsxAssignment workbook.xlsxAnswer key.xlsx
  7. 06
    Sensitivity & Robustness60–75 min
    Example workbook.xlsxAssignment workbook.xlsxAnswer key.xlsx
  8. 07
    Capstone90–120 min
    Term sheet.mdAssignment workbook.xlsxAnswer key.xlsx

Every figure is an illustrative assumption — no market data is claimed. Commercial-mortgage interest accrues Actual/360; XIRR discounts Actual/365. Workbooks were validated by independent recomputation of every formula.