Financial Modelling Smart Campus

All the Excel keyboard shortcuts you will EVER need Download now
10 SMART Guidelines for financial modelling Download


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

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