FFE Initial Cash Modeling
Model Settings
Date range, annual price escalation, and starting cash for the cash-flow projection.
Brands
The brands in this model. Openings are entered per brand; each brand gets its own SKU mix below.
SKU Detail
Each SKU belongs to a brand and sets its own units per location. It also has a sale price, base unit cost, country of origin, HTS code, tariff % and inbound shipping. Landed cost = base cost × (1 + tariff%) + shipping; margin & markup update live, and the financials use the landed cost for COGS. Buy (cash out to supplier) anchors to order (opening − lead time) or receipt (opening date). Sell (cash in from customer) anchors to the location opening date — deposits land before (− days), final payments after (+ days). Percentages are of unit cost (buy) or sale price (sell).
Beem Millwork Beem 1/loc Price $16,000 Landed $10,250 Margin $5,750 (35.9%) Lead 0d 1 buy 1 sell
Sauna Beem 4/loc Price $7,500 Landed $6,150 Margin $1,350 (18%) Lead 45d 2 buy 1 sell
Body20 Millwork Body20 1/loc Price $20,000 Landed $15,000 Margin $5,000 (25%) Lead 0d 1 buy 1 sell
iFlex Metal iFlex 3/loc Price $6,025 Landed $4,587 Margin $1,438 (23.9%) Lead 0d 2 buy 1 sell
iFlex Millwork iFlex 1/loc Price $20,000 Landed $16,000 Margin $4,000 (20%) Lead 0d 1 buy 1 sell
iFlex Retail iFlex 1/loc Price $3,473 Landed $2,665 Margin $808 (23.3%) Lead 30d 1 buy 1 sell
iFlex Shipping iFlex 1/loc Price $4,665 Landed $3,365 Margin $1,300 (27.9%) Lead 0d 1 buy 1 sell
iflex Wall Finish iFlex 1/loc Price $4,330 Landed $1,897 Margin $2,433 (56.2%) Lead 0d 2 buy 1 sell
Aurum Import Parts and Upholstery Pilates Addiction 13/loc Price $1,175 Landed $1,007 Margin $168 (14.3%) Lead 45d 2 buy 1 sell
Aurum Metal Manufacturing Pilates Addiction 13/loc Price $6,300 Landed $5,300 Margin $1,000 (15.9%) Lead 0d 2 buy 1 sell
Aurum Plating Pilates Addiction 13/loc Price $1,050 Landed $891 Margin $159 (15.1%) Lead 0d 1 buy 1 sell
PA Millwork Pilates Addiction 1/loc Price $53,000 Landed $38,000 Margin $15,000 (28.3%) Lead 0d 1 buy 1 sell
PA Millwork Shipping Pilates Addiction 1/loc Price $8,800 Landed $7,750 Margin $1,050 (11.9%) Lead 0d 1 buy 1 sell
Reformer Shipping Pilates Addiction 1/loc Price $9,900 Landed $8,800 Margin $1,100 (11.1%) Lead 0d 1 buy 1 sell
ULC Equip Coordination ULC 1/loc Price $2,500 Landed $0 Margin $2,500 (100%) Lead 0d 0 buy 1 sell
ULC Millwork ULC 1/loc Price $60,000 Landed $40,000 Margin $20,000 (33.3%) Lead 0d 1 buy 1 sell
ULC Wall Finishes ULC 1/loc Price $20,000 Landed $14,000 Margin $6,000 (30%) Lead 0d 1 buy 1 sell
Location Orders Forecast (Openings)
Store openings per brand per month — everything flows from here.
OPEX Detail (bottom-up)
Build OPEX from the ground up, line by line. Each item applies to every month (escalated by the OPEX annual increase) and is paid in-month. Collapse the list once it's set — the totals stay live.
Capital / Funding
One row per debt / repayment schedule (loan, financed equipment, owner draws, etc.). Enter the total amount, the period it's paid over, and the annual interest rate. The cash flow will show a monthly outflow of principal (total ÷ months) plus interest charged on the remaining balance. Hits the cash balance only — does not touch P&L.
Capital & Exit
Cost of capital charges interest each month on any financing shortfall (a negative running cash balance) — it shows as an Interest line in the P&L and is paid in the cash flow. Exit value applies your multiple to the chosen metric for a selected period. Both update live with the sensitivity scenario.
Saved scenarios 2
Each scenario captures its own openings / COGS / OPEX flex — values shown are independent of the live page sliders.Per-brand adjustments — openings & COGS
Financial Output
Location Orders Forecast — planned store openings per brand
Projected P&L
Projected Cash Flow
Running balance starts from opening cash ($0) plus YTD net cash. Cash is timed by each SKU's payment milestones (deposits & final payments), lead time, and OPEX.
By Brand & SKU — product P&L & cash flow, each SKU under its brand subtotal (OPEX, interest & capital are company-wide — see the totals above)
SKU Summary
Included SKUs only — price, landed cost & margin per unit.