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!