Changelog

Invest for Excel 4.3

New features (since compilation 4.2.001):

Compilation 4.3.001

New features:

  • Parameters can be included at the top of the Income statement.
    The parameters can be included and updated from a parameter file.
  • A waterfall chart can be created from NPV/NPVe.
  • ROCE (average) has been added to the Result sheet.
    This feature requires a new calculation file.
  • You can extract data from multiple calculation files in one run.
  • You can extract data in CSV (text) format in addition to Excel format.
  • You can extract data in one file or separate files per table (Investments, Income, …).
  • Decimals can be used for the Tornado chart %-changes.
  • An English scenario example Power BI report has been added.

Fixes:

  • The calculated tax part of perpetuity/extrapolation was not included in the impairment test verification when the impairment test was done before tax, but the calculation file included tax. This problem has been fixed.

  • Adding DuPont analysis to a calculation file would add a link to Invcode.xlam. This problem has been fixed. For the calculation file with the DuPont link, you can delete the DuPont analysis, then add it back, and the link will be gone.

  • Any missing flip buttons for specification rows are added to the Calculations sheet when the Arrange buttons is run.