Invest for Excel 3.7, DataPartner --------------------------------- Compilation 3.7.010 ------------------- New features: - Max. loan term in Financing file is 60 years + 12 months. Max. Drawdown period is 60 months. - Optimizations for speed have been done. - As an option, Offset formulas can be used for specification rows. Fixes: - Windows text scaling issues have been addressed. This especially helps Windows 10 users with a high-resolution (4K) laptop screen. - Calculating WACC using the WACC dialog box did not work for percentages less or equal to 1. This problem has been fixed. - Interest that had been capitalized from an financing file to an investment may have been excluded from investment book value if the investment amounts have been changed in the investment table after capitalization. This problem has been fixed. - When rows had been removed from an analysis chart, the analyzed rows' formulas may not have been restored correctly. This problem has been fixed. - All rows selected for calculating working capital based on turnover days may not have been taken into account. This problem has been fixed. - When deleting a specification row, a #REF!-error could be generated in the residual column cell of the respective total row. This problem has been fixed. - When using floating interest rate in a Financing file, 0% could not be used. This problem has been fixed. Compilation 3.7.009 ------------------- New features: - Copy/Distribute: - Percentage change applied also for previous periods - Base year can be selected for Index - Extrapolation time for firm and equity is syncronized in FCFE calculations. This change requires 3.7.009 or newer template. - Category axis crosses at value 1 instead of 0 for Profitability index in Analysis and Spider charts. - Camera shot: if Shift key is pressed when Camera button is pressed, buttons etc. on sheet are included. - Optimizations for speed have been done. - Analysis chart (Tornado chart & Spider chart) can include 20 variables (previously 5). Fixes: - Extrapolation time info was not included in Profitability analysis in Snapshot file and Camera shot. This problem has been fixed. Compilation 3.7.008 ------------------- Fixes: - When specification rows had no operators, the formula was not updated. This problem has been fixed. Compilation 3.7.007 ------------------- Fixes: - When accounts receivable or accounts payable where specified as more than one asset group, the respective balance amounts in the balance sheet only included the first asset group. This problem has been fixed. - When a corporate acquisition file was created in Microsoft Excel 2010, the first Overvalue allocation dropdown in the Goodwill calculation table was missing. This problem has been fixed. - An open financing file could not be selected for language change if it was not the active file in Excel. This problem has been fixed. Compilation 3.7.006 ------------------- Fixes: - Handling of historical working capital in the beginning of the calculation term has been changed in the working capital table so that it works more logical when zero period is not used. Compilation 3.7.005 ------------------- New features: - Flip buttons for specification rows work in calculation file also when Invest for Excel is not open. This feature requires the calculation file to have been created in version 3.7.005 or newer. Fixes: - Specification rows calculation may not include all sub-rows if additional sub-rows have been added. This problem has been fixed. - Modifying specification rows may cause some borders to disappear. This problem has been fixed. Compilation 3.7.004 ------------------- New features: - When an investment asset is specified as Long-term loans receivable, partial capital changes can be made without generating relisation profits or losses. - In a Free-cash-flow-to-Equity calculation, cell break-even can be sought for NPV to Equity. Fixes: - When switching to Bullet loan in the Financing file, formulas were not updated in every case. This problem has been fixed. - Yearly percentage change and Index were not showing the correct change with some combinations of detailed periods. This problem has been fixed. - In the Calculation file's Elimination selection list, some rows were listed as empty although they were not. This problem has been fixed. Compilation 3.7.003 ------------------- New features: - User manuals in six languages: English, Finnish, Swedish, German, Polish and Russian. - Easy access to example files in different languages. Compilation 3.7.002 ------------------- New features: - Distribution change percentage can be applied per year or per period. Fixes: - Languages could not be filtered in the edit texts dialog box for the comparison file. This problem has been fixed. Compilation 3.7.001 ------------------- New features: - Eliminations can be made in consolidation of calculation files. (Enterprise edition) - Financing files can be consolidated. (Enterprise edition) - Currency translation can be applied to consolidation of calculation files and financing files. (Enterprise edition) - Currency file including updating of rates from European Central Bank. (Enterprise edition) - Financial periods can be rolled along with numbers. (Pro and Enterprise edition) - Percentage change/index sub-rows can be added to a number of row and percentage can be put in cell. - Hide/unhide toggle buttons have been added to specification rows. - Added rows for income, variable costs and fixed costs. - Five additional income statement variable analyses. - Working capital: up to 5 rows per working capital group with options to select variable cost rows they are based on. - Change indicators (percentage and index) can be added for distributed rows. - Camera/Snapshot buttons are available for each table. Take a picture copy of any table. Shift-Print for older files (not old financing files). - A freeze/unfreeze-button has been added for row headers. - Sheet cells can be formatted using Microsoft Excel formatting options. - When updating financing from a financing file, there's an option to add to previously read values. - Analyses and charts are automatically updated when saving a Snapshot file. - New digital signature has been added for macros. The signature is valid until Aug. 10, 2016. - Tested in Microsoft Excel 2013.