Invest for Excel 3.8, DataPartner --------------------------------- --- Compilation 3.8.004 --- New features: - New digital signature added on June, 29, 2018. - Invest for Excels file menu has been renamed as "IFE File" to separate it from the Excel's file menu that is always visible. Fixes: - When creating a marginal calculation of consolidated calculation files, the Investment totals could be wrong in the Profitability analysis. This problem has been fixed. - Consolidation period-related summing with option "Longest common period" has been fixed. - Corporate acquisition / Valuation file IRR to Equity was not calculated correctly when Interest-bearing net debt was included. This problem has been fixed. --- Compilation 3.8.003 --- New features: - In the version 3.8.003 Financing file interest and/or fees can be capitalized on loan principal (and on chosen fixed asset when financing is read to calculation file). - Bulgarian language has been added (requires files created in version 3.8.003). - All supported languages have been added to Monte Carlo simulation (applied to new simulations). - "Hide/show zero values" command have been added to Invest for Excel menus. The command is the the same as the "Show a zero in cells that have zero values" found in Microsoft Excel options. - Chart titles can be entered in multiple languages. Also, if the chart title and the chart sheet name is the same, chart sheet name is automatically changed when file langage is changed. - Basic values sheet texts can be entered in multiple languages. - 15 new group-related rows have been added to calculation file in Pro and Enterprise edition (3.8.003 or newer). The rows, which are hidden by default, are: (Income statement) Share of associated companies' profits (Working capital) Accounts receivable, group Change in accounts receivable, group, incr. (-)/decr. (+) Other receivables, group Change in other receivables, group, incr. (-)/decr. (+) Accounts payable, group Change in accounts payable, group, incr. (+)/decr. (-) Other interest-free current liabilities, group Change in interest-free current liabilities, group (Cash flow statement) Changes in long-term debt, group (Balance sheet) Accounts receivable, group Other receivables, group Interest-bearing long-term debt, group Accounts payable, group Other interest-free short-term debt, group The idea behind these rows is easier follow-up of consolidated values with elimination in a group planning scenario. Fixes: - When consolidating files with specified Working capital, some working capital items could be excluded from consolidated file. This problem has been fixed. - After rolling periods in a calculation file the working capital formulas would not be updated automatically. This problem has been fixed. - When using Microsoft Excel 2016, the acquisition file goodwill-calculation related dropdowns could be displayed in a way that makes them hard to use. This problem has been fixed. - When analyzing related variables in spider/tornado chart, the lines/bars some of these bars could show wrong in chart. This problem has been fixed. - A grouping header before the first investment in the investment table could not be removed. This problem has been fixed. - Analysis sheet charts displayed percentage numbers as decimal numbers. This problem has been fixed. - Any change made to a chart would change all chart series to column. This problem has been fixed. - When a Tornado chart's data changed so that new sorting changes data range, some data could be left out from the chart after refresh. This problem has been fixed. --- Compilation 3.8.002 --- Fixes: - IRR and MIRR returned #VALUE when the last period was not a full year in a version 3.8 calculation file. This problem has been fixed. - Margin calculation did not included working capital for version 3.8 calculation files. This problem has been fixed. - In some regional settings analysis charts did not display decimal numbers correctly. This problem has been fixed. --- Compilation 3.8.001 --- New features: - New Digital signature in program files valid until Aug. 8, 2018. - Mid-year discounting. - Monte Carlo simulation. (English language only.) - 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. - 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 feature requires the calculation file to have been created in version 3.7.009 or newer. - 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). - 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. - 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. - Easy access to example files in different languages. - Distribution change percentage can be applied per year or per period. Fixes (after compilation 3.7.001): - 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. - Extrapolation time info was not included in Profitability analysis in Snapshot file and Camera shot. This problem has been fixed. - When specification rows had no operators, the formula was not updated. This problem has been fixed. - 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. - 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. - 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. - 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. - Languages could not be filtered in the edit texts dialog box for the comparison file. This problem has been fixed.