Version History

•New: The regular payment interval (interest & principal repayment) of debt 1 (the fully automatic annuity loan) can now be freely changed between monthly, bi-monthly, quarterly, semi-annual, and annual.

•Fixed: File saving problems when using EFM with macOS Sonoma 14.1.2 and Excel for Mac. The problem only occasionally occurred for Mac users after an update from Microsoft in November 2023.

•Improvement of selected formulas and formats.

•New: For sources and uses calculation and overview (on summary 01 sheet), number of months to be calculated/shown can be entered/changed on inputs sheet (miscellaneous section).

•Revised: Interest payments during grace periods can now be switched on/off at any time.

•New: Digital Code Authentication. The VBA/macro code has been digitally signed by Fimovi GmbH (= software developer). A Code Signing Certificate from the certified signing authority SECTIGO (https://sectigo.com/) guarantees that the VBA/macro project created by Fimovi has not been changed or otherwise modified.

•Improvement of selected formulas and formats.

•Fixed: File saving problems when using EFM with macOS High Sierra 10.13.2 and Excel for Mac 2016 version 16.9 (180116). The problem only occasionally occurred for Mac users after an update from Microsoft in January 2018.

•New assumption to select VAT accounting basis was added oh the "Inputs" sheet. You can now choose between invoice basis (aka imputed taxation) and payments basis (aka actual taxation).

•New bi-monthly interval added for filing VAT returns and associated payments to/from the tax authorities.

•Revised calculation of "cash received" on the "Offering 1" to "Offering 4" sheets to better reflect billing type and frequency. Separate calculations by month cohort for revenue and payments received have been added at the bottom of each sheet (section 7).

•Improvement of selected formulas and formats.

•Initial version