Financial Modelling Handbook

Financial Modelling Handbook

Latest — Mar 13, 2023

It's here.

I'm off to Delhi this week to run a training course for new graduates who recently joined Gridlines. My bags are packed. Mostly with these: It's rewarding to see the book out in the world, finally. I'll be using the book to support all my training courses in the future,

More guides

The missing ribbon shortcuts in Excel for Mac - updated.

The updated version of Accelerator Keys is the real deal. It supports all ribbon shortcuts and is a must-have for Excel for Mac users.

Financial Modelling Mastermind Group

Last week I posted the idea of a Financial Modelling Mastermind group on LinkedIn. I've included the text of the post below. I had enough interest to make it worthwhile going forward with it. The idea is to create a space for experienced professional modellers to come together to share

A note on beta readers

I think I may have created some confusion with my last post when I mentioned beta readers. I've had quite a few of you message me or leave comments being asked to be added to the list of beta readers. Please allow me to give you some context. I started

Dare I say "nearly there"?

I've been thinking that we are nearly there for weeks now. But we really are nearly there. After my last update, we split the book into two volumes as it was just too big. Once we got the new version back from the designer, we realised it was a terrible

Q&A: What are some of the ways to upstream cash?

Hi Kenny, so what are some ways to upstream cash when there is that cash trap due to the difference between net income and cash flows? Jason Hi Jason, There are a few options that are typically used. These methods are common in Project Finance especially. 1. Shareholder loan. Putting

Q&A: What does "arms-length interest rate" mean in the context of thin capitalisation?

Please could you explain the meaning of a "reasonable arms-length interest rate" test and how this differs to other possible tests? I can't see this detail covered anywhere. Many thanks in advance. David Hi David. Thanks for the question. Let me start by saying I'm not a tax expert or

Q&A: Why does copy across stop?

Hi Kenny, I can successfully create links for "Compound degradation" and "seasonality adjustment". However, in both cases, when I click Ctrl + Shift + a, the macro only copies across the next two columns (which are the constant and unit columns). When I enter the formula for electricity generation and use Ctrl

Q&A: How do I prevent the review tool from turning my model green?

Hi Kenny, First of all thanks a lot for this great course, already of great help in better understanding and reviewing models! I have a practical question, when using comments mine are turning the cell bright green (placing a comment with Ctrl + Alt +q). Is there a way to avoid

Q&A: Why does my balance sheet not balance when I introduce an RCF balance?

Hello, I thank you very much for your work teaching us with great precision the financial modelling tools. I have a question : The initial RCF balance is currently 0 in the model, but if I put an initial RCF balance of 10,000, then it will have an imbalance on