Build a Break-Even and Pricing Calculator Spreadsheet in Excel
You get an Excel layout that separates fixed and variable costs, formulas for break-even and margin at three prices, and a ranking of which inputs move the result most.
Prompt
You are a small-business financial analyst who builds clear, simple Excel models.
Your job: build a break-even and pricing calculator spreadsheet for my product or service. First ask me these questions in one message, then wait for my answers:
1. What do you sell, and what is one unit (an item, an hour, a monthly subscription)?
2. What are your monthly costs that stay the same regardless of sales, and your costs per unit sold, with rough amounts?
3. What price do you charge now, or what range are you considering?
4. How many units do you expect to sell per month?
Rules:
- Put fixed and variable costs on an Inputs sheet, one cost per row, so I can edit any number.
- Give exact Excel formulas with cell references for contribution margin, margin %, break-even units (rounded up) and profit.
- Model three price points: current, 15% lower and 15% higher.
- Change price, fixed costs and variable cost by 10% each, report the effect on break-even units, and rank the inputs by impact.
- Flag any cost that looks missing or unrealistic.
Output format:
1. Sheet layout table (Cell, Label, Value or Formula)
2. Price comparison table (Price, Contribution margin, Margin %, Break-even units, Profit at expected volume)
3. Sensitivity ranking table (Input, Effect of +10%, Rank)
4. Three-sentence takeaway
End with one line on assumptions made and costs that may be missing. This is not professional financial advice; check major pricing decisions with an accountant.Example output
Tips and common edits
Why this works
- Asking four questions first means the model works with your real costs instead of generic numbers.
- Requiring cell-referenced formulas gives you a working sheet, not just a one-off calculation.
- The 10% sensitivity test shows which input to focus on, turning numbers into a pricing decision.
Use when setting or reviewing a price. Have your monthly fixed costs, per-unit costs, current price and expected sales ready. Works in ChatGPT, Claude or Gemini; paste the formulas straight into Excel or Google Sheets.
Common edits
- Change the price points to fixed dollar amounts you are actually considering.
- Add a column for a target monthly profit and ask for units needed to reach it.
Prompt details
- By
- Prompts-GPT editors
- Published
Did this prompt work?
Keep exploring
More like this
Build a 13-Week Cash Flow Forecast in Excel with Low-Balance Alerts
You get a 13-week cash flow sheet layout with committed and expected cash split apart, exact running-balance formulas, and red flags for weeks below your minimum.
Build an Employee Shift Schedule and Hours Tracker with Overtime in Excel
You get a ready-to-build spreadsheet layout with formulas for overnight shifts, unpaid breaks, weekly hours per employee and highlighted overtime.
Build an Inventory Tracker Spreadsheet with Reorder Points and Low-Stock Alerts
You get exact columns, copy-ready reorder-point formulas, a status column and conditional formatting that highlights items to reorder now or this week.
Build an Invoice Template in Excel or Google Sheets with Automatic Totals
You get a cell-by-cell invoice layout with exact formulas for line totals, discount, tax, due date, and a duplicate-proof invoice numbering system.
Build a Budget vs Actual Variance Analysis That Separates Timing from Overspend
Get a variance table with dollar and percent variances, a materiality filter, timing vs permanent labels, short explanations with next actions, and Excel formulas.
Build a Power Query Workflow That Combines and Cleans Monthly Excel Files
You get numbered Power Query steps with paste-ready M code, a full query, and a flag on every step that breaks when column names change.