Break-Even Analysis Template
Budgeting & Forecasting
Quick Answer
Enter your fixed costs variable costs and pricing. Paste into Claude or ChatGPT. Get your break-even point in revenue and units with sensitivity analysis and recommendations to improve profitability.
What You Get
A break-even analysis covering break-even revenue and units, contribution margin calculation, payback period from current revenue, sensitivity analysis on key variables, and specific recommendations to improve the break-even profile.
Who Is This For
Entrepreneurs evaluating a new business or product, business owners assessing profitability of a new service line, and startup founders planning the path to profitability.
About This Template
Break-even analysis tells you exactly how much revenue you need to cover all your costs — the minimum viable revenue for the business to survive. This template guides business owners through entering their fixed costs, variable costs, and pricing, then uses AI to calculate the break-even point and produce commentary on what the number means for the business, how sensitive it is to changes in pricing or costs, and the specific actions that would lower the break-even threshold.
Fill In Your Details
Your business or the specific product line you are analyzing
Costs that do not change with volume: rent, salaries, software subscriptions, insurance e.g. $45000 per month
Revenue per sale or per customer per month e.g. $299 per month per customer
Costs that scale with each unit sold: COGS, commissions, delivery costs e.g. $45 per customer
e.g. $28000 per month currently
e.g. 8 percent per month, or $3000 per month incremental
Gather these details then use them to fill in the prompt below.
AI Prompts
Generate break-even analysis
Paste this prompt into Claude or ChatGPT with your figures filled in.
You are a financial analyst conducting a break-even analysis. Using the data below, calculate the break-even point and produce a comprehensive analysis. Business: [business_name] Monthly fixed costs: [fixed_costs] Price per unit: [price_per_unit] Variable cost per unit: [variable_cost_per_unit] Current monthly revenue: [current_revenue] Monthly revenue growth: [revenue_growth] Calculate and explain: 1. Contribution Margin — price minus variable cost per unit, and contribution margin percentage 2. Break-Even Units — fixed costs divided by contribution margin per unit 3. Break-Even Revenue — break-even units multiplied by price 4. Months to Break-Even — based on current revenue and stated growth rate 5. Sensitivity Analysis — how break-even changes if price increases or decreases by 10 percent, and if fixed costs increase by 20 percent 6. Margin of Safety — how far current revenue is above or below break-even 7. Recommendations — specific actions to lower the break-even threshold Show all calculations clearly. Express break-even in both units and revenue.
Sample Output
This is an example of what AI produces when you use this template.
Break-Even Calculation
Contribution margin per customer: $299 minus $45 equals $254 per customer per month. Contribution margin percentage: 85 percent. Break-even customers: $45,000 fixed costs divided by $254 contribution margin equals 177 customers. Break-even monthly revenue: 177 customers multiplied by $299 equals $52,923 per month. Current monthly revenue of $28,000 represents 147 customers, which is 30 customers or $8,973 per month below break-even. At 8 percent monthly growth rate, break-even is reached in approximately 2.8 months.
Recommendations
Three actions would materially lower the break-even threshold: 1. Raise price from $299 to $329 — a 10 percent price increase reduces break-even to 161 customers and accelerates the break-even date by approximately 3 weeks. Churn risk is low at this price point for a B2B product. 2. Negotiate hosting and infrastructure contracts — a 20 percent reduction in the $8,000 monthly infrastructure cost reduces break-even by 31 customers. 3. Eliminate the $3,500 per month conference budget until break-even is reached — this reduces break-even to 164 customers with no impact on existing customer retention.