Linking three financial statements and how to balance the balance sheet every time

Being able to build a full financial model with all three financial statements is a foundational skill for any financial modeller. Linking all three dynamically and, most importantly, getting the balance sheet to balance (and stay balanced!) is not always an easy task. Watch to hear from expert financial modeller Carolina Lago as she takes us through her unique and simple approach for building each statement and ensuring the balance sheet balances at every step. (more…)

How Financial Modelling skills can help you on the CFO path

According to top finance experts, the most in-demand “hard skills” for senior finance leaders are financial modelling and analysis. Being able to convert numbers and formulas into strategic and insightful decision-making is, without question, one of the hardest technical skills to master. Watch to hear from financial modelling industry expert, Lance Rubin on how to track your career path towards the most sought-after jobs in Finance. (more…)

Scalable Modelling; using MS Fabric to dislodge OLAP cubes (Future of Financial Modelling Part 3)

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…)

Future of Financial Modelling with ChatGPT – or not? (Part 1)

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…)

Part 5: Calculating CAGR with Excel Functions 

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…)

Predictive Modelling with Monte Carlo Simulations in Excel

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…)

Developing Models to Prevent User Error

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…)

Excel Model Review Tools you need to know

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…)