Category Archives: Finance math in Excel

SSRS Tutorial Part 2 – Data Source Configuration in SSRS – Reporting services

We took a look at creation of project and empty report in the BI tool SSDT (SQL Server Data tools) in previous part of the miniseries (Part 1 -SSRS project and report creation). This set up the ground for this part in which we will configure the report for data tools (SQL Server database in… 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 »