Questions & Answers

Q: Do you have a non excel based Pricing and Breakeven Analysis product?

A: Yes, our Business Analysis Software https://bizpep.com/businessanalysis.html provides browser based Pricing and Breakeven Analysis Excel plus forecasting and valuation.

Question and Answer Item 2058343 - Browse All Question and Answer Items

Q: Hello, how difficult will be to change the file not to 3 but for 20 years analysis?

A: We do have a browser based Business Valuation Model at https://bizpep.com/businessanalysis.html which allows you to set the forecast years up to 10 years. This model applies the same methodology as the Excel based version. It is worth noting that as the number of forecast years is increased the reliability of the forecast decreases because the further into the future we look the less certain it becomes. Generally a 3 year forecast provides a solid base for analysis. Adjusting the Excel version for increased years would require a rework of the calculation sheets (not a straight forward exercise) however another option is to simply build a number of consecutive forecasts using the outputs of the first as the inputs of the second etc you could apply this approach to build a forecast for as many years as required.

Question and Answer Item 2058311 - Browse All Question and Answer Items

Q: I have a question with regard to inputs for break even analysis. How do variables like economic, political risks and other non-quantifiable variables affect break even calculations ? Are there taken into consideration ?

A: Not directly in standard break even analysis. Break even analysis is at a point in time, so if you are looking at current data ie revenue/expenses it already includes all internal and external environmental impacts. However if you build a business forecast using relative indicators ( https://bizpep.com/Input-Help.html#Relative-Indicators ) as applied in our forecast methodology areas such as Market Strength, Business Market Position, Level of Competition, etc are applied in developing the forecast and these do consider the future impact of these variables and apply them in a quatifiable manner. You can then calculate break even points for future years using the forecast values. This would allow future subjective variables to be considered in break even calculations, see https://bizpep.com/Breakeven-Help.html .

Question and Answer Item 2058295 - Browse All Question and Answer Items

Q: Is there a discounted cash flow model available to analyze a potential acquisition?

A: For a time frame of 3 years Net Present Value provides little additional benefit and results in negligible change, as the time frame increases it becomes increasingly relevant. However applying Net Present Value increases the complexity of calculations and tends to make them less intuitive. Therefore base valuations are calculated using the average forecast returns without discounting future cash flows. FYI we have released a browser based valuation model that applies discounted cash flow to determine NPV over extended time frames it is based on the same methodology as the Business Valuation Model and can be assessed from https://bizpep.com/businessanalysis.html . Additional detail on Discounted Cash Flow and Net Present Value can be found at https://bizpep.com/businessanalysis.html .

Question and Answer Item 2058245 - Browse All Question and Answer Items

Q: I am starting a business and am looking for simple and effective software that will help me find my breakeven point, forecast the performance of the business and make decisions regarding the pricing of my products.

A: Pricing and Breakeven Analysis https://bizpep.com/pricebreakevenanalysis.html will identify breakeven points and optimal price points. Business Valuation Model https://bizpep.com/businessvaluation.html will provide a business forecast as does as Forecast and Budget Builder https://bizpep.com/forecastbudget.html

Question and Answer Item 2058233 - Browse All Question and Answer Items

<< < Page 1 2 3 4 5 6 7 8 9 10 > >>