valuationbreak evenprofitcontributionforecastshiftqueuingbusiness analysis
accountbasbudgetBAS-I.Cshare valueshort salesinvestment
site mapform1
Browse All Question and Answer Items
Items selected where Item is 2058311
Questions & Answers
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