Also very handy were charts for Depreciation, Asset Disposal, Goodwill, Tax Calculation, and other elements important for determining potential ROI. We were pleased with the built-in financial analysis charts and their ease of use. Entering data-and knowing where to enter data-was a simple matter, although for the latter, some understanding of accounting principles is necessary. The spreadsheet performed very well in our tests. 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 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 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). ![]() ![]() 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.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |