Invest for Excel® Editions overview
Table of Invest for Excel® functionalities
|
Software Editions |
|||
|
|
|
|
|
Flexible definition of calculation term, length of interval periods, discount rate, tax rates and more | ![]() |
|
|
|
Ability to specify multiple capital expenditure outlays, each with its own depreciation method and option for residual value |
|
|
|
|
Profit and Loss statement |
|
|
|
|
Working capital calculation |
|
|
|
|
Cash flow statement |
|
|
|
|
Profitability Analysis Report including investment profitability indicators such as NPV, IRR, payback, RONA, EVA, DCVA and more |
|
|
|
|
A wide variety of sensitivity analyses using charts and tabular reports |
|
|
|
|
Ability to calculate break-even points using any input variable |
|
|
|
|
Comparison of various investment options and scenarios |
|
|
|
|
Margin calculation (the marginal effect of an investment as compared to the status quo, e.g. a modernisation project) |
|
|
|
|
Functionality for creating customised charts and sensitivity analyses |
|
|
|
|
Ability to create up to 3 levels a hierarchy so rows within the model can be easily categorised and shown or hidden |
|
|
|
|
Automatically generate the Balance Sheet | ![]() |
![]() |
||
Automatically generate the Investment Proposal |
|
|
||
Multi-currency functionality |
|
|
||
Multi-language functionality (English, German, Spanish, Swedish, Finnish, Polish, Russian, Serbian, Bulgarian, Czech) |
|
|
||
Create Report Sheets New! |
|
|
||
Customisation of headings, rows, and key ratios |
|
|
||
Rolling of forecast periods |
|
|
||
Monte-Carlo simulations | ![]() |
![]() |
||
Financial ratios and DuPont analysis | ![]() |
![]() |
||
Project financing module & Liquidity planning |
|
|||
Consolidation of multiple calculations into one summary file including eliminations of internal transactions |
|
|||
Impairment testing of Goodwill and other assets |
|
|||
Valuation for acquisitions, mergers, and business sales |
|
|||
Perpetuity extrapolation for valuing an entity in a going concern situation |
|
|||
Investor's return: Profitability calculation based on Free Cash Flow to Equity (FCFE) |
|
|||
Business planning template with valuation
New! |
|