Investment and Business Valuation

This is an Excel template that facilitates evaluation of investments, financial analysis and business case scenarios.

Investment and Business Valuation template, suitable for Excel 97-2003 and 2010 versions, lets you evaluate a wide range of investment, financial analysis and business case scenarios. The template uses the discounted cash flow valuation method but provides additional evaluation means. These include economic value added valuation, accounting impact, and a range of other evaluation parameters. The input process is straightforward and step by step making it easy to arrive at timely decision making. The tool uses analysis methods that take into account net present value (NPV), modified internal rate of return (MIRR), return on investment (ROI) and economic value added (EVA) calculations. You are able to obtain detailed breakdown of components. The underlying workflow used is simple and flexible and is helped along by help icons.

The tool allows you the flexibility to value new business investments or changes to existing business structures or comparison between two investment proposals. Cost of capital calculation and Economic value added valuation is available. You are able to decide economic costs flexibly based on specific amortization periods. Asset purchase, disposal of it and depreciation are accurately handled. The tool will let you set comparative investment scores so that separate investments can be evaluated and prioritized based on the prevailing business environment. Alternatives are available that follow investment life cycle accurately and evaluate a terminal value calculation by more than one alternative methods. Not for amateurs, this is a tool for the specialists. Do try it out and see if you are happy with the results before making the investment in purchase!

The Investment and Business Valuation template is ideal for evaluating a wide range of investment, financial analysis and business case scenarios. While it is based on the traditional discounted cash flow method of valuation, its also provides ability to evaluate economic value added valuation, accounting impact, and a range of other evaluation parameters. Furthermore, the step-by-step input flow makes usage straightforward, gaining quick results to drive decision making. The key features of the Investment and Business Valuation model include: Ease and flexibility of input, with embedded help prompts; Cost of capital calculation; Economic value added valuation with flexibility on identifying economic costs with specific amortization periods; Accurate handling of asset purchase, disposal and depreciation with capital and gearing impacts; Evaluation of new investments or changes to existing investments; Unique 'finite' terminal value calculation alternative to mimic investment life cycles; and Unique Comparative Investment Score can be set to evaluate and prioritise different investments, depending on the prevailing business environment.