Invest for Excel® functionality
|
|
Software Editions |
|||
|
|
|
|
|
|
| Flexible definition of calculation term, length of interval periods (1, 2, 3, 4, 6, 12 months), discounting rate, taxes and more |  |
|
|
|
| Specification of capital expenditures with a selection of depreciation methods and options for residual value |
|
|
|
|
| Profit calculation in a form of Profit and Loss Account |
|
|
|
|
| Working capital calculation |
|
|
|
|
| Cash flow statement |
|
|
|
|
| Profitability Analysis Report including investment profitability indicators such as NPV, IRR, payback, RONA, EVA, DCVA and more |
|
|
|
|
| A great variety of sensitivity analysis in a form of charts and report tables |
|
|
|
|
| Break-even function on any input variable |
|
|
|
|
| Comparison of various investments |
|
|
|
|
| Margin calculation (the marginal effect of an investment as compared to status quo, for example used in modernization projects) |
|
|
|
|
| Function for creating customised charts and sensitivity analysis |
|
|
|
|
| Modeling rows can be categorised into 3 levels of hierarchy specification |
|
|
|
|
| Balance sheet | |
|
||
| Investment proposal |
|
|
||
| Currency conversion function |
|
|
||
| Language change function (English, German, Spanish, Swedish, Finnish, Polish, Russian) |
|
|
||
| Locking of calculation files (partial/full) |
|
|
||
| Customization of headings, rows, and key ratios |
|
|
||
| Project financing module & Liquidity planning |
|
|||
| Consolidation of many calculations into one summary file |
|
|||
| IFRS and US GAAP impairment test |
|
|||
| Valuation for acquisitions, mergers, and sales of businesses |
|
|||
| Perpetuity (going concern) & Extrapolation |
|
|||
| Profitability calculation based on Free Cash Flow to Equity (FCFE) |
|
|||
