This week’s guide has been put together with Andrew, one of the modelling instructors at F1F9 and looks at depreciation calculations. You’ll see a use of SUMIF that you might not have come across. There are lots of ways of doing these kinds of “look backward” or “look forward” – this is one way that we have found to be useful.
I’ll be taking a break over Easter. After Easter I’ll be sending out a quick survey to find out what you think of the material that’s been produced so far, and what our priorities should be over the next few months. We’ll be publishing a list of “topic ideas” that you may be interested in contributing and also making it clearer how to contribute. Watch out for all that after Easter – as well as our first modelling guide translated into French.
p.s. We will be running a webinar on “Debt Sizing in Excel” on May 8th. The webinar will look at 4 different debt sizing methods using case examples in Excel that we will then share after the webinar. I know it’s cheesy marketing speak to say that it’s “filling up fast” and to “reserve your place now”, but the truth is that we announced it on Thursday and it really is nearly full; we only have capacity for 1,000 people. If you’re interested you can sign up here – Debt sizing in excel
Help make the handbook better