Investment and Business Valuation 3.2

License: Free Trial ‎File size: 171.01 KB
‎Users Rating: 3.4/5 - ‎13 ‎votes

The Excel Investment and Business Valuation template is ideal for evaluating a wide range of investment, financial analysis and business plan scenarios. Business valuation is based on the traditional discounted cash flow method but also evaluates economic value added valuation (EVA), accounting impact and additional quantitative investment performance indicators. The logical input flow makes usage straightforward to gain quick results for business strategy decision making. Simple and flexible input with embedded help prompts facilitates application to required valuation dynamic. The financial accounting impact is analyzed including Profit and Loss Statement, Balance Sheet and Cash Flow Statement. An optional tools 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. 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. An 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. The customizable Comparative Investment Score can be set to evaluate and prioritize different investments depending on the prevailing business environment. 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.

VERSION HISTORY

  • Version 3.2 posted on 2016-09-05
    Compatible with Microsoft Excel 2016 for Windows and Mac
  • Version 1.0 posted on 2006-12-01

Program Details

EULA

Business Spreadsheets MAKE NO REPRESENTATIONS OR WARRANTIES OF ANY KIND, EXPRESS OR IMPLIED, AS TO THE OPERATION OF THIS SOFTWARE OR THE INFORMATION, CONTENT, MATERIALS, OR SERVICES INCLUDED WITHIN IT. YOU EXPRESSLY AGREE THAT YOUR USE OF THIS SOFTWARE IS AT YOUR SOLE RISK. TO THE FULL EXTENT PERMISSIBLE BY APPLICABLE LAW, Business Spreadsheets DISCLAIM ALL WARRANTIES, EXPRESSED OR IMPLIED. Business Spreadsheets DO NOT WARRANT THAT THIS SOFTWARE, ITS SITE, ITS SERVERS, OR E-MAIL SENT FROM ANY OF ITS AFFILIATES ARE FREE OF VIRUSES OR OTHER HARMFUL COMPONENTS. Business Spreadsheets WILL NOT BE LIABLE FOR ANY LOSSES OF ANY KIND ARISING FROM THE USE OF THIS SOFTWARE, INCLUDING, BUT NOT LIMITED TO DIRECT, INDIRECT, INCIDENTAL, PUNITIVE, AND CONSEQUENTIAL LOSSES.