Corality

Blog

filter post by
Showing all blog

Improve your financial model with best practice Index-linked bonds

This tutorial outlines the reasons for using index-linked debt instruments and demonstrates a way to model them, focusing particularly on index-linked bonds.

Learn More

Working capital – financial modelling of trade debtors and creditors

It is important to recognise the trade debtors and trade creditors in a cash flow financial model because they capture the cash cycle of a company. This is important since not all revenue earned in a given period is received in the same period, and that not all costs are paid as soon as they are incurred.

Learn More

Project finance transactions and debt sizing versus debt sculpting

Financial modelling of debt facilities has been, is, and always will be, at the heart of a project finance transaction. While the basic terms and conditions are incorporated in the term sheet, the industry nuances and accepted practices are generally expected by senior bankers to simply be embedded into the model. Two of these concepts are often confused when discussing and modelling project finance debt so let us take a look at this issue.

Learn More

Circular interest on average balances

Solve common problems with calculating interest using basic algebra instead of VBA.

Learn More

Average DSCR in financial modelling

There are two different ways to calculate the average debt service coverage ratio (ADSCR) that could result in different numerical outcomes. What are the methods, what are the limitations that we should be aware of and which one should be used?

Learn More