DataPartner Invest for Excel 3.0 (January 2004) New features: ------------- - Calculation term definition has been simplified so that financial years can be used easily. This is the new default. Shorter periods can be still be defined for one or two phases as before. - Number of columns in calculations sheet of investment file can be from 1 to 240. Previously number of columns was restricted to 4-240. - An option to select the calculation point has been added. Calculation point defines to what point of time net cash flow is discount/compounded. An alternative calculation point can be defined for payback. - The Zero-period column can be excluded from the calculation. - Number of investments increased from 15 to 30 in investment table. - Depreciation of investments that has been done before the calculation term can be calculated in investment table. - Straight-line depreciation is now accurate for subsequent investments. - Net assets, average: Calculation has been changed so that, if there is no starting balance, then ending balance is used. In previous versions, the ending balance was devided by two if there was no starting balance, which often resulted in abnormal RONA- and Eva-figures in the first financial year of the calculation term. - Row texts can be edited in all languages (English, Finnish, Swedish and German) in Profit calculation, Working capital calculation, Cash flow statement, Balance sheet and Result table. - Some operational cash-flow items can be broken down one detail level in the Cash-flow statement. - Perpetuity can be used as residual value (as an alternative to the residual column) in Enterprise-calculations. - An additional result indicator, 'Discounted Value Added', has been added. Yearly 'Economic Value Added' figures are discounted. This result indicator should be used as an additional indicator to NPV. - A possibility to use multiple exchange rates in currency translation has been added. By default, the calculation will be locked from modifying after this operation, since all entered formulas will be converted to values. - An investment file can be locked in two ways: 1. Partial locking: Lock selected parameters, like discount factor and tax. 2. Full lock: All unlocked cells will be locked. An investment file that has been fully locked cannot be edited or unlocked. - Two levels of row specifications (previously one) can be used. Row specification handling has been rewritten for faster calculation. The rewritten Row specification handling should prevent occasional Excel- crashes related to chart editing and snapshot saving. - Border and alignment formatting has been added to the Format menu. - Discounted investments have been added to Result sheet. - Annuity method is hidden by default in Result sheet. - File path have been added to result sheet. - Updating of proposal file has been optimized for faster action. - Acquisition loans can be calculated using a ProFinance calculation. - Corporate license owners can force the use of custom templates instead of Invest's default templates. Users can make custom templates of the templates as before. - Corporate license owners can filter out any language not needed in the program. The program languages are: English, Finnish, Swedish and German. If, for example only English and German is used, then Finnish and Swedish can be left out. Bug fixes: - Compilation 3.0.005: Impairment test: group book value written double to impairment verfication when corporate acquisition is tested. This problem has been fixed. Specification rows: The use of division operator (/) resulted in unresolvable DIV#/0-errors in the balance sheet. This problem has been fixed. - Compilation 3.0.007: Investment term: history periods are checked when periods are updated on Calculations sheet that there are no overlapping periods. In some cases, net assets opening balance could in previous versions show faulty values in the beginning of the investment term because of faulty history periods. This problem has been fixed. - Compilation 3.0.008 (April 2004): Financing file: - A circular reference followed from the use of the following parameters combination: - Repayment period starts at B: First draw - Financing type: B: Annuity - Amortization interval: 1 month - The first draw is entered in the financing closing row - Fixed fees in advance and arrears did not work when defined as first fee. These problems have been fixed. Net assets: Average net assets is now calculated so that, if there is no starting balance (i.e. ending balance previous year), then ending balance is used. For the first financial year zero-period balance is used as starting balance if there is no ending balance in history period. This change is made primarily to prevent abnormal RONA and EVA figures at the start of the calculation term. Cash flow table detail level toggle did work correctly if two levels of specification rows were used. This problem has been fixed. User manual: Goodwill calculation chapter is updated with version 3 dialogs and text. Dialogs: Entering of numbers in dialogs have been changed so that thousand separator and decimal separator is taken from Windows Regional settings. Previously space was used as thousand separator and both point and comma (. and ,) were accepted as decimal separators. - Compilation 3.0.009 (May 3, 2004): The discount factor's impact on profitability: When perpetuity is used as residual value and NPV is used as analysed result factor, the analysis returns false values. This problem has been fixed (requires new file created with 3.0.009). This problem affected Enterprise version users only. - Compilation 3.0.010 (June 2, 2004): The discount factor's impact on profitability: When perpetuity is used as residual value and NPV is used as analysed result factor, the analysis returns false values if payback chart has been shown. This problem has been fixed (requires new file created with 3.0.009 or newer). This problem affected Enterprise version users only. - Compilation 3.0.011 (September 29, 2004): All row texts could not be edited in the Calculations sheet Hide / Show Rows form. This problem, which affected Pro and Enterprise version users only, has been fixed. Copying data to investment table rows could cause Excel to hang and incomplete calculation. This problem has been fixed. Positive investments in margin calculations could not be handled. This resulted in calculation errors in the margin calculation. This problem has been fixed. Positive investments are now supported. Investments and realizations have been separated in the investment table total rows. A language change in a margin calculation could cause texts to be displayed on wrong rows if specification rows were used. This problem has been fixed. A problem with depreciation method declining -> straight line occured when: - straight line depreciation exceeds the declining depreciation in the first depreciation period. - less than 12 months have been defined as included months for the first depreciation period This resulted in the use of the same straight line depreciation for all periods. This problem has been fixed. The calculation of an investment file created with compilation 3.0.011 invfile.xlt works without Invest for Excel program files. Any structural changes to an investment file and analyze tables updating still require Invest for Excel program files to be open. Any pre-entered depreciation percents are cleared when a margin calculation is created or updated to avoid confusion. Investment files created from compilation 3.0.011 invfile.xlt should not be used with earlier versions of Invest for Excel. - Compilation 3.0.012 (February, 2005): Financing items that have been imported from a ProFinance file to an investment calculation file were not included in a margin calculation. This problem has been fixed. A problem with depreciation method declining -> straight line occured when an old investment had been done during the financial year. As a result, the book value and depreciation of the old investment was wrong. This problem has been fixed. - Compilation 3.0.013 (February, 2005): Creating or updating a margin calculation from version 2.15 source files could lead to false book value in investment table and balance sheet. Cash flow was correct. This problem has been fixed.