Editable Pop Up Shop Financial Model in Excel

What you'd pay a freelance analyst: $2,000+. What you'd spend building it yourself: a week.
Pop-Up Shop Financial Model head image: overview of the model’s purpose and structure, highlighting key tabs, outputs, and how it helps founders forecast cash runway, test scenarios, and prepare investor-ready projections.
Fully Editable
Instant Download
Professional Design
Pre-Built
No Expertise Is Needed
Pop-Up Shop Financial Model head image: overview of the model’s purpose and structure, highlighting key tabs, outputs, and how it helps founders forecast cash runway, test scenarios, and prepare investor-ready projections.
Industry Benchmarks
Projected balance sheet
Capital expenditure plan
Capitalization table
Cash flow forecast
Financial charts
COGS & Operating expense forecast
Financial model dashboard
DuPont analysis
Projected income statement
Payroll forecast
Financial ratio analysis
Return on invested capital analysis
Revenue forecast
Financial scenario analysis
Sources and uses of funds
Financial model summary
Top expense analysis
Top revenue streams
Business valuation analysis
Revenue forecast
Fully Editable
Instant Download
Professional Design
Pre-Built
No Expertise Is Needed
Pop-Up Shop Bundle
See included products:
Financial Model iPop-Up Shop Bundle Financial Model template included in this product.
$149 $109
ADD TO YOUR ORDER
Business Plan iPop-Up Shop Bundle Business Plan template included in this product.
$79 $59
Pitch Deck iPop-Up Shop Bundle Pitch Deck template included in this product.
$49 $29
YOU SAVE $0 TODAY
30-Day Money-Back Guarantee
Created by a Former CFO
Updated for 2026
One-Time Purchase
Description

The Pop-Up Shop Financial Model is an Excel template for a recurring gift-and-accessories store. It links traffic, conversion, product mix, prices, merchandise costs, staffing, and initial funding to five-year projections.

The illustrated 500-square-foot shop rotates quarterly among mid-cost U.S. neighborhood spaces. Its 2026–2030 forecast assumes 20 trading days monthly and demand-driven sales without a store-capacity cap.

Forecast
5annual forecast years
Product categories
5merchandise groups
Trading days
20per modeled month
INSIDE THE EXCEL MODEL

What Is Included in This Pop-Up Shop Model?

The workbook links retail assumptions and monthly calculations with financial statements, financing controls, and decision-focused reports.

Revenue & Calc

Edit visitor traffic, conversion, items per sale, product mix, prices, and seasonality. Calc produces monthly items sold and revenue by category.

COGS & OPEX and Payroll

Plan merchandise, freight, packaging, stock loss, payment fees, advertising, temporary overhead, and role-based salaries without double-counting payroll.

CAPEX, CapTable & Debt

Record reusable equipment, startup assets, equity contributions, and optional debt facilities with repayment schedules.

Financial Statements & Dashboard

Review the Income Statement, Cash Flow, Balance Sheet, combined Summary, sales mix, and selected-scenario metrics.

Returns, Scenarios & Checks

Explore break-even, payback, ROIC, Low/Base/High cases, and workbook reconciliation checks.

RETAIL REVENUE FORECAST

How Does the Model Calculate Monthly Shop Sales?

Revenue starts with entering shoppers, converts them into purchases, and prices the items sold across five merchandise categories.

Monthly item demand equals trading days times visitors per day, purchasing conversion, and items per purchase, adjusted for seasonality. That demand is distributed among categories without a separate sales-capacity ceiling.

The item mix is 25% candles, 20% jewelry, 20% tote bags, 15% art prints, and residual 20% ceramics. Each category earns items sold times its annual unit price.

Revenue Forecast

The Revenue Forecast presents visitor demand, product mix, prices, and category sales. Compare how conversion, traffic, or merchandise allocation changes projected revenue.

pop up shop financial model revenue fml30
2026 sales in a month with a 1.0 seasonal multiplier

20 days × 150 visitors × 22% conversion × 1.4 items = 924 items; 924 × $31.80 weighted item price ≈ $29,383 in sales.

Seasonal factors total 12.0 in 2026, with 0.8 in January and February and 1.5 in December. Illustrated annual sales reach $352,598, not historical results.

Although launch is January 31, 2026, January counts as a full operating month; prelaunch sales are zero.

RETAIL COST STRUCTURE

How Are Inventory, Overhead, and Payroll Modeled?

Direct and sales-linked costs scale with revenue, while temporary rent, support expenses, and base staffing follow separate schedules.

Direct costs total 53% of revenue: merchandise 48%, freight 2.5%, packaging 1.2%, and stock loss 1.3%. Variable costs add 3% processing and 2.5% advertising.

Fixed expenses cover rent, utilities, insurance, software, storage, administration, fixture moves, and maintenance. Example 2026 rent is $4,000 monthly for 12 paid months; total annual fixed costs are $68,100.

COGS and Operating Expenses

The COGS and Operating Expenses report distinguishes direct merchandise costs, variable spending, and fixed overhead. Edit its rates and monthly amounts to test projected margins.

pop up shop financial model cogs opex fml30

In 2026 staffing is one manager plus 0.75 associate FTE. At $45,000 per manager and $37,440 per associate FTE, annual payroll is $73,080; with 1.0 associate FTE, 2030 payroll is $82,440.

Payroll Forecast by Staff Role

The Payroll Forecast schedules role-based FTE, annual salaries, and employment dates. Monthly personnel costs flow to the statements separately from merchandise and operating overhead.

pop up shop financial model payroll fml30
OPENING INVESTMENT & FUNDING

What Capital Does a Temporary Retail Shop Require?

The model keeps reusable assets, other opening cash needs, working capital, and owner funding distinct from ongoing operating earnings.

Assets include $4,500 fixtures and lighting, $1,200 POS equipment, and $1,300 signage and security: $7,000 total. Separate opening cash covers deposits, permits, launch marketing, decor, and preopening wages.

Capital Expenditure Plan

The Capital Expenditure Plan records asset purchases, timing, and depreciation treatment. It separates investment in movable displays and POS hardware from recurring shop expenses.

pop up shop financial model capex fml30

Working capital assumes zero receivable days, zero payable days, and 45 inventory days. Initial owner funding of $124,777 reflects opening assets, other launch cash, net working capital, a three-month reserve, and funding offsets.

No extra deficit buffer is built into this opening funding estimate. Adjust inventory, deposits, assets, and contributions before evaluating liquidity.

Sources and Uses of Funds

The Sources and Uses of Funds report reconciles equity, debt, investment, payments, and retained cash. It keeps owner contributions distinct from merchandise revenue.

pop up shop financial model sources uses fml30
ILLUSTRATIVE FIVE-YEAR RESULTS

What Do the 2026–2030 Financial Projections Show?

The example operating forecast shows sales growth and rising EBITDA as visitor conversion, traffic, and annual selling prices change.

Illustrative operating forecast, U.S. dollars
Year Revenue Operating Expenses EBITDA
2026 $352,598 $347,450 $5,148
2027 $404,997 $382,018 $22,979
2028 $462,487 $419,626 $42,861
2029 $525,428 $460,486 $64,942
2030 $571,224 $493,253 $77,971

Illustrative model outputs, not observed business results; displayed amounts are rounded independently to whole dollars.

Revenue increases from $352,598 in 2026 to $571,224 in 2030, while EBITDA rises from $5,148 to $77,971. EBITDA margins are approximately 1.5% and 13.6%.

EBITDA excludes interest, taxes, depreciation, and amortization; it is not net profit or cash. The Income Statement, Balance Sheet, and Cash Flow Statement address those separate perspectives.

Cash Flow Forecast

The Cash Flow Forecast reconciles operating, investing, and financing activity to closing cash. Evaluate inventory, equipment purchases, equity funding, and debt payments here rather than relying on EBITDA for liquidity.

pop up shop financial model cf fml30
BREAK-EVEN & INVESTMENT DECISIONS

How Can the Model Test Break-Even and Payback?

The Returns and scenario reports evaluate distinct operating and investment questions beyond the example EBITDA projection.

Sales break-even concerns the revenue needed to cover operating costs; cash break-even considers when cash balances cover requirements. Payback tracks invested-fund recovery, while annual ROIC relates returns to invested capital.

Dashboard Scenario Controls set Low, Base, and High multipliers for revenue, direct costs, variable costs, fixed costs, and payroll. Compare profitability across cases.

Break-Even, Payback and ROIC

The Returns report covers sales break-even, cash break-even, investment payback, and annual ROIC. Positive illustrative EBITDA does not establish a payback month or ROIC.

pop up shop financial model returns fml30
MODEL FIT

Who Can Use This Pop-Up Retail Template?

It is suited to evaluating one rotating gift-and-accessories storefront with demand-driven sales and recurring monthly operating commitments.

Evaluate traffic, conversion, merchandise mix, pricing, rotating locations, rent, and staffing. Replace the estimated inputs with your own observations and costs.

Benchmarks compare projected KPIs with user-entered reference values; Valuation provides DCF and terminal sensitivities. Neither establishes an industry average or guaranteed valuation.

FREQUENTLY ASKED QUESTIONS

Pop-Up Shop Financial Model FAQs

Answers to common questions about inputs, forecasting mechanics, funding, and financial reports.

Can I change visitor traffic and conversion?

Yes. Edit the trading days, entering visitors, purchasing conversion, and items per purchase to recalculate demand-driven sales.

Which products are included in the revenue model?

The five product groups are candles, jewelry, tote bags, art prints, and ceramics, each with a share of sold items and annual selling prices.

Does store floor space limit the sales forecast?

No. The documented calculation is demand-based and does not impose a separate capacity ceiling on monthly sales.

Can I change monthly seasonality?

Yes. The Revenue inputs use a repeating 12-month set of seasonal multipliers, including an elevated December factor in the illustrative case.

Are manager and associate wages counted twice?

No. The documented fixed base salaries are included in Payroll, separately from direct costs, variable expenses, and fixed operating expenses.

Does the model distinguish startup funding from sales?

Yes. Assets, other opening cash needs, working capital, and owner contributions are separate from recurring merchandise revenue and operating EBITDA.

Does the workbook include cash flow and financial statements?

Yes. It includes the Income Statement, Cash Flow Statement, Balance Sheet, and a combined Summary, alongside forecasting and financing schedules.

Does positive EBITDA prove the investment pays back?

No. Operating EBITDA is not cash flow, and investment payback and ROIC require their own calculations and assumptions.

What Does the Pop-Up Shop Financial Model Contain?

pop up shop financial model dashboard fml30

Financial Dashboard

KPIs, forecasts, and cash flow at a glance.

pop up shop financial model revenue fml30

Revenue Engine

Key assumptions and calculations driving revenue forecasts.

pop up shop financial model sources uses fml30

Sources & Uses

Funding sources, spending, and closing cash.

pop up shop financial model returns fml30

Returns & Break-Even

Cash break-even, payback, and ROIC.

pop up shop financial model valuation fml30

Business Valuation

DCF valuation and sensitivity analysis.

pop up shop financial model top expenses fml30

Expense Breakdown

Largest costs and spending trends.

pop up shop financial model summary fml30

Financial Summary

Annual and monthly financial performance.

pop up shop financial model benchmarks fml30

KPI Benchmarks

Compare margins and returns to benchmarks.

Trusted by 25,000+ startup founders, investors and CPAs

Scenario Planning Made Simple

Mia Thompson, NY

4 star rating

The low, base, and high cases were a mess before this template. I saved hours setting up our pop-up shop forecast and could finally compare assumptions side by side.

Cleaner Reports In One Place

Daniel Reed, IL

4 star rating

I used to dig through separate files for statements and charts. Now everything is in one model, and I had a clean update ready for our meeting in under an hour.

Easy To Use For Non-Experts

Priya Patel, CA

5 star rating

I’m not great with advanced Excel, but this template kept the hard parts out of my way. I filled in the inputs, understood the logic, and booked a planning call the same day.