Tabellab

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.

20 lessons 20 labs Certificate

  • 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

  1. Halberd Business Park at a Glance: Is the Price Right?LabFree
  2. Rent Roll vs Leases: Finding the MismatchesLab Locked
  3. Floor Areas: Measured Survey vs Rent RollLab Locked
  4. Passing Rent vs Market Rent: Reversion and Over-RentingLab Locked
  5. WAULT to Expiry: Weighted by Rent and by AreaLab Locked
  6. WAULT to Break: When Tenants Can Leave FirstLab Locked
  7. Lease Expiry Profile by YearLab Locked
  8. Tenant Concentration: Share of Rent and Top TenantsLab Locked
  9. Rent-Free Periods Still Running: Vendor Top-UpsLab Locked
  10. Arrears Ageing: Who Owes What and for How LongLab Locked
  11. Rent Collection by Quarter: Is Payment Slowing?Lab Locked
  12. Vacancy and Void Costs: What Empty Units CostLab Locked
  13. Expiry Risk: Expected Costs of Leases Ending SoonLab Locked
  14. Service Charge: Recoverable vs Irrecoverable CostsLab Locked
  15. Service Charge Caps and the Owner's ShortfallLab Locked
  16. Capex Backlog from the Condition SurveyLab Locked
  17. NOI Normalisation: From the Vendor's Figure to the Buyer'sLab Locked
  18. Net Initial Yield, Purchaser's Costs and the Price AdjustmentLab Locked
  19. Red-Flag Scoring: Turning Findings into a Risk ScoreLab Locked
  20. Final Project: The Due Diligence DashboardLab Locked

Learner reviews

Be the first to review this course.

Write a review

Your rating

Reviews are checked before they appear. By submitting you confirm the images are yours and may be shown on this page. Privacy