Blog

filter post by
Showing all blog

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

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

Benefits of using excel shortcuts: get your shortcut sheet

Corality’s Excel shortcut sheet is one of our free materials. We’re proud to share it as part of our passion to spread the best practice modelling message.

Learn More