| |
| 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 |
|
|
|
| Recommended Business Valuation References |
|
| by Recognized Experts |
|