Test the numbers behind a holiday rental

Holiday letting projections are sensitive to small changes in occupancy, price and costs. This calculator brings those assumptions into one annual operating illustration. It shows booked nights, accommodation income, commission and management costs, operating surplus and cash flow after entered debt payments. It does not predict demand or confirm that a property may lawfully be offered to guests.

Start with the actual nights you are willing and able to let. Personal stays, maintenance closures and other unavailable periods belong outside that availability figure. Occupancy is then applied only to the nights entered as available. This avoids treating a property used privately for several months as though every night of the year were on sale.

Build a consistent set of inputs

• Available nights: whole nights offered for letting within the year being modelled.
• Occupancy: the proportion of those available nights expected to be booked.
• Average nightly income: accommodation revenue per booked night on a consistent basis.
• Combined commission and management percentage: the share of that revenue allowed for these costs.
• Other cost per booked night: a separate allowance for variable operating expenditure.
• Annual fixed operating costs: costs not already included in the percentage or nightly allowance.
• Annual debt payments: the full cash payments entered for the borrowing scenario.

The calculator accepts up to 366 available nights so that a leap-year scenario can be modelled. For a year with 365 nights, use that actual limit and subtract unavailable periods. Expected booked nights may include a decimal because the model is an annual average rather than an actual booking diary.

Worked example

With 300 available nights and 60% occupancy, expected bookings total 180 nights. At €140 per booked night, gross accommodation income is €25,200. A 20% combined commission and management allowance costs €5,040. A further €20 per booked night adds €3,600 of variable operating costs. Neither amount should also appear in the fixed-cost input.

After €5,000 of fixed operating costs, the operating surplus is €11,560 before finance and tax. Deducting €8,000 of annual debt payments leaves €3,560 before tax. This is an operating cash-flow illustration. It does not show a return on the purchase price, and it does not include acquisition costs, income tax or replacement spending unless expressly entered in an appropriate cost field.

Understand the break-even result

The contribution per booked night equals nightly income after the percentage cost, minus the other variable cost per night. In the example, €140 less 20% leaves €112. Deducting the €20 variable allowance leaves €92 per booked night to cover fixed costs and debt. Combined fixed costs and debt of €13,000 therefore require approximately 141.3 booked nights.

Against 300 available nights, that is approximately 47.1% occupancy. A break-even result above 100% means the selected price, costs and availability cannot cover the entered fixed costs and debt within the available year. If the nightly contribution is zero or negative, the tool reports that no positive contribution exists; it does not divide by zero or present an impossible occupancy target as achievable.

Commission and cost bases need checking

Management quotations do not always cover the same services. A percentage might exclude cleaning, laundry, call-outs, platform charges or tax on the management service itself. Ask for an itemised explanation, then combine the amounts consistently. This worksheet applies its percentage to the accommodation revenue input; it does not reproduce every platform’s contractual fee base.

If cleaning is charged per stay, estimate the likely number of stays and annual cleaning cost separately before converting it to a per-night allowance. Longer stays and shorter stays can have the same booked-night total but very different turnover costs. Do not assume a single average captures that difference unless the underlying booking pattern supports it.

Separate seasonal evidence from annual averages

An annual nightly average should reflect the likely mix of booked periods rather than the highest advertised summer price. Keep the source and period of any comparison. An asking rate on a platform does not establish the rate actually received, occupancy achieved or cancellation pattern. Discounts, refunds and uncollectible amounts can all affect realised income.

Make at least three scenarios using clearly stated assumptions: a cautious case, a central case and a stronger-demand case. These are planning scenarios, not probabilities. Change one assumption at a time when trying to understand its effect, then combine the changes for a more demanding stress case. The investment projections guide helps organise the evidence behind those choices.

Permission comes before projected income

Before relying on letting income in a purchase decision, investigate the applicable municipal, regional, community and national requirements for the particular use and property. This calculator does not check a register, inspect an agreement or confirm compliance. The holiday rental guide provides a starting point for organising those separate questions.

A spreadsheet can remain profitable even when a proposed use cannot proceed. Keep the evidence about intended letting use alongside the income assumptions, with unresolved conditions visible. If operating arrangements are still uncertain, run a scenario with no letting income and consider whether the household could hold the property while those matters are investigated.

Debt, repairs and personal use

The annual debt field is a cash-flow deduction. It does not distinguish interest from capital for a tax computation. Enter the payments expected under the chosen borrowing scenario and keep tax treatment separate. If the rate or repayment schedule changes during the year, calculate an appropriate annual payment total before entering it here.

Major furniture replacement, a large repair or an assessment from the community can exceed an ordinary annual allowance. Run a separate case including that spending and consider the reserve needed before letting starts. Personal use also has a cost: removing peak-demand nights may affect annual income more than removing the same number of low-demand nights, which this single-average model cannot capture.

Read the result alongside the full investment

A positive annual cash figure does not establish an attractive overall return. Purchase taxes, furnishing, setup expenditure, future repairs and disposal costs belong in the wider investment assessment. Use the rental yield calculator to compare entered income with an acquisition cost, keeping its different assumptions clear.

Before appointing a manager, agree who handles pricing, maintenance approvals, guest communication, reports and payments. Ask how collected money and expenses will be reconciled. Compare the actual monthly statements with the assumptions in this model. Investigate differences in booked nights, achieved rates and individual costs rather than merely replacing the original forecast with the year-end total.

Use the calculator with a clear record

Write down the inputs, the date of the exercise and the decision you are trying to inform. Mark provisional figures as provisional. If you compare two scenarios, keep the unchanged inputs visible and explain the assumption that changed. This makes the output easier to discuss with another owner, a lender or an adviser without losing the basis of the calculation.

The form runs in your browser. The supplied calculator does not send the entered figures to a server or add them to the website’s analytics events. Results appear after selecting Calculate estimate. Browser extensions and other software are outside this implementation. A text or lightweight agent view provides the guidance and worked examples but does not run the interactive form.

Practical questions

Are these current market figures? No. The default numbers are illustrations. Replace them with your own clearly sourced amounts. The tool does not look up interest rates, property values, exchange rates or quotations.

Can I use the answer as an approved budget? Treat it as a scenario. The relevant lender, professional or contracting party must confirm matters within their responsibility. A mathematically correct result does not establish eligibility, permission or the completeness of the inputs.

What if a field does not fit my case? Keep a separate calculation for a more complex case. Do not put an unexplained adjustment into another field merely to reach a preferred total. An explicit exclusion is easier to review than a result whose inputs conceal different assumptions.