Pawganix — Interactive Product Financial Model

Amazon FBA — Inputs

Business metrics

Monthly Units Sold Avg Selling Price (ASP, $) COGS per Unit ($) Bulk Shipping (supplier → FBA) per Unit ($)

Sea/air freight per unit landed at Amazon. Often absorbed in landed COGS.

Amazon fees

Referral Fee (% of ASP) FBA Fulfillment Fee per Unit ($) Storage Rate ($/cu ft/mo) Avg Product Volume (cu ft/unit) Inbound Shipping to FBA per Unit ($) Return Rate (%) Return Processing Fee per Return ($) Long-Term Storage Buffer (% of inv) LTS Rate ($/cu ft)

Advertising

TACOS — Total Ad Cost of Sales (%)

TACOS = Ad spend ÷ Total Revenue. e.g. 30% TACOS on $30,000 revenue = $9,000 ad spend.

Coupon Discount (% off price) Coupon Redemption Rate (%) Coupon Fee per Redemption ($)

Operating overhead

Amazon Seller Subscription ($/mo) Tools & Software allocated ($/mo) Marketing / Agency allocated ($/mo) Photography & Listing amortized ($/mo) Miscellaneous (% of revenue)

Catch-all buffer for unplanned ops costs. Default 2.5% of gross revenue. Allocations split across SKUs — enter this product's share.

Monthly P&L — Amazon FBA

Unit Economics (per unit sold)

Volume Sensitivity — Net Profit by Monthly Units

Holds price & cost structure constant. Fixed overhead (subscription, tools, marketing, photo) does not scale with volume; everything else does.

Shopify DTC (Private Label) — Inputs

Fulfillment mode

Business metrics

Monthly Orders Average Order Value ($) Items per Order (avg) COGS per Unit ($) Avg Discount Rate (% of gross) Return Rate (%)

Fulfillment & logistics

Bulk Shipping (supplier → US) per Unit ($) Domestic Shipping per Order ($) Pawganix-paid (S&S/free-ship) Buyer-Paid Shipping Order % orders where buyer pays at checkout (typically non-S&S) Pawganix Residual on Buyer-Paid ($/order) handling/packaging cost we still bear Pick & Pack Base ($/order) (3PL only) Additional Item Fee ($/extra item) Packaging per Order ($) Storage ($/SKU/mo or warehouse rent) # SKUs (3PL) / 1 if self Returns Processing Fee per Return ($) Receiving Fee per Unit ($) Monthly Inventory Received (units) 3PL Monthly Minimum ($)

Marketing & Acquisition

Marketing Spend (% of gross revenue) applied to non-email, non-sub-renewal portion Platform / Transaction Fee (% of net rev) Affiliate / Influencer Commission (% of gross) Email / SMS Attributed Revenue (%) owned channel, no paid CAC Chargeback Reserve (% of gross) 0.5–1% typical for sub products

Customer Lifetime Value (LTV)

Subscription % of New Orders Subscription Monthly Churn (%) Subscription Discount (%) Non-Subscriber Repeat Orders / Year

Avg sub length = 1 / churn (e.g. 8% churn → 12.5 months). Blended LTV = AOV × [sub% × sub_length + (1 − sub%) × repeat_freq]. CAC payback shown in KPI bar.

Portfolio Mix (Blended Sales Modeling) — optional, leave shares at 0 for single-product mode

When share > 0 in any row, the model auto-overrides AOV/COGS/Items above with the weighted blend. Edit each product's AOV/COGS here to match your current catalog. Bundle dynamics apply when orders contain 2+ items.

Order Share %

AOV / COGS ($)

🛡️ YeastGuard

💪 MoveGuard Adult

🐕 MoveGuard Growth

🐈 CalmGuard Pheromone

Bundle Dynamics

Bundle Attach Rate (% of orders with 2+ products) Avg Items per Bundle Order Bundle AOV Lift (%) value premium of bundling Bundle Discount (%) discount to drive bundle attach

Overhead & Labor

Shopify Plan + Core Tools ($/mo) Marketing & Retention Apps ($/mo) Klaviyo, Yotpo, Recharge, Triple Whale, Loop, etc. Back-office Overhead ($/mo) Bookkeeping, sales tax, insurance, legal Labor / Operations Salary ($/mo) Founder draw, VA, CS rep

Monthly P&L — Shopify DTC

Unit Economics (per order)

Volume Sensitivity — Net Profit by Monthly Orders

LTV / CAC Sensitivity — Effect of Sub % & Email %

Side-by-Side

Both channels using current inputs. Add the two if running concurrently.

Combined P&L

Launch costs (one-time + first 3 months)

Pre-launch (one-time)

Product Development / Sampling ($) Initial Inventory — Amazon ($) Initial Inventory — Shopify ($) Photography & Video ($) Listing / A+ / Storyboards ($) Store Design (Shopify) ($) Brand Registry / Trademark ($) UPC / Barcodes ($) Package Design & Inserts ($) Legal / Business Formation ($) Pre-Launch Marketing / Seeding ($) Misc / Contingency ($)

Launch phase (monthly, first 3 months)

Elevated PPC / Ad budget ($/mo) Launch Promotions / Discounts ($/mo) Review Acquisition / Vine ($/mo) Influencer / Creator ($/mo) Content Creation ($/mo) PR / Press ($/mo) Top-up Inventory ($/mo) Misc launch ($/mo)

Ramp assumptions

Month 1 — % of steady-state revenue Month 2 — % Month 3 — % Months to full steady-state

24-month cash flow projection

Investment summary

📊 High-Level Portfolio Forecast

✓ Saved

Multi-product × multi-platform revenue and profit modeling. Set monthly quantities and prices for each product/platform pair, then watch the portfolio totals update in real time. Add new products as your catalog grows. Every edit autosaves to the cloud — bookmark this URL and open it on any device to pick up where you left off.

Portfolio totals — by product

Per-product roll-up — same view as your Notion "Blended total" table, auto-calculated.

Portfolio totals — by platform

Channel-mix view — which platform is driving how much revenue and profit across the entire portfolio.

📦 Inventory & Re-order Planner

Edit each row. The Latest re-order date is computed so a new batch lands just before you run out — and it already bakes in a 5 business-day safety buffer. Add a row for any future product.

Logic: days of stock = inventory ÷ daily sales; total lead time = (manufacturing + Amazon stocking) weeks × 7; latest re-order date = (today-of-row + days of stock − total lead time) − 5 business days.

Product	As-of date	Inventory (units)	Daily sales (units/day)	Mfg lead (wks)	Amazon lead (wks)	Latest re-order date incl. 5 biz-day buffer

🟢 plenty of runway · 🟠 order within ~2 weeks · 🔴 overdue — order now. Estimated stock-out date shown under each computed date.