If you’re thinking about sitting for the FMI Level 1 Financial Modelling Certification exams, you’d better get started with your preparation as they’re not easy! As a MFM (Level 3 Master Financial Modeler), an exam proctor and an FMI approved training provider, many people ask me about the exam, so here’s some information you will find useful. (more…)
Plum Solutions is very pleased to announce that in partnership with the Financial Modeling Institute (FMI), we will be offering a “Women in Financial Modelling” scholarship aimed at empowering and advancing women within the financial modelling industry. (more…)
As AI technology evolves rapidly through advances such as ChatGPT, let’s consider how this will impact the financial modelling industry. Join industry leaders Jeff Robson, Lance Rubin and Craig Hatmaker and host Danielle Stein Fairhurst for a virtual meetup to discuss how these technological advancements might impact the process of building a model along with the role and skills of a financial modeller both today and in the future. (more…)
Welcome to a 5-part video series on the “Must-have Excel Functions for Financial Modelling”. If your financial model is showing some returns, growth rates or any outputs that are fluctuating quite a bit over time, it’s useful to see what the compound annual growth rate is for this. In part 4 of this series, we take a look at a couple of different ways to calculate the compound annual growth rate (CAGR) using simple Excel functions. (more…)
A Monte Carlo simulation is a numerical method that uses random draws to perform calculations and complex problems. Contrary to what many people think, you don’t need programming knowledge or a fancy software to start using the power of Monte Carlo Simulations in your Excel models. Watch to see the Hybrid meetup replay of the Sydney financial Modelling meetup group with visiting Associate Professor of Finance, David Brown during his trip to Sydney. (more…)
If you’ve had any experience building financial models for others to use, you’re probably familiar with the ways users can use and misuse your model. In fact, one of the key sources of financial model error occurs when a model is not used for its intended purpose or users enter invalid inputs which cause incorrect calculations and inadvertent output error. (more…)
It is well-documented that up to 90% of spreadsheets contain errors and although any individual mistake may be small, they can quickly add up. Checking for errors is an important part of the financial model build and there are many native Excel tools that can be used for this purpose. (more…)
Excel today is not the Excel of yesterday. Dynamic Array Functions and Custom Data Types are just two of the relatively new must-know game-changing features. In this session, Microsoft trainer Mike Thomas gives us a tour of the most useful techniques, incorporating practical use cases that can help take your productivity in Excel to the next level.