All they sent was PDF! Can we rebuild the whole model in Excel?
In this episode, Microsoft MVP Danielle Stein Fairhurst tackles a classic valuation problem by recreating a discounted cash flow (DCF) model based on a PDF attachment received via email. Using Power Query in Excel, Danielle walks us through extracting data, building assumptions, and running different scenarios to determine valuation based on various changes such as discount rate and cost of goods sold (COGS). Watch as she navigates (more…)
Working with dates in Excel can be tricky. Conversion is rarely straightforward, as conversion issues and regional format differences can complicate the process of consolidation. Power Query can solve these issues, but knowing the right steps makes all the difference. If you have struggled with dates, you’re not 
In this case, we look at the time value of money and we’ll see what a huge impact adding the dates will make on the rate of return. Watch Microsoft MVP Danielle Stein Fairhurst walk though the “Sweet Time” case 1 of the Financial Modeling World Cup (FMWC) Stage 2 2025. You’ll learn how to calculate the internal rate of return (IRR) for a series of cash flows, the impact of adding dates on the rate of return using XIRR, and how different sales discount 
I started my career in investment banking, where back then, no one talked about having financial modelling skills—it was just expected you were able to do the job. It was just what you did to test assumptions, structure deals, and make decisions.
Let’s build a simple debt calculations to work out the rate of return on the equity cashflows of a project. Watch Microsoft MVP Danielle Stein Fairhurst walk though some questions from “Playing with Repaying” case 1 of the Financial Modeling World Cup (FMWC) Stage 4 2025. Can we build this using dynamic arrays?
Managing dependencies and circular references within Excel can be daunting especially in large financial models. As models grow in size and complexity, the chain of relationships between cells can become increasingly intricate and difficult to follow, making it hard to identify how assumptions and inputs changes might affect 
Artificial Intelligence is here, and financial modellers are under increasing pressure from Boards, banks and management to understand where AI can be applied and how it can deliver real business value. Hear from financial modeller Jeff Robson as he cuts through the hype and focuses on the practical implications of 
