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…)
Join us for an enlightening meetup as we continue our journey into the Future of Financial Modelling, powered by cutting-edge technology and AI. Hosted by Danielle Stein Fairhurst, Part 3 in this series culminates with an in-depth exploration of Microsoft Fabric, presented by technology and financial modelling expert, Lance Rubin. He delves into its potential to disrupt traditional OLAP Cube modelling systems that will revolutionise traditional accounting, (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…)
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.
(more…)