How to Calculate Cash Flow for a Rental Cottage

Which tool should you start with?

The best starting point is a combination: a revenue calculator to build an operating scenario, followed by a spreadsheet to calculate net cash flow. The MonsieurChalets rental profitability calculator, available in French, lets you test the average nightly rate and the number of booked nights.

That result is not your profit. It is an initial rental revenue projection. Check whether the amount displayed includes any management fees, then add the remaining expenses, financing costs, and required reserves to build a realistic picture without counting the same cost twice.

A tool is only useful if its assumptions are visible. If you do not know the occupancy rate, nightly rate, or expenses behind the result, you cannot compare two cottages properly.

Step 1: establish realistic gross revenue

Annual gross revenue is a simple calculation: average nightly rate multiplied by booked nights. Build three scenarios rather than relying on the most optimistic figure.

1. Conservative: weaker demand, a longer low season, and several unbooked weekends.
2. Base case: assumptions supported by comparable properties and your marketing strategy.
3. Favourable: stronger demand, a well-booked calendar, and a higher average nightly rate.

In your spreadsheet, separate available nights, booked nights, and nights reserved for personal use. A cottage theoretically available 365 nights a year is not necessarily rentable for all 365: maintenance, repairs, blocked dates, and seasonal limitations reduce actual capacity.

Break down the average nightly rate by season as well. A single annual average can hide a heavy reliance on summer holidays, skiing, or the holiday season. Include at least four periods: peak season, shoulder seasons, low season, and special dates.

Step 2: include actual operating expenses

Your net cash flow needs to account for every cost required to operate the cottage, even when it does not arise every month. A credible estimate includes at least:

• cleaning and preparation between stays;
• routine maintenance and repairs;
• snow removal, lawn care, and outdoor maintenance;
• electricity, heating, internet, and water;
• insurance suited to tourist accommodation;
• municipal and school taxes;
• supplies, linens, and replacement items;
• maintenance of the hot tub, sauna, fireplace, or water sports equipment;
• management, booking, and marketing fees;
• accounting, software, and banking fees;
• a reserve for major expenditures.

Keep variable and fixed expenses separate. Cleaning costs increase with the number of stays. Municipal taxes change little with occupancy. This distinction lets you see what happens if revenue falls by 10% or the number of bookings increases.

A reserve is not an imaginary cost. A roof, septic system, appliance, or hot tub will eventually need replacement. If you set nothing aside, your model looks better until a single bill wipes out several months of cash flow.

To review the broader relationship between revenue, amenities, and management, see the guide to making a rental cottage profitable in Quebec. This model goes further into monthly cash flow and borrowing capacity.

Step 3: calculate debt service

Show the mortgage payment separately from other expenses. Split annual payments into principal and interest if your lender provides that information. Principal reduces the loan balance, but it still leaves your bank account each month.

Include the following in your model:

• purchase price;
• down payment;
• amount borrowed;
• interest rate;
• amortization period;
• financing fees;
• monthly payment;
• projected balance at the end of each year.

Do not base your scenario on the lowest rate in an advertisement. Also test a higher rate at renewal and lower revenue. A cottage that stays cash flow positive only when everything goes perfectly deserves a second look before purchase.

Step 4: check debt ratios

Cottage profitability and loan approval are two different questions. A project can show a good return on paper while exceeding your personal borrowing capacity.

Ask your broker or financial institution which rental income will be accepted and how it will be calculated. Some lenders use a portion of projected revenue, while others require a track record. The rules vary with the property type and your application.

Then add these measures to your model:

• Gross debt service ratio (GDS): eligible housing costs, including mortgage payments, property taxes, heating, and applicable condominium fees, divided by qualifying gross income.
• Total debt service ratio (TDS): those housing costs plus other debt payments, divided by qualifying gross income.
• Project debt service: the total annual principal and interest payments on the loan.
• Debt service coverage ratio (DSCR): net operating income divided by annual debt service.

The last ratio is particularly useful for testing the cottage itself. A result below 1 means operating income does not cover annual debt service in your scenario. You then need to revisit the purchase price, down payment, expenses, or revenue assumption.

Keep these ratios in a separate tab. Your lender may not use the same inputs as you do, and your personal cash flow projection must not be presented as financing approval. The CMHC guide to calculating GDS and TDS, in French, explains the distinction between the two ratios.

Step 5: address CITQ registration before committing

CITQ registration is not an administrative box to tick after buying. It is part of determining whether the project is feasible.

In Quebec, a unit offered to tourists for payment for stays of 31 days or less must be registered. The Government of Quebec also states that you must obtain an official municipal document confirming the project’s compliance before submitting the application.

The CITQ explains that registration is not transferable when an establishment is purchased. If you buy a cottage that is already operating, you therefore need to check its municipal status and complete the necessary steps in your own name.

Add a compliance line to your model and assign a status to each item:

• zoning confirmed in writing;
• suitable liability insurance and proof available;
• existing registration certificate checked, if applicable;
• condominium or neighbourhood restrictions checked;
• renewal and display obligations understood.

If compliance remains uncertain, do not treat rental revenue as secured. Build a scenario without short-term rentals instead. This test often reveals the application’s real risk.

Step 6: calculate monthly net cash flow

Monthly cash flow after debt service is cash actually received minus operating expenses actually paid and debt payments. To measure the amount available after setting money aside, deduct the reserve as well:

Gross revenue - variable expenses - fixed expenses - reserve contribution - debt payments = available cash flow before income tax.

Money transferred to a reserve remains yours, but is no longer available for day-to-day use. When that reserve funds a major expense, record the payment and the reserve withdrawal without deducting the same cost twice.

Create one column for each month. Allocate revenue by season and place major expenses in the month they occur. You will immediately see whether the cottage funds its quieter months or requires you to contribute cash during certain periods.

Add three summary lines:

• Net operating income: revenue minus operating expenses, before debt service, income tax, and the reserve contribution shown separately.
• Cash flow after debt service: net operating income minus loan payments; show available cash after the reserve contribution on a separate line.
• Cash-on-cash return: annual cash flow after debt service divided by the down payment and acquisition costs; specify whether the calculation also deducts the reserve contribution.

Do not confuse return with equity accumulation. Repaying principal increases your net worth, but it does not pay your electricity bill. When deciding whether you can hold on to the cottage, cash flow after debt service remains the most practical measure.

Step 7: test difficult scenarios

A sound model needs to withstand less comfortable assumptions. Change one input at a time, then test a combination of risks.

In particular, test:

• fewer booked nights;
• a lower average nightly rate;
• higher insurance or energy costs;
• a major repair;
• a period without rental authorization;
• professional management instead of self-management;
• a higher interest rate;
• a few weeks reserved for personal use.

The result to watch is not just gross return. Record the number of months with negative cash flow, the minimum cash required, and the amount you need to keep in reserve. This information helps you choose a cottage you can realistically keep.

How can you use the MonsieurChalets calculator without overstating the result?

Use the MonsieurChalets calculator, in French, to obtain an initial revenue projection based on your nightly rate and booked nights. Transfer the corresponding gross revenue to your spreadsheet, then build net cash flow using your own expenses, financing, and reserves. If a displayed amount already deducts management fees, reconcile it before deducting those fees again.

The calculator helps compare operating assumptions. It does not replace a financing analysis, municipal validation, CITQ checks, or tax advice.

To understand which documents to request and the risks of a cottage already in operation, also see Rental cottages for sale in Quebec: 7 criteria, available in French. The goal is to compare advertised revenue with expenses and the supporting evidence.

FAQ

What is the best tool for calculating a rental cottage’s profitability?

The best tool separates gross revenue from net cash flow. Start with the MonsieurChalets calculator to build a revenue scenario, then use a spreadsheet with your expenses, debt, reserves, and quieter months.

How do you calculate the profitability of a seasonal cottage rental?

Multiply the average nightly rate by the number of booked nights to obtain gross revenue. Then deduct operating expenses, the reserve contribution, and debt service to obtain available cash flow before income tax, and compare that result with the cash invested.

Which costs belong in a cottage cash flow calculation?

Include cleaning, utilities, insurance, property taxes, maintenance, supplies, amenities, management, booking fees, accounting, and a reserve for major repairs. A projection that overlooks irregular expenses almost always overstates available cash.

Is CITQ registration required to rent out a cottage short term?

Yes, tourist rentals of 31 days or less are generally subject to registration. You must also check municipal zoning and obtain the required confirmation of compliance before presenting rental revenue as a feasible assumption.

Which debt ratios should you review before buying a cottage?

Review the debt ratios used by your lender and the project’s debt service coverage. The cottage’s cash flow should cover annual debt service in a conservative scenario, not only a favourable one.

Should you count nights reserved by the owner?

No. Nights you keep for yourself generate no revenue and must be deducted from available nights. Their opportunity cost should appear when you compare scenarios.

Sources and references

• Government of Quebec: registering a tourist accommodation establishment: registration rules, municipal compliance, and insurance (in French).
• CITQ: frequently asked questions: requirements for stays of 31 days or less and non-transferability of registration (in French).
• MonsieurChalets profitability calculator: initial revenue projection based on the nightly rate and booked nights (in French).
• CMHC: calculating GDS and TDS: definition of the debt service ratios (in French).

Related articles

• Making a rental cottage profitable in Quebec
• Rental cottages for sale in Quebec: 7 criteria (in French)
• Investing in a rental cottage in Quebec: 2026 guide (in French)
• Tax reporting for a rental cottage (in French)