Property Management Math: Rent Rolls, Vacancy & CAM Reconciliation

What you'll build

What you will be able to do

Each lab ends with a concrete result that you build yourself and the checker confirms, cell by cell.

• Read the rent roll of Harbourline Commons: rent per square foot, occupied area, occupancy, average rent and the leases that end next year.
• Build the rent waterfall from gross potential rent to the rent actually collected and compare physical with economic vacancy.
• Build the lease expiry profile of the building – leases and rent ending each year – chart it, and calculate the weighted average lease term.
• Project the rent of a new office lease under three escalation clauses and compare what each brings in over five years.
• Reconcile the 2026 common area maintenance (CAM) charges: recoverable pool, each tenant's pro-rata share, and who owes or gets back how much.
• Age the open tenant invoices into buckets and estimate the bad-debt allowance the owner should book.
• Close the 2026 operating statement: effective gross income, operating expenses, NOI, and the variance of every line against budget.
• Compare two lease offers for the vacant suite O-202 by their cash flows, NPV and net effective rent per sq ft.