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 through the case ‘Will you be Mine?’ from the Financial Modeling World Cup (FMWC) 2025, handles circular references, avoids using Tables, turns on gridlines and make use of Focus Cell. PLUS, how to tell when you’ve got your answer completely wrong!
★Follow Danielle Stein Fairhurst on LinkedIn
★Compete in the Financial Modeling World Cup (FMWC)
★Purchase the official case solution from FMWC
★Join a financial modellers’ live virtual meetup
