Breakeven Analysis - Units & Sales

Cost Description Year 1 Year 2 Year 3
Selling price per unit
Number of units to be sold
Total Sales Revenue
Variable Costs
Cost of Goods Sold
Total Variable Costs
Variable cost per unit
Fixed Costs
Salaries (includes payroll taxes)
Supplies
Repairs & maintenance
Advertising
Car, delivery and travel
Accounting and legal
Rent
Telephone
Utilities (Phone, Gas, Electricity, nternet)
Insurance
Taxes (Real estate, etc.)
Interest
Depreciation
Consultancy
Other (specify)
Miscellaneous expenses
Total Fixed Costs
Total Variable Costs
Breakeven Sales level =
Breakeven Units Sold =
Formula and Calculation for COGS
COGS=Beginning Inventory+P−Ending Inventory where P=Purchases during the period​
COGS - Taken as the cost of making or producing the items sold. The items not sold are not part of COGS but of finished goods inventory.
In the cell b16 you may adjust your variable costs, then change the percentage in corresponding cells, i.e.d16, E16 and F16