Welcome to the
SMART campus

We are dedicated to exceptional financial modelling. Our commitment is to sharing best practice tips and techniques, through step-by-step tutorials following our SMART best practice methodology and insightful blogs, so your financial models give you confidence when it counts.
img-dummy-sign-nick-1.jpgimg-dummy-sign-rick-1.jpg

RECENT CONTENT

Modelling P50 versus P90 wind profiles

Modelling P50 and P90 wind profiles is generally poorly done in the models I am sent. This is maybe one reason we are producing so many financial models for wind projects at the moment!

Learn More

Debt service reserve account (DSRA), financial modelling considerations

The debt service reserve account (DSRA) is a key component in almost every project finance term sheet and financial model. The primary purpose of the DSRA is to protect a lender against unexpected volatility, or interruption, in the cash flow available to service the debt (CFADS). These funds, essentially put aside for a rainy day, are usually established at the end of a construction period, once the loan becomes repayable.

Learn More
OFFSET FUNCTION IN EXCEL

OFFSET FUNCTION IN EXCEL

The OFFSET( ) function returns a cell (or range of cells) that is a specified number of rows and/or columns from the reference cell. In this tutorial we will explain the most common OFFSET( ) applications, and mistakes that are often made using this function in Microsoft Excel.

Learn More
Average DSCR in financial modelling

Average DSCR in financial modelling

There are two different ways to calculate the average debt service coverage ratio 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
SEE ALL