Business Valuation

Excel business valuation template for business plans and investment proposals
Find Excel Solutions




Home > Business Valuation
 
The Excel Investment and Business Valuation template is designed to value proposed investment projects or existing businesses for a variety of valuation scenarios. The underlying logic of the template is based on the traditional discounted cash flow method of business valuation, however analysis is also provided to evaluate economic value added valuation, accounting impact and other performance evaluation indicators. The step by step and intuitive input process makes utilization fast and simple in order to obtain timely results for decision making purposes. Video
Screens
Reviews
Key features of the Excel Investment and Business Valuation template include:
  • Economic Value Added (EVA) calculation with the flexibility to identify economic costs of 'investment nature' and specify amortization periods representing expected payback periods. Economic value added is fundamental for quantifying value attributable to equity holders and important for acquiring equity financing.
  • Financial accounting analysis provides Profit and Loss Statement, Balance Sheet and Cash Flow Statement constructed automatically from input data and assumptions and includes breakdown and impact analysis.
  • Formulas accurately calculate financials for existing and new asset purchases, disposals and depreciation with financing assumptions and gearing impacts.
  • Flexibility to value a new business investments, changes to existing business structures or comparison between two investment proposals (such as lease versus purchase analysis).
  • Expandable input for a five year explicit valuation period is provided with configurable terminal value calculation.
  • An option is provided to employ an alternative 'finite' terminal value calculation to mimic investment or product life cycles. This is useful in competitive new economy markets, whereby future growth peaks after a certain time period and subsequently diminishes.
  • The components of a Comparative Investment Score can be defined in order to evaluate and prioritize different investments or business case proposals depending on the prevailing business environment.
  • The analysis includes net present value (NPV), modified internal rate of return (MIRR), return on investment (ROI) and economic value added (EVA) calculations with detailed breakdown of components and chart visualization.
  • The workflow is designed for simplicity and flexibility of input assumptions, with embedded help icons to clearly describe input parameters and result calculations.
Requirements
Windows: Excel 97-2010
Mac OS X: Excel 2004 or 2011		 (US $26.00) Secure Processing
A free and basic version of this template is available for Excel 2007 and higher at Office.com: Free Excel Business Valuation Template.

Customers who bought the Excel Investment and Business Valuation template also bought:
Real Option Valuation, Multiple Regression Analysis and Forecasting
Find more Excel Business Valuation Solutions in the Business Finance Section of the Excel Templates & Add-ins Directory. Sell the Excel Investment and Business Valuation template as an affiliate.
Share experiences with the Excel Investment and Business Valuation template in the Investment and Business Valuation Section of the Excel Help Forums for Business.
 
Download Business Valuation References
by Recognized Experts
Explore the User Guides
to Empower Business
Decision Making
with Business Spreadsheets
Recommended Resources: More Resources and Solutions
Business Plan Pro - Comprehensive business planning software with data import from Excel.
Office Ready Business Plan - Templates for Business Planning & Valuation in MS Office (Free Download).
Venture Planning Associates - Resources to help the funding of your business.
Business materials to create project and valuation proposals for virtually any business.
       
  © 2012 Business Spreadsheets. All Rights Reserved. Legal | About Us