
For a distribution business, a credible plan is mostly about working capital. Distributors buy stock before they sell it and usually sell on credit, so even a profitable plan can run out of cash. This template is built around that reality and presents the results in two interactive dashboards.
Management Panel and Operations Panel
- Management Panel: scenario selector (Base / Upside / Downside) and period filter (Year 1 to Year 5, or 5-year total). KPI cards for revenue and growth, gross margin, EBITDA, net income, closing cash, free cash flow and enterprise value; charts for revenue, EBITDA and net income by year, margins, cost structure, month-end cash versus the minimum cash target, cash flow by activity and break-even revenue; an alerts block (integrity, funding, profitability, debt service, loan repayment, product margins) and a valuation and financing summary.
- Operations Panel: year filter and product-line filter. Units sold, revenue, average selling price, gross margin, cash conversion cycle, inventory and turnover, contribution margin; monthly revenue, gross profit and margin, monthly units (seasonality), revenue and gross margin by product line, month-end receivables, inventory and payables, and monthly operating expenses.
What you plan
- Up to five product lines with first-month units, monthly volume growth for each year, and selling price and purchase cost per unit at today’s prices.
- A 12-month seasonality index and separate annual inflation rates for prices, costs and salaries (useful in high-inflation markets).
- Headcount by role (employees per year × monthly cost), warehouse rent, utilities and other fixed G&A, and variable selling costs as a percentage of revenue (commissions, delivery, marketing, bad debts).
- Annual capital expenditure in three asset classes, each depreciated on a straight-line basis over its own useful life.
- Receivables, inventory and payables driven by DSO, DIO and DPO days; an equity injection and a term loan with a grace period and straight-line repayment (no circular references).
Outputs
- Integrated monthly engine (60 months) with an annual income statement, a year-end balance sheet that balances every month, and a cash flow statement.
- KPIs: growth, gross / EBITDA / net margins, minimum cash, net working capital, debt service coverage, return on equity, contribution margin, monthly break-even revenue and inventory turnover.
- Discounted cash flow (DCF) valuation of free cash flow to the firm with terminal value, enterprise value and equity value, project IRR and payback month.
- A checks sheet with 16 integrity tests; the cover and both dashboards show “ALL CHECKS OK” or what needs to be reviewed.
How to use it
- Enter your assumptions in the yellow cells of the Inputs sheet (every numeric input has data validation).
- Select the scenario and the period on the Management Panel.
- Use the year and product filters on the Operations Panel, then review the statements, KPIs, valuation and checks.
Limitations (stated honestly)
- Single currency; no VAT or sales tax calculation; no revolving credit line; a single term loan.
- Income tax applied to positive monthly profits, without loss carry-forward (a conservative simplification).
- The product filter applies to units, revenue, price and gross margin; overheads, inventory and working capital are company-level (the model has no overheads or stock by product).
Series note
This model belongs to the C15 sector series by Petrich Financial Models. It shares the integrated three-statement architecture and dashboard design with our Trucking & Freight Fleet model, but its revenue, cost, working capital and operating logic is specific to wholesale distribution.
Compatibility and requirements
- Microsoft Excel for desktop. Designed and tested in Microsoft Excel for Microsoft 365 (Windows): recalculated from scratch with no formula errors and all checks OK.
- Standard Excel functions only (no dynamic arrays), no macros, no add-ins, no external links; works offline.
- Not yet tested in Excel 2016/2019, Excel for Mac or Excel for the web.
- No locked cells and no passwords: all formulas are visible and editable.
Support
- Questions about how to use the model are answered through the eFinancialModels messaging system, in English or Spanish, within 3 business days.
- Bug fixes are free for 12 months after purchase.
- Customization is not included; it can be quoted separately.
Terms of use
- Single-user license (one company or one advisor). Resale or redistribution is prohibited.
- Provided as a planning template with fictitious sample data. It is not investment, tax or accounting advice; results depend entirely on your assumptions.
With this comprehensive 5- or 10-year monthly tool, investors can assess the viability of setting up... Read more
The Mobile App Financial Plan Template in Excel allows you to develop financial projections when lau... Read more
The Food Truck Financial Model helps entrepreneurs, founders, business owners, consultants, and anal... Read more
The Green Hydrogen from Wind Financial Model aims to comprehensively forecast a horizon of 40 years ... Read more
Protect your business secrets with ease using our Simple Mutual Non-Disclosure Agreement Template. S... Read more
The Solar Energy Financial Model Spreadsheet Template in Excel assists you in preparing a sophistica... Read more
Starting a restaurant without a financial plan is like driving a car blindfolded. You wouldn´t do i... Read more
You must log in to submit a review.