Blog

Category
Archive
Average Internal Rate of Return

Average Internal Rate of Return (AIRR)

An introduction by F1F9: We were approached by Thierry Renard and Carlo Alberto Magni and were intrigued by what they had to say: a new approach to calculating an internal rate of return. What's more, they were illustrating the application of the Average Internal Rate of Return ("AIRR") using Excel...
Modelling Balances

How to Model Balances in Excel

There are two basic types of line item in financial models – flows and balances. Balances are amounts at a point in time. Balances can be financial or non financial. Every balance has similar properties. This blog explains what those properties are, and gives a standard model component that...
Effective Modelling Framework

New ebook: Managing Modelling

The article below is taken from our new ebook: Managing Modelling - How to run an effective modelling team - you can download the full ebook here. Modelling should be a collaborative team-based activity, not an individual activity. Building team spirit and a collaborative environment is...
Agile Financial Modelling EBook

Agile Financial Modelling in 30 seconds

Building financial models is an inherently difficult and complex task. Most guidance on managing the model build process recommends a traditional life-cycle approach of Specify, Design, Develop, Test, Deploy. When applied to most financial modelling assignments this approach doesn’t...