Property Management Math: Rent Rolls, Vacancy & CAM Reconciliation
Run the numbers of a mixed-use building like a property manager: rent roll, vacancy and loss to lease, lease expiries, escalations, CAM reconciliation, arrears, budget vs actual NOI and net effective rent, with every cell checked as you go.
The first lesson is free — no account needed.
About this course
A property management course that runs one fictional mixed-use building's numbers in a spreadsheet, for property managers, asset managers and real estate students. You read the rent roll for rent per square foot, occupancy and next year's expiries, build the rent waterfall from gross potential rent to rent collected and compare physical with economic vacancy and loss to lease, chart the lease expiry profile and calculate the weighted average lease term, project a new office lease under fixed-percentage, CPI-linked and stepped escalations, reconcile the year's CAM charges with each tenant's pro-rata share, age tenant arrears and estimate the bad-debt allowance, close the operating statement with NOI and budget variances and compare two offers for a vacant suite by NPV and net effective rent per square foot after tenant improvements and leasing commissions. The first lab is free.
Lessons
- The Rent Roll: Area, Rent per Sq Ft & OccupancyFree
- Physical vs Economic Vacancy & Loss to Lease Pro
- Lease Expiry Schedule by Year & WALT Pro
- Rent Escalations: Fixed %, CPI-linked & Fixed Steps Pro
- CAM Pro-rata Shares & Year-end Reconciliation Pro
- Arrears Ageing & Bad-Debt Allowance Pro
- Operating Budget vs Actual: NOI & Variances Pro
- TI, Leasing Commissions & Net Effective Rent Pro