Pricing and Breakeven Analysis Download Help Purchase

Pricing and Breakeven Analysis

Test price changes, determine optimum pricing and breakeven for your business

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 of 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 Businesses;
  • Established Businesses;
  • Product Lines;
  • Service Lines; and
  • Individual Items.

Pricing and Breakeven Analysis will determine the impact of a price change on your business. 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. Pricing and Breakeven Analysis incorporates break even analysis, break even charts, break even points and price elasticity to determine the impact of pricing on your business and optimum pricing.

You can Download Pricing and Breakeven Analysis free of charge for evaluation. Software is available as a standard spreadsheet (.xlsx file developed with Microsoft Excel) and will run on most spreadsheet applications.

Pricing and Breakeven Analysis software with proven results...

Just purchased your great spreadsheet.

Terje Larsen

Excellent software program. I have already referred several folks to your site to download the demo. Hopefully, they will turn into sales for you. Good Luck!

Anthony Beebe

Well done. It proved very useful for me already.

Roland Mechler

I think you have an excellent product and I look forward to trying some more of your software. I am very pleased!

Rod Butler

Thank you for all the your help and information that you sent me for the break-even analysis. I received a perfect score on my project thanks to your help. Thank you again.

Lisa Orsi

You have excellent products that have saved me several hours of time. Ease of purchase is excellent. Keep up the good work and keep coming up with improved business models. You are absolutely on the right track.

Denis Cowley

I just purchased your software - it's wonderful.

Roger Varner

Great piece of software. It has been a real winner in presentations here already. I have more to explore with it, too.

Chad Haight

Received and working great... Excellent service.

Kevin Long

Thank you for this great software!

Cedric Franklin

I just down loaded the excel version...awesome....thanks so much

Edward M. Rouse

more client feedback...

Download Pricing and Breakeven Analysis and give it a try.

Download Pricing and Breakeven Analysis

downloadzip file Download Pricing and Breakeven Analysis - Compressed Zip file
pba.zip

or

downloadexcel file Download Pricing and Breakeven Analysis - .xlsx file
PricingBreakevenAnalysis.xlsx

Click the required Download Pricing and Breakeven Analysis link to download and save your software file. If you download the Compressed Zip file unzip/uncompress the downloaded file and save the content .xlsx software file. If you download the .xlsx file simply save the .xlsx file. Open the .xlsx software file and follow the Instructions for Use. This software does not access or alter your system or system files in any way. To uninstall simply delete the saved files.

Pricing and Breakeven Analysis is an xlsx file developed with Microsoft Excel and will run on current versions of Microsoft Excel and most other spreadsheet applications. It is secure and safe, it does not include any macros or visual basic coding and cannot access your system in any way. In this format you can simply save the file with different file names to use with multiple entities or time frames. The software is divided into sheets accessible using the sheet tabs. All input is via unprotected blue input cells, protected cells contain formula and should not be changed.

You can Download Pricing and Breakeven Analysis free of charge for evaluation. In evaluation mode some functionality is restricted. To license your software and fully enable all functions you must purchase the appropriate license. If you have not already please Purchase a License to fully enable your software. For additional detail and help see please refer to Pricing and Breakeven Analysis.

The specific suitability of this software must be independently assessed. Software is provided as is, use is entirely at the users risk, and use acknowledges that the developers and all associated parties are held harmless from any claims or losses relating to software provided.

Help Pricing and Breakeven Analysis

Pricing and Breakeven Analysis 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. 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 Breakeven Charts for Current, Increased, Decreased, and Optimum pricing. Analysis determines the Optimum Price to maximize your business surplus, and the Revenue, Surplus, and Number of Sales are calculated for prices ranging from -50% to +50% of the current price.

This is the current version of our original Pricing and Breakeven Analysis, this is proven software providing real business value as evidenced by client feedback.

Overview

Pricing and Breakeven Analysisl 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. 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 Breakeven Charts for Current, Increased, Decreased, and Optimum pricing. Analysis determines the Optimum Price to maximize your business surplus, and the Revenue, Surplus, and Number of Sales are calculated for prices ranging from -50% to +50% of the current price.

Instructions for Use

Pricing and Breakeven Analysis is an xlsx file developed with Microsoft Excel and will run on current versions of Microsoft Excel and most other spreadsheet applications. It is secure and safe, it does not include any macros or visual basic coding and cannot access your system in any way. In this format you can simply save the file with different file names to use with multiple entities or time frames. The software is divided into sheets accessible using the sheet tabs. All input is via unprotected blue input cells, protected cells contain formula and should not be changed.

You can Download Pricing and Breakeven Analysis free of charge for evaluation. In evaluation mode some functionality is restricted. To license your software and fully enable all functions you must purchase the appropriate license. If you have not already please Purchase a License to fully enable your software. For additional detail and help see please refer to Pricing and Breakeven Analysis.

Specific item help is also provided within the software via hyperlinks to related help information.

Quick Start
  1. All input is on the Input Sheet. Click the sheet tabs to access. Blue cells allow input.
  2. You can save the file with different file names to use with multiple businesses.
Welcome

The Welcome sheet provides software and license details, Help and Purchase links and license details input. When you purchase a software license you will receive License Details by email. To license your software input your License Details into the blue cells at the bottom of the Welcome sheet and save the spreadsheet. Current license details are displayed in red.

Input

Start here.

Current Operating Performance Data

This section reviews the current performance of your business or product for a full year period. Inputs include Revenue, the level of expenses that vary with your sales (Variable Costs), and those that don't (Fixed Costs). Inputs do not have to be perfect but should reasonably reflect business operation. You can analyze a component of the business or a specific product by including values that apply only to the area under analysis. As an example we will analyze Acme Widgets producers of quality Widgets.

Business Name or Identifier

Input a name for the business. This appears as an identifier on the Output Sheets.

Business Revenue

Input the Revenue generated by the business or product for the current year. If you are setting the price for a new product or service input your forecast sales for a year.

Sales

Select your Sales input as Price (average revenue per sale) or Num Sales (Number of Sales). This allows you to input your Sales breakdown directly as the average price per sale or the number of sales per year.

Price & Number of Sales

Input the average revenue per sale (Price) or the average number of sales (Num Sales).

Expenses

Select your Expense input as Monetary or Percent. This allows you to input your Expenses directly in Monetary (Dollars, Pounds etc) or Percentage terms.

Variable Costs

Variable Costs change with the volume of product or service you provide. These costs include materials, production, distribution, and transaction costs.

Fixed Costs

Fixed Costs are expenses which remain constant (up to a point) while the volume of sales vary. This includes administration, location, and finance costs.

Operating Surplus

Operating Surplus reflects the before tax operating profit/loss of the business. It is calculated as the Revenue less Variable Costs less Fixed Costs.

Current Breakeven Analysis

Current Breakeven Analysis applies your current performance input to determine breakeven points and the required revenue and number of sales for a desired surplus under current trading conditions.

Current Breakeven Revenue is

This is the revenue required before any profit is generated by the business. If revenue is less than this the business will lose money for the period.

Current Breakeven Number of Sales is

This is the number of sales required before any profit is generated by the business. If the number of sales is less than this the business will lose money for the period.

Current Price Breakeven Chart

The Breakeven Chart plots the Revenue, Variable Cost, Fixed Cost, and Surplus against the Number of Sales for a year. The red line indicates total costs and the black line revenue. Where they cross is the breakeven point. The green area to the right of the breakeven point represents profit, the green area to the left of breakeven is a loss.

To generate a surplus of

You can input your desired surplus for a week, month, or year. The model will calculate the revenue and number of sales required to generate this surplus based on current pricing. This can be applied for budgeting and goal setting.

You currently require Revenue of

This is the revenue required to generate your desired surplus for the period.

Pricing Analysis

Pricing Analysis allows you to test the impact of pricing changes. Input estimated changes in the number of sales for changes in price to test the impact on revenue and surplus.

Increased Average Price

Increased Average Price allows you to determine the revenue and surplus generated by an increased price. The ratio of price to number of sales is applied in extended pricing analysis. Select your Increased Average Price input as Units or Percent. This allows you to input directly in Units (Monetary and Number of Sales) or Percentage terms.

An average price increase of

Input the amount of average price increase to test. This increase is relative to your current price. The ratio of price change to number of sales change will be applied in the extended pricing analysis. As a percentage this price increase should be no greater than 50%.

annual Number of Sales decrease by

Input the estimated impact on the number of sales your price increase will have. Consider competitor and consumer reactions. The ratio of price change to number of sales change will be applied in the extended pricing analysis.

This results in Revenue of

This is the revenue calculated from the increased price and corresponding number of sales.

With an Operating Surplus of

This is the operating surplus (profit) based on the increased price and the corresponding number of sales. The Variable Cost applied is the Variable Cost per Unit produced as calculated from the current performance input.

Increased Price Breakeven Chart

The Breakeven Chart plots the Revenue, Variable Cost, Fixed Cost, and Surplus against the Number of Sales for a year. The red line indicates total costs and the black line revenue. Where they cross is the breakeven point. The green area to the right of the breakeven point represents profit, the green area to the left of breakeven is a loss.

Decreased Average Price

Decreased Average Price allows you to determine the revenue and surplus generated by a decreased price. The ratio of price to number of sales is applied in extended pricing analysis. Select your Decreased Average Price input as Units or Percent. This allows you to input directly in Units (Monetary and Number of Sales) or Percentage terms.

An average price decrease of

Input the amount of average price decrease to test. This decrease is relative to your current price. The ratio of price change to number of sales change will be applied in the extended pricing analysis. As a percentage this price decrease should be no greater than 50%.

annual Number of Sales increase by

Input the estimated impact on the number of sales your price decrease will have. Consider competitor and consumer reactions. The ratio of price change to number of sales change will be applied in the extended pricing analysis.

This results in Revenue of

This is the revenue calculated from the decreased price and corresponding number of sales.

With an Operating Surplus of

This is the operating surplus (profit) based on the decreased price and the corresponding number of sales. The Variable Cost applied is the Variable Cost per Unit produced as calculated from the current performance input.

Decreased Price Breakeven Chart

The Breakeven Chart plots the Revenue, Variable Cost, Fixed Cost, and Surplus against the Number of Sales for a year. The red line indicates total costs and the black line revenue. Where they cross is the breakeven point. The green area to the right of the breakeven point represents profit, the green area to the left of breakeven is a loss.

Price Analysis Chart

The Price Analysis Chart plots the Number of Sales, Revenue, and Surplus for each of the defined price settings, Current, Increased, and Decreased.

Extended Pricing Analysis

Extended Pricing Analysis projects outcomes for pricing from 50% less than current to 50% more than the current price. It applies the ratio of price to number of sales defined in the increased and decreased price analysis and calculates the optimum price. The optimum price provides the highest surplus (profit). This information is intended to indicate outcomes based on your inputs. These inputs should be regularly refined to ensure they remain current.

Applying extended price analysis the optimum average sale price is

This is the price that will generate the highest surplus (profit).

This results in Revenue of

This is the revenue calculated from the optimum price and the corresponding number of sales.

With an Operating Surplus of

This is the operating surplus (profit) based on the optimum price and the corresponding number of sales. This surplus is based on Fixed Costs remaining constant and Variable Costs per Unit produced as calculated from the current performance input.

Optimum Price Breakeven Chart

The Breakeven Chart plots the Revenue, Variable Cost, Fixed Cost, and Surplus against the Number of Sales for a year. The red line indicates total costs and the black line revenue. Where they cross is the breakeven point. The green area to the right of the breakeven point represents profit, the green area to the left of breakeven is a loss.

Extended Price Analysis Chart

The Extended Price Analysis Chart plots the Number of Sales, Revenue, and Surplus projections for prices ranging from -50% to +50% of the Current price. It also identifies the current price setting and the Optimum price to maximize your surplus.

Breakeven Tables

Breakeven tables are provided for Current, Increased, Decreased, and Optimum pricing. They provide calculations for the number of sales from 0 to double the input amount. These results are also represented in the Breakeven Charts.

Requirements for Use

Pricing and Breakeven Analysis is an xlsx file developed with Microsoft Excel and will run on current versions of Microsoft Excel and most other spreadsheet applications. It is secure and safe, it does not include any macros or visual basic coding and cannot access your system in any way. In this format you can simply save the file with different file names to use with multiple entities or time frames. The software is divided into sheets accessible using the sheet tabs. All input is via unprotected blue input cells, protected cells contain formula and should not be changed.

Installation

Click the required Download Pricing and Breakeven Analysis link to download and save your software file. If you download the Compressed Zip file unzip/uncompress the downloaded file and save the content .xlsx software file. If you download the .xlsx file simply save the .xlsx file. Open the .xlsx software file and follow the Instructions for Use. This software does not access or alter your system or system files in any way. To uninstall simply delete the saved files.

Conditions of Use

The specific suitability of this software must be independently assessed. Software is provided as is, use is entirely at the users risk, and use acknowledges that the developers and all associated parties are held harmless from any claims or losses relating to software provided.

Software Support and Contact Details

For software support please refer to this Help and our Pricing and Breakeven Questions and Answers pages.

Full contact details are provided at Contact Us.

Purchase Pricing and Breakeven Analysis

Secure online transaction processing is provided via PayPal.

Pricing and Breakeven Analysis
$69.00 USD Annual License Fee


PayPal

Are you interested in purchasing other bizpep software titles?

Software license details are sent by email as soon as your transaction is processed. The license details provided cover software use on multiple devices by the individual licensed email address holder for the 1 year duration of the license. At the expiration of the license period updated License Details will be emailed upon license renewal through either the standard PayPal subscription process or purchase of a new license.

The specific suitability of this software must be independently assessed. Software is provided as is, use is entirely at the users risk, and use acknowledges that the developers and all associated parties are held harmless from any claims or losses relating to software provided.

Bizpep transactions encompass payments for Bizpep and partner sites.

Summary Pricing and Breakeven Analysis

Pricing and Breakeven Analysis
Developer Web Site:
Price: $69.00 (USD)
Download Pricing and Breakeven Analysis
Requirements for Use: Microsoft Excel or other Spreadsheet Application.

Pricing and Breakeven Analysis 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.

Pricing and Breakeven Analysis Screen Shot, click for full size

bizpep
<
buy
email
search
I am very impressed with the functionality of your Business Valuation Model, the lay out and the user friendliness. Your purchasing and registration procedure is also excellent.Robert de Rooy ... thank you for a brilliant and easy to use tax system, you have literally saved me hours and hours of work with simple clicks and drag from my accounting software to BAS-I.C my bas is done.Lisa Groundwater Thank you for this great software!Cedric Franklin This is the best model I have seen in a few decades.Darren Stevenson ...a resounding '1' for excellence. I am pleased with the performance of the software, the ease of use and the overall service. I am glad that I went ahead and ordered it. I plan to make heavy use of it during the rest of my MBA program and in my work life. No doubt I will be purchasing other programs from you. You have what I need.Judy Bottita the software has really simplified my tax and therefore my life! Thanks so much!Gail Tagarro Thanks very much for putting the BAS-I-C software 'out there' - so far it seems terrific and perfect for what I need.Chris Hargreaves I just down loaded the excel version...awesome....thanks so muchEdward M. Rouse great model for small biz and start up!Russell Smith I have my own accounting firm and I must admit that I am very impressed ... IT IS OUTSTANDING.Robert B. Wester, Jr Excellent software program. I have already referred several folks to your site to download the demo. Hopefully, they will turn into sales for you. Good Luck!Anthony Beebe Wow...you're good. Thanks for your help...and the rapid response was greatly appreciated. I think you have a great product; I've been doing 'if/then' scenarios on future options for my company, and it is quite fascinating using your program...You guys were great...exactly what I was looking for...I was very impressed with your customer service...great follow-up and execution. The software is easy to use, as was your web site. Thanks for your software; if I need any business software, I would be happy to look at you guys first. Keep up the good work.Kevin O'Keefe Thanks your program it was great for me starting out in my small business, definitely recommend it for startups.Jayne Bachelor I was greatly impressed...Michelle Lamont Great Software...Art Vedner I'm just starting to use this system for BAS reporting and am enjoying the simplicity and ease of use....I give you guys 5 stars.Jodie Maurer I am very impressed with the model.Jozua Fokker I think you have an excellent product and I look forward to trying some more of your software. I am very pleased!Rod Butler ...the system works great.Lyslei Chirico ...works perfectly.Hendry Buter You have excellent products that have saved me several hours of time. Ease of purchase is excellent. Keep up the good work and keep coming up with improved business models. You are absolutely on the right track.Denis Cowley Now to begin my third year with your excellent system ... How lucky I am to have bought your software. Thank youZoe Harrison Now that I have purchased the program, I honestly believe the price is ridiculously low for the power, utility and results generated by the program.Martin Caplan Just started playing with your software and I like it!Roger Loweth I just purchased your software - it's wonderful.Roger Varner I have been very happy with software purchase and was going to purchase another app... Thanks again for the great software!Frank Brown The Business Valuation software that runs in Excel saved my company a lot of time in evaluating an acquisition candidate. The instructions are clear and straightforward, and the program worked flawlessly.Tom Sweet I have loved your BAS Business Accounts Software and think it's ideal for sole traders (which was the reason I purchased it).Nicole Cornish Great piece of software. It has been a real winner in presentations here already. I have more to explore with it, too.Chad Haight ...I am in the midst (or shall we say was in the midst) of selling my company for a much lower amount...your software is working wonderfully...i think i shall send you a bottle of your favorite...Sean Hawley Love this application! It certainly can improve one's comfort level, especially the small business owner, when talking to the financial people. Seems to me like you can get a quick budget snapshot as well as the business valuation. Thanks again!Stan Shaw I am impressed with your business valuation model.Peter Davies Am really enjoying working with this programme, I am sure within the next week I will be putting an order in. I have found it so easy to use, wish I had known about it years ago, life would have been much easier.Lyn Laycock This spreadsheet has really made my life easy and I have recommended it to my colleagues.Moses Mwanjirah We are very pleased with your Business Valuation Model.Steve Geringer ...very easy to use.Karl Hayes Just purchased your great spreadsheet.Terje Larsen I think it is a very useful spreadsheet and I'm using it and I haven't found anything better and have stopped looking.Antoine Matarasso I am very happy with the Excel valuation model supplied. I think it constitutes good value for money and has been of great help to me in my work.Graham Ireson Well done. It proved very useful for me already.Roland Mechler The program is quite easy to use.Jackquie Grant I still love the software.Jim Dickey Received and working great... Excellent service.Kevin Long ...very user friendly...Abel Acuna I recently purchased a copy of this package and have found it to be extremely helpful as a quick valuation tool...This is a great piece of software...Jim Wendler