Pricing and Breakeven Analysis Excel

Pricing and Breakeven Analysis uses break even analysis to calculate your current business break even point using revenue, variable, and fixed cost inputs. This is combined with price elasticity (estimates for price and sales volume variations) to produce revenue and surplus (profit/loss) forecasts by price.
The model determines the Optimum Pricing to maximize your surplus and can be applied to new or established businesses, product/service lines, or individual items. It is compact, easy to use, and requires minimal inputs. Outputs include break even charts for Current, Increased, Decreased, and Optimum pricing.
Each break even chart is a graphical display of the break even analysis including the break even point considering price elasticity. Extended Price Analysis determines Optimum Pricing to maximize your business surplus. The Revenue, Surplus, and Number of Sales are calculated for prices ranging from -50% to +50% of the current price.
This addin smoothly incorporates break even analysis, break even points, break even charts and price elasticity that will help you determine the impact of your current pricing on your business and the optimum pricing.System requirementsMicrosoft Excel
Limitations in the unregistered versionInput for current performance values are limited to example business data