Branded Residence Rental Pool Distribution Model: Condo-hotel rental pool distribution, owner statements and yield

Full description

For residence managers, asset managers, financial controllers and owners' committees of condo-hotels and branded residences with a rental pool. You enter the pool agreement terms (distribution costs, operator fee, cost per rented night, fixed pool costs, reserve contribution), the owner-borne costs (service charge per square metre, insurance, property tax, cleaning of owner stays) and, for each unit and month, owner use days, maintenance days, nights rented and room revenue. The workbook builds the monthly pool statement down to net pool income, gives every unit participation points (size x view factor x days available to the pool) and shares the net pool income by points. Owner-borne costs come off unit by unit, monthly advances are paid on account and a year-end true-up settles the balance. The same pool is also split by revenue earned so owners and the committee can see who gains from the points method. Each owner's net payout is shown as a yield on purchase price, with a ranking, a yield distribution and a printable statement for any unit.

Save with a bundle: this workbook is also in the Hotel Finance & Investment Pro Bundle, 25 workbooks for $59 instead of $329. All 100 Pro workbooks are in the Pro Library for $119, and all 241 templates and workbooks are in the Ultimate Hospitality Library for $149.

What is inside

• Branded_Residence_Rental_Pool_Model.xlsx: 12 tabs, 11,478 formulas, 2 native charts, 13 drop-down and input rules, 14 integrity checks, a Method tab with 15 calculation notes.
• Units: 40 sample units in 4 types and 3 view categories, with 10 spare rows.
• Unit_Nights: 600 unit-month rows with availability, nights, revenue, occupancy, rate, points and flags.
• Pool_PnL: monthly pool statement, sharing lines, reserve fund roll-forward and a 5 x 5 yield grid by ADR change and operator fee.
• Distribution engine: seven visible steps per unit and month, from points to advance paid.
• Owner_Statement: one-page monthly statement for any unit with year-end settlement and yield.
• Owner_Summary and Reconciliation: year totals, points vs revenue earned, true-ups, ranking, yield bands and 11 tie-out lines.
• Dashboard: 11 KPI tiles, a check tile, a payout ranking chart for all units, a yield distribution chart and the top and bottom five units.
• README.txt and LICENSE-and-Terms.txt.

How it works

1. Enter the rental pool agreement terms, owner-borne cost rates, the monthly advance % and view factors.
2. List units with size, view, type and purchase price.
3. Enter owner use, maintenance, nights rented and room revenue for each unit and month.
4. Read the pool statement, owner payouts, yields and the method comparison; print owner statements.
5. At year end, check the reconciliation, settle true-ups and confirm the Checks tab shows ALL OK.

Details

• Format: one .xlsx workbook, English.
• Software: Excel 2016 or later, or LibreOffice Calc 7 or later.
• No macros, no data tables, no array formulas, no add-ins.
• 12 months, up to 50 units, any currency.
• Delivery: instant download.

Good to know

• Sample data is illustrative and does not describe any property or market. Replace it with your own figures.
• Not legal, tax or investment advice. Follow your rental pool agreement and verify local requirements for taxes and owner charges.
• Owners appear as codes (Owner 01, Owner 02). Keep the owner register in a separate, protected file.
• Single-user license.

FAQ

How are participation points calculated?

Points per day = unit size in square metres x a view factor you set. Monthly points = points per day x days the unit was available to the pool, so owner use and maintenance days reduce a unit's share.

Why compare points with revenue earned?

Points share the pool by what each owner contributes in space and time; revenue earned rewards the units that happened to sell. The comparison shows which owners gain or lose under the points method and flags large differences.

Can owners end the year owing money?

Yes. If monthly advances exceed the year's net payout, the true-up is negative and the Reconciliation tab lists the amount to recover.

Can I change the pool agreement terms?

Yes. Distribution costs, operator fee, cost per rented night, fixed costs, reserve %, owner-borne costs and the advance % are all inputs.

How many units does it hold?

50 unit slots. The sample uses 40; add units in the spare rows of Units and enter their months on Unit_Nights.