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

EuSprIG 2014 – financial modelling observations

EuSprIG 2014 – financial modelling observations

Haydn Palliser, Managing Director – EMEA and myself represented Corality at EuSprIG 2014 in Delft, Holland in July this year. I would like to share some reflections on the conference, which brought together the crème-de-la-crème of spreadsheet professionals, academics and enthusiasts.

Learn More

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
SEE ALL