Investment and Business Valuation

The Investment and Business Valuation template is ideal for evaluating a wide range of investment and business case scenarios. While it is based on the discounted cash flow method of valuation, its also provides ability to evaluate economic value added va

The Excel Investment and Business Valuation template is suitable for evaluating a variety of simple to complex investment, financial analysis and business plan scenarios. Business valuation is based on the traditional discounted cash flow net present value method but also evaluates economic value added valuation (EVA), financial accounting impact and additional quantitative investment performance indicators.

The logical input flow makes usage straightforward to gain quick results for business strategy and investment decision making. Simple and flexible input with embedded help prompts facilitates targeted application to required valuation dynamics.

The financial accounting impact is analyzed including pro forma Profit and Loss Statement, Balance Sheet and Cash Flow Statement. An optional tool is included to calculate the weighted average cost of capital under the capital asset pricing model.

Economic value added calculation parameters include flexibility for identifying economic costs with allocated amortization periods. EVA valuation is particularly important for communicating value attributable to equity stakeholders and indispensable for raising venture capital funding for start-up investment projects.

The financial calculations accurately account for asset purchases, disposals and depreciation with capital and gearing impacts. Investment and business valuation can be applied to new businesses or changes to existing investments. This functionality also allows the comparison between two alternative strategies, such as lease versus purchase.

The optional and alternative finite terminal value calculation can be applied to mimic new economy investment and product life cycles where return cannot be expected to persist indefinitely as competitive advantages diminish. The customizable Comparative Investment Score can be set to evaluate and prioritize different investments depending on the prevailing business and economic environments.

The Investment and Business Valuation template is compatible with Excel 97-2013 for Windows and Excel 2011 or 2004 for Mac as a cross platform business valuation solution.

Price: $26.00 USD Category: Spreadsheets Screenshot: Added: Oct 27th 2013 Publisher: Business Spreadsheets Homepage: http://www.business-spreadsheets.com