The FP&A Guy Network

This week on Future Finance before getting to our guest interview HAL 9000l makes a guest appearance and Glenn has a fun discussion about romantic relationships and AI that you will not want to miss. 

Welcome to the exciting world of Future Finance! Today's episode dives into the exploration of the dynamic intersection of AI and finance. Ben Dooley, the global head of Productized Solutions at Infospace, joins Paul Barnhurst and Glenn Hopper for a thought-provoking discussion on responsible AI, strategic innovation, and the future of financial automation.

Here are the key takeaways to whet your appetite for the full episode:

• Ben emphasizes the importance of a responsible AI framework that includes human-centric design, fairness, explainability, security, reliability, and compliance to ensure ethical and effective AI implementation.

• Tailoring AI to meet human needs without mimicking human intelligence is crucial for making AI tools that enhance human capabilities and ensure user trust.

• The need for AI to be explainable is highlighted, with Ben suggesting models should cite their sources and provide logic for their decisions to build trust and understanding among users.

• Privacy concerns around AI usage are discussed, emphasizing the necessity for better regulatory frameworks to control who has access to data and how it is used.

• The discussion on how AI can play a strategic role in finance by improving forecasting, automating processes, and driving strategic transformation within organizations.

• The discussion touches on the current capabilities of AI in automating traditional finance tasks and the potential future where true autonomous agents could revolutionize the industry.

With over a decade of experience in managing complex projects, driving corporate change, and leading entrepreneurial ventures, Ben is an expert in AI and change management. This insightful episode with Ben Dooley underscores the importance of responsible AI and its transformative potential in finance.

Follow Ben:

LinkedIn: https://www.linkedin.com/in/bendooley/

Website: https://www.infocepts.ai/

Follow Glenn:

LinkedIn: https://www.linkedin.com/in/gbhopperiii

Follow Paul:

LinkedIn: https://www.linkedin.com/in/thefpandaguy

Follow QFlow.AI:

Website - https://qflow.ai/future-finance

Stay tuned for a deeper understanding of how AI is shaping the future of finance and what it means for businesses and individuals alike.

Future Finance is sponsored by QFlow.ai, the strategic finance platform solving the toughest part of planning and analysis: B2B revenue. Align sales, marketing, and finance, speed up decision-making, and lock in accountability with QFlow.ai.

Learn more at Qflow.ai/future-finance.

In today's episode:

[01:16] - Episode Overview and Sponsorship

[03:00] - Responsible AI Framework Introduction

[04:40] - Reliability and Compliance in AI

[06:21] - Current AI Capabilities and Risks

[11:47] - Guest Introduction

[12:14] - AI in Traditional Finance Tasks

[17:52] - Fairness and Bias in AI

[19:40] - Trust and Verification in AI

[22:02] - Strategic Use of AI and Balancing Privacy in Finance

[27:32] - Future Predictions for AGI

[28:52] - Other Exciting Technologies

[31:57] - Fun rapid-fire Session

[34:20] - Best Career Advice

[36:34] - Conclusion

Welcome to the Financial Modeler's Corner (FMC), where we discuss the Art and Science of Financial Modeling with your host Paul Barnhurst.

Financial Modeler's Corner is sponsored by the Financial Modeling Institute (FMI), the most respected accreditation in Financial Modeling globally.

In today’s episode, Paul engages in a conversation with Brian Vaddan.

Brian Vaddan is a distinguished financial modeler with a rich background in investment banking and financial engineering. His emphasis on intellectual curiosity, the need for simplicity, and the creative nature of financial modeling provide listeners with a fresh perspective on the discipline.

Key takeaways from this week's episode include:

• A distinction between those who use spreadsheets casually and those who build models as a core discipline. He emphasizes the importance of creating models that are understandable and usable by others, akin to the difference between a sketch artist and an architect.

• Intellectual curiosity, an almost obsessive desire to solve problems, and the ability to bring structure out of chaos are highlighted as key traits for successful financial modelers. Brian stresses that these traits are more critical than technical skills alone.

• One of the profound insights shared is the importance of simplifying complex problems. Brian believes that the true measure of a modeler’s intellect is their ability to present complex ideas in a straightforward and understandable manner.

• Financial modeling is described as a deeply creative exercise. Brian compares it to art, where each model reflects the modeler’s thought process and experiences, much like an artist’s painting.

• Brian shares his experience transitioning from being a modeler to managing a team. He discusses the challenges of letting go and empowering others, and the iterative learning process involved in both building and reviewing models.

Quotes:

Here are a few relevant quotes from the episode on financial analysis and modeling:

"I guess, the easiest way for me to describe it is the difference between somebody who sketches on paper and someone who's an architect, or someone who has a hammer and someone who's an actual carpenter.”- Brian Vaddan

“One of the primary differences is that you will do it for someone else. So when I built a lot of the initial models from the earlier part of my career, it was for me. It was to derive an answer that I needed to a question that was asked of me.”- Brian Vaddan

“The way you display the depth of your intellect, to me, is not the complexity in the formula that you build, but how you take that complex formula and simplify it into a manner that anyone with just a basic understanding can understand.”- Brian Vaddan

“Never stop learning and don't quench that intellectual curiosity that will make your modeling experience and career so much richer and so much more rewarding.”- Brian Vaddan

In this engaging episode of Financial Modeler's Corner, Brian Vaddan shares his insights on the intricacies of financial modeling. He recounts his journey from investment banking to EY, emphasizing the importance of intellectual curiosity and perseverance. He advises aspiring modelers to maintain a growth mindset and continually seek learning opportunities, providing valuable insights into the discipline of financial modeling.

Sign up for the Advanced Financial Modeler Accreditation Today and receive 15% off by using the special show code ‘Podcast’. Visit www.fminstitute.com/podcast and use code “Podcast” to save 15% when you register.  

Go to https://earmarkcpe.com, download the app, take the quiz and you can receive CPE credit. 

View and download the Financial Modeling Code at financial-modelling-code.ashx (icaew.com)

Follow Brian:

• LinkedIn - https://www.linkedin.com/in/brian-vaddan-62ba7325/

Follow Paul: 

• Website - https://www.thefpandaguy.com   
• LinkedIn - https://www.linkedin.com/in/thefpandaguy  
• TikTok - https://www.tiktok.com/@thefpandaguy  
• YouTube - https://www.youtube.com/@thefpaguy8376  

Follow Financial Modeler's Corner  

• LinkedIn Page- https://www.linkedin.com/company/financial-modeler-s-corner/?viewAsMember=true  
• Newsletter - Subscribe on LinkedIn- https://www.linkedin.com/build-relation/newsletter-follow?entityUrn=7079020077076905984

In today’s episode:

[00:03] - Introduction

[01:00] - Guest Introduction

[01:14] - Horror Story

[03:40] - Rule of Thumb

[04:10] - Guests’ Background

[06:28] - Spreadsheets vs. Modeling

[10:16] - Essential Traits for Modelers

[13:30] - Modeling as a Discipline

[19:00]  - Simplicity in Complexity

[24:00] - Modeling as a Creative Exercise

[28:10] - Transition to Team Leadership

[33:00] - Rapid-Fire Session and Guests’ Contact Information

[38:10] - Conclusion

Welcome to FP&A Tomorrow, where we discuss financial planning and analysis, examining its current state and future prospects, with your host Paul Barnhurst.

In today’s episode, Paul engages in an insightful roundtable discussion with Julio Martinez on how mid-market companies can harness the power of technology, data, and business partnering to drive performance and accountability.

Julio, a visionary in the finance world, currently serving as the CEO of Abacum. His passion for innovation and technology makes him a leading voice in transforming the finance sector. With over two decades of experience in finance, investment banking, and fintech, Julio brings unparalleled insights into the evolving landscape of FP&A.

Key takeaways from this week's episode include:

Here is a concise summary of the key points from the discussion:

• Effective FP&A requires breaking down traditional silos in finance, fostering collaboration, empathy, and rapport to influence and persuade stakeholders across the organization.

• Mid-market companies face unique challenges with data volume and complexity. They require tailored solutions that provide sophisticated capabilities without the long implementation times of enterprise-level software.

• Clean, well-organized data is essential. Many FP&A teams still spend excessive time on data cleaning and assembly, limiting their ability to focus on strategic business partnering.

• The CFO's role is evolving towards a Chief Performance Officer, integrating strategy, operations, and performance management to drive accountability and execution throughout the organization.

• There is a growing trend for FP&A to take on revenue operations and data analytics roles, ensuring objective performance analysis and avoiding biases from other departments.

• Despite advancements in technology, mastery of spreadsheets remains a critical technical skill for FP&A professionals, along with knowledge of SQL and potentially Python for data modeling.

• Taking a sabbatical can be a powerful, life-changing experience, providing valuable personal and professional growth that can significantly impact one's career trajectory.

Quotes:

Here are a few relevant quotes from the episode 

• "FP&A will become the command center of the company's operational rhythm.”- Julio Martinez

• “The mid-market is a very unique, complex, sophisticated, and underserved category.”- Julio Martinez
• 
  
• “I think professionals still need to master Excel and Google Sheets and that spreadsheet realm.”- Julio Martinez

This conversation with Julio Martinez offers an in-depth look into the current and future state of FP&A, emphasizing the importance of business partnering and the transformative power of technology. As the FP&A field continues to evolve, professionals can take inspiration from Julio's journey and the innovative approaches discussed in this episode to excel in their roles.

Exciting Announcement

I am excited to share my two new digital FP&A Courses with you FP&A Business Partnering, and Modern Excel. They just launched and I am excited to offer a 20% discount to my listeners using code PODCAST.

Link to courses: 

FP&A Business Partnering (thinkific.com)

Modern Microsoft Excel (thinkific.com)

Follow Julio:

LinkedIn - https://www.linkedin.com/in/thejuliomartinez/

Website - https://www.abacum.io/

Follow Paul:

Website - https://www.thefpandaguy.com 

LinkedIn - https://www.linkedin.com/in/thefpandaguy

For CPE credit please go to earmarkcpe.com, listen to the episode, download the app, and answer a few questions. For AFP FPAC certification answer the questions and contact Paul Barnhurst for further details.

In today's episode:

[00:50] - Introduction

[01:48] - Guest Introduction

[03:54] - Blending of Operations in FP&A

[04:47] - Guest’s Background and Career Journey

[07:00] - The Value of a Sabbatical

[09:12] - The Impact of Community in Microfinance

[14:57] - Launching Fintech Startups and the Transition to Abacum

[18:16] - Why FP&A for a Startup- Motivation from Guest

[20:30] - Identifying Key Pain Points in FP&A

[23:34] - Mid-Market FP&A Challenges and Opportunities

[33:59] - Opportunities in Business Partnering for FP&A

[36:00] - Rapid-Fire Session

[39:50] - Get to Know Guest

[42:22] - Conclusion

Welcome to a special episode of our podcast! Today, we're thrilled to bring you an exciting Podswap. We are sharing an episode from Financial Modeler’s Corner.  Stay tuned for an engaging conversation you won't want to miss. 

Here are the show notes from our previous episodes.

Welcome to the Financial Modeler's Corner (FMC), where we discuss the Art and Science of Financial Modeling with your host Paul Barnhurst.

Financial Modeler's Corner is sponsored by the Financial Modeling Institute (FMI), the most respected accreditation in Financial Modeling globally.

In today’s episode, Paul engages in a conversation with Cameron and Nicholas Hay to discuss dynamic arrays in financial modeling. Cameron and Nicholas share their experiences and insights on using dynamic arrays to build fully dynamic models, avoiding common pitfalls, and the benefits of this approach.

Cameron and Nicholas are seasoned financial modeling experts and co-founders of Finomatic Consulting. Their practical advice and innovative tips have helped countless professionals enhance their modeling skills.

Key takeaways from this week's episode include:

• Use dynamic arrays to reduce the number of formulas and potential error points. Clearly separate inputs, calculations, and outputs into distinct sheets. This enhances clarity and ease of use.

• Ensure uniform column and row structures across sheets. This consistency minimizes errors and simplifies formula management, making models easier to audit and understand.

• Mixing traditional Excel formulas with dynamic arrays reduces the benefits. A complete commitment ensures better performance and error reduction.

• Using graphs and charts helps quickly identify trends and anomalies, making it easier to ensure realistic assumptions and accurate models.

• Establishes a solid foundation, ensuring you learn best practices early on, which prevents the development of bad habits and enhances overall modeling skills.

• Implementing dynamic arrays can drastically reduce the file size and complexity of models, making them more efficient and manageable.

• Issues like mixed calculations and unrealistic assumptions emphasize the importance of thorough checks and realistic inputs in financial modeling.

Download a sample fully dynamic 3-statement model Excel Files — The FP&A Guy (thefpandaguy.com), courtesy of Cameron and Nicolas Hay. 

Quotes:

Here are a few relevant quotes from the episode on financial analysis and modeling:

"A blank Excel workbook doesn't have any errors in it until you add data and formulas. Minimizing the number of formulas should reduce the error potential of the file.”

“With business, if you can understand how cash flows around a business, that's you can get in and really understand a business.”

“If you're going to dip your toe into dynamic arrays, you've got to make sure you commit fully with 100% commitment.”

Follow Cameron and Nicholas:

Cameron Hay LinkedIn - https://www.linkedin.com/in/cameron-hay-ca-a31b4752/

Nicholas Hay LinkedIn- https://www.linkedin.com/in/nicholas-hay-1992/

Website - https://finomatic.co.uk/

Follow Paul: 

Website - https://www.thefpandaguy.com   

LinkedIn - https://www.linkedin.com/in/thefpandaguy  

Follow Financial Modeler's Corner  

LinkedIn Page- https://www.linkedin.com/company/financial-modeler-s-corner/?viewAsMember=true  

Newsletter - Subscribe on LinkedIn- https://www.linkedin.com/build-relation/newsletter-follow?entityUrn=7079020077076905984

In today’s episode:

[00:03] - Introduction

[00:40] - Guest Introduction and Theme for the Week: Dynamic Arrays

[01:50] - The Worst Financial Model the Guest Experienced

[02:00] - Horror Stories: Mixed Calculations and Unrealistic Assumptions

[04:10] - Key Takeaways from Horror Stories

[05:00] - Guests’ Backgrounds and Career Journeys

[10:00] - The Importance of Structure and Design in Financial Modeling

[14:10] - Introduction to Dynamic Arrays and Their Benefits

[21:30] - Challenges with Corkscrews and Lambdas

[31:20] - Rapid-Fire Session and Guests’ Contact Information

Welcome to a special episode of our podcast! Today, we're thrilled to bring you an exciting Podswap. Stay tuned for an engaging conversation you won't want to miss. Here are the show notes from our previous episodes.

TLDR: These show notes were optimized using Claude AI Haiku and are designed to make you listen to the full episode. We even asked Haiku to provide a Haiku summarizing the show notes for your reading pleasure.

Haiku:

Finance takes new shape,

AI-driven transformation,

Shaping the future. 

Prepare to be captivated as hosts Paul Barnhurst and Glenn Hopper welcome Sasha Orloff, CEO of Puzzle, to uncover the technological advancements reshaping the world of finance and accounting. In this eye-opening episode, you'll discover:

- How generative AI is seamlessly integrating into everyday software, automating tasks and delivering data-driven insights.

- The rise of "AI agents" in 2024 - advanced systems designed to autonomously process complex problems and provide tailored solutions.

- Sasha's visionary project, Puzzle, modernizing accounting software with real-time, flexible financial data processing.

- The transformative potential of blockchain technology to enhance transparency and traceability of financial transactions.

- The future of finance is reimagined through AI and predictive analytics, empowering more precise forecasting and strategic decision-making.

Sasha shares his insightful perspective:

- "I'm building Puzzle, which is modern accounting software for growing companies."

- "We may not yet be at a point where AI is going to take our jobs, but the future will be divided into two camps: people who use AI and those who don't. One of these groups is going to be left behind."

Don't miss this captivating conversation that explores the intersection of finance, technology, and AI. Gain invaluable insights to stay ahead of the curve and thrive in the rapidly evolving world of corporate finance.

Follow the Conversation:

• Glenn Hopper (LinkedIn: https://www.linkedin.com/in/gbhopperiii)

• Paul Barnhurst (LinkedIn: https://www.linkedin.com/in/thefpandaguy)

• Sasha Orloff (LinkedIn: https://www.linkedin.com/in/saor/)

• Puzzle (LinkedIn: https://www.linkedin.com/company/puzzlefin, Website: https://puzzle.io)

Future Finance is sponsored by Qflow.ai. Learn more at Qflow.ai/future-finance.

Financial Modeler’s Corner is sponsored by the Financial Modeling Institute. Learn more at https://fminstitute.com/podcast/.

In today's episode:

[01:52] Introduction

[03:30] The latest phase of the AI revolution

[04:49] Pros and cons of chatbots and the rise and evolution of AI agents

[09:15] Recent updates about AI

[12:51] Guest’s background

[14:00] Insights from guest’s career

[16:35] Introduction of Puzzle and future of general ledger in accounting

[25:10] How blockchain can be an effective tool for accounting

[30:22] How AI and predictive analytics can change finance in upcoming years

[34:32] Democratization of data science and various uses of machine learning

[39:05] Lighting Round Questions

Welcome to FP&A Tomorrow, where we discuss financial planning and analysis, examining its current state and future prospects, with your host Paul Barnhurst.

In today’s episode, Paul engages in an insightful roundtable discussion with Nathan Kaemingk & Karan Sood on LinkedIn. In the episode, we discuss the nuances of strategic pricing and its immense impact on business profitability.

Karan, a seasoned pricing professional, shares his extensive experience across various industries, emphasizing the importance of cross-functional alignment and value-based pricing.

Nathan, with a unique background in mechanical engineering and forecasting, highlights the critical role of understanding costs and leveraging pricing strategies to combat inflation and optimize profits.

Key takeaways from this week's episode include:

Here is a concise summary of the key points from the discussion:

• Effective pricing requires collaboration between finance, FP&A, and pricing teams. Transparent communication and alignment on goals are essential to ensure cohesive strategies that drive profitability.

• Value-based pricing is the gold standard, especially in service industries. By quantifying and communicating the value provided to customers, businesses can justify higher prices and enhance profitability.

• Inflation significantly affects pricing strategies. Companies must adjust prices to keep up with rising costs and maintain profit margins, making strategic pricing more critical than ever.

• Relying solely on cost-plus pricing can lead to missed opportunities. Understanding customer value and competitive positioning allows for more strategic price setting, rather than simply adding a margin to costs.

• Constructively using promotions and discounts can drive volume without eroding profit margins. Measuring and optimizing these strategies ensures they contribute positively to overall profitability.

• Rebates can be effective for maintaining uniform pricing across different channels and incentivizing performance. However, companies must measure and adjust rebate programs regularly to ensure they are beneficial.

• Accurate forecasting and aligning sales with operational capacity are crucial. Effective sales inventory and operations planning [SIOP] can significantly increase net profit margins by optimizing resource utilization and pricing strategies.

Quotes:

Here are a few relevant quotes from the episode 

• "The art of pricing goes beyond just number crunching, it goes into cross-functional alignment on what the goals are."

• “The 1% increase in price leads to an 11% increase in profit margins coming out of McKinsey years ago. It still holds true.”

• “It's amazing how easy it is to increase profits by being good at pricing.”

• “Pricing is going to become one of the most important things that we get good at over the next half-decade.”

Exciting Announcement

I am excited to share my two new digital FP&A Courses with you FP&A Business Partnering, and Modern Excel. They launched yesterday and I am excited to offer a 20% discount to my listeners. Use code PODCAST.

Link to courses: 

FP&A Business Partnering (thinkific.com)

Modern Microsoft Excel (thinkific.com)

Follow Karan:

LinkedIn - https://www.linkedin.com/in/soodkaran/

Website - https://www.kobo.com/

Follow Nathan:

LinkedIn - https://www.linkedin.com/in/nathankaemingk/

Website - https://www.betterforecasting.com/

Follow Paul:

Website - https://www.thefpandaguy.com 

LinkedIn - https://www.linkedin.com/in/thefpandaguy

For CPE credit please go to earmarkcpe.com, listen to the episode, download the app, and answer a few questions. For AFP FPAC certification answer the questions and contact Paul Barnhurst for further details.

In today's episode:

[01:10] - Introduction

[02:00] - Guest Introduction

[03:00] - Misconceptions About Pricing

[04:20] - The importance of Value-Based Pricing

[07:00] - The Role of FP&A in Pricing

[11:40] - Leveraging Digital Courses for FP&A Professionals

[12:00] - Guest Backgrounds

[18:40] - Impact of Inflation on Pricing

[22:00] - Strategies for Competitive Markets

[26:30] - Effective Rebate Strategies

[31:00] - Collaboration Between Finance and Pricing Teams

[36:10] - Rapid-Fire Session

[58:30] - Conclusion

TLDR: These show notes were optimized using Google Gemini after we tried Meta Llama 3 8B and ran into issues. The show notes are designed to make you listen to the full episode thanks to AI. 

Below is a poem for the show from Gemini

• The numbers whiz by,
• a blur in the night, 
• Financial wizards locked in a fight. 
• AI swoops in, a tool sharp and bright, 
• Saving precious hours, 
• making data take flight.

Future Finance: AI Revolutionizes Financial Planning

Welcome to the exciting world of Future Finance! Today's episode dives into the transformative power of Artificial Intelligence (AI), specifically generative AI, in the financial industry. Our guest, Adam Tzagournis, a CPA, full-stack developer, and the founder of FlowCog Canvas, joins Paul Barnhurst and Glenn Hopper for a thought-provoking discussion.

Here are the key takeaways to whet your appetite for the full episode:

• Generative AI for the Win: Researchers are making significant strides in AI, with studies demonstrating its ability to outperform human analysts in tasks like financial statement analysis. This translates to more accurate and timely insights for better decision-making.

• AI as a Powerhouse for Productivity: Generative AI automates repetitive tasks such as data analysis and reporting, freeing up valuable time for finance professionals to focus on strategic analysis and decision-making.

• Human-AI Collaboration is Key: The future lies in a collaborative approach where AI empowers human expertise. Financial professionals can leverage AI tools to gain deeper financial insights and proactive risk management strategies.

• The Rise of the Evolving Workforce: The financial industry is on the cusp of a transformation. While some jobs may be displaced by AI, new roles will emerge, emphasizing the need for data science and AI literacy.

Follow Adam:

LinkedIn: https://www.linkedin.com/in/adam-tzagournis-cpa/

Website: https://canvas.flowcog.com/

Follow Glenn:

LinkedIn: https://www.linkedin.com/in/gbhopperiii

Follow Paul:

LinkedIn: https://www.linkedin.com/in/thefpandaguy

Follow QFlow.AI:

Website: https://qflow.ai/future-finance

Stay tuned for the full episode where you'll learn more about the exciting applications of generative AI in financial projections, the future of financial roles, and much more

Future Finance is sponsored by QFlow.ai, the strategic finance platform solving the toughest part of planning and analysis: B2B revenue. Align sales, marketing, and finance, speed up decision-making, and lock in accountability with QFlow.ai.

Learn more at Qflow.ai/future-finance.

In today's episode:

[06:54] Introduction

[07:30] AI and Nose-Picking

[08:55] Guest Introduction

[10:10] Early Adoption of AI

[13:28] Generative AI in Financial Projections

[17:00] Pace of AI Advancements

[18:12] AI as a Productivity Tool

[25:39] AI for Small and Medium Businesses

[30:35] Fun rapid-fire Session

[33:40] Future of Finance Predictions

[36:50] Contact information for more learning opportunities

Welcome to the Financial Modeler's Corner (FMC), where we discuss the Art and Science of Financial Modeling with your host Paul Barnhurst.

Financial Modeler's Corner is sponsored by the Financial Modeling Institute (FMI), the most respected accreditation in Financial Modeling globally.

In today’s episode, Paul engages in a conversation with Cameron and Nicholas Hay to discuss dynamic arrays in financial modeling. Cameron and Nicholas share their experiences and insights on using dynamic arrays to build fully dynamic models, avoiding common pitfalls, and the benefits of this approach.

Cameron and Nicholas are seasoned financial modeling experts and co-founders of Finomatic Consulting. Their practical advice and innovative tips have helped countless professionals enhance their modeling skills.

Key takeaways from this week's episode include:

• Use dynamic arrays to reduce the number of formulas and potential error points. Clearly separate inputs, calculations, and outputs into distinct sheets. This enhances clarity and ease of use.

• Ensure uniform column and row structures across sheets. This consistency minimizes errors and simplifies formula management, making models easier to audit and understand.

• Mixing traditional Excel formulas with dynamic arrays reduces the benefits. A complete commitment ensures better performance and error reduction.

• Using graphs and charts helps quickly identify trends and anomalies, making it easier to ensure realistic assumptions and accurate models.

• Establishes a solid foundation, ensuring you learn best practices early on, which prevents the development of bad habits and enhances overall modeling skills.

• Implementing dynamic arrays can drastically reduce the file size and complexity of models, making them more efficient and manageable.

• Issues like mixed calculations and unrealistic assumptions emphasize the importance of thorough checks and realistic inputs in financial modeling.

Download a sample fully dynamic 3-statement model Excel Files — The FP&A Guy (thefpandaguy.com) courtesy of Cameron and Nicolas Hay. 

Quotes:

Here are a few relevant quotes from the episode on financial analysis and modeling:

"A blank Excel workbook doesn't have any errors in it until you add data and formulas. Minimizing the number of formulas should reduce the error potential of the file.”

“With business, if you can understand how cash flows around a business, that's you can get in and really understand a business.”

“If you're going to dip your toe into dynamic arrays, you've got to make sure you commit fully with 100% commitment.”

Sign up for the Advanced Financial Modeler Accreditation Today and receive 15% off by using the special show code ‘Podcast’. Visit www.fminstitute.com/podcast and use code “Podcast” to save 15% when you register.  

Go to https://earmarkcpe.com, download the app, take the quiz and you can receive CPE credit. 

View and download the Financial Modeling Code at financial-modelling-code.ashx (icaew.com)

Follow Cameron and Nicholas:

• Cameron Hay LinkedIn - https://www.linkedin.com/in/cameron-hay-ca-a31b4752/
• Nicholas Hay LinkedIn- https://www.linkedin.com/in/nicholas-hay-1992/
• Website - https://finomatic.co.uk/

 Follow Paul: 

• Website - https://www.thefpandaguy.com   
• LinkedIn - https://www.linkedin.com/in/thefpandaguy  
• TikTok - https://www.tiktok.com/@thefpandaguy  
• YouTube - https://www.youtube.com/@thefpaguy8376  

Follow Financial Modeler's Corner  

• LinkedIn Page- https://www.linkedin.com/company/financial-modeler-s-corner/?viewAsMember=true  

• Newsletter - Subscribe on LinkedIn- https://www.linkedin.com/build-relation/newsletter-follow?entityUrn=7079020077076905984

In today’s episode:

[00:03] - Introduction

[00:40] - Guest Introduction and Theme for the Week: Dynamic Arrays

[01:50] - The Worst Financial Model the Guest Experienced

[02:00] - Horror Stories: Mixed Calculations and Unrealistic Assumptions

[04:10] - Key Takeaways from Horror Stories

[05:00] - Guests’ Backgrounds and Career Journeys

[10:00] - The Importance of Structure and Design in Financial Modeling

[14:10] - Introduction to Dynamic Arrays and Their Benefits

[21:30] - Challenges with Corkscrews and Lambdas

[31:20] - Rapid-Fire Session and Guests’ Contact Information

Welcome to FP&A Tomorrow, where we discuss financial planning and analysis, examining its current state and future prospects, with your host Paul Barnhurst.

In today’s episode, Paul engages in an insightful interaction with Philip Watson, for a discussion on what it takes to excel in financial planning and analysis (FP&A).

Philip, the CFO of Paddle, brings a wealth of knowledge, having led FP&A at ZoomInfo through its rapid growth and IPO. He is known for his commitment to developing talent, Philip's leadership has shaped the careers of many finance professionals. Currently leading Paddle’s financial strategy, Philip is transforming how fintech companies handle complex financial operations.

Key takeaways from this week's episode include:

Here is a concise summary of the key points from the discussion:

• Great FP&A extends beyond finance skills, encompassing the ability to communicate with stakeholders, understand the business, and manage relationships. It's about being operationally involved, translating complex financial stories, and driving business insights.

• While finance skills are fundamental, the future of FP&A will require advanced technical abilities. Soft skills, like communication and stakeholder management, remain crucial, but familiarity with data science and coding will become increasingly important.

• Emphasizing the importance of small, incremental improvements, aiming for 1% better every day. This approach, combined with rigorous measurement and process optimization, helps drive long-term business success and operational excellence.

• Sales compensation is a significant driver of behavior and revenue. Aligning incentives with business goals is essential to ensure that sales efforts contribute positively to the company’s financial health and strategic objectives.

• Implementing a detailed, three-statement forecast on a rolling 18-month basis provides valuable insights into future business performance. This process requires the right tools, experienced personnel, and a robust infrastructure to ensure accuracy and reliability.

• FP&A serves as an excellent training ground for becoming a CFO. Exposure to various business aspects, forecasting, and financial strategy prepares professionals for leadership roles, making FP&A a vital stepping stone in a finance career.

The title sponsor for this week’s episode of FP&A Tomorrow is Plan Buddies. Plan Buddies, where professionals meet excellence. Ready to elevate your career? Visit plan-buddies.com and become a member today. Here's a special treat. Use the promo code TheFPandAGuy, that is TheFPandAGuy for an exclusive 25% discount on your first-year membership.

Quotes:

Here are a few relevant quotes from the episode 

• "Some of the nice stuff, some of the machine learning stuff will probably take care of some of the grunt kind of modeling grunt, grinding through Excel that we have now, and it will automate some of that. It won't replace. I don't think it will replace people. It will change their job."

• “I think FP&A is probably the best launchpad for being a CFO. You get exposure to all the business leaders. You get exposure to all other aspects. It forces you to think ahead and not behind.”

• “Your job is to go translate numbers, to go communicate to the business, and be out with the business, in the meetings, in the room. It's important to be in the room.”

• “Sales comp is a massive driver. I mean, compensation is a massive driver of behavior.”

Follow Philip:

LinkedIn - https://www.linkedin.com/in/philipawatson

Website - https://www.paddle.com

Follow Paul:

Website - https://www.thefpandaguy.com 

LinkedIn - https://www.linkedin.com/in/thefpandaguy

For CPE credit please go to earmarkcpe.com, listen to the episode, download the app, and answer a few questions. For AFP FPAC certification answer the questions and contact Paul Barnhurst for further details.

In today's episode:

(01:10) - Introduction

(01:45) - Guest Introduction

(02:00) -  Defining Great FP&A

(03:25) - Future of FP&A

(04:20) - Guest Background

(06:04) - Scaling at ZoomInfo

(18:17) - FP&A as A Launchpad for CFO

(27:40) - Sales Commission Strategies

(32:47) - Effective Forecasting Practices

(41:49) - Rapid-Fire Session

(43:20) - Guest’s Personal Insights

(45:30) - Advice for FP&A Business Partners

Welcome to the Financial Modeler's Corner (FMC), where we discuss the Art and Science of Financial Modeling with your host Paul Barnhurst.

Financial Modeler's Corner is sponsored by the Financial Modeling Institute (FMI), the most respected accreditation in Financial Modeling globally.

In today’s episode, Paul engages in a conversation with Gary Knott, to discuss invaluable insights and tips on avoiding common Excel pitfalls, structuring workbooks for success, and the importance of consistency and clarity.

Gary is a seasoned financial modeling expert and author of "Avoid Excel Horror Stories." He shares his golden ground rules for Excel modeling. With a background at Deloitte and his successful consultancy, Gary's practical advice and innovative tips have helped countless professionals enhance their modeling skills.

Key takeaways from this week's episode include:

• Organize workbooks with clear, logical structures. Separate inputs, calculations, and outputs into distinct sheets. Use consistent naming conventions and separator sheets to enhance clarity and ease of use.

• Maintaining a consistent design throughout the workbook. Use uniform column and row structures across sheets. Consistency minimizes errors and simplifies formula management, making models easier to audit and understand.

• Formal training in financial modeling is crucial. It establishes a solid foundation, ensuring you learn best practices early on, which prevents the development of bad habits and enhances overall modeling skills.

• Real-life horror stories highlight common errors, such as improper data copying and pasting. Ensuring consistent data formats and understanding the intricacies of your calculations are essential to avoid costly mistakes.

• Use Macros for repetitive tasks like generating output sheets, not for complex calculations. They help automate processes and reduce manual errors but should be applied judiciously to maintain model integrity.

• Implement data validation to restrict inputs. This minimizes user errors by ensuring only valid data entries are made, such as positive numbers or specific date ranges, enhancing the reliability of your models.

• Regularly test models to ensure accuracy. Use master check sheets to consolidate checks and quickly identify errors. This proactive approach helps maintain the model’s integrity and reliability over time.

Quotes:

Here are a few relevant quotes from the episode on financial analysis and modeling:

"Consistency is key." I think of all the rules there are, that's the one. If you follow that one, that can bring you a long way in terms of getting a reliable model.

“Certainly, getting trained early, not trying to learn it yourself, but taking some formal training course so you can learn the basics.”

“I'm always a very keen fan of putting checks in models, collating them all on a master check sheet, and then adding them all up.”

"If the difference is zero, then your balance sheet balances. You can send that through to a master check sheet. Then if you add them all up, all the checks up and they're totally zero, then you haven't identified any issues"

Sign up for the Advanced Financial Modeler Accreditation Today and receive 15% off by using the special show code ‘Podcast’. Visit www.fminstitute.com/podcast and use code “Podcast” to save 15% when you register.  

Go to https://earmarkcpe.com, download the app, take the quiz and you can receive CPE credit. 

View and download the Financial Modeling Code at financial-modelling-code.ashx (icaew.com)

Follow Gary:

• LinkedIn - https://www.linkedin.com/in/garyknottconsulting/
• Website - https://www.knott-consulting.com/
• Book - Amazon.com: Avoid Excel Horror Stories

 Follow Paul: 

• Website - https://www.thefpandaguy.com   
• LinkedIn - https://www.linkedin.com/in/thefpandaguy  
• TikTok - https://www.tiktok.com/@thefpandaguy  
• YouTube - https://www.youtube.com/@thefpaguy8376  

Follow Financial Modeler's Corner  

• LinkedIn Page- https://www.linkedin.com/company/financial-modeler-s-corner/?viewAsMember=true  

• Newsletter - Subscribe on LinkedIn- https://www.linkedin.com/build-relation/newsletter-follow?entityUrn=7079020077076905984

In today’s episode:

(00:55) - Introduction

(01:40) - Guest Introduction

(01:50) - The worst Financial Model the Guest Experienced

(01:56) - First Horror Story and Mixed Calculations

(02:50) - Second Horror Story and Daisy Chains

(04:06) - Guest’s Career Journey

(05:50) - The Role of Accounting in Financial Modeling

(08:45) - Guest’s Introduction as Author

(10:00) - Golden Ground Rules for Financial Modeling

(14:00) - Importance of Using a Clear and Logical Workbook Structure.

(17:00) - A clean, Consistent Design to Make Models Professional and User-friendly.

(23:10) - Instructions for Users to Ensure They Understand How to Use the Model.

(29:00) - Horror Stories from Financial Modeling

(33:40) - Tips and Tricks and Benefits of Using Power Query

(37:19) - Rapid-Fire Session

(42:10) - Guest's Contact Information