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.
- 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
- Rent Roll: Due, Paid, Balance and a Late FlagFree
- Late Fees: Grace Period, Percentage and a Cap Locked
- Expense Log: Totals by Category and Property with SUMIF Locked
- Maintenance Reserve: Saving for Roofs, Water Heaters and Floors Locked
- Vacancy Loss and Occupancy Rate Locked
- Mortgage Payment: PMT, and the Interest/Principal Split with IPMT and PPMT Locked
- Monthly Cash Flow per Unit Locked
- Cap Rate and Cash-on-Cash Return Locked
- Rent Increase Scenarios: Three Rates, Capped at Market Rent Locked
- Security Deposit Tracker: Refunds and Return Deadlines Locked
- Year-End Summary per Property with SUMIFS Locked
- Landlord Dashboard: Monthly Cash Flow with a Chart and Colour Scale Locked
- Tenant Ledger: Charges, Payments and a Running Balance Locked
- Lease Expiry Calendar: End Dates with EDATE, Notice Deadlines and Days Left Locked
- Maintenance Requests: Days to Fix, Averages by Category and Open Jobs Locked
- Turnover Cost: Vacant Days, Make-Ready Costs and Whether a Rent Increase Pays Locked
- Rent Comparables: Rent per Square Foot, the Median and a Suggested Rent Locked
- Renovation Budget: Quotes, Contingency, Actual Costs and Payback from Higher Rent Locked
- Next Year's Budget: Rent Increases from the Renewal Month, Expense Changes and the Net Result Locked
- Final Project: The Annual Property Review – NOI, Debt Coverage, Cash-on-Cash and a Watch List Locked
Learner reviews
Be the first to review this course.