Vacancy Loss and Occupancy Rate
Lessons in this course
- 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