Category Archives: Uncategorized

Consolidation of Financial Statements/Monthly Reporting – Automatic Processing in Excel/SQL – Part 1

The aim of this article is not to extensively describe the consolidation of financial statements from a theoretical perspective but to demonstrate how to automate the preparation of consolidated statements as much as possible, perhaps using Excel. It is assumed that if you are reading this article, you have an idea of what it’s about.… Read More »

Day Count Convention (Fractions) for Bonds, Loans, Accrued Interest – Financial Mathematics

Most calculations in the area of financial mathematics are relatively easy – for example, to calculate an annuity payment, interest rate or target amount value with regular deposits. However, financial calculations can be quite complex in certain circumstances. This is particularly true on the money and capital markets (bonds) or on some specifically agreed corporate… Read More »