Pricing and Breakeven Analysis Excel will determine the impact of a price change on your business. It calculates current breakeven points using revenue, variable cost, and fixed cost inputs. These are combined with estimates for price and sales volume variations to produce revenue and surplus (profit/loss) forecasts by price. The model finds the Optimum Price to maximize your surplus, for new or established businesses, products, or services.