Aurum Model

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.

Pilates Addiction

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).

⬇ Download Excel template Bulk-add SKUs from a spreadsheet — appends to this model.

Aurum Import Parts Pilates Addiction 13/loc Price $850 Landed $595 Margin $255 (30%) Lead 90d 2 buy 1 sell

Name Brand Units / location Sale price Unit cost (base) Lead time (days) Buy from Buy until

Purchase window. Limits the months this SKU is ordered from the supplier. Leave either blank for no limit. The window gates on the order month (opening month minus lead time), so a SKU you stop buying in, say, July still supplies later openings whose orders were placed by July — and their receipts, revenue, and buy/sell payments keep flowing forward on the normal lead-time and payment schedule. Months are inclusive: “Buy until July 2026” means July is the last month you place an order.

Country of origin HTS code Tariff % Shipping / unit

Manufacturer Item number MOQ

Landed cost — Gross / unit — Margin — Markup —

Payment milestones Buy — Sell — (each side should total 100%)

%

% from opening

Payment milestones. Set when cash actually moves for this SKU — separate from when revenue and COGS are booked. Split into Buy (cash out to the supplier, a % of landed cost × units) and Sell (cash in from the customer, a % of sale price × units). Each side should total 100%. A milestone lands relative to an anchor, shifted by its ± offset (days or months; net-30 = 1 month):
• Buy “at order” = opening month − lead time (when you place the PO); “at receipt” = the opening month (when goods arrive).
• Sell “from opening” = the location opening / delivery month.
Examples — Buy: Deposit 30% at order + Final 70% at receipt pays 30% up front when the PO is placed and 70% on delivery. Sell: Deposit 50% from opening −30 + Final 50% from opening +30 collects half a month before the store opens and half a month after.

Aurum Manufacturing Pilates Addiction 13/loc Price $6,080 Landed $5,300 Margin $780 (12.8%) Lead 60d 2 buy 1 sell

Name Brand Units / location Sale price Unit cost (base) Lead time (days) Buy from Buy until

Purchase window. Limits the months this SKU is ordered from the supplier. Leave either blank for no limit. The window gates on the order month (opening month minus lead time), so a SKU you stop buying in, say, July still supplies later openings whose orders were placed by July — and their receipts, revenue, and buy/sell payments keep flowing forward on the normal lead-time and payment schedule. Months are inclusive: “Buy until July 2026” means July is the last month you place an order.

Country of origin HTS code Tariff % Shipping / unit

Manufacturer Item number MOQ

Landed cost — Gross / unit — Margin — Markup —

Payment milestones Buy — Sell — (each side should total 100%)

%

% from opening

Payment milestones. Set when cash actually moves for this SKU — separate from when revenue and COGS are booked. Split into Buy (cash out to the supplier, a % of landed cost × units) and Sell (cash in from the customer, a % of sale price × units). Each side should total 100%. A milestone lands relative to an anchor, shifted by its ± offset (days or months; net-30 = 1 month):
• Buy “at order” = opening month − lead time (when you place the PO); “at receipt” = the opening month (when goods arrive).
• Sell “from opening” = the location opening / delivery month.
Examples — Buy: Deposit 30% at order + Final 70% at receipt pays 30% up front when the PO is placed and 70% on delivery. Sell: Deposit 50% from opening −30 + Final 50% from opening +30 collects half a month before the store opens and half a month after.

Aurum Plating Pilates Addiction 13/loc Price $1,050 Landed $891 Margin $159 (15.1%) Lead 30d 1 buy 1 sell

Name Brand Units / location Sale price Unit cost (base) Lead time (days) Buy from Buy until

Purchase window. Limits the months this SKU is ordered from the supplier. Leave either blank for no limit. The window gates on the order month (opening month minus lead time), so a SKU you stop buying in, say, July still supplies later openings whose orders were placed by July — and their receipts, revenue, and buy/sell payments keep flowing forward on the normal lead-time and payment schedule. Months are inclusive: “Buy until July 2026” means July is the last month you place an order.

Country of origin HTS code Tariff % Shipping / unit

Manufacturer Item number MOQ

Landed cost — Gross / unit — Margin — Markup —

Payment milestones Buy — Sell — (each side should total 100%)

%

% from opening

Payment milestones. Set when cash actually moves for this SKU — separate from when revenue and COGS are booked. Split into Buy (cash out to the supplier, a % of landed cost × units) and Sell (cash in from the customer, a % of sale price × units). Each side should total 100%. A milestone lands relative to an anchor, shifted by its ± offset (days or months; net-30 = 1 month):
• Buy “at order” = opening month − lead time (when you place the PO); “at receipt” = the opening month (when goods arrive).
• Sell “from opening” = the location opening / delivery month.
Examples — Buy: Deposit 30% at order + Final 70% at receipt pays 30% up front when the PO is placed and 70% on delivery. Sell: Deposit 50% from opening −30 + Final 50% from opening +30 collects half a month before the store opens and half a month after.

Aurum Upholstery - Domestic Pilates Addiction 13/loc Price $655 Landed $555 Margin $100 (15.3%) Lead 30d Buy 2026-07 → 2026-10 1 buy 1 sell

Name Brand Units / location Sale price Unit cost (base) Lead time (days) Buy from Buy until

Purchase window. Limits the months this SKU is ordered from the supplier. Leave either blank for no limit. The window gates on the order month (opening month minus lead time), so a SKU you stop buying in, say, July still supplies later openings whose orders were placed by July — and their receipts, revenue, and buy/sell payments keep flowing forward on the normal lead-time and payment schedule. Months are inclusive: “Buy until July 2026” means July is the last month you place an order.

Country of origin HTS code Tariff % Shipping / unit

Manufacturer Item number MOQ

Landed cost — Gross / unit — Margin — Markup —

Payment milestones Buy — Sell — (each side should total 100%)

%

% from opening

Payment milestones. Set when cash actually moves for this SKU — separate from when revenue and COGS are booked. Split into Buy (cash out to the supplier, a % of landed cost × units) and Sell (cash in from the customer, a % of sale price × units). Each side should total 100%. A milestone lands relative to an anchor, shifted by its ± offset (days or months; net-30 = 1 month):
• Buy “at order” = opening month − lead time (when you place the PO); “at receipt” = the opening month (when goods arrive).
• Sell “from opening” = the location opening / delivery month.
Examples — Buy: Deposit 30% at order + Final 70% at receipt pays 30% up front when the PO is placed and 70% on delivery. Sell: Deposit 50% from opening −30 + Final 50% from opening +30 collects half a month before the store opens and half a month after.

Aurum Upholstery - Foreign Pilates Addiction 13/loc Price $600 Landed $422 Margin $178 (29.6%) Lead 90d Buy 2026-10 → 2027-12 2 buy 1 sell

Name Brand Units / location Sale price Unit cost (base) Lead time (days) Buy from Buy until

Purchase window. Limits the months this SKU is ordered from the supplier. Leave either blank for no limit. The window gates on the order month (opening month minus lead time), so a SKU you stop buying in, say, July still supplies later openings whose orders were placed by July — and their receipts, revenue, and buy/sell payments keep flowing forward on the normal lead-time and payment schedule. Months are inclusive: “Buy until July 2026” means July is the last month you place an order.

Country of origin HTS code Tariff % Shipping / unit

Manufacturer Item number MOQ

Landed cost — Gross / unit — Margin — Markup —

Payment milestones Buy — Sell — (each side should total 100%)

%

% from opening

Payment milestones. Set when cash actually moves for this SKU — separate from when revenue and COGS are booked. Split into Buy (cash out to the supplier, a % of landed cost × units) and Sell (cash in from the customer, a % of sale price × units). Each side should total 100%. A milestone lands relative to an anchor, shifted by its ± offset (days or months; net-30 = 1 month):
• Buy “at order” = opening month − lead time (when you place the PO); “at receipt” = the opening month (when goods arrive).
• Sell “from opening” = the location opening / delivery month.
Examples — Buy: Deposit 30% at order + Final 70% at receipt pays 30% up front when the PO is placed and 70% on delivery. Sell: Deposit 50% from opening −30 + Final 50% from opening +30 collects half a month before the store opens and half a month after.

Location Orders Forecast (Openings)

Store openings per brand per month — everything flows from here.

Brand	07/26	08/26	09/26	10/26	11/26	12/26	01/27	02/27	03/27	04/27	05/27	06/27
Pilates Addiction

OPEX Detail (bottom-up)

Monthly total: $0

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

Each line: total ÷ months principal + interest on remaining balance

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.

No funding lines yet — add one below to start modeling capital flows.

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

Each scenario captures its own openings / COGS / OPEX flex — values shown are independent of the live page sliders.

Financial Output

1,125,000 +225,000 Top line is the scenario amount; the smaller figure below is the change vs. the base scenario (green = better, red = worse). It only appears when a sensitivity scenario is active.

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.

Model Settings

Brands

SKU Detail

Location Orders Forecast (Openings)

OPEX Detail (bottom-up)

Capital / Funding

Capital & Exit

Saved scenarios

Financial Output

Location Orders Forecast — planned store openings per brand

Projected P&L

Projected Cash Flow

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