Merchandise Financial Plan Template for Apparel Brands
The top-down financial framework for your season — net sales targets, gross margin rates, receipt budget, and inventory turns, structured for executive planning reviews with finance. Better than starting from a blank sheet.
Free download. Work email required.
// Template Preview
What the template looks like
Simplified preview. The full template includes complete formula logic, data validation, and step-by-step instructions.
| Department | SS Q1 (Feb–Apr) | SS Q2 (May–Jul) | FW Q1 (Aug–Oct) | FW Q2 (Nov–Jan) | Annual Total |
|---|---|---|---|---|---|
| Tops | $286,000 | $318,000 | $242,000 | $384,000 | $1,230,000 |
| Bottoms | $198,000 | $224,000 | $178,000 | $286,000 | $886,000 |
| Outerwear | $42,000 | $28,000 | $108,000 | $196,000 | $374,000 |
| ··· | ··· | ··· | ··· | ··· | ··· |
// What It Is
What is a merchandise financial plan?
A merchandise financial plan (MFP) is the top-down seasonal financial framework that governs all merchandising decisions. It sets the targets — net sales, gross margin rate, receipt budget, inventory turns — that every downstream plan (assortment plan, OTB, buy plan) must be built within.
The MFP is the contract between merchandising and finance. Finance approves the receipt budget and inventory investment. Merchandising executes within those constraints. Without an MFP, buying decisions lack a shared financial reference point — and plan-vs-actual analysis at the end of the season is a postmortem instead of a management tool.
This template gives planning and finance teams a structured MFP format — built for apparel planning cycles, not generic financial modelling.
Who this template is for
- VPs and Directors of MerchandisingBuilding the top-down financial plan for the season and presenting it to finance and the board.
- Merchandise PlannersTranslating the MFP into OTB budgets by department and ensuring the assortment plan stays within the financial guardrails.
- Finance and CFOsReviewing planned receipt spend, inventory investment, and margin targets — and tracking actual performance against them in-season.
- Founders and COOs at Growing BrandsBuilding a formal financial planning structure before the business has a dedicated planning team. The MFP is the starting point for any brand with multi-department buying.
// Where the MFP Fits
The MFP in the planning workflow
Sales targets and brand strategy set by leadership. The MFP translates those targets into department-level financial guardrails.
Net sales, margin rate, receipt budget, and inventory turn targets by department and month. The financial framework all downstream plans must stay within.
The OTB plan tracks receipt execution within the MFP budget. The assortment plan builds the product strategy within the MFP financial guardrails.
// Template Contents
What the template includes
Five worksheets covering the full MFP lifecycle — from pre-season financial targets to mid-season plan-vs-actual reviews.
Top-down net sales targets by department and month, with a rolling 12-month view. Enter your season plan and the sheet builds the monthly phasing automatically using historical sales curves.
Department-level gross margin rate planning. Set initial margin targets, planned full-price sell-through assumptions, and markdown budget by department. Blended margin rolls up to the total.
Monthly receipt plan by department, linked to the sales and inventory bridge. Shows receipt dollars vs OTB budget and flags months where receipts exceed plan.
Calculates planned inventory turns from the sales plan and average inventory position. Set turn targets by department and model the inventory investment required to achieve them.
In-season tracking: enter actuals each month and the sheet calculates plan-vs-actual variance for sales, margin, and inventory. Flags where the season is running off-plan and by how much.
// When to Use It
The right situations for this template
Annual and seasonal planning
Build the top-down financial framework for the season before the assortment plan is developed. The MFP sets the guardrails — net sales targets, margin floors, receipt ceilings — that every downstream plan must stay within.
Finance and board reviews
The MFP format is designed to be handed to finance or presented to the board without cleanup. Net sales, margin, and inventory turn targets are summarised at the level finance needs — without requiring access to SKU-level detail.
Pre-season budget alignment
Use the MFP to align merchandising, buying, finance, and operations teams on the same seasonal financial targets before the assortment plan is built. Prevents OTB disagreements later in the process.
Mid-season performance review
The Plan vs Actual tab is designed for quarterly or monthly business reviews. Enter actuals and the template calculates variance to plan with enough detail to identify which departments are driving over- or under-performance.
// Get the Template
Download the MFP template
Merchandise Financial Plan (MFP) Template
A top-down seasonal financial planning workbook covering net sales, margin rate, receipt budget, and inventory targets — structured for executive planning reviews.
- Instant access
- No credit card
- Work email required
- Yours to keep
Enter your work email to get instant access. No spam, promise.
// What Spreadsheets Do Well
Honest about what works
Spreadsheet MFPs genuinely work in these situations — and this template is designed to maximise that utility.
// Where Templates Break Down
What a spreadsheet MFP cannot do
A structured MFP template is significantly better than an ad-hoc approach. It is not a system. Here is where the difference shows up in practice.
// Beyond the Template
How RetailNorthstar improves MFP management
RetailNorthstar makes the MFP a live document — not a snapshot from last quarter. Top-down targets flow automatically to every downstream plan, and plan-vs-actual updates from ERP actuals without manual work.
Top-down guardrails flow to every plan
In RetailNorthstar, MFP targets set the constraints for assortment planning and OTB automatically. When the MFP is revised, the downstream plans update — no manual reconciliation between files.
Margin calculated from live product data
Gross margin in RetailNorthstar is calculated from actual cost and selling prices at the SKU level, weighted by sell-through. The MFP margin rate reflects what is actually happening — not a season-start assumption.
Plan vs actual from ERP actuals automatically
RetailNorthstar pulls net sales, receipts, and inventory on hand from the ERP. The plan-vs-actual view is always current — no monthly data extraction, no formatting work.
Drill from financial plan to product plan in one click
When a department is underperforming, merchandising leaders can drill from the MFP summary to the assortment plan, the receipt flow, and the style-level sell-through — all in the same system.
// Common Mistakes
What goes wrong with MFP planning
These mistakes recur across apparel brands at every stage of planning maturity — from template-based teams to those with connected systems.
The MFP must come first. Set net sales, margin, and receipt budget targets before any assortment decisions are made. Assortment planning is a process of executing within the MFP — not setting it.
Adjust the prior year GMR for any known variables before finalising targets: vendor cost changes, AUR shifts, category mix changes, or new markdown policies.
Split the MFP into SS (Feb–Jul) and FW (Aug–Jan) before OTB planning begins. Most apparel brands run 55–60% of annual net sales in FW.
Set turn targets by department in the MFP. Let the implied average inventory investment constrain the receipt budget. Turns are a strategic input, not a reporting output.
Schedule a formal MFP reforecast at mid-season when 4–5 months of actuals are available. Update the remaining season forecast and revise OTB accordingly.
// Best Practices
How high-performing planning teams use the MFP
These practices determine whether the MFP is a live management tool or a pre-season document filed after the first buy review.
Build top-down, validate bottom-up
Set annual financial targets first. Then confirm that the assortment plan can deliver those targets within the receipt budget. Misalignment between top-down and bottom-up is best discovered before the buy, not after.
Set inventory turn targets before receipt budgets
Inventory turn determines average inventory investment, which determines how much buying room is available. Turn targets are inputs, not derived outputs. Set them first.
Plan initial markup and maintained margin separately
IMU is a sourcing and pricing decision. MMU (maintained margin) is a sell-through and markdown execution decision. Track both — and understand which is driving the margin gap when the plan misses.
Allocate markdown budget by risk profile, not as a flat percentage
New introductions carry more markdown risk than proven carry-overs. Categories with faster inventory turns carry less markdown risk than slow-moving departments. Apply markdown budget accordingly.
Use the MFP as the cross-functional reference document
Finance, buying, planning, and operations should all reference the same MFP — not their own versions of the financial plan. One document, one set of targets.
Document key planning assumptions explicitly
MFP numbers are only useful if stakeholders understand what they are based on. Document the sales curve assumptions, turn targets, and margin inputs so revisions are traceable and the plan can be updated without starting from scratch.
Merchandise Financial Plan (MFP) Template
A top-down seasonal financial planning workbook covering net sales, margin rate, receipt budget, and inventory targets — structured for executive planning reviews.
- Instant access
- No credit card
- Work email required
- Yours to keep
Enter your work email to get instant access. No spam, promise.
// What's Next
After you use the template
Most teams download a template and get a quarter of use from it. These three steps turn it into actual improvement.
Where does your planning operation actually stand?
Start hereBefore building on a template, benchmark your planning against 5 dimensions — infrastructure, responsiveness, alignment, data quality, and workflow. Takes 5–8 minutes. Results are instant.
When does the template stop being enough?
At some point templates hit a ceiling — OTB disconnected from assortment, actuals requiring manual entry, version chaos across buyers and planners. See exactly where the gap is.
What would a connected system look like for our team?
A 30-minute live walkthrough built around your actual planning workflow — OTB, assortment, and buy planning in one connected system.
// FAQs
Merchandise financial plan — common questions
What is a merchandise financial plan (MFP)?
A merchandise financial plan (MFP) is the top-down financial framework that governs all merchandising decisions for a season. It sets net sales targets, gross margin rate objectives, receipt budgets, and inventory turn goals by department — typically built before the assortment plan and used to align merchandising, buying, finance, and operations on the same financial targets.
Who builds the MFP in an apparel brand?
In brands with dedicated planning teams, the MFP is typically built by the Director of Planning or VP of Merchandising, in collaboration with finance. In smaller brands without a dedicated planning function, it is often built by the Founder, COO, or a senior merchandising lead. The MFP is a leadership-level financial document — not a buyer-level tool.
How does the MFP relate to the OTB plan?
The MFP is the top-down framework. The OTB plan is the operational output. The receipt budget in the MFP sets the total inventory spend available — OTB tracks how that budget is allocated and consumed over the season. The MFP tells you how much you can spend; OTB tracks whether you are staying within that limit.
How does the MFP relate to the assortment plan?
The assortment plan should be built within the financial guardrails the MFP sets — option counts and receipt units should stay within the OTB budget the MFP defines. Department-level margin targets in the MFP should be reflected in the assortment plan's margin bridge. In a well-run planning process, the MFP is built first, then the assortment plan executes within it.
How often should the MFP be updated?
The initial MFP is built pre-season — typically 4–6 months before delivery. Most brands reforecast the MFP at least once mid-season, and again at the end of the season for postmortem analysis. The plan-vs-actual tab in this template supports monthly or quarterly reviews without rebuilding the plan from scratch.
Is the MFP different from the open-to-buy plan?
Yes. The MFP is a strategic, top-down financial plan — it sets what the business is trying to achieve for the season. The OTB plan is an operational, real-time constraint — it tracks whether receipt spending is staying within the budget the MFP defines. The MFP is typically reviewed monthly or quarterly; OTB is typically managed weekly.
Related Resources
Ready for an MFP that stays current all season?
RetailNorthstar keeps your merchandise financial plan connected to live OTB, assortment, and buy data — plan-vs-actual updates automatically, no monthly extraction required.