Break-Even Analysis Worksheet

Document Sample
Break-Even Analysis Worksheet Powered By Docstoc
					Break-Even Analysis Worksheet


STEP 1                            STEP 2
Estimated Total Annual Revenues   Gross Profit Percentage by Category

                                  Category 1: <enter category name>

                                                Average sales price:
                                                Average variable cost:
                                                Average gross profit:

                                                Gross profit percentage:

                                                Estimated annual revenues:

                                                Total estimated gross dollars:


                                  Category 2: <enter category name>

                                                Average sales price:
                                                Average variable cost:
                                                Average gross profit:

                                                Gross profit percentage:

                                                Estimated annual revenues:

                                                Total estimated gross dollars:


                                  Category 3: <enter category name>

                                                Average sales price:
                                                Average variable cost:
                                                Average gross profit:

                                                Gross profit percentage:

                                                Estimated annual revenues:

                                                Total estimated gross dollars:


                                  Estimated Annual Gross Profit

                                  Total estimated gross dollars, all categories:
                                  Total estimated annual revenues:
Average Gross Profit Percentage:
     STEP 3
     Estimated Annual Fixed Costs

                <enter monthly fixed cost 1>
                <enter monthly fixed cost 2>
                <enter monthly fixed cost 3>
                <enter monthly fixed cost 4>
$0              <enter monthly fixed cost 5>
                <enter monthly fixed cost 6>
0%              <enter monthly fixed cost 7>
                <enter monthly fixed cost 8>
                <enter monthly fixed cost 9>
               <enter monthly fixed cost 10>
$0                    Total Monthly Fixed Costs   $0

           Total Estimated Annual Fixed Costs     $0




     RESULT
$0   Break-even Point

0%     Estimated Annual Fixed Costs:              $0
       Average Gross Profit Percentage:           0%
       Break-even Point:                          0%

$0




$0

0%




$0




$0
$0
0%