- Quick specs
- Price: Free to try (30-day trial); $26.00 to buy
- Operating system: Windows 95/98/Me/2000/XP/Vista/NT
- Date added: January 28, 2009
- Total Downloads: 2,733
- Downloads last week: 15
- See full specifications
- CNET editors' rating: stars
- Average user rating: stars out of 2 votes
See all user reviews
CNET editors' review
Reviewed by: CNET staff on June 02, 2009
Investors who want to determine the possible returns of their funding, plus figure the impact of amortized goodwill and other factors, will certainly want to check out this preformatted Excel spreadsheet.
The Investment and Business Valuation tool is a preformatted spreadsheet with four tabs: Assumptions, Before (investment), After (assumptions regarding value of investment), and Results (Return on Investment). The initial tab, Assumptions, lets you choose either New or Existing investment and to enter a number of key factors: taxation and amortization, capital, and cost of capital--including risk-free rate, market risk premium, and weighted cost of capital. The interface is well-designed for leading the user step by step through entering assumptions regarding taxable and nontaxable revenue, operating expenses, investment expenses, existing assets, and capital expenditures for up to five years. The spreadsheet performed very well in our tests. Entering data--and knowing where to enter data--was a simple matter, although for the latter, some understanding of accounting principles is necessary. We were pleased with the built-in financial analysis charts and their ease of use. Also very handy were charts for Depreciation, Asset Disposal, Goodwill, Tax Calculation, and other elements important for determining potential ROI. For instance, the Annual Cash Flow trending chart and the Comparable Investment Score charts provide excellent data for helping to make important investing decisions.
The trial period is adequate for anyone familiar with investment procedures, and the price is nice. This is a pleasing little spreadsheet to add to your tool portfolio.
Publisher's description
From Business Spreadsheets :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 traditional DCF 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.
More popular Spreadsheet Software downloads
- 9,511 downloads 1. Excel Calendar Template
- 5,137 downloads 2. Microsoft Office Excel 2007
- 1,954 downloads 3. Batch XLSX to XLS Converter
- 1,890 downloads 4. Microsoft Excel 2003
- 723 downloads 5. Classic Menu for Excel 2007
- See all Spreadsheet Software downloads
User reviews
- Average user rating: 0 stars Not yet available
- My rating: 0 stars Write review
-
Showing 1 of 1 user reviewSee 1 user review
This software version | All versions -
Version: Investment and Business Valuation 1.0
"Well set-up and very easy to use."
Pros: A large number of investment calculations including economic value added.
Cons: requires enabling of VBA macros
- See 1 user review Write review
Submit your review
- See more CNET content tagged:
- business case,
- spreadsheet,
- valuation
Previous Versions:
