Scenario presets
Presets override only vehicles, weekly rent, weeks rented, and insurance (and switch to flat rent). Every other assumption stays as you set it.
Annual P&L waterfall (fleet)
Gross rent to cash profit to accounting net income. Loan principal is added back because depreciation already charges the asset cost.
P&L detail
Fleet totals, per-vehicle figures, and the share of gross rent.
Sensitivity: profit vs utilization
At the current weekly rent. The x-axis is weeks rented per vehicle per year.
Sensitivity: profit vs weekly rent
At the current utilization. Uses a flat-rent equivalent, so in share mode the x-axis is effective weekly rent.
Tornado: key drivers
Each driver is flexed on its own while everything else stays at the current case.
Flex
Metric
Profit fallsProfit risesBar-end labels show the flexed input value. Weeks are capped at 52.
Unit economics per vehicle
Per rented week, per month, and per year.
Sensitivity & scenario strip
Grid: fleet cash operating profit across weekly rent and weeks rented (outlined cell = current case). Table below: the scenario presets run live against your other assumptions.
Insurance gapUber's contingent coverage applies only while the app is on. Off-app and personal-use exposure is modeled through your insurance line, not Uber's cover. Price a true commercial or rideshare-rental policy.
Competing with Avis / HertzProgram rentals bundle insurance and maintenance into the weekly price. When you benchmark against them at about $260, remember their price includes insurance. Lower your insurance input only if your driver carries their own coverage. Otherwise your rent has to cover it.
PlatformFleet onboarding and vehicle/driver management go through Uber Fleet Hub: fleethub.uber.com (reference only, not linked). Fees and requirements change, so confirm them there.
Methodology & formulas
- Weeks rented (W) = utilization weeks input (Utilization % = W ÷ 52; the two fields are linked). Effective weeks We = W × (1 − downtime contingency %).
- Weekly rent (R) = flat rent, or in share mode R = owner share % × estimated driver weekly gross.
- Gross rent = cars × R × We. The security deposit is a refundable liability, so it is shown as a memo item and never counted as revenue.
- Tax on rent (if the toggle is ON, the owner remits the tax out of collections): default convention
tax = gross × t(rent quoted before tax and absorbed by the owner, which is conservative). Alternative: rent quoted tax-inclusive,tax = gross × t ÷ (1+t), so net = gross ÷ (1+t). If OFF, tax is added on top and passed through to the driver, with no P&L effect. t = state rate + county surtax. - Net rent = gross − tax. Bad debt = net rent × bad-debt %. Net revenue = net rent − bad debt.
- Cash opex (fleet) = cars × [insurance/mo × 12 + maintenance + registration/inspection/cleaning + tolls/GPS + listing/software + other + damage reserve]. All are fixed per vehicle-year, because they are incurred whether or not the car is rented.
- Owner time = hours/mo × 12 × $/hr. Always shown as a memo item. If the toggle is ON, it is deducted as an imputed management fee in EBITDA and everything below it.
- EBITDA = net revenue − cash opex (− owner time if ON). Loan service = loan/mo × 12 × cars. Cash operating profit = EBITDA − loan service.
- Depreciation = (basis − residual) ÷ life × cars, with residual = basis × residual %. Interest = loan service × interest share %. Principal is not a P&L expense.
- Pre-tax income = EBITDA − interest − depreciation. Income tax = max(0, pre-tax) × effective rate. Net income = pre-tax − income tax. (Waterfall view: cash op. profit + principal add-back − depreciation − income tax.)
- Margin = cash operating profit ÷ net revenue.
- Contribution margin per rented week (per vehicle) = R × (1 − tax factor) × (1 − bad-debt %), where the tax factor is t, t÷(1+t), or 0. Because every opex line is treated as fixed per vehicle, revenue-linked deductions (tax, bad debt) are the only variable costs.
- Breakeven weeks per vehicle = fixed cash costs per vehicle ÷ CM per rented week, where fixed cash costs = cash opex + loan service (+ owner time if ON) per vehicle, grossed up for contingency: ÷ (1 − contingency %). This is a cash breakeven and excludes depreciation. The accounting breakeven (including depreciation and interest instead of full loan service) appears in the unit-economics table.
- Payback = (down payment / initial capex × cars) ÷ after-tax cash flow, where after-tax cash flow = cash op. profit − income tax. N/A if capex = 0. A memo payback on the full vehicle basis is also shown.
- Verdict rule (heuristic, not advice): VIABLE if cash margin ≥ 20% and breakeven is at least 6 weeks below current utilization. MARGINAL if cash op. profit > 0. Otherwise NOT VIABLE.
Florida notes (verify with a CPA): the state sales tax on motor-vehicle rentals is 6%, plus any county discretionary surtax (often 0.5% to 1.5%). Florida also imposes a rental car surcharge (per day, first 30 days of a rental) that may apply to short-term vehicle rentals. If it does, model it in "Other fixed opex" or raise the tax rate. Income tax depends on your entity and personal situation. The 0% default is a pre-tax view.