Changelog

Invest for Excel 4.3

New features (since compilation 4.2.001):

Compilation 4.3.002

New features:

  • Does not require ActiveX.
  • Parameter tables in multiple calculation files can be updated in one run.
  • Financing cost rows are included in analyze chart rows.
  • Default Meta data language in Data extract is English independent of what program language is used.

Fixes:

  • Waterfall chart buttons did not connect to macros in xlsx calculation file.
    This problem has been fixed.
  • Analyze chart Value axis could show wrong year when zero period was not in use.
    This problem has been fixed.

 

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.