Blog

filter post by
Showing all blog

10 SMART Guidelines for financial modelling - the complete handbook

The complete 10 SMART Guidelines series is now available. Download the handbook and start creating SMART financial models today.

Learn More

DSRA – Debt Service Reserve Account

The debt service reserve account (DSRA) works as an additional security measure for lenders. It is generally a deposit which is equal to a given number of months projected debt service obligations. This tutorial explains how to code a transparent and efficient DSRA, and how it is linked to the financial statements without circular references.

Learn More

Calculate NPV without Excel functions

Net present value (NPV) is a standard method of using the time value of money to appraise long-term projects and investments. This tutorial will discuss the principles of NPV calculation and the discount rate and, in particular, highlight how to calculate NPV without using the built-in functions in Excel. This achieves greater transparency and reduces the risk of errors.

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

Financial modelling - Global infrastructure boom drives increased risk

The global surge of activity in the infrastructure sector has been very happily regarded by many people, including us here at Corality.

Learn More