Use the extrapolation spreadsheet to prepare the base earnings scenario for a 10 year business plan valuation. Hide unwanted rows.
Valuation calculations use a selected choice of multiples.
In the second “Company Valuation” workbook you can prepare a quick value of your company based on five year results or forecasts and apply sales multiples, EBIT or Price Earnings values. You can then incorporate the Terminal Value beyond the forecast horizon period to create the additional net worth.
In addition to P/L valuation basis, you can adjust a business valuation using balance sheet figures. You can select which basis of valuation you want to apply and the table automatically adjusts the Total Value.
QuickValue 5.0 can incorporate Industry Benchmarks into your Value calculations. You just pull down a selector, choose your industry and the benchmark ratios are included into your valuation calculations if you wish. Your valuation can be very quick and accurate and relevant to your current time frame using data from the US acquisitions and mergers market updated monthly. |