Invest for Excel 3.8.5 - DataPartner ------------------------------------ --- Compilation 3.8.503 --- New features: - New digital signature valid until 12th of July 2022. - Online activation of Invest for Excel. - Calculation file print areas have been adjusted for better printing of whole sheets. - Intelligence have been added to IRR-calculation so that clearly invalid IRRs are not displayed. - When analyzing investments, manual depreciation is altered proportionally with changed investments. Previously only other depreciation methods have changed. - Debt residual correction for calculating Free cash flow to equity (FCFE) has been changed so that starting balance of Interest-bearing long-term debt is subtracted from ending balance before correcting FCFE. - An option to turn on iteration (calculation) when a calculation file is opened has been added. This is useful when a calculation file contains formulas that require iteration. Fixes: - Changing texts "EBITDA, %" and "EBIT, %" in the Income statement would not change the same texts in Analysis sheet. This problem has been fixed. - All valid rows where not always available in Variable´s impact on profitability-analysis. This problem has been fixed. --- Compilation 3.8.502 --- New features: - An "Update all analyses"-function added to menu. You can update all analyses in a calculation file with one click. - Some speed optimizations have been applied. Fixes: - Updating some of the analyses on the analysis sheet (income, variable costs and fixed costs) would also change sub-rows, which could cause unexpected results. This problem has been fixed. - Using program option "Update analysis charts automatically" could leave sheets unprotected. This problem has been fixed. - Airline example file contained external links. The links have been removed. --- Compilation 3.8.501 --- Fixes: - If you change language in a calculation file after deleting a Total row in the Calculations sheet, the texts on rows after the Total row would be placed on wrong rows. This problem has been fixed. --- Compilation 3.8.500 --- New features: - Bulgarian language and user manual has been added. - CAPM calculation for return on equity has been added to WACC calculation. - Printing options have been added to Monte Carlo simulation. - Total rows can be added to Income statement. - Consolidation investment summary columns can be hidden. - Consolidation investment summary shows depreciations according to plan when imputed depreciation is used. - A "Back to Calculation file Profitability Comparison" button (<) added to Comparison file Profitability Comparison for convenient return to Calculation file. - Text alignment button added to consolidation dialog box list. - New digital signature have been added and is valid until Aug. 10, 2019. - Invest for Excels file menu has been renamed as "IFE File" to separate it from the Excel's file menu that is always visible. - In the Financing file interest and/or fees can be capitalized on loan principal (and on chosen fixed asset when financing is read to calculation file). - 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 language 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. - Ready-made charts can easily be added to a calculation file. - Camera button is added to created chart for easy copying to clipboard. Fixes: - Monte Carlo could not be run for a (locked) variable cell in an unprotected sheet. This problem has been fixed. - The Distribute option to put change percentage in D-cell did not work in all sub-rows. This problem has been fixed.