Manufacturing Pro Forma Template

Start with the Assumptions sheet. Enter your product line or job category breakdown, the average selling price for each category, and your direct material cost as a percentage of revenue. If you're a job shop, this might be three categories — standard machined parts, custom fabrication, and tooling/fixtures. If you're a production manufacturer, it might be your top SKU families. Set your planned capacity utilization for year one — most manufacturing businesses don't start at full capacity, and the ramp schedule lets you model realistic output growth without assuming 100% throughput from day one. Get these inputs right before moving to any other sheet, because every downstream calculation flows from here.

Once assumptions are in place, review the Cost of Goods Sold sheet and verify the cost percentages match your actual production economics. Direct materials as a percent of revenue is the most important input — it varies from 20% for highly labor-intensive custom work to 60%+ for manufacturers who buy expensive raw stock and do light conversion. Direct labor hours per unit and the wage rate plus burden will drive your labor cost calculation. If you have historical job cost data, use it to calibrate these numbers; if you're projecting a new product or line, use industry benchmarks as your starting point and build in a 5–10% buffer for startup inefficiency. Then populate the Overhead & SG&A sheet with your actual or planned fixed cost base.

Use the 5-Year P&L Summary and Cash Flow Projection when presenting to banks, equipment lenders, or SBA loan officers. Manufacturing lenders focus on gross margin trends (is it stable or compressing as material costs rise?), EBITDA coverage of debt service, and the working capital cycle — specifically whether your cash conversion cycle allows you to fund receivables and inventory without exhausting your credit line. Run the Break-Even Analysis under a pessimistic capacity utilization scenario before any financing meeting; showing that you can cover fixed costs at 60% utilization, for example, demonstrates you've stress-tested the model and aren't assuming everything goes perfectly from day one.

Manufacturing is capital-intensive, inventory-heavy, and slow to scale — which is exactly why pro forma financial projections matter more here than in most industries. Equipment takes months to procure and qualify. Suppliers need lead time before they can ramp supply. New product lines require tooling investment before the first unit ships. A manufacturer who projects revenue without modeling the capital expenditures, inventory build, and working capital required to support that revenue will run into cash shortfalls before reaching the growth targets they projected. The pro forma isn't just for showing investors a number — it's for stress-testing whether the growth plan is actually fundable.

The two numbers that define manufacturing financial health are gross margin and EBITDA margin. For discrete manufacturers — machined parts, fabricated assemblies, consumer goods — gross margins typically run 20–35%, with gross margin determined almost entirely by the relationship between your average selling price and your direct material plus direct labor cost. Net margins in manufacturing are tight: 4–10% is normal, and many manufacturers run at 5–7% net. This means that a 2-percentage-point increase in material costs — from steel price increases, aluminum tariffs, or supply disruptions — can cut net income by 40% if you don't raise prices to match. Modeling these scenarios in a pro forma before they happen is how manufacturing operators stay solvent through commodity cycles.

For SBA lenders, equipment financing institutions, and commercial bank lenders, a manufacturing pro forma needs to demonstrate three things: that your unit economics work at realistic volume, that your capex plan is tied to revenue milestones rather than speculative growth, and that your cash flow covers debt service with meaningful headroom. Equipment lenders in particular want to see the depreciation schedule tied to the equipment financing plan — they're evaluating whether the asset generates enough revenue to service its own cost. This template structures the Cash Flow Projection and Break-Even Analysis specifically for those conversations, with the depreciation, debt service, and capacity utilization calculations that manufacturing lenders actually request.