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...
Collaborative Financial Modelling

New ebook on collaborative financial modelling

The article below is taken from our new ebook: Managing Modelling - How to run an effective modelling team, it's available for you to download free of charge and with no form-filling. Financial modelling should be a collaborative team-based activity, not an individual activity. Building team...