Revenue and Monthly Calc
Revenue and Calc combine fleet-hour capacity, booked utilization, five freight allocations and hourly rates into monthly and annual revenue.

The Transportation Company Financial Model is an Excel template for planning a small commercial freight carrier through 2030. It connects owned truck capacity, hourly service mix, route utilization, operating expenses, payroll, startup investment and financing to monthly financial statements and management reports.
Three owned 26-foot liftgate box trucks make weekday commercial deliveries in metropolitan Atlanta, including occasional regional routes. Figures are illustrative US-dollar forecasts, not observed results or industry averages.
The workbook links freight demand and fleet capacity to operating costs, investment plans, projected financial statements and decision-focused reports.
Revenue and Calc combine fleet-hour capacity, booked utilization, five freight allocations and hourly rates into monthly and annual revenue.
COGS and OPEX split delivery-linked percentages from fixed fleet, yard, insurance and dispatch expenses.
Payroll forecasts staff FTE and salaries; CAPEX tracks asset purchases and depreciation, with CapTable and Debt for funding.
Income Statement, Cash Flow and Balance Sheet connect freight operations with profitability, working capital and liquidity; Summary combines their results.
Dashboard and scenario controls compare assumptions, while Returns, Valuation, Charts and Checks support performance analysis and model consistency.
Five service lines draw from one available fleet-hour pool, with each booked truck-hour allocated once and priced at its service-specific rate.
Three trucks × 22 days × 8 hours yield 528 available truck-hours monthly. At 55% utilization, 290.4 sold hours are allocated to Local Pallet Freight (35%), Store Replenishment (30%), Expedited Freight (15%), Commercial Equipment Delivery (10%) and Returns Collection (10%).
Starting hourly rates are $110, $100, $143, $125 and $95, respectively. Utilization increases to 65%, 72%, 78% and 82% through 2030, with annual rate increases for each service.
The Revenue Forecast combines booked truck-hours, freight mix and annual hourly prices into monthly sales by service. It helps test whether utilization or pricing drives growth.
290.4 sold truck-hours/month × $111.95 weighted hourly rate × 12 months ≈ $390,123 annual revenue.
The forecast separates delivery-related direct costs, variable overhead, fixed monthly expenses and salaried staff to avoid counting the same cost twice.
The direct cost rate is 22.5% of revenue: fuel 14%, tires and parts 3%, maintenance 3%, tolls and parking 2%, and consumables 0.5%. Acquisition, claims and collection fees add 3.5% variable overhead.
The COGS and Operating Expenses Forecast applies delivery-cost rates and fixed schedules to projected sales. It separates usage-driven expenses from insurance, yard and dispatch overhead.
Fixed overhead covers insurance, the secured yard, routing tools, telematics, bookkeeping, connectivity, registrations, recruitment, training and cleaning. Monthly insurance rises from $2,700 in 2026 to $3,024 in 2030.
Staffing includes three drivers at $50,000 each, an owner supervisor at $65,000 and a half-time dispatcher based on $50,000 full-time pay. The case has $240,000 annual base payroll.
The Payroll Forecast calculates personnel expenses from role FTE, salary and employment dates. Drivers, the supervisor and the half-time coordinator are separate from COGS; the case excludes employer taxes and benefits.
The model distinguishes truck and equipment purchases, other preopening cash needs, operating working capital and initial owner funding.
Opening assets include $210,000 for three used liftgate trucks, $9,000 for pallet jacks and cargo equipment, and $5,000 for dispatch IT and tracking hardware. These purchases are separate from recurring expenses.
The Capital Expenditure Plan schedules truck and equipment purchases and their depreciation treatment. It distinguishes capital investment from recurring expenses and supports asset balances in the projected financial statements.
Preopening cash also covers a lease deposit, licenses, formation, a launch campaign, occupancy, staff setup and software setup. Working-capital assumptions are 30 receivable days, 4 payable days and 3 inventory days.
The Sources and Uses of Funds report reconciles funding with planned operating, investing and financing payments. The $383,594 illustrative owner contribution covers eligible assets, preopening cash, initial working capital and a three-month recurring-outflow reserve.
The 2026–2030 operating case reports annual revenue, total operating expenses and EBITDA for the modeled Atlanta-area freight fleet.
| Year | Revenue | Operating Expenses | EBITDA |
|---|---|---|---|
| 2026 | $390,123 | $414,872 | -$24,749 |
| 2027 | $474,028 | $438,895 | $35,133 |
| 2028 | $539,447 | $458,100 | $81,347 |
| 2029 | $599,969 | $476,044 | $123,925 |
| 2030 | $647,102 | $490,495 | $156,607 |
Amounts are estimated scenario projections, rounded to whole dollars. Minor differences may result from rounding.
In this case, revenue rises from $390,123 in 2026 to $647,102 in 2030 as utilization and prices increase. EBITDA changes from a $24,749 operating loss to positive $156,607, before depreciation, interest and income tax.
The Income Statement calculates accounting profit, while the Balance Sheet tracks assets, liabilities and equity. Neither net profit nor year-end cash can be inferred from the EBITDA figures.
The Cash Flow Forecast tracks monthly receipts, operating payments, investing and financing cash flows, with opening-to-closing cash reconciliation. It helps test how customer collection timing and truck purchases affect liquidity despite improving EBITDA.
Returns and scenario tools help test the revenue needed to cover costs, cash recovery timing and investment efficiency using editable assumptions.
Returns separates sales break-even, cash break-even, investment payback and annual ROIC. Operating EBITDA may improve before cumulative project free cash flow recovers the original investment.
The Returns report compares sales with break-even requirements and analyzes project free cash flow, payback and return on invested capital. It helps evaluate fleet investment without assuming a payback month or return percentage.
Dashboard Scenario Controls apply Low, Base and High multipliers to revenue, direct costs, variable expenses, fixed expenses and payroll. Four configurable debt facilities have separate borrowing and repayment schedules; no outside financing is confirmed.
Valuation discounts unlevered free cash flow with terminal assumptions, while Checks flags input and reconciliation issues. Neither feature establishes a guaranteed investment outcome or a verified business value.
The template fits owner-operators, prospective fleet owners and financial advisers planning a small commercial box-truck freight business.
The structure fits pallet freight, store replenishment, expedited loads, equipment deliveries and returns collection with a staffed weekday shift. Warehousing, passengers and two-person installation jobs are excluded.
Change rates, utilization, truck counts, staffing, costs and funding for your operation. Actual customers, insurance, financing and collection patterns can differ materially from the Atlanta illustration.
These answers clarify the model inputs, forecast logic and the limits of its illustrative financial projections.
Yes. Change truck count, service days, available hours and annual utilization to recalculate capacity and freight revenue.
Each has its own hourly rate and share of the common sold-hour pool; the five shares total 100% in this case.
No. Drivers, the supervisor and dispatcher are in Payroll, separate from COGS and fixed overhead.
The 2026–2030 forecast uses a January 31, 2026 illustrative launch and monthly calculations.
No. Receivables, payables, trucks and funding affect cash separately; consult the Cash Flow and Balance Sheet reports.
Yes. Debt controls schedule configurable borrowing, but the illustrative startup funding is owner-provided and no external loan is confirmed.
Returns and Valuation provide these calculations, but the supplied forecast does not establish a payback date, return or business value.
KPIs, forecasts, and cash flow at a glance.
Key assumptions and calculations driving revenue forecasts.
Funding sources, spending, and closing cash.
Cash break-even, payback, and ROIC.
DCF valuation and sensitivity analysis.
Largest costs and spending trends.
Annual and monthly financial performance.
Compare margins and returns to benchmarks.
The template organized our pricing, fuel costs, and growth assumptions in one place, so I stopped chasing numbers across tabs. It cut two hours from each planning session and made the forecast much easier to review.
I’m not deep into Excel, and this model was still easy to work through. The inputs were clear enough that I built a full five-year forecast in one afternoon without asking for help.
I used to keep the statements and charts in separate files, which made updates messy. This template pulled everything together and saved me a full day before our lender meeting.