Items selected where Item is 2058311
Questions & Answers
Topic: Business Valuation Model Excel
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 www.businesssoftwaremanagement.com 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.
The latest Question and Answer Items are available as a from
The current RSS feed is: