Retail Pro Forma Template

Start with the Assumptions sheet. Enter your store's square footage, target revenue per square foot, average transaction value, and expected monthly transaction count — these four inputs drive most of the revenue model. If you're projecting a new store, use your retail category's benchmark sales-per-square-foot as your year-three target and apply a ramp schedule to years one and two (most new retail stores operate at 60–75% of mature-store productivity in their first year). Set your seasonal distribution based on your product category: apparel and gifts weight heavily toward Q4, outdoor and gardening toward Q2–Q3, and home goods tend to be more even with a modest Q4 lift.

Once the Assumptions sheet is set, review the COGS & Gross Margin sheet and adjust the markdown and shrinkage percentages to match your actual or industry-benchmark experience. Initial gross margin for most specialty retailers is 50–60% before markdowns, but realized gross margin after planned promotions, clearance, and shrinkage typically lands 8–15 points lower. Verify these numbers against your own historical data or supplier cost sheets before using the model in any financing conversation. Then move to Operating Expenses and enter your actual or quoted lease rate, your planned staffing model by role type, and your other fixed costs — this is where many retail pro formas are built too optimistically, so use real quotes where you have them.

Use the 5-Year P&L and Cash Flow sheets when presenting to SBA lenders, commercial landlords, or franchise development teams. Lenders evaluating retail businesses focus on gross margin stability, occupancy cost as a percentage of sales (should be under 12% for most formats), and the cash flow model — especially whether the working capital requirement for pre-season inventory purchases is covered. Run the Break-Even Analysis before any lender meeting and know your sales-per-square-foot break-even cold; it's one of the first questions a retail-experienced lender will ask, and having a specific answer backed by the model builds credibility immediately.

Retail is one of the most margin-sensitive industries to finance because small swings in gross margin have an outsized impact on net income. A specialty retailer running at 48% gross margin and 12% occupancy costs has roughly 36 points of gross profit left to cover labor, marketing, and G&A — leaving perhaps 3–6% net margin in a well-run store. Drop gross margin by 5 points due to higher markdowns or a vendor price increase and net income can disappear entirely. That's the specific problem a retail pro forma is built to address: projecting not just revenue, but the gross margin realization, operating cost structure, and cash timing that determines whether a store is actually viable before you sign a lease.

The financial metrics that define retail health are gross margin (40–60% for specialty retail; 20–30% for grocery; electronics lower), labor as a percentage of sales (10–15% is healthy for most formats), and occupancy as a percentage of sales (8–12% is the typical target; above 15% is a structural problem that's hard to grow out of). Sales per square foot is the single most useful performance metric for comparing locations and benchmarking against competitors — top-performing specialty retailers achieve $500–$800+ per square foot annually; average performers run $250–$400. A retail pro forma that doesn't tie revenue projections to a specific square footage and a credible sales-per-square-foot assumption isn't a financial model — it's a guess.

For any new retail location, the working capital challenge is the most important thing to model carefully. Inventory must be purchased 4–8 weeks before the selling season for most categories, which means cash goes out before receipts come in. Add a security deposit, build-out costs, and 2–3 months of operating losses during the ramp period, and the total cash requirement to open a retail store is typically 18–24 months of projected operating expenses. Lenders and investors want to see this modeled explicitly — not as a single line item labeled 'startup costs,' but as a month-by-month cash flow showing exactly when cash is needed and when the store generates enough operating cash to cover its own costs.