Break-even Analysis

Model fixed and variable costs, explore what-if scenarios, and find your break-even point in one browser page.

Overview

Break-even Analysis is a single-page app for finance and operations teams who need to understand unit economics without a spreadsheet. Enter cost and price assumptions, see break-even metrics update live, compare scenarios in a grid, chart cost vs revenue, export to Excel, and save snapshots that persist in your browser.

Key features

Cost & price inputs

• Form fields for fixed costs, variable cost per unit, selling price, and expected volume.
• Values update break-even calculations instantly as you type.
• Break-even formula panel shows the contribution-margin math with a live worked example.

Summary cards

• Four KPI cards at the top of the page:
• Break-even units — how many units you must sell to cover fixed costs.
• Break-even revenue — dollar revenue at the break-even volume.
• Contribution per unit — selling price minus variable cost.
• Margin of safety — percent cushion above break-even at your expected volume.
• Cards use color-coded left borders and adapt to dark mode.

What-if sliders

• Alpine.js range sliders mirror the four main inputs.
• Live formatted values appear beside each slider as you drag.
• Moving a slider recalculates summary cards, the chart, and the scenario grid.

Cost vs revenue chart

• Chart.js line chart plots total cost and revenue across unit volumes.
• Break-even point marked with a labeled dot where the lines cross.
• Currency tooltips and axis labels; chart colors follow light or dark theme.

Scenario table

• AG Grid table with sample scenarios (Discount, Base, Standard+, Premium).
• Editable columns: scenario name, price, variable cost, and volume.
• Break-even units and revenue recalculate automatically when you edit a cell.
• Add scenario inserts a new row seeded from current inputs.
• Sortable, resizable columns with single-click editing.

Excel export

• Export Excel downloads a workbook with two sheets:
• Summary — current inputs and break-even results.
• Scenarios — all rows from the scenario table.

Saved scenarios

• Save scenario prompts for a name and stores the current inputs, scenario table, and break-even results.
• Saved scenarios table shows name, timestamp, break-even units, and break-even revenue.
• Load restores a saved snapshot; Delete removes it from the list.

Theme & persistence

• Dark mode toggle in the header (☀️ / 🌙) with Tailwind `class` dark mode.
• AG Grid uses a custom dark theme when dark mode is on.
• Three localStorage keys persist current inputs and scenario rows, saved scenario snapshots, and theme preference across reloads.

Data & persistence

Default sample values ship with the app (e.g. $75,000 fixed costs, $28 variable cost, $65 price, 3,500 expected volume). Edits to the form, sliders, and scenario grid save automatically. Saved scenarios are stored separately and can be loaded or deleted at any time.

Charts & reporting

Chart.js powers the cost-vs-revenue line chart with a custom break-even marker. SheetJS generates the downloadable Excel workbook (`breakeven-analysis.xlsx`).

Built with

Tailwind CSS, Alpine.js, AG Grid Community, Chart.js, and SheetJS (xlsx).

Try the interactive walkthrough below. Click Walk through features and use Next / Back (or arrow keys) to explore every feature.