Rental Service Charges & Utility Billing: Allocation Keys, Prepayments & Year-End Statements
Share a fictional apartment building's running costs among its tenants: the recoverable cost pool, floor-area and occupant keys, a fixed/variable heating split, water submeters, tenant changes and vacancy, prepayments and refunds, and a complete year-end statement with a chart, with every cell checked as you go.
One-time payment · lifetime access · lessons, labs, exam and certificate included · no subscription.
About this course
In this course you prepare the yearly service charge and utility statements for a fictional eight-apartment rental building in spreadsheet labs. You separate recoverable from non-recoverable costs, share costs by floor area, blend an area and an occupant key for a single water bill, split heating into a fixed part by area and a variable part by meter units, and charge metered water plus the unmetered remainder. You prorate a tenant change by days with a vacancy for the landlord and weighted winter heating, compare prepayments with actual charges, set a new monthly prepayment with ROUNDUP, and finish with a complete statement and a pie chart.
Lessons
- The Cost Pool: Recoverable vs Non-Recoverable Building Costs Pro
- Allocation by Floor Area: Shares That Add Up to 100 % Pro
- Ratio Billing without Meters: Floor Area, Occupants & Per-Apartment Keys Pro
- Heating Costs: A Fixed Part by Floor Area, a Variable Part by Meter Units Pro
- A Tenant Moves Out: Prorating by Days, Vacancy & Weighted Heating Pro
- Water Submeters: Readings, Price per m³ & the Unmetered Remainder Pro
- Prepayments vs Actual Charges: Balance Due, Refunds & the New Monthly Amount Pro
- Capstone: One Tenant's Year-End Statement with a Chart Pro