Financial Modelling Smart Campus

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

RECENT CONTENT

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

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