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.
| Metric | Tops | Bottoms | Outerwear | Accessories | TOTAL |
|---|---|---|---|---|---|
| Net Sales | $620,000 | $450,000 | $310,000 | $200,000 | $1,580,000 |
| IMU % | 68.0% | 65.0% | 72.0% | 70.0% | 68.2% |
| Markdown Rate | 18.0% | 22.0% | 12.0% | 15.0% | 17.6% |
| Reductions Rate | 21.0% | 25.0% | 14.0% | 18.5% | 20.4% |
| ··· | ··· | ··· | ··· | ··· | ··· |
// 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 the annual plan and monthly cadence to the margin bridge and the in-season actuals review.
The six steps to work the file — plan annually, weight the months, phase planned reductions, enter receipts and opening inventory, fill in actuals in-season, review the bridge — plus how the file treats reductions in stock, receipts, margin, and turn, and the cost-complement MMU definition the formulas actually use.
Department-level annual plan: net sales, returns, IMU, planned reductions (markdown, discount, and shrink and other-loss rates, with their retail dollars), maintained margin (MMU) net of all three, COGS, and gross margin dollars. The TOTAL column uses sales-weighted rates — never simple averages — so the blended plan is honest.
Weight the months and the sheet phases the annual plan into a 12-month cadence — normalised so the months always sum exactly to the annual total. Includes prior-year comparison, monthly planned reductions reconciled to the Annual Plan, planned receipts, a beginning/ending inventory bridge that deducts reductions (EOM = BOM + receipts − sales − reductions), and actuals rows that calculate plan-vs-actual variance as months close.
The IMU-to-MMU waterfall: margin at initial markup, the cost-complement deductions for markdowns, discounts, and shrink and other losses, and net gross margin — with a live check row that ties back to the Annual Plan to the dollar.
A one-page finance view: totals, blended IMU / markdown / total-reductions / MMU / margin rates, planned reductions and FY receipts, and YTD actual vs YTD plan with variance — computed over closed months only, so open months never dilute the read.
// 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 actuals rows on the Monthly Cadence tab are designed for monthly or quarterly business reviews. Enter actual net sales as months close and the template calculates plan-vs-actual variance in dollars and percent, with the YTD read summarised on the Executive Summary tab.
// Get the Template
Download the MFP template
Merchandise Financial Plan (MFP) Template
A top-down seasonal financial planning workbook covering net sales, planned reductions, margin rate, receipt budget, and inventory targets — structured for executive planning reviews.
- Emailed to you
- No credit card
- Work email required
- Yours to keep
For brand, retailer, wholesaler and manufacturer teams. We email the link to your work address; requests from companies we can’t verify are reviewed first.
// 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, planned reductions, margin rate, receipt budget, and inventory targets — structured for executive planning reviews.
- Emailed to you
- No credit card
- Work email required
- Yours to keep
For brand, retailer, wholesaler and manufacturer teams. We email the link to your work address; requests from companies we can’t verify are reviewed first.
// 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 actuals rows on the Monthly Cadence tab support 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.
No credit card. No commitments.
Connected merchandise planning — live in weeks, not quarters.