Software : Business : Finance : Excel Business Tools : Investment and Business Valuation

The Investment and Business Valuation template is ideal for evaluating a wide range of investment and business valuation scenarios. While it is based on the traditional discounted cash flow method of business valuation, it also provides the 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.

Key features of the Investment and Business Valuation template include:

• Ease and flexibility of input, with embedded help prompts.
• 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.
• Valuation of new business investments or changes to existing business structures.
• Unique 'finite' terminal value calculation alternative to mimic investment life cycles.
• Unique Comparative Investment Score can be set to evaluate and prioritise different investments, depending on the prevailing business environment.

FAQ

What version of Excel do I need?
All templates are compatible with Microsoft Excel 97 or above.

How can I open the download files?
The download files are "zipped" to to minimise the file size. You will need some extraction software like Winzip to open them on your computer once they are downloaded.

Why can't I see all of the cell formulas?
The worksheets are protected to ensure the robustness of operation. However, critical formulas are outlined in the embedded help prompts.

When I open the file, it asks me if I want to enable macros. What should I do?
You need to click "Yes" to accept macros in order to run the tools.

When I open the file, it doesn't ask me if I want to enable macros. Therefore, the macros are disabled. What should I do?
In this case you need to set your macro security settings to Medium. You can do this by opening a blank workbook and choosing Tools >> Options >> Security >> Macro Security, and selecting the Medium level. You should now be presented with the option to enable macros on opening the template file.

Why can't I see the VBA code?
The VBA code has been protected to ensure the robustness of operation and for intellectual property purposes.

Can other users open the models that I have completed?
When other users open the model for the first time on another computer, they are presented with the 30-day trial version. After 30 days, if they have not registered the model, they will still be able to view completed models, but not run processes. In this way, the templates can be freely distributed to clients and/or interested parties to view results.

I want to customize a model for my own use or to distribute it to multiple users in my organization. What are my options?
Upon purchasing the products, you will receive the password to unlock cells, sheets, and the workbook. Since much of the functionality depends on the original workbook structure, modifications made are at the sole risk of the user. Site licenses are available on purchase so that the model can be registered for an unlimited number of users within the same organization.

An updated version of a model is available on your site. How can I upgrade my older registered version?
You can simply download the new version and it will work as a registered version on the same computers that you have your older version on.

How can I forecast inputs for the model?
You can use regression methods to produce statistically robust forecasts as inputs for the model.

Why does the model attribute value to the "PV of capital commitments after year 5"?
A unique feature of the model is to fully account for all actions taken during the forecast period. Therefore the impact of any remaining capital commitments after year 5 (resulting from actions taken before year 6) are discounted back to the end of year 5 and included in the overall valuation.

What is Economic Value Added (EVA)?
EVA is a valuation methodology trademarked by Stern Stewart & Co..

What is the "finite" terminal valuation option, and when should I use it?
A unique feature of the model is to provide an alternative to the traditional perpetuity terminal value calculation. In highly dynamic and competitive environments common today it is sometimes unreasonable to expect cash flows to grow at a constant rate into infinity. As products and businesses mature, decline, and cease to be profitable, this alternative provides a suitable method for mimicking such life cycles.

Why should I use the Comparable Investment Score (CIS)?
The CIS is a unique feature to benchmark and compare different and competing investment proposals within your business. It provides an excellent tool for prioritising business proposals and accelerating approval and decision-making processes.

Secure Order

Goto Developer Web Site for more information

Home

Excel Spreadsheets