FP&A Today Glenn Hopper
-
- Business
FP&A Today is the podcast for Financial Planning and Analysis. The weekly show dives into the challenges and opportunities within the world of FP&A, interviewing FP&A leaders, CFOs and other finance pros in order to give you the freshest insights and takeaways. Each week our top guests provide actionable advice about financial planning and analysis – from career goals to navigating challenges, and powerful Excel tips.
Our weekly show provides unrivalled insights for navigating FP&A.
FP&A Today is brought to you by Datarails.
Datarails is the financial planning and analysis platform that automates data consolidation, reporting and planning, while enabling finance teams to continue using their own Excel spreadsheets and financial models. Get in touch at www.datarails.com
-
FP&A as Business Intelligence – Len McFall
FP&A professionals are the original business intelligence (BI) experts, says Len Mcfall, senior consultant, finance at Windstream Holdings, a $1billion US telecoms company.
“FP&A itself is synonymous with business intelligence,” he says. “And honestly, weren’t, weren’t we the first business intelligence? We’ve always been working with data. We’ve always been trying to simplify and present data in a meaningful way to people who might not,otherwise be literate.”
In this frank and honest interview McFall, whose background is heavily influenced by BI, gives insights from a 20 year career including HCT Investments, Sitel, Crossroads Treatment Center and a minefield of data at Windstream.
“I’m not a bullet point guy. I’m a paragraph guy” says Len– warning he’s not one for short, snappy answers, but a storyteller who loves to dive deep, as he reveals:
Why 40% of my job is touching base with people to curate all the data we use across the organization
Putting sales on blast: how often do you catch a forecast from a sales organization that’s even 50%, right?
Coming into a company to save them after they were delivering finance reporting 30 days after close (from 30 days to day 8)
the role of data analysis and bi in finance and in the decision making process.
How business runs on “hunches” and why it is FP&A to prove that hunch
Why if you cannot communicate to the business you are useless
The vast amount of data we have access to in telecoms and how we separate the signal from the noise
How finance rubs against IT and why it’s not pretty
Why AI in finance is like a “very smart but green intern” and prompt engineers are ridiculous
Killing for food in winters during his childhood
Connect with Len on Linkedin: https://www.linkedin.com/in/len-mcfall-6274857b/ -
My Adventures in Finance Real Estate: From Whistleblowing Fraud to Big Wins for Residents
CFO Seth Zimmerman faced a triple blow of tests in his decades-long real estate career. Firstly, he witnessed the Lehman collapse first-hand from within a real estate division of the famed bank (“We just got a call from our New York office, a guy in New York. He’s like, well, it’s done. We’re bankrupt.”). Secondly, being forced to blow the whistle when his CEO boss pocketed $1m into his bank account–the day after a $10m raise (the startup is now defunct). Finally, being the finance person when a developer absconded with $12m. “One of the things that I’ve learned is that when it comes to money, you never know what somebody’s going to do”.
In this episode, Seth Zimmerman, CFO at Invest with Roots, explains the core metrics in finance real estate and why things are never cookie cutter (“Every deal is, is different and you have to look at them individually”)
Zimmerman talks:
Life as CFO at Invest with Roots, one of the hottest companies in Atlanta,the only real estate portfolio that creates wealth for renters.
The role of finance at a REIT (Real Estate Investment Trust) – a security that trades like a stock on the major exchanges and reports to the SEC.
Blowing the whistle in finance when a former CFO pocketed $1m
Creating $700,000 for residents at Invest with Roots
Becoming CFO and bringing in budgeting and FP&A processes
Love of modeling and how I am using modeling skills to get into the multifamily space
How to find great finance staff +the accountant recruitment challenge
Favorite Excel function
My motorbike crash
Follow Seth on LinkedIn https://www.linkedin.com/in/sethazimmerman/ -
Ready FP&A One: From Assassin’s Creed to Battling Big Budget Bosses – David Fortin
As a lifelong gamer, David Fortin successfully landed his dream job managing FP&A at Ubisoft – the $2.79 billion gaming company responsible for Assassin’s Creed, Driver, and Far Cry, For Honor. The former PwC auditor then decided to take on an even more daunting leap. He ran FP&A at Saas Startup Polka “building the plane while we were flying” – cue his boss leaving, learning how to fundraise, facing disinterested investors, budgets rejected by the board, the CTO crying, before managing an eventual successful exit (in 2023 the company was acquired by Swedish enterprise software giant IFS). Now he is a full-time YouTuber teaching Excel and Microsoft Copilot – still using finance and analytics to build his business.
In this episode David talks:
PwC CPA audit coming up that way to FP&A
Quebec, loving video games and landing a role at Ubisoft
Moving from a big company to a startup and a steep finance learning curve
Building the plane while flying in FP&A
Learning the sales pitch of funding round facing questions and disinterterested investors
CTOs crying when the budget is rejected by the board
Due diligence and exit – lessons
Becoming a YouTuber making Excel fun again and grasping Microsoft Copilot
How CoPilot and AI will transform FP&A
Scenario analysis in Copilot
20,000 hours of gaming and my favorite Excel function
Follow David on LinkedIn at https://www.linkedin.com/in/david-fortin-cpa-816b20b5/
Follow David’s YouTube channel: https://www.youtube.com/@piggybankaccountant -
The FP&A Playbook from Nestlé, Mars, Kraft Heinz and Amazon: Swati Bagri
From being the First kid in her family to finish high school, Swati Bagri began as a role as auditor at Deloitte (“I did what any 17-year-old smart kid would do. I just followed my friends”). At Deloitte she discovered a “love of finance” realizing it’s “what I want to do for the rest of my life”.
Swati cemented her FP&A career at some of the world’s biggest brands: Nestlé, Mars, Amazon, and Kraft Heinz. At these giants she absorbed and built a playbook to get from “good” to “great” FP&A. Behing the success of FP&A at these teams, she explains is 3 things: strategic planning and forecasting, technology and risk management.
In this episode Swati talks about:
Finance transformation as a significant part of her role (the slippery term of “finance transformation” defined as the “effective use of technology to free up people’s time”)
How predictive analytics was used at Nestlé from rainfall data, and the wider playbook of building financial models with consumers in mind
Hyperinflationary markets like Turkey and Egypt and FP&A and the lessons learned
Business partnering roles at Amazon and Nestlé and what I have learned about successful relationship building towards common objectives
Co-founding The Strategy Story (including learning about Marriage insurance for wedding days)
Start by Explaining the P&L and coaching non-finance folk
War stories – annual planning cycles
FP&A-led transformation at an ecommerce marketplace business and getting buy-in from senior management through a data story
The power of podcasts to keep your at the top of your finance game
Sky Jumping and my favorite Excel function
Connect with Swati Bagri on Linkedin https://www.linkedin.com/in/swatibagri/
Book a mentoring session with Swati at https://topmate.io/swatibagri -
Forecasting and Leading (FP&A) in Las Vegas
We host our first ever FP&A guest from the US casino and gambling sector with the head of FP&A at Genting Americas, a world leader in casinos and lodging with luxurious loactions in Las Vegas, Bimini, Malaysia, Singapore, the Philippines, and the United Kingdom.
Bill Singh is VP FP&A of Genting Americas, part of the world’s largest Destination Resort operator operating as Resorts World . Genting boasting five public companies capitalized at $45 billion and employing more than 50,000 people worldwide. This episode reveals their inside FP&A game including metrics such as “win per unit per day” tacking the “hold”. Bill is strategic leader with more than a decade leading FP&A and providing insights on skills and budgeting management, to insider advice about gaming.
In this episode:
Getting an unexpected offer of an FP&A role at a casino in Nevada
Why FP&A at the “nexus of data and decision-making” is an “ultimate” career path
Critical skills you must develop in FP&A
Giving “X+1” in your FP&A answers
Salesmanship in FP&A
FP&A metrics: “Win per unit per day and hold”
Lodging: occupancy, your ADR, your revenue per available room
Odds and statistics from tables, games and FP&A modeling
Insider advice about gaming (including “Don’t play a game right by the door”)
The power of leading budget for the operating side and the capital budget for all divisions +lessons from 10 years of budgeting
The impact of AI in getting answers faster for operators
MATCH+TEMPO – My favorite Excel function and lessons from drumming
Follow and connect with Bill Singh: https://www.linkedin.com/in/billsinghprofile/ -
Hitmaking, Taylor Swift, and FP&A
What’s the connection between FP&A and Taylor Swift? To answer we are joined by Michael Stotland, Vice President of FP&A at AEG Presents.
AEG Presents is one of the largest live music companies in the world, and most famously the concert promoter behind the $1 billion dollar revenue Eras Tour by Taylor Swift: the highest grossing tour of all time.For good measure, Stotland’s FP&A team also supports the tours of Paul McCartney, Katy Perry Elton John, and the Rolling Stones, and 25 music festivals, including the iconic Coachella Valley Music and Arts Festival, along with Stagecoach, the New Orleans Jazz Fest, hangout Fest, electric Forest, and Firefly.
In this blockbuster episode, we want to teach you how FP&A feels (apologies to Swifties):Michael Stotland VP of FP&A at AEG reveals in conversation with host Glenn Hopper:
How growing up in Los Angeles the entertainment industry the entertainment industry was a natural choice, and starting my career at MGM
Spreading my wings at 20th Century Fox
Building up the FP&A function at MarVista (a TV and movie production company showcasing nearly 2,500 hours of content) and the story behind a facing a “fantastic year” during COVID FP&A leadership at AEG helping live entertainment “ return from the abyss”
“Seeing the financials bounce” back as pent up demand was realized
Pulling external data into daily FP&A work
Heatmaps on beer costs and price of living as part of FP&A planning
Managing 3 areas of FP&A at AEG: General, systems and business strategy units
The FP&A dimension of Taylor Swift Eras Tour
Using local macroeconomics to impact business decision-making – from the UK to Singapore and the US
How Television revenues and licensing of big movies saves movie studios
FP&A swiftness when Kanye West bowed out at the last minute at Coachella
Using AI to look at past events and ticket sales and performance on a contribution margin basis
Looking to optimize how we do FP&A and ambitions to become CFO
Links between FP&A and my triathlon career
Connect with Michael Stotland Vice President, Financial Planning & Analysis at AEG Presents: https://www.linkedin.com/in/mikestotland/
Further Reading:
Rolling Stone: Taylor Swift’s Eras Tour Is the Highest-Grossing of All Time and First-Ever to Hit $1 Billion
Investopedia: Swiftonomics: The Economic Influence of Taylor Swift
Datarails Blog: How FP&A makes Huge Hollywood Hits