Tabellab

Excel for Small Landlords: Rent Roll, Expenses, Cash Flow & Returns

20 hands-on labs for owners of a few rental units: rent roll with late flags, late fees, expense log, maintenance reserve, vacancy, mortgage split, cash flow per unit, cap rate, rent increases, deposits, year-end summary and a dashboard – plus a tenant ledger, a lease expiry calendar, a repair log, turnover costs, rent comparables, a renovation budget, next year's budget and an annual property review.

20 lessons 20 labs Certificate

  • One-time payment
  • Instant access right after payment
  • Secure checkout with Stripe

About this course

This course gives owners of a few rental units the spreadsheets they actually need, in 20 hands-on labs with a fictional landlord and four units. You set up a rent roll with late flags, calculate capped late fees, sum an expense log with SUMIF, plan a maintenance reserve, measure vacancy and occupancy, split mortgage payments with PMT, IPMT and PPMT, build cash flow per unit, compare cap rate and cash-on-cash, test rent increases, track deposits and prepare a year-end summary and a dashboard. The second half adds a tenant ledger with a running balance, a lease expiry calendar with EDATE, a repair log with AVERAGEIFS, the true cost of a turnover, rent comparables per square foot, a renovation budget with payback, next year's budget and an annual property review with DSCR. Examples only, not legal or tax advice.

Lessons

  1. Rent Roll: Due, Paid, Balance and a Late FlagLabFree
  2. Late Fees: Grace Period, Percentage and a CapLab Locked
  3. Expense Log: Totals by Category and Property with SUMIFLab Locked
  4. Maintenance Reserve: Saving for Roofs, Water Heaters and FloorsLab Locked
  5. Vacancy Loss and Occupancy RateLab Locked
  6. Mortgage Payment: PMT, and the Interest/Principal Split with IPMT and PPMTLab Locked
  7. Monthly Cash Flow per UnitLab Locked
  8. Cap Rate and Cash-on-Cash ReturnLab Locked
  9. Rent Increase Scenarios: Three Rates, Capped at Market RentLab Locked
  10. Security Deposit Tracker: Refunds and Return DeadlinesLab Locked
  11. Year-End Summary per Property with SUMIFSLab Locked
  12. Landlord Dashboard: Monthly Cash Flow with a Chart and Colour ScaleLab Locked
  13. Tenant Ledger: Charges, Payments and a Running BalanceLab Locked
  14. Lease Expiry Calendar: End Dates with EDATE, Notice Deadlines and Days LeftLab Locked
  15. Maintenance Requests: Days to Fix, Averages by Category and Open JobsLab Locked
  16. Turnover Cost: Vacant Days, Make-Ready Costs and Whether a Rent Increase PaysLab Locked
  17. Rent Comparables: Rent per Square Foot, the Median and a Suggested RentLab Locked
  18. Renovation Budget: Quotes, Contingency, Actual Costs and Payback from Higher RentLab Locked
  19. Next Year's Budget: Rent Increases from the Renewal Month, Expense Changes and the Net ResultLab Locked
  20. Final Project: The Annual Property Review – NOI, Debt Coverage, Cash-on-Cash and a Watch ListLab 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