✍️

Break Even Worksheet

A break even worksheet can help you determine how much your store needs to make in sales to cover all costs before you can start making a profit. The steps below will walk you through the process of how to do this.

This is a blank Breakeven Worksheet.

To determine your store's breakeven, use your store's P&L to enter your variable cost %s in the first column.

Add the royalty expense and total variable costs in the last two spaces under Variable Costs. Then add your fixed cost %s to the second column.

Look for other expenses and total fixed costs on your P&L and add it to the last two spaces under Fixed Costs.

Now add your AWUS from your P&L to Current AWUS on the worksheet. To determine your Contribution Margin Ration (CMR), subtract 100% from your variable cost %.

Enter the number you got for your CMR in the space provided. To determine your breakeven, take your Total Fixed Costs and divide it by your CMR. Enter the amount you got for your Period Break Even in the space provided.

To determine your Weekly Break Even, take your Period Break Even amount and divide it by 4. Enter the amount you got for you Weekly Break Even in the space provided.

Locate your EBITDA on your P&L and enter it in the Period EBITDA space provided on the worksheet.

📥

Download a fillable Breakeven Spreadsheet here

Breakeven Spreadsheet.xlsx.pdf118.7KB