A car can bring in steady rental revenue and still leave too little cash for its loan payment. To judge its performance, calculate the contribution from each paid day, deduct the costs of keeping the vehicle available, and then make a separate cash calculation. The downloadable car rental profit calculator does those steps in one monthly model.
It covers one owned or financed vehicle. Enter your rates, utilization, downtime, operating costs and finance payments to see profit before tax, the number of paid days needed to break even, and closing cash. A second sheet compares rental rates and utilization so you can see which assumptions matter most.
Download the car rental profit calculator (XLSX). The file has editable inputs, visible formulas and a worked example. All example prices and costs are illustrative assumptions, not industry averages or forecasts for a particular country.
Choose a consistent period and cost basis
Start with one month and one currency. Use the actual number of calendar days, then subtract days when the vehicle cannot be rented because of repairs, servicing or operational downtime. Apply utilization to the remaining available days. This distinction matters: a vehicle with 21 paid days in a 30-day month has 70% calendar utilization, but 75% utilization of availability if it lost two days to maintenance.
The calculator uses the second definition. Entering 70% would give a different result, so check the denominator in any utilization figure you import. Keep complimentary use, staff travel and unpaid extensions separate from paid rental days.
Enter rental revenue excluding sales tax or VAT collected for the authorities. Put an average earned add-on amount beside the rental rate. A refundable security deposit is not part of the rental revenue input. The model has a separate deposit cash field so those funds do not inflate profit.
Collect actual figures from rental records, invoices, bank statements and the finance schedule before adjusting the defaults. If a cost is an estimate, make that visible in your own records. A precise-looking margin is only as useful as the amounts beneath it.
Calculate contribution from a paid rental day
Contribution is the amount left from a rental day’s revenue after the costs that vary with that activity. In this workbook, those costs include a blended commission or payment fee, a direct cost per paid day, and a share of the cleaning and handover cost for each booking.
Turnaround cost needs special care. A 20 cleaning and handover cost spread over a four-day booking adds 5 per rental day. The same cost on a one-day booking adds 20. A short booking can therefore produce less contribution per day even when the advertised daily rate is unchanged.
The formula is: contribution per paid day = rental rate + add-on revenue − percentage fees − direct daily cost − turnaround cost per booking ÷ average booking length. Fees in this model apply to both rental and add-on revenue. If your channels charge on different bases, enter a suitable blended assumption or adapt the calculation.
A worked example using the download
Assume a 30-day month with two unavailable days and 75% utilization of the remaining 28 days. That produces 21 paid days. A rental rate of 60 plus 4 in average add-ons gives 64 in revenue per paid day and 1,344 for the month.
A 10% blended fee costs 6.40 per paid day. Add 8 of direct costs and 5 of allocated turnaround cost. Total variable cost is 19.40 per day, leaving 44.60 of contribution. Across 21 paid days, variable costs total 407.40 and contribution totals 936.60.
These are illustrative amounts, not results from a rental company.
Replace them with your own figures, including realistic costs for tyres, servicing, cleaning and the booking channels you use. If you already include a maintenance allowance in the daily cost, avoid adding that same allowance again to fixed overhead. Use the same cost basis when comparing vehicles; otherwise one can appear cheaper simply because some of its expenses sit elsewhere in the accounts.
Deduct fixed costs, depreciation and interest
The example has monthly insurance of 90, parking of 60 and an overhead allocation of 70. Together, they add 220 of fixed cash costs. The overhead allocation should include a fair share of items such as staff, premises, software and administration. Leaving them out makes vehicle profitability look better without reducing the company’s bills.
The workbook calculates straight-line management depreciation from vehicle cost, estimated residual value and useful life. With a cost of 30,000, residual value of 15,000 and a 60-month useful life, monthly depreciation is 250. This is a planning assumption. It does not determine local tax depreciation or guarantee what the vehicle will sell for.
Subtract the 220 fixed costs, 250 depreciation and 50 interest from monthly contribution of 936.60. The result is 416.60 profit before tax. Dividing that by 1,344 of revenue gives a 31.0% margin before tax. The margin describes this particular set of assumptions; it is not a target every rental company should expect to achieve.
Include interest once. The loan’s principal repayment belongs in the cash calculation, while the vehicle’s cost is reflected through depreciation in this simplified profit model. Entering the full monthly loan payment as an expense and also subtracting depreciation would mix two different calculations.
Find the break-even number of rental days
The U.S. Small Business Administration’s break-even formula divides fixed costs by selling price per unit less variable cost per unit. Here, the unit is a paid rental day. For profit before tax, the costs to cover include fixed operating costs, management depreciation and interest.
The example therefore needs 520 divided by 44.60, or about 11.66 paid days, to cover those monthly costs. The calculator rounds up to 12 whole paid days. The corresponding exact utilization threshold is about 41.6% of the 28 available days; scheduling 12 whole days uses about 42.9% of that availability.
Round the days up when planning a whole-day target. Rounding 11.66 down to 11 would leave the vehicle short of break-even.
The calculator also compares the target with the days physically available. If repairs leave only one available day, a 12-day target cannot be achieved within that period. Selling extra days on paper does not create the missing capacity. Change the repair timing, cost base or planning period before treating the result as a workable schedule.
There is another boundary to watch. When contribution per day is zero or negative, adding paid days cannot cover positive fixed costs under the entered assumptions. The file displays “Not achievable” instead of presenting a negative or infinite break-even target as meaningful.
Use the threshold to ask a specific question
Suppose the vehicle is below break-even. Check whether the gap comes from too few rentable days, insufficient demand, a low achieved rate or an expensive booking mix. Each cause suggests a different response. Raising rates does not repair a car, and reducing the rate does not help if the extra bookings cost more to service than they contribute.
For operational ways to reduce idle capacity, see our guide to increasing fleet utilization. Use the calculator to put numbers against an action before assuming it will improve the monthly result.
Why cash can differ from profit
Profit and cash answer different questions. The IFRS Foundation’s IAS 7 overview explains that reconciling profit to cash requires adjustments for non-cash items, accruals and items associated with investing or financing. The workbook applies a simplified version of that distinction for a single vehicle; it is not a statutory cash-flow statement.
Assume you collect 95% of the example month’s revenue before month-end. Cash receipts from current revenue are 1,276.80, leaving 67.20 still to collect. Pay the 407.40 variable costs, 220 fixed operating costs, 50 interest and 300 loan principal in the same month. Cash increases by 299.40, compared with profit before tax of 416.60.
The bridge is easy to inspect: start with 416.60 profit, add back 250 of non-cash depreciation, subtract 300 principal and subtract the 67.20 collection delay. That gives the same 299.40 cash change. With opening cash of 1,000 and no other flows, closing cash is 1,299.40.
Separate inputs cover collections of earlier receivables, capital purchases, new financing, net deposit receipts or refunds, and other net cash outflows. A vehicle purchase can make cash negative in a profitable month. A new loan can make cash positive without improving the vehicle’s operating economics.
Refundable deposits also need care. Their cash may appear in the bank, but an amount still owed back to renters should not be treated as free money to distribute. The workbook does not separate restricted and unrestricted cash. Keep a separate deposit reconciliation and include actual tax payments or owner withdrawals in the appropriate cash input.
Compare rate and utilization before changing prices
The Sensitivity sheet calculates monthly profit across five rate levels and five utilization levels. Rate multipliers apply to your entered rental rate. Other assumptions, including add-ons, downtime and fixed costs, remain linked to Calculator. Change the amber percentages to test combinations that make sense for your market.
At the example 60 rate and 75% utilization, the grid reproduces 416.60 profit. At a 45 rate and the same utilization, profit falls to 133.10. At the 60 rate with only 40% utilization, the result is a loss of 20.48. The grid makes that trade-off visible without pretending to predict how customers will respond to a price change.
Do not select the highest-profit cell just because it looks attractive.
Higher prices may reduce bookings, change booking length or increase reliance on channels with different fees. Those relationships require evidence from your own demand and booking records. Enter a plausible combination, then change the relevant costs as well. A useful comparison might involve fewer weekend bookings at a higher rate versus longer weekday rentals with a lower turnaround cost per day.
Test a downside month with fewer paid days, more downtime and a lower residual-value estimate. For an existing fleet, run vehicles or comparable vehicle groups separately before combining their results. An average can hide a premium car that sits idle or an older car with unusually high maintenance costs.
Use the result without overstating what it means
The workbook is a monthly management tool for owned or financed vehicles. It assumes operating expenses and interest are paid in the same period, uses average booking length rather than a reservation-by-reservation schedule, and calculates profit before income tax. It excludes disposal gains or losses and does not model the full balance sheet.
A leased fleet needs a model that reflects its lease arrangements. Do not add a full lease payment to this calculator while keeping the same owned-vehicle depreciation assumptions. The discussion of buying, leasing and subscribing to fleet vehicles helps frame that separate decision.
After entering your figures, check that the Input check reads Ready. Missing required numbers suppress the outputs so an incomplete model does not look like a zero-cost business. Review unusual results against the source records, save the assumptions with the month, and compare the estimate with the actual result when the period closes.
If collecting vehicle income and expense records has become the slowest part of this process, review TopRentApp’s Economics feature. Keep the calculation questions the same: what did this vehicle earn, what did it cost, and how much cash remains after the payments actually due?
