Excel-Skills.com
100% UNIQUE EXCEL TEMPLATES
40 

Business Valuation Template

This template enables business owners and buyers or sellers of businesses to calculate an estimated valuation of a business or company based on the discounted cash flow (DCF) method by using the weighted average cost of capital (WACC) as a discount rate for future cash flow projections over three and five year periods. Valuations are calculated by using the net present value (NPV) method with the option of including a terminal value.

  • Suitable for all business owners and buyers & sellers of businesses
  • Automated 5 year annual cash flow projections
  • Customize the 23 default expense items (and add more)
  • Discounted cash flow (DCF) calculations
  • Calculates weighted average cost of capital (WACC)
  • Uses net present value (NPV) calculation method
  • Business evaluation with NPV and IRR
  • Also includes options for profit multiple and terminal value
business valuation template sheet 1
Business Valuation Template - Sheet 1
business valuation template sheet 2
Business Valuation Template - Sheet 2
business valuation template sheet 3
Business Valuation Template - Sheet 3