Business financial model file
Car Rental Financial Model
Separate fleet purchase cash from the contribution on paid rental-days, allowing for unavailable vehicles and turn time.
Opening investment and working cash
The original twelve-vehicle operator buys selected used cars; it does not assume financed purchases or an already owned fleet. Local vehicle taxes, condition and insurance must be in actual quotes. Refundable customer security deposits are not operating revenue.
| Cash use | $ |
|---|---|
| CAPEX: Twelve selected used vehicles | 240,000 |
| CAPEX: Depot/parking setup | 12,000 |
| CAPEX: Telematics and POS equipment | 5,000 |
| Pre-opening: Fleet/local setup and initial professional costs | 8,000 |
| Pre-opening: Pre-opening staff and launch | 5,000 |
| Refundable deposit / tied-up cash | 5,000 |
| Opening stock / initial working inputs | 3,000 |
| Reserve: 2 selected fixed-cost months | 30,000 |
| Selected opening cash total | 308,000 |
CAPEX totals $257,000, pre-opening expense $13,000 and working cash $38,000. The deposit and opening stock tie up cash; they are not added again as monthly rent or consumed inputs. The reserve is a chosen fixed-cost buffer, not proof of full funding. Obtain actual installed/tax-inclusive quotes and dated opening payments.
Monthly fixed and variable OPEX
The loaded operations roster is$7,500/month. Cleaning is allocated from an assumed$24 turn over a three-day average rental, or$8 per rental-day; fixed staff cover check-in/operations rather than the same outsourced cleaning work. Base maintenance and mileage-related wear are separate selected allowances.
| Commitment | $ per month |
|---|---|
| Check-in/operations team: loaded budget | 7,500 |
| Fleet insurance budget | 1,800 |
| Depot lease | 2,500 |
| Software/telematics | 350 |
| Base maintenance commitment | 1,200 |
| Recurring registration/services budget | 500 |
| Marketing | 700 |
| Admin/fees | 450 |
| Total selected fixed cash | 15,000 |
| Item | $ per unit |
|---|---|
| Net collected selling value | 75 |
| Turn cleaning allocation per rental-day | 8 |
| Incremental mileage/wear allowance | 7 |
| Percentage-only fee allocation (3%) | 2.25 |
| Contribution before scheduled payroll/fixed OPEX | 57.75 |
The percentage fee is an aggregate allocation, with no fixed per-payment charge assumed. Unit contribution is not owner income: the full listed monthly roster and overhead still need coverage.
Capacity, break-even and a lower-sales case
Twelve cars over 30 days give 360 nominal vehicle-days;85% availability leaves 306. The selected booking/turn calendar permits 280 paid days, and the plan is 250. A car waiting for repair or cleaning is unavailable even when another customer requests a booking.
For this fixed mix and commitment, whole-unit cash break-even is 260 paid vehicle rental-days per month: ($15,000) ÷ $57.75, rounded up. The aggregate capacity is 280 units; it does not establish customer demand or a workable daily sequence.
| Paid units | Net sales $ | Selected result $ |
|---|---|---|
| 200 | 15,000 | -3,450 |
| 260 | 19,500 | 15 |
| 250 (planned) | 18,750 | -562.50 |
| 280 | 21,000 | 1,170 |
At 200 paid days, fleet insurance, depot and roster remain. Compare break-even with usable days before buying another car; the retained guide's incremental fleet decision has a different scope.
Practical KPI definitions
Use paid rental-days/available vehicle-days for utilization, net rental revenue/paid days for average daily rate and contribution after turn/mileage costs per available day. Track average contract duration because cleaning is charged by turn, not automatically by day.
No depreciation, debt service, income tax or future vehicle replacement is counted in the selected operating cash result. Deposits, damage recoveries and cash settlement need separate contracts/dates.
Method context: SBA business planning. All case prices, wages, cost ratios, reserve and capacity inputs above are original planning assumptions.
What the model covers
The official FinModelsLab listing describes editable annual units and prices by revenue stream, launch/end dates, salaries, staffing and capital schedules. Core rental contracts, protection plans and add-ons are modeled through units times prices. Stated outputs include profit and loss, cash forecasting, break-even and visual KPIs.
Bridge contract revenue to vehicle-day capacity
Our original five-car case has 125 available days and needs 82 paid days to cover selected operating and financing cash. Seventy-five paid days show $900 before financing but negative $300 after it.
Bridge rental contracts to vehicle-days using actual duration and realized price. Reconcile vehicle dates, turnaround, deposits and finance payments before increasing volume. The Car Rental planning guide develops the original worked case.
Planning guide