Invest for Excel 3.6, DataPartner --------------------------------- Compilation 3.6.024 ------------------- - Equity corrections and minority interest was not calculated correctly in all cases when valuation files were consolidated. This problem has been fixed. Compilation 3.6.023 ------------------- - Net Assets did not calculate correctly when the "allocate expenditure" option was used for investments. This problem has been fixed. - The marginal effect calculation did not show correct book value for investments when the "allocate expenditure" option was used. This problem has been fixed. - The "Arrange buttons" function was not able to move all buttons and other controls to their correct positions in Excel 2007, 2010 and 2013. This problem has been fixed. Compilation 3.6.022 ------------------- - Distributing a cell value using adjusting with months did not work correctly in all scenarios. This problem has been fixed. - Changing Perpetuity to be based on entered annual value did not always work in Excel 2010. This problem has been fixed. Compilation 3.6.021 ------------------- - Update of Proposal file did not work with some combinations of hidden rows in the Income Statement. This problem has been fixed. Compilation 3.6.020 ------------------- - The "Arrange buttons" function was not able to move all buttons and other controls to their correct positions in Excel 2007, 2010 and 2013. This problem has been fixed. Compilation 3.6.019 ------------------- - Fixed asset book values could be doubled in the zero period of a marginal calculation when the source files where done with an older version of Invest for Excel. This problem has been fixed. Compilation 3.6.018 ------------------- - "EBITDA", "Internal Rate of Return before tax", "Profitability Index (PI)" and "Simple Payback, years" have been added to analyses. - "Include sum-of-changes line" option has been added to Spider analysis chart. - "Correction of income tax for financial items" was added to consolidated Income statement Income tax when acquisition files where consolidated. This problem has been fixed. Compilation 3.6.017 ------------------- - Break-even undo can be done on self-added worksheets in a calculation file. - Tornado chart data is sorted so that biggest values are at the top of the chart. - The comment field in the Comparison table did not resize with the text in Excel 2007, 2010 and 2013. This problem has been fixed. Compilation 3.6.016 ------------------- - Invest for Excel could crash at startup in Excel 2013 (64-bit) in Windows 8 (64-bit) in some cases. This problem has been fixed. Compilation 3.6.015 ------------------- - The row specification buttons in the "Equity, increase (+) / decrease (-)" section of the Cash flow statement placed the specification rows under the "Long-term debt, increase (+) / decrease (-)" section. This problem has been fixed. Compilation 3.6.014 ------------------- - An "Arrange buttons" function has been added to the main Invest for Excel menu for putting misplaced or missing calulation file worksheet buttons back in their correct places. Compilation 3.6.013 ------------------- - New digital signature for macros. Valid until Aug. 10, 2014. - Extrapolation residual period was described as "perpetuity" in the Impairment Test Verification file. This problem has been fixed. - Num Lock was turned off in some cases. This problem has been fixed. Compilation 3.6.012 ------------------- - Consolidating files that include more than one history column in compilation 3.6.011 would lead to an empty consolidated file. This problem has been fixed. - Comparison file chart buttons would not work correctly in Excel 2007/2010. This problem has been fixed. Compilation 3.6.011 ------------------- - When creating a new calculation the current year was not offered as default starting point in Excel 2007/2010. This problem has been fixed. Compilation 3.6.010 ------------------- - USB key could not be read with 64-bit Windows 7 and 64-bit Microsoft Excel 2010. This problem has been fixed. Compilation 3.6.009 ------------------- - Browsing for Folders in Excel 2010 in 64-bit Windows 7 would cause a software crash. This problem has been fixed. - Discount factor analysis: Key factors heading row showed WACC instead of Cost of equity when Equity-based result factor was selected for chart. This problem has been fixed. - Removing rows from a custom chart could cause Excel to show the message: "A formula in this worksheet contains one or more invalid references." This problem has been fixed. - Consolidating one file using the consolidation option "Longest common period" would result in an empty file. This problem has been fixed. - Setting the change-% to -100% in analysis charts was not possible. This problem has been fixed. Compilation 3.6.008 ------------------- - A snapshot file did not always have all the same sheets as the calculation file that it was created from. This problem has been fixed. - If a consolidated file was updated with changed number of investments in the consolidated calculation files, a circular reference could appear in the Investment Summary sheet. This problem has been fixed. - The effect of financing costs, that had been capitalized on fixed assets, was doubled in a consolidated balance sheet. This problem has been fixed. Compilation 3.6.007 ------------------- - A "Make folder default" button has been added to the Template Folders tab of the Files and Folders form. - An option to "include transactions prior to calculation term in opening balance" has been added to the update from financing file form. - When Invest for Excel was started in Microsoft Excel 2010 the Home screen was sometimes not displayed properly. This problem has been fixed. - When more than 255 characters were entered in a proposal file field, they text was not displayed correctly. This problem has been fixed. - Carry over book value in Investments and Realizations table was not displayed correctly in a marginal effects file in all cases. This problem has been fixed. - Calculation term info was not fully written to comparison file. This problem has been fixed. - When creating a new calculation file, the option to select template from defined template folder was not shown in Pro, Standard and Lite edition of Invest for Excel. This problem has been fixed. - When manual tax calculation was used a calculated tax debt could be introduced in the balance sheet. This problem has been fixed. Compilation 3.6.006 ------------------- - Formula missing for zero period EBITDA. This problem has been fixed. Compilation 3.6.005 ------------------- - In a server installation of the Excel 2007/2010 version, the second user who started the software was asked to enter a workbook open password. This problem has been fixed. Compilation 3.6.004 ------------------- - Printing the discount rate analysis using the print selection on the home page caused corruption on the Analysis sheet. This problem has been fixed. Compilation 3.6.003 ------------------- - Microsoft Excel 2010 64-bit supported. Compilation 3.6.002 ------------------- - Investments in associated companies did not show in the balance sheet of a consolidated file. This problem has been fixed. - Analysis: change % in selected profitability indicator was not updated correctly. This problem has been fixed. Compilation 3.6.001 ------------------- NEW FEATURES ------------ - Microsoft Excel versions 2002, 2003, 2007 and 2010 are supported. - Russian manual is included. - Program code is signed with a digital signature which is valid until Aug 11, 2012. - Template folders can be used to categorize pre-made templates. - An option has been added to allow Goodwill depreciation to be deducted from income before tax. - Internal rate of return before tax can be found in the Profitability analysis table. - A Tornado analysis chart type is available as an option to the traditional Spider analysis chart. - An option has been added to automatically correct debt residual included in free cash flow to equity. - The Discount rate’s impact on profitability analysis has been extended to include more options. - Changes in provisions can be entered in the Income statement before EBITDA. - Deferred taxes can be entered in the Income statement after ordinary Income taxes. - Calculation file external links can be edited from Invest for Excels menu. - A SharePoint file menu has been added for accessing Sharepoint. (Enterprise-version is required.) - Equity changes can be included when updating financing file cash flows from the calculation file. - When perpetuity/extrapolation is used, an implied exit multiple is automatically calculated in the bottom of the perpetuity calculation table. - In a valuation file Profitability analysis an EV / EBITDA-ratio is calculated.