Commercial Property Due Diligence by the Numbers: Rent Roll Checks, Lease Expiry Profiles, Tenant Concentration, Arrears, Service Charges, Capex, Price Adjustments & a Dashboard
Work through 20 hands-on labs as the buyer's analyst for a fictional 14-unit business park – test the rent roll against the leases and a measured survey, size the reversion, WAULT and expiry cliffs, check tenant concentration, arrears and void costs, split service charges, price the capex backlog, normalise the NOI, turn the findings into a price adjustment and a red-flag score and finish with a due diligence dashboard – with every cell checked as you go.
- One-time payment
- Instant access right after payment
- Secure checkout with Stripe
About this course
In 20 hands-on spreadsheet labs you act as the buyer's analyst for a fictional 14-unit business park. You test the rent roll against the lease abstracts and a measured survey, compare passing with market rent and calculate the WAULT to expiry and to break with DAYS and SUMPRODUCT. You build the lease expiry profile, measure tenant concentration with SUMIFS, LARGE and RANK.EQ, value rent-free top-ups, age the arrears and price void costs and expiry risk. Later labs split service charges into recoverable and irrecoverable costs, apply lease caps, total the capex backlog, normalise the NOI, capitalise it into a revised bid and score the red flags on a final dashboard.
Why learn with Tabellab
- Practise in a real spreadsheetEvery lab runs in your browser and checks your cells instantly.
- Verifiable certificatePass the final exam and get a certificate with a public verification code.
- Try before you buyLesson 1 is free, with no sign-up or card needed.
- Who is behind TabellabBuilt by Babala Software in Füllinsdorf, Switzerland. Questions? hello@tabellab.com · Imprint
Lessons
- Halberd Business Park at a Glance: Is the Price Right?Free
- Rent Roll vs Leases: Finding the Mismatches Locked
- Floor Areas: Measured Survey vs Rent Roll Locked
- Passing Rent vs Market Rent: Reversion and Over-Renting Locked
- WAULT to Expiry: Weighted by Rent and by Area Locked
- WAULT to Break: When Tenants Can Leave First Locked
- Lease Expiry Profile by Year Locked
- Tenant Concentration: Share of Rent and Top Tenants Locked
- Rent-Free Periods Still Running: Vendor Top-Ups Locked
- Arrears Ageing: Who Owes What and for How Long Locked
- Rent Collection by Quarter: Is Payment Slowing? Locked
- Vacancy and Void Costs: What Empty Units Cost Locked
- Expiry Risk: Expected Costs of Leases Ending Soon Locked
- Service Charge: Recoverable vs Irrecoverable Costs Locked
- Service Charge Caps and the Owner's Shortfall Locked
- Capex Backlog from the Condition Survey Locked
- NOI Normalisation: From the Vendor's Figure to the Buyer's Locked
- Net Initial Yield, Purchaser's Costs and the Price Adjustment Locked
- Red-Flag Scoring: Turning Findings into a Risk Score Locked
- Final Project: The Due Diligence Dashboard Locked
Learner reviews
Be the first to review this course.