Use the left and right arrow keys to move between preview images.
Spreadsheet · Digital download
Subscription Box Profit Planner
Cost each box tier line by line, see contribution and LTV for monthly, prepaid and gift plans, and forecast 24 months of subscribers, profit and payback.
- Instant digital download — nothing is shipped.
- Secure checkout by Stripe.
- Version 1.0.0 · updated Nov 9, 2026.
Description
For founders running or planning a subscription box who want to know what each box really earns and when the business pays back.
Box Builder costs up to 3 tiers from 45 component lines (product, packaging, printed inserts, fulfilment, shipping), with a breakdown by type. Plans handles up to 6 monthly, prepaid and gift plans: revenue, box cost, processing and platform fees and contribution per box, then churn per renewal converted to monthly churn, expected lifetime, LTV, LTV:CAC and CAC payback. The Forecast runs 24 months of new and active subscribers by plan, boxes shipped, revenue, costs, marketing, fixed costs, net and cumulative profit, and the Dashboard shows the first profitable month and payback month. Price Tester tries up to 7 price changes on one plan, each with the churn you expect at that price.
Included: worked-example and blank workbooks (7 sheets, 665 formulas) and a 4-page guide (US Letter and A4).
Processing and platform fees are editable inputs with a dated source: verify your provider's current rates. Revenue is counted per box shipped; prepaid cash timing isn't modelled. General information, not financial, tax or investment advice.
Who it's for: Subscription box founders and small e-commerce brands adding a subscription (tea, coffee, snacks, books, beauty, crafts, pets)..
Included files
- subscription-box-profit-planner-v1.0.0-all-files.zipAll files in one ZIP (includes licence)ZIP
- Subscription-Box-Profit-Planner-Example.xlsxWorkbook with a fictional tea subscription box: 7 sheets, 665 formulasXLSX
- Subscription-Box-Profit-Planner-Blank.xlsxBlank workbook ready for your boxXLSX
- Subscription-Box-Profit-Planner-Guide-Letter.pdfGuide (US Letter, 4 pages): worked example, plan economics, 24-month forecast, price testerPDF
- Subscription-Box-Profit-Planner-Guide-A4.pdfGuide (A4, 4 pages)PDF
- LICENCE.txtLicence summaryTXT
- Plus a single ZIP with every file and the licence (364 KB).
How to use
Open the blank .xlsx and read Start Here. Fill Settings, Box Builder and Plans, then read the Forecast and Dashboard and try prices on Price Tester.
Customer reviews
No reviews yet. Reviews can only be written by customers who own this product.
Frequently asked questions
Is this a physical product?
No. This is a digital download. Nothing is shipped — you download the files from your account after purchase.
How do I get my files?
After payment, go to My Downloads in your account. Your purchase stays available there to re-download.
What can I do with it?
Use for yourself, your household or your own business. Print unlimited copies for that use. No reselling or sharing the files.
Does it handle prepaid and gift plans?
Yes. Set billing every 1, 3, 6 or 12 months with the price per billing. Revenue is spread per box shipped, the fixed card fee is charged once per period, and churn per renewal is converted to a monthly rate.
Is the cash from prepaid plans shown up front?
No. Revenue is counted when each box ships, so the forecast shows profit, not cash. Prepaid cash timing isn't modelled.
Are the processing fees current?
They're editable inputs. The default 2.9% + 30¢ was Stripe's US list price on 2026-11-09. Verify your own provider's rate.
Which apps has it been tested in?
LibreOffice Calc (recalculated and checked against expected values). Not tested in Excel, Google Sheets or Numbers.
You may also like
- New
- New
- New
- New
- New
- New




