Home > Business Valuation

Business Valuation


Sophisticated business valuation & capital investment analysis

...Evaluating a wide range of business valuation scenarios.
Find Excel Solutions:




 
 
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 a range of other evaluation parameters. The step by step and intuitive input process makes usage straightforward in order to obtain timely results for decision making purposes.

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.
  • 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.
  • Accurate handling of 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.
  • Expandable input for a five year explicit valuation period is provided with terminal value calculation.
  • An option can be chosen to employ an alternative 'finite' terminal value calculation to mimic investment or product life cycles, whereby future growth peaks and diminishes over time.
  • The components of a Comparative Investment Score can be defined in order to evaluate and prioritize different investments, 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.
  • The workflow has been 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.
 
Recommended 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.
       
  © 2012 Business Spreadsheets. All Rights Reserved. Legal | About Us