With the huge amount of data available to us every day, a well-built and visually appealing dashboard is one of the best ways to interpret and communicate large quantities of information. Learn to quickly and effectively communicate the results of your analysis to be easily interpreted and understood by others at a glance. Hear from Excel modelling specialist, Danielle Stein Fairhurst as she provides an introduction to her popular online workshop “Dashboard Reporting in Modern Excel”. (more…)
Dynamic Arrays in Microsoft 365 Excel have fundamentally changed the way we use Excel for financial modelling. A single cell formula may return several values and they all spill across and/or down the grid. Financial modellers can benefit by using dynamic arrays to offer more business insights with fewer formulae than ever before. (more…)
There’s nothing quite like experience to really hone and sharpen your Excel modelling skills. Every hour that you spend nutting through a problem on the job means that the next time you come across a similar problem, you’ll solve it in a matter of minutes, not hours. This is especially true for creating complicated Excel formulas, or for model design and layout. So often I come across a problem when building a modelling solution for a client and I know I’ve seen this problem before. Whilst it might have taken me half an hour to model it out the first time, often using trial and error but the next time it’ll only take a few minutes. The more experience you’ve got, the quicker and better modeller you’ll be.
Financial models often follow a similar format, but their design, build, layout, drivers and assumptions will be entirely different depending the sector or function for which they will be used. For example, a modeller working in Mergers & Acquisitions will build a model quite differently to a FP&A professional, and a Project Finance Business Case will look very different to Tech startup model.
When embarking upon the budget process for your organisation this year, practical Microsoft Excel tools and strong financial modelling skills will be critical for managing the budget process. Historically, the budget process involves pulling out the financials and rolling them forward, but last year’s actuals can no longer be an automatic target.
I’m often asked what degree of skill level one needs to be able to include financial modelling as a skill on your resume or LinkedIn profile. Once you’ve got an idea of exactly what is financial modelling, what is involved in the modelling process and you feel like you’ve got a good knowledge of financial modelling skills that you have used in the workplace then – yes – “Financial modelling” definitely needs to go on your resume and on LinkedIn. (Hint: no one can endorse you for a skill unless you list it on your profile, so be sure to keep your skills listing up to date).
Traditional management accounting has always had its challenges and the COVID pandemic has made its shortfalls even more apparent. We find ourselves with forecasts and budgets that were not realistic, and we have learnt that organisations must be agile to survive.
The cash flow is an intrinsic part of a project finance model, particularly when modelling the debt schedule. In this live meetup session we hear from Paris-based financial modelling author, lecturer and investment banker, Hedieh Kianyfard as she describes and demonstrates the cash flow waterfall.
If you have obtained your Level 1 AFM qualification from the Financial Modeling Institute (FMI) and are thinking about taking the next step, watch to find out more about Level 2. The next FMI Level 2 Financial Modelling certification exam is coming up on 24th April, and again in October 2020, and you may be wondering what to expect on the day, or how you can best get ready to give yourself the best possible chance of success.
If you are thinking about sitting for the next FMI Level 1 Financial Modelling certification exam, you may be wondering what to expect on the day, or how you can best get ready to give yourself the best possible chance of success. In this session we hear from FMI representative, Julian Cupillari and FMI Approved Training Provider, Danielle Stein Fairhurst to find out more about the exam. We will be sharing some tips and tricks to help you prepare and will also be joined by a panel of AFM modellers from around the world (Nicole Cambridge, Jamie Hughes, Adza Stella Vajime and Rafi Al Kabid) who were answering audience questions and sharing their strategies on how they passed and gained this rigorous qualification!