The FP&A Guy Network

In this special episode, Paul Barnhurst, aka the FP&A Guy, recaps key insights from the past six months of interviews on the "FP&A Tomorrow" podcast. He reflects on the soft and technical skills needed for financial planning and analysis (FP&A) professionals, shares standout advice from his expert guests, and dives into what makes great FP&A. Paul Barnhurst, known as the FP&A Guy, is a finance professional with years of experience in the field of FP&A. Through his podcast, Paul brings in thought leaders to share their expertise, providing actionable advice for finance professionals looking to level up their skills. The episode is packed with tips from top CFOs, finance leaders, and FP&A professionals who have shaped the field.Expect to Learn:Learn the human skills that will help you collaborate better and drive impact in your organization.Discover why financial modeling, Excel mastery, and understanding data are critical for FP&A success.Hear expert perspectives on what makes FP&A teams truly world-class, with an emphasis on technology, data, and strategy.How to translate complex financial data into actionable insights that your business partners can easily understand.Why anticipating business needs and solving complex problems are vital traits for anyone in finance.Here are a few relevant quotes from the episode:"In FP&A, communication skills are crucial because you're translating complex finance into actionable insights." - Paul Barnhurst"Learning to simplify is an art. Great FP&A professionals can take complex models and make them understandable." - Paul Barnhurst"Understanding data architecture has been huge in my career—knowing how systems work together can set you apart." - Paul Barnhurst"Great FP&A comes down to having the right people with the right skills, all working toward the same goal." - Paul BarnhurstFrom mastering technical skills like financial modeling to honing soft skills like empathy and storytelling, Paul highlights how FP&A professionals can drive real business impact. By empowering teams with data, communicating clearly, and anticipating future needs, FP&A becomes more than just a financial function—it becomes a strategic partner to the business. Follow Paul: Website - https://www.thefpandaguy.com LinkedIn - https://www.linkedin.com/in/thefpandaguyWorld-class Digital FP&A Course Bundle: Signup for over ten hours of video content with 4 different courses and 8 modules on FP&A topics including: Business Partnering, Data Analysis, Financial Modeling Design Principles, and Modern Excel. Use code Podcast to save 25%. What are you waiting for signup now: https://bit.ly/4decOf3Enroll for Financial Planning & Analysis Certificate Program:Sign up for the 8 week online financial planning & analysis certificate program by Wharton Online and learn the art of forecasting, analysis, business partnering and financial storytelling: https://bit.ly/4debs46 Use Code: THEFPAGUY300 to save $300. Earn Your CPE Credit For CPE credit please go to earmarkcpe.com, listen to the episode, download the app, and answer a few questions and earn your CPE certification. To earn education credits for FPAC Certificate, take the quiz on earmark and contact Paul Barnhurst for further details.In Today’s Episode[01:29] – Introduction and overview[03:27] – Key soft skills in FP&A[09:44] – Essential technical skills[15:50] – Personal dinner choices[20:10] – Defining great FP&A[26:25] – Courses and training for FP&A[31:41] – Business partnering in FP&A[36:37] – Final reflections and wrap up

In this episode of the Future Finance, hosts Paul Barnhurst and Glenn Hopper do an in-depth analysis of the transformative role of AI in finance with Nicolas Boucher. With AI becoming increasingly central to the finance industry, this conversation explores how generative AI and automation are reshaping the future of financial operations, decision-making, and business strategy.Nicolas Boucher is a finance expert and the founder of AI Finance Club, a platform dedicated to educating finance professionals about the integration of AI into their workflows. With over 15 years of experience in global finance positions at firms like PwC and Thales, Nicolas has trained more than 5,000 finance professionals. He shares his passion for AI and finance, emphasizing the importance of AI tools like ChatGPT, Python, and generative AI in driving efficiency and innovation in the finance world.In this episode, you will discover:How AI and generative tools like ChatGPT can help finance professionals streamline tasks and enhance productivity.The importance of debiasing AI models and ensuring fairness in AI-driven decisions.How to incorporate Python and automation into finance operations to accelerate workflows.Practical insights on how companies can integrate AI without needing vast data science teams.The future of citizen developers in finance and the democratization of coding with AI tools.In this episode, Nicolas Boucher discusses the vast potential of AI in finance, from automating mundane tasks to empowering professionals with tools that enhance productivity and decision-making. Ultimately, while AI is revolutionizing finance, human expertise, creativity, and strategic thinking will remain irreplaceable.Follow Nicolas:LinkedIn: https://www.linkedin.com/in/bouchernicolas/Website: https://ai-finance.club/Join hosts Glenn and Paul as they unravel the complexities of AI in finance:Follow Glenn:LinkedIn: https://www.linkedin.com/in/gbhopperiiiFollow Paul:LinkedIn: https://www.linkedin.com/in/thefpandaguyFollow QFlow.AI:Website - https://qflow.ai/future-financeFuture 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. Stay tuned for a deeper understanding of how AI is shaping the future of finance and what it means for businesses and individuals alike.In Today’s Episode:[01:57] Addressing bias in AI and its impact[06:25] Your Job is Safe (for Now)[09:50] Introduction to guest Nicolas Boucher[13:41] AI in day-to-day business[17:53] Generative AI and Python in finance[25:01] AI tools for finance professionals[30:02] Citizen developers and AI in SMBs[35:14] How to stay ahead in AI[40:02] Random questions segment[46:18] Conclusion and final thoughts

In this episode of Financial Modelers Corner, host Paul Barnhurst welcomes Ruby Liu, Director at KPMG Australia’s Valuation Team, to dive into intricacies of financial modeling. Having led KPMG Australia’s Sydney modeling team and worked as the head of corporate finance in the energy sector, Ruby’s vast experience spans from transactional modeling for infrastructure assets to advising clients on valuation and capital raising. Ruby Liu brings over 16 years of professional expertise in corporate finance, financial modeling, and valuations. This episode offers practical insights on managing complex financial models, optimizing processes, and the challenges of transitioning models from transactional to operational use. Ruby’s guidance provides a valuable learning opportunity on how to build efficient and user-friendly financial models. Her deep knowledge and hands-on experience make her a key voice in the field of financial modeling. Key takeaways from this week's episode include:The key differences between transactional and operational models and how to adapt them for long-term use.Why keeping the model user in mind is crucial for building effective financial models.Ruby’s top strategies for creating models that are simple, visually appealing, and efficient in calculation speed.Insights into the challenges of working with large, complex models and how to manage issues.How Ruby’s experiences at KPMG shaped her understanding of the financial modeling landscape.Here are a few quotes from Ruby Liu:"The most efficient model isn’t the one with the most complex formulas, but the one that’s easy to understand and use." - Ruby Liu"In financial modeling, the goal is to fit the user’s purpose, not dazzle them with complexity." - Ruby Liu"I think AI can help build models, but we’ll still need human oversight to interpret the results." - Ruby LiuIn this insightful episode, Ruby Liu offers a masterclass in financial modeling. From her candid reflections on the pitfalls of overly complex models to the importance of keeping the end user in mind, Ruby’s practical advice is invaluable for both novice and seasoned modelers alike. Follow Ruby Liu:LinkedIn - https://www.linkedin.com/in/liurubyFollow Paul: Website - https://www.thefpandaguy.com  LinkedIn - https://www.linkedin.com/in/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=7079020077076905984Sign 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 the code “Podcast” to save 15% when you register. In today’s episode: [01:13] - Introduction to the episode and guest[03:01] - Worst financial model and lessons learned[08:28] - Ruby reflects on her evolving perspective on the industry [12:47] - Ruby’s leadership experience at KPMG’s Sydney team[16:47] - Insights into Ruby’s current role in valuations[22:14] - Different valuation methods; income and market approaches[25:57] - Converting transactional models into operational ones [41:16] - Rapid fire questions segment with Ruby[47:49] - Advice for modelers and contact information

In this episode of FP&A Tomorrow, host Paul Barnhurst interviews Brian Lanier, a seasoned CFO with extensive experience in financial planning and analysis (FP&A) across multiple industries, including SaaS, technology, and healthcare. The discussion revolves around how FP&A can evolve from just reporting numbers to becoming a key partner in driving business decisions and transformations. Brian shares insights from his journey in private equity-backed companies, turnarounds, and M&A activities.Brian Lanier is a CFO who has held financial leadership roles in multiple growth-stage companies. With a career that started at EY as an auditor, he has since moved into CFO roles across public, private, and private equity-owned companies. His expertise includes introducing companies to their first budgeting processes, upgrading accounting systems, and overseeing over $7 billion in M&A transactions. His deep understanding of business levers and their impact has led to successful turnarounds and significant cost savings.Expect to Learn:How FP&A has evolved from reporting to business partnering and transformation.The key components of a successful FP&A function, including operational alignment.The role of data and its quality in making sound financial decisions.Strategies for managing financials during mergers, acquisitions, and divestitures.The importance of flexibility and simplicity when creating financial models and budgets.Here are a few relevant quotes from the episode:“Great FP&A starts off with partnership with the company itself. It’s about more than reporting numbers.” - Brian Lanier“I build my models with flexibility in mind, so if things change, you can quickly adjust without having to start from scratch.” - Brian Lanier“Data is critical, but a lot of companies don’t have clean data. The first step is cleaning it up so you can make informed decisions.” - Brian Lanier“Predictability is essential in FP&A. The more predictable you can make your revenue and expenses, the better decisions you can make.” - Brian LanierFrom his hands-on experience in growth-stage companies and M&A activities, Brian emphasizes the importance of understanding key business levers, fostering collaboration, and building flexible financial models that can evolve with the company. His deep dive into topics such as budgeting, pricing strategies, and operational alignment offers listeners practical advice on how FP&A can be a strategic partner in business transformation.Follow Brian:LinkedIn - https://www.linkedin.com/in/brianlanier1/Follow Paul: Website - https://www.thefpandaguy.com LinkedIn - https://www.linkedin.com/in/thefpandaguyWorld-class Digital FP&A Course Bundle: Signup for over ten hours of video content with 4 different courses and 8 modules on FP&A topics including: Business Partnering, Data Analysis, Financial Modeling Design Principles, and Modern Excel. Use code Podcast to save 25%. What are you waiting for signup now: https://bit.ly/4decOf3Enroll for Financial Planning & Analysis Certificate Program:Sign up for the 8 week online financial planning & analysis certificate program by Wharton Online and learn the art of forecasting, analysis, business partnering and financial storytelling: https://bit.ly/4debs46 Use Code: THEFPAGUY300 to save $300. Earn Your CPE Credit For CPE credit please go to earmarkcpe.com, listen to the episode, download the app, and answer a few questions and earn your CPE certification. To earn education credits for FPAC Certificate, take the quiz on earmark and contact Paul Barnhurst for further details.In Today’s Episode[01:34] - Introduction of the episode and guest[03:31] - What makes great FP&A?[06:15] - First 90 days as a CFO[10:49] - Real-life examples of pricing and margins[16:43] - Balancing optimism in sales forecasting[21:39] - Tying operations to financials[27:03] - Brian’s approach of understanding the business[31:56] - Advice for building a robust budget model[37:44] – M&A and Turnarounds[41:18] - Key skills for FP&A professionals[49:26] - Final thoughts and contact information

In this special solo episode, host Paul Barnhurst, also known as "The FP&A Guy," reflects on key insights gathered from past episodes of Financial Modeler’s Corner. With over 40 episodes under his belt, Paul dives into recurring rapid-fire questions posed to expert financial modelers worldwide. From circular references to VBA use and Excel's future, this episode offers valuable wisdom on the art and science of financial modeling.Paul Barnhurst, an accomplished financial modeling professional and host of the podcast, takes center stage. Paul is the founder of “The FP&A Guy” and has earned the prestigious Advanced Financial Modeler (AFM) certification from the Financial Modeling Institute (FMI). His wealth of experience and insights makes this solo episode both engaging and informative.Key takeaways from this week's episode include:The most common preferences of expert financial modelers on key technical decisions.Why dynamic arrays and other Excel functions are becoming increasingly important, and the pace of their adoption.Insights into how artificial intelligence (AI) could impact financial modeling and whether it will replace human modelers.The importance of good design principles in financial models, as shared by leading financial modeling experts.Fun and practical Excel shortcuts used by seasoned modelers to boost efficiency and accuracy.Here are a few quotes from Paul in this episode:"Circular references are dangerous because most people don’t really understand what’s going on, and it can lead to other errors in your model." - Paul Barnhurst"If at all possible, don’t use VBA in your model. The less you use it, the simpler the model is." - Paul Barnhurst"I’m of the belief that AI will build models for us. It’s a question of when, not if." - Paul BarnhurstIn this special solo episode, Paul Barnhurst takes a moment to reflect on the lessons learned from over 40 episodes of Financial Modeler’s Corner. He shares key takeaways from the rapid-fire questions posed to some of the top financial modelers in the world, offering a wealth of advice on best practices, common pitfalls, and emerging trends in financial modeling. As always, he invites listeners to reach out with feedback, questions, and guest suggestions, reinforcing the show's commitment to fostering a global community of financial modeling enthusiasts.Follow Paul: Website - https://www.thefpandaguy.com  LinkedIn - https://www.linkedin.com/in/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=7079020077076905984Sign 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 the code “Podcast” to save 15% when you register. In today’s episode: [01:09] - Introduction and background[03:18] - Circular references in models[04:55] - VBA in financial models[06:45] - Dynamic arrays: the future of excel?[16:50] - Will excel ever die?[18:16] - AI and financial modeling[20:31] - Financial models as corporate decision-making tools[22:26] - Favorite excel shortcuts from top financial modelers[30:34] - Closing thoughts and invitation to audience

In this episode of FP&A Tomorrow, Paul Barnhurst interviews Jack McCullough to discuss the evolving landscape of FP&A and the changing role of CFOs. They explore the journey from FP&A to CFO roles, the strategic importance of finance today, and how CFOs are transitioning into broader leadership roles such as CEO. With insights into board management, leadership, and career growth, this episode offers a comprehensive look at the finance function's future.Jack McCullough is a recognized authority in the world of finance leadership. As President of the CFO Leadership Council, Jack has guided countless CFOs through leadership development and strategic decision-making. He holds an MBA from MIT, is the host of the podcast Secrets of Rockstar CFOs, and is the author of two books, including The Psychopathic CEO. With a background in accounting and finance, Jack brings deep expertise in helping finance professionals thrive in leadership roles.Expect to Learn:The key skills FP&A professionals need to develop to become future CFOs.How the role of CFO has shifted from financial control to strategic leadership.The importance of building strong relationships with board members and using them as resources.Insights into creating effective board presentations that align with audience expectations.Leadership qualities that define successful CFOs and finance leaders.Here are a few relevant quotes from the episode:"FP&A is all about the future—how to consider it, prepare for it, and react when things go off course." - Jack McCullough"Empathy is one of the most underrated leadership skills for CFOs."  - Jack McCullough"When you see a problem no one else sees, and you solve it, that’s real value-add."  - Jack McCulloughIn this episode, Jack McCullough provides a clear vision of the evolving role of CFOs and offers a wealth of knowledge on navigating the complexities of modern finance. His practical advice on building relationships with the board, crafting effective presentations, and honing leadership qualities such as empathy and transparency are invaluable for finance professionals at every level.Follow Jack:LinkedIn - https://www.linkedin.com/in/jackmcculloughcfo/Follow Paul: Website - https://www.thefpandaguy.com LinkedIn - https://www.linkedin.com/in/thefpandaguyVisit Abacum - The Ultimate FP&A SolutionThe title sponsor for this week’s episode of FP&A Tomorrow is Abacum, the leading mid-market FP&A solution trusted by hundreds of companies to eliminate the spreadsheet struggle. https://www.abacum.ioWorld-class Digital FP&A Course Bundle: Signup for over ten hours of video content with 4 different courses and 8 modules on FP&A topics including: Business Partnering, Data Analysis, Financial Modeling Design Principles, and Modern Excel. Use code Podcast to save 25%. What are you waiting for signup now: https://bit.ly/4decOf3Earn Your CPE Credit For CPE credit please go to earmarkcpe.com, listen to the episode, download the app, and answer a few questions and earn your CPE certification. To earn education credits for FPAC Certificate, take the quiz on earmark and contact Paul Barnhurst for further details.In Today’s Episode[01:32] Introduction to the episode and guest[02:54] The role of FP&A in today’s finance world[04:03] The Shift in the CFO role[08:33] Stories from Jack’s Podcast World[11:17] Mastering the key principles behind board deck[13:46] Building relationships with board members[18:09] Optimism vs. Realism in leadership[22:53] Jack’s book “The Psychopathic CEO”[34:47] Essential leadership qualities for CFOs[39:09] Key technical and soft skills for FP&A[45:26] Jack’s personal life and fitness insights[52:19] Closing remarks and contact information

In this episode of Future Finance Show, hosts Paul Barnhurst and Glenn Hopper dive deep into the revolutionary impact of generative AI on industries, with a particular focus on its implications in finance. They explore how AI transforms workflows, enhances productivity, and shifts the focus from tasks to higher-level thinking. The conversation breaks down common misconceptions about AI, such as the overhyped role of “prompt engineering,” and emphasizes how businesses can integrate AI while maintaining data privacy and security. Conor Grennan, the guest of this episode, is the Chief AI Architect at NYU Stern School of Business and the founder of AI Mindset, a company helping leaders adopt AI effectively. Beyond AI, Conor is a New York Times best-selling author, recognized globally for his humanitarian work. His expertise lies not only in AI implementation but also in helping non-technical individuals understand and utilize AI's potential.In this episode, you will discover:The reality behind generative AI myths and why prompt engineering is overrated.How AI transforms jobs by automating tasks, not replacing roles.Ways finance professionals can balance AI efficiency with data privacy concerns.Why adopting an AI mindset is crucial for leveraging its full potential.How embracing AI in your work can give you a competitive edge in your career.For finance professionals interested in harnessing the power of generative AI while balancing efficiency and security, this episode offers practical insights and frameworks. Conor Grennan’s unique blend of technical knowledge and relatable, human-centered teaching makes this a must-listen for anyone looking to stay ahead in the AI revolution.Follow Conor:LinkedIn: https://www.linkedin.com/in/conorgrennan/Website: conorgrennan.comJoin hosts Glenn and Paul as they unravel the complexities of AI in finance:Follow Glenn:LinkedIn: https://www.linkedin.com/in/gbhopperiiiFollow Paul:LinkedIn: https://www.linkedin.com/in/thefpandaguyFollow QFlow.AI:Website - https://qflow.ai/future-financeFuture 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. Stay tuned for a deeper understanding of how AI is shaping the future of finance and what it means for businesses and individuals alike.In Today’s Episode:[01:59] - Concerns about data privacy in AI[08:32] - Introduction of Conor Grennan[10:10] - Conor's background and AI journey[12:40] - The role of a chief AI architect[16:42] - The truth about prompt engineering[20:54] - The AI mindset and learning curve[27:55] - AI’s impact on jobs[35:23] - Conor's AI course and framework[37:29] - Conor’s book: Little Princess[42:47] - Conclusion and final thoughts

In this episode of Financial Modelers Corner, host Paul Barnhurst welcomes Paul Medici, founder and CEO of Medici Financial Modeling. They dive into the art and science of financial modeling, sharing horror stories, insights, and practical tips on how to avoid common pitfalls. The discussion revolves around the importance of simplicity and structure, and how mastering the fundamentals can save time and deliver better results.Today’s guest is Paul Medici, the Founder and CEO of Medici Financial Modeling. With over a decade of experience, Paul specializes in building bespoke financial models and custom data automation tools for corporate clients across the US, Canada, and Europe. His expertise spans a wide range of industries, including financial services, healthcare, manufacturing, mining, real estate, retail, technology, and even charitable organizations. He holds an MBA from the University of Toronto and a Master’s in Geological Science and Engineering from Queen’s University.Key takeaways from this week's episode include:The most common mistakes in bad financial models and how to avoid them.How a background in geology led Paul Medici to a career in financial modeling.The importance of understanding revenue and cost build-ups in different industries.Why practicing financial modeling on personal projects can enhance your skills.Key shortcuts and techniques to speed up your Excel modeling process.Here are a few quotes from Paul Medici:"All bad models have one thing in common: they're not user-friendly, difficult to update, and time-consuming." - Paul Medici"Most corporate models start simple but turn into 'Frankenstein' models over time as people add complexity." - Paul Medici"If you're thinking about financial modeling, practice by building models for everyday tasks like personal budgets." - Paul Medici"The key to mastering financial modeling is understanding how the financial statements and supporting schedules link together." - Paul MediciFrom his early career in geology to teaching advanced Excel at top investment banks, Paul brings a wealth of knowledge to the conversation. He emphasizes the importance of building user-friendly models, practicing regularly, and finding the right balance between complexity and functionality. Follow Paul Medici:Website - https://medicifinancialmodeling.com/LinkedIn - https://www.linkedin.com/in/paulmedici/Follow Paul: Website - https://www.thefpandaguy.com  LinkedIn - https://www.linkedin.com/in/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=7079020077076905984Sign 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 the code “Podcast” to save 15% when you register. In today’s episode: [01:27] - Introduction to the episode and guest [03:15] - The worst financial model story and lessons learned.[07:17] - Career transition from Geology to Finance[12:40] - Challenges in modeling different industries[19:22] - Favorite industries and financial models[22:17] - Bespoke data automation tools[25:47] - Teaching Excel and financial modeling courses[34:29] - Advice for FMI Certification[39:03] - Rapid fire: financial modeling preferences[44:13] - Final advice and contact information

In this episode of FP&A Tomorrow, host Paul Barnhurst is joined by Jim Caltabiano, a seasoned finance leader with over 30 years of experience in financial planning and analysis (FP&A) across various industries, including consumer packaged goods and food and beverage. The discussion centers around the evolving role of FP&A, the importance of insights over data, and strategies for building effective finance teams that can drive business value.Jim Caltabiano brings a wealth of knowledge from his extensive career in FP&A and finance leadership roles at major companies such as Procter & Gamble, General Mills, Campbell Soup Company, Ajinomoto Foods, and Del Monte Foods. With a background in both finance and marketing, Jim offers a unique perspective on how FP&A professionals can go beyond traditional financial functions to become true business partners.Expect to Learn:Insights over data and the importance of connecting financial insights to drive business decisions.Strategies to move from a siloed finance function to a business-first approach.How FP&A professionals can better understand and contribute to business goals.Techniques for making sound decisions when data is less than perfect.Insights from Jim’s experience as a CTO on the role of data cleanliness and AI in future finance functions.Here are a few relevant quotes from the episode:"Great FP&A is all about the insights. It's all about being able to connect insights for the business." - Jim Caltabiano"Thinking of data as a product rather than just a system changes how you manage and use it." - Jim Caltabiano"Active listening is the most underutilized skill in business; it’s key to building relationships and understanding the business." - Jim CaltabianoIn this episode, Jim Caltabiano shares valuable insights on the evolving role of FP&A professionals in today's dynamic business environment. By adopting a holistic approach to data, leveraging multiple data sources, and focusing on active listening, FP&A professionals can elevate their role from number crunchers to strategic business partners. This episode is a must-listen for anyone looking to sharpen their FP&A skills and drive meaningful impact within their organization.Follow Jim:LinkedIn - https://www.linkedin.com/in/jimcaltabiano/Email - [email protected] Paul: Website - https://www.thefpandaguy.com LinkedIn - https://www.linkedin.com/in/thefpandaguyWorld-class Digital FP&A Course Bundle: Signup for over ten hours of video content with 4 different courses and 8 modules on FP&A topics including: Business Partnering, Data Analysis, Financial Modeling Design Principles, and Modern Excel. Use code Podcast to save 25%. What are you waiting for signup now: https://bit.ly/4decOf3Enroll for Financial Planning & Analysis Certificate Program:Sign up for the 8 week online financial planning & analysis certificate program by Wharton Online and learn the art of forecasting, analysis, business partnering and financial storytelling: https://bit.ly/4debs46 Use Code: THEFPAGUY300 to save $300. Earn Your CPE Credit For CPE credit please go to earmarkcpe.com, listen to the episode, download the app, and answer a few questions and earn your CPE certification. To earn education credits for FPAC Certificate, take the quiz on earmark and contact Paul Barnhurst for further details.In Today’s Episode[01:24] - Introduction to the episode and the guest, Jim Caltabiano[02:38] - Defining great FP&A and the importance of insights [04:50] - Jim’s career journey and professional background[07:12] - Jim’s philosophy of business first, function second[12:19] - Strategy for learning new businesses as an FP&A professional[17:06] - Techniques for FP&A professionals to provide insights beyond reports[25:00] - Managing data quality issues and incomplete information[28:11] - Insights from Jim’s tenure as Chief Technology Officer[38:27] - Discussion on the use of generative AI in FP&A[40:51] - Quick insights on essential technical and soft skills [49:30] - Closing thoughts and how to connect with Jim

In this episode of the "Financial Modelers Corner," host Paul Barnhurst welcomes Gilbert Hangartner, a financial modeler with a background in science. The discussion delves into the intricacies of financial modeling, the importance of simplicity in model construction, and the application of Monte Carlo simulations to understand risk. Gilbert shares his insights on how to approach financial modeling by asking the right questions rather than having complex formulas.Gilbert Hangartner is a seasoned financial modeler who transitioned from a career in science, specializing in chemistry and physics, to financial modeling and risk analysis. His scientific training gives him a unique perspective on financial modeling, treating it as both a creative process and a technical discipline. Gilbert emphasizes the importance of simplicity and clarity in building effective models and is an advocate for using models as tools for communication and strategic decision-making.Key takeaways from this week's episode include:Understanding the importance of simplicity in modeling The debate on whether financial modeling is more of an art or a scienceSimplifying a problem and understanding the question before diving into model building.Introduction to Monte Carlo simulations for risk managementA discussion on the limitations of Excel and future of financial modelingHere are a few quotes from Gilbert Hangartner:"A good model is not about complexity; it's about clarity and answering the right question." - Gilbert Hangartner"For me, modeling is a creative act, much like writing a song or painting a picture." - Gilbert Hangartner"Multi-dimensional modeling is key; real-world problems are never just two-dimensional." - Gilbert Hangartner"The future of financial modeling lies beyond Excel; it’s time for more advanced, structured tools." - Gilbert HangartnerIn this episode, Gilbert Hangartner offers a fresh perspective on the world of financial modeling and challenges the conventional wisdom that financial models must be complex to be effective. Whether you're a seasoned modeler or just starting out, Gilbert's insights on Monte Carlo simulations provide valuable guidance on how to enhance your modeling skills and approach.Follow Gilbert:LinkedIn - https://www.linkedin.com/in/gilbert-hangartner-71754047/ Follow Paul: Website - https://www.thefpandaguy.com  LinkedIn - https://www.linkedin.com/in/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=7079020077076905984Sign 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 the code “Podcast” to save 15% when you register. In today’s episode: [01:16] - Introduction to the episode and the guest, Gilbert Hangartner[01:57] - The worst financial model horror story shared by Gilbert[04:42] - Discussion on the importance of simplicity in financial modeling[06:10] - Gilbert explains his transition from science to financial modeling[10:11] - Art or Science? The nature of financial modeling[13:45] - Strategies for asking the right questions when building a model[17:16] - An overview of Monte Carlo simulations for risk modeling[28:31] - The advantages of Quantrix over Excel [44:47] - A contrarian view on the future of Excel in financial modeling[47:48] - Closing Remarks and Contact Information

In this episode of FP&A Tomorrow, we dive into the evolving landscape of Financial Planning & Analysis (FP&A) with a focus on finance transformation. Leslie Stuart, a seasoned expert in FP&A and finance transformation, shares her insights on how modern finance functions are adapting to new technologies, data management practices, and process improvements to drive better business outcomes.Leslie Stuart is the Director of Financial Planning & Analysis at Walmart Canada and a certified CPA. With a robust background in accounting, auditing, and operational finance, Leslie has been at the forefront of finance transformation, leading initiatives that integrate cutting-edge technology with traditional finance functions. Her career journey from external audit to leading finance transformations offers valuable lessons for anyone involved in or aspiring to drive financial excellence.Expect to Learn:The importance of data quality and its impact on business decisions.Strategies for successfully managing finance transformation projects.How to navigate challenges in data management, from garbage data to valuable insights.The role of technology, including AI, in modernizing FP&A processes.Tips for engaging teams and fostering change in finance departments.Here are a few relevant quotes from the episode "Data and technology are often the easier pieces; the real challenge is with people and processes." - Leslie Stuart"Starting with a strong foundation in processes and controls is critical to any successful transformation." - Leslie Stuart"AI and machine learning are the way of the future for finance—helping us work more efficiently and effectively." - Leslie StuartIn this insightful episode, Leslie Stuart takes us through the intricate process of finance transformation, emphasizing the importance of data quality, the role of technology, and the critical need for effective communication and process management. Her practical advice and personal experiences offer a roadmap for those looking to navigate the complexities of modern FP&A.Follow Leslie:LinkedIn - https://www.linkedin.com/in/leslie-stuart/Follow Paul: Website - https://www.thefpandaguy.com LinkedIn - https://www.linkedin.com/in/thefpandaguyWorld-class Digital FP&A Course Bundle: Signup for over ten hours of video content with 4 different courses and 8 modules on FP&A topics including: Business Partnering, Data Analysis, Financial Modeling Design Principles, and Modern Excel. Use code Podcast to save 25%. What are you waiting for signup now: https://bit.ly/4decOf3Enroll for Financial Planning & Analysis Certificate Program:Sign up for the 8 week online financial planning & analysis certificate program by Wharton Online and learn the art of forecasting, analysis, business partnering and financial storytelling: https://bit.ly/4debs46 Use Code: THEFPAGUY300 to save $300. Earn Your CPE Credit For CPE credit please go to earmarkcpe.com, listen to the episode, download the app, and answer a few questions and earn your CPE certification. To earn education credits for FPAC Certificate, take the quiz on earmark and contact Paul Barnhurst for further details.In Today’s Episode[01:31] - Introduction to the episode [02:17] - Leslie’s career journey and background[02:46] - Discussion about evolution of FP&A[08:07] - Leslie explains her transition from audit to FP&A[12:35] - Managing large-scale finance transformations[20:18] - Project management approaches in finance transformations[31:14] - The Role of AI in FP&A[37:06] - Continuous evolution in finance[49:13] - Final thoughts and conclusion

In this episode of the Future Finance Show, hosts Paul Barnhurst and Glenn Hopper explore the transformative impact of artificial intelligence (AI) on financial planning and analysis (FP&A). The discussion revolves around how AI tools, from generative AI to sophisticated models like OpenAI's Project Strawberry, are reshaping the finance landscape. The episode features Gabriela Gutierrez, a finance professional turned AI enthusiast, who shares her journey of integrating AI into finance.Gabriela Gutierrez is a dynamic finance leader and entrepreneur with a strong background in AI, Python programming, and machine learning. She has worked in various financial roles, including FP&A at eBay and as a local CFO for Teads in Germany. Gabriela’s passion for innovation led her to launch a stealth startup focused on AI-powered finance solutions. She shares her insights into the evolving role of finance professionals in the AI era and her experiences in building an AI-centric company. In this episode, you will discover:The potential of AI to automate and enhance FP&A processes.Insights into OpenAI's Project Strawberry and its implications for the finance industry.The skills finance professionals need to thrive in an AI-driven world.How Gabriela Gutierrez transitioned from traditional finance roles to becoming an AI-driven entrepreneur.Predictions on the future of finance jobs in the context of advancing AI technologies.It's clear that the intersection of AI and finance offers both exciting opportunities and unique challenges. This episode provides a wealth of knowledge for finance professionals to embrace AI as a tool for innovation, efficiency, and strategic growth.Follow Gabriela:LinkedIn: https://www.linkedin.com/in/gabriela-gutierrez-15ba0571/Join hosts Glenn and Paul as they unravel the complexities of AI in finance:Follow Glenn:LinkedIn: https://www.linkedin.com/in/gbhopperiiiFollow Paul:LinkedIn: https://www.linkedin.com/in/thefpandaguyFollow QFlow.AI:Website - https://qflow.ai/future-financeFuture 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. Stay tuned for a deeper understanding of how AI is shaping the future of finance and what it means for businesses and individuals alike.In Today’s Episode:[00:59] - Introduction to the episode[01:43] - Key takeaways from Carl Seidman’s FP&A insights[07:02] - Exploring OpenAI’s project Strawberry[11:58] - Gabriela Gutierrez background and career journey[16:39] - Overcoming challenges in AI integration[19:51] - Insights on Gabriela’s Stealth Startup[26:29] - Fun segment: get to know Gabriela[30:31] - Conclusion and episode wrap-up

In this episode of Financial Modelers Corner, host Paul Barnhurst is joined by Giles Male, who brings his unique perspective on the rapidly changing landscape of financial modeling. Together, they explore how the latest advancements in Excel—such as dynamic arrays and Lambda functions—are revolutionizing the way financial models are built and used. Giles also provides invaluable advice on the importance of simplicity, adaptability, and effective communication in modeling.Giles Male is a CMA-qualified accountant and a seasoned financial modeler with extensive experience in bid analysis and complex financial modeling. As a co-founder of Full Stack Modeler, Giles is passionate about training and mentoring the next generation of financial modelers. He holds the prestigious Master Financial Modeler (MFM) accreditation from the Financial Modeling Institute, making him one of only seven individuals worldwide to have achieved this honor. Giles brings a wealth of knowledge on modern Excel and its application in financial modeling.Key takeaways from this week's episode include:The importance of embracing modern Excel techniques, including dynamic arrays and Lambda functions.Insights into the changing landscape of financial modeling and why simplicity is often more effective than complexity.The challenges and rewards of transitioning from traditional modeling methods to modern approaches.How Giles's experiences in ultra-marathon running have influenced his approach to problem-solving and pushing beyond perceived limits in both personal and professional contexts.Practical advice on maintaining model integrity, including the use of structured standards like FAST or SMART while adapting to specific project needs.Here are a few quotes from Giles Male:"Simplicity is the biggest lesson I’ve learned in my career. Complex models might seem impressive, but they’re often impractical." - Giles Male"A good financial model should be as complex as it needs to be, but as simple as possible." - Giles Male"There’s a visibility fog when reviewing your own models. Stepping away and coming back later is essential." - Giles MaleIn this episode, Giles Male offers a wealth of insights into the evolving world of financial modeling. He emphasizes the importance of simplicity, the transformative power of modern Excel, and the critical need for clear communication in model design. As the industry continues to evolve, Giles’s focus on adaptability, continuous learning, and user-centric design serves as a guide for both seasoned professionals and newcomers alike.Follow Giles:Website - https://www.fullstackmodeller.com/LinkedIn - https://www.linkedin.com/in/giles-male-30643b15/ Follow Paul: Website - https://www.thefpandaguy.com  LinkedIn - https://www.linkedin.com/in/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=7079020077076905984Sign 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 the code “Podcast” to save 15% when you register. In today’s episode: [01:18] - Introduction to the topic and guest Giles Male[05:31] - Lessons from complex models[07:12] - Giles shares his career journey into financial modeling[16:10] - Achieving master financial modeler accreditation[17:19] - Giles shares practical project insights[28:42] - Defining advanced modeling skills[34:00] - The future of excel and financial modeling[41:50] - Excel shortcuts and best practices[47:47] - Conclusion and contact information

In this insightful episode of FP&A Tomorrow, host Paul Barnhurst dives into the future of Financial Planning and Analysis (FP&A) with Dr. Liran Edelist, a seasoned expert with over 30 years of experience in finance and technology. The discussion focuses on the importance of modernization, the role of technology, and how FP&A professionals can better align their tools and processes with the needs of the business.Dr. Liran Edelist, referred to as "The Doctor" by Paul, is a distinguished professional with a PhD in Business Administration. Originally from Israel, Liran now operates out of the Greater Boston area and has extensive experience in consulting, technology, and business leadership. With a career spanning nearly three decades, including a presidency at Jedox Americas and a role as an adjunct professor at Boston University, Liran brings a wealth of knowledge on the intersection of finance, technology, and business processes. Expect to Learn:The key components that define modern FP&A and why reducing manual work is crucial.How to find the right balance between people, processes, and technology in FP&A.The importance of selecting the right FP&A tools and avoiding common pitfalls during implementation.Insights into the role of AI in FP&A and how it can act as an additional "pair of hands" rather than a replacement.The significance of having a modernization mindset and how it can lead to continuous improvement in FP&A processes.Quotes:Here are a few relevant quotes from the episode "The great FP&A is a modernized FP&A where you don't have too much manual work." - Dr. Liran"FP&A should be the front office of the organization, helping lead the business alongside the CEO." - Dr. Liran"The key to successful FP&A is balancing the right people, processes, and technology." - Dr. LiranIn this episode, Dr. Liran Edelist emphasizes the importance of modernization in FP&A, urging professionals to adopt a mindset of continuous improvement rather than relying on outdated methods. This episode underscores FP&A’s vital role as a strategic partner in guiding organizations toward a more data-driven and forward-thinking future.Follow Dr. Liran:Website - https://www.topit.biz/LinkedIn - https://www.linkedin.com/in/drliranedelist/ Follow Paul: Website - https://www.thefpandaguy.com LinkedIn - https://www.linkedin.com/in/thefpandaguyWorld-class Digital FP&A Course Bundle: Signup for over ten hours of video content with 4 different courses and 8 modules on FP&A topics including: Business Partnering, Data Analysis, Financial Modeling Design Principles, and Modern Excel. Use code Podcast to save 25%. What are you waiting for signup now: https://bit.ly/4decOf3Enroll for Financial Planning & Analysis Certificate Program:Sign up for the 8 week online financial planning & analysis certificate program by Wharton Online and learn the art of forecasting, analysis, business partnering and financial storytelling: https://bit.ly/4debs46 Use Code: THEFPAGUY300 to save $300. Earn Your CPE Credit For CPE credit please go to earmarkcpe.com, listen to the episode, download the app, and answer a few questions and earn your CPE certification. To earn education credits for FPAC Certificate, take the quiz on earmark and contact Paul Barnhurst for further details.In Today’s Episode[01:35] - Introduction to the episode and guest, Dr. Liran[02:57] - What defines great FP&A?[04:24] - Critical balance between people, processes, and technology[09:18] - Key considerations for selecting the right FP&A tools[15:06] - Trends in FP&A technology[23:32] - The Role of AI in FP&A[26:00] - FP&A as the front office of organization[28:46] - The Plan Buddies community[33:23] - Implementing FP&A tools successfully[45:27] - Conclusion and closing remarks

In this episode of Financial Modelers Corner, Paul Barnhurst dives into the intricacies of financial modeling, focusing on cash flow forecasting and continuous planning with FP&A expert Randy Brown. Randy shares his unique journey from music school to becoming a financial consultant and emphasizes the importance of practical financial strategies, especially in volatile markets.Randy Brown is a seasoned financial consultant with a rich background in FP&A, corporate finance, and financial modeling. After initially pursuing a career in music, Randy transitioned into finance, where he has built a successful career, particularly in cash flow management and continuous planning. His approach blends technical financial skills with real-world business acumen, making him a sought-after consultant in the industry.Key takeaways from this week's episode include:The critical importance of cash flow forecasting for business stability.Practical steps to build a 13-week cash flow forecast.Why continuous planning is more effective than traditional annual budgeting.Common pitfalls in financial modeling, including the dangers of circular references and external workbook links.Randy’s insights on managing finances for small to medium-sized businesses, especially in distressed situations.Here are a few quotes from Randy Brown:"The minute you create a budget, it’s meaningless. The business environment changes too fast for a static plan." - Randy Brown"For cash flow forecasting, it’s all about identifying your sources and uses of cash and laying them out on a calendar." - Randy Brown"The flexibility of working from home and being my own boss was the number one driver for becoming an independent consultant." - Randy Brown"Learn relational data structures; understanding how data relates will improve every analytical task you do." - Randy BrownIn this insightful episode, Randy Brown shared his wealth of knowledge on financial modeling, continuous planning, and the critical importance of cash flow forecasting. His emphasis on the importance of relationships, the simplicity of effective cash forecasting, and the pitfalls of traditional budgeting methods offers a fresh perspective for financial professionals striving to improve their modeling practices.Follow Randy:Website - https://www.instagram.com/randy_brown/LinkedIn - https://www.linkedin.com/in/randyjbrown/ Follow Paul: Website - https://www.thefpandaguy.com  LinkedIn - https://www.linkedin.com/in/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=7079020077076905984Sign 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 the code “Podcast” to save 15% when you register.  In today’s episode:[01:28] - Introduction to the episode and guest Randy Brown[07:27] - Insights into Randy’s background and career journey[13:17] - Continuous planning vs. annual budgeting[20:36] - The benefits of fractional consulting[23:37] - The Importance of cash flow forecasting[28:01] - Building a 13-Week Cash Flow Forecast[34:53] - Key considerations for cash flow management[42:48] - Rapid fire financial modeling questions[48:28] - Final advice and closing thoughts

In this episode of FP&A Tomorrow, host Paul Barnhurst, aka "The FP&A Guy," dives into the intricacies of financial planning and analysis (FP&A) with Renato Villanueva, CEO of Parallel, a startup  FP&A tool for early-stage founders. They discuss what makes great FP&A, the journey from risk management to FP&A, and the challenges of scaling a startup while maintaining financial discipline.Renato Villanueva is an accomplished finance professional and the CEO of Parallel, a company providing innovative financial modeling and forecasting solutions for startups. With a finance degree from Utah Valley University, Renato's experience spans multiple high-profile companies, including Qualtrics, American Express, and Divvy. His deep understanding of FP&A and his entrepreneurial spirit drive the conversation as he shares valuable insights from his career and current ventures.Expect to Learn:The essential characteristics of effective FP&A and why understanding your company's goals is crucial.How persistence and networking can open doors in your career, as demonstrated by Renato's journey into Divvy.The importance of aligning financial planning with company growth strategies, especially in a startup environment.Key operational metrics to focus on during the early stages of a startup.Strategies for building strong relationships between finance and other business departments to drive success.Quotes:Here are a few relevant quotes from the episode “Great FP&A is about understanding what the company is trying to accomplish and the role your leader plays in that. It's knowing the North Star metric and ensuring your department has the resources to achieve it." - Renato Villanueva"You want to make it as easy as possible for whoever you work with. Sometimes that means meeting people where they’re at rather than forcing them into a new process." - Renato Villanueva"The most rewarding part is tackling a really hard problem and empowering founders to make better, bigger bets with confidence." - Renato VillanuevaRenato's journey from risk management to becoming the CEO of Parallel offers valuable lessons in persistence, adaptability, and the power of understanding the big picture. Tune in for expert insights as we continue to explore the evolving landscape of FP&A.Follow Renato:LinkedIn - https://www.linkedin.com/in/villanuevar/ Follow Paul: Website - https://www.thefpandaguy.com LinkedIn - https://www.linkedin.com/in/thefpandaguyWorld-class Digital FP&A Course Bundle: Signup for over ten hours of video content with 4 different courses and 8 modules on FP&A topics including: Business Partnering, Data Analysis, Financial Modeling Design Principles, and Modern Excel. Use code Podcast to save 25%. What are you waiting for signup now: https://bit.ly/4decOf3Enroll for Financial Planning & Analysis Certificate Program:Level up your career and build skills for financial planning and analysis. Sign up for the 8 week online financial planning & analysis certificate program by Wharton Online and learn the art of forecasting, analysis, business partnering and financial storytelling: https://bit.ly/4debs46 Use Code: THEFPAGUY300 to save $300. Earn Your CPE Credit For CPE credit please go to earmarkcpe.com, listen to the episode, download the app, and answer a few questions and earn your CPE certification. To earn education credits for FPAC Certificate, take the quiz on earmark and contact Paul Barnhurst for further details.In Today’s Episode[01:32] - Introduction to the topic and guest Renato Villanueva[02:35] - Renato shares his views on what constitutes great FP&A.[03:29] - Discussion of Renato's career journey[05:46] - Renato explains how persistence and networking led to his role at Divvy[14:12] - A look at the key metrics Renato focused on while scaling Divvy[24:05] - The evolution of the budgeting and forecasting process at Divvy[26:19] - Tips on how finance professionals can build strong relationships with other departments[33:10] - Renato shares insights into his current venture, Parallel, and the rewarding experience of building a company from the ground up.[39:24] - Renato answers quick questions about key FP&A skills[48:17] - Final thoughts and how to connect with Renato

This week’s show notes are written by Microsoft CoPilot. What does the future of accounting and finance look like? How can you leverage technology, especially generative AI, to take your career to the next level? Join Paul Barnhurst and Glenn Hopper as they explore these questions and more with Tom Hood, a renowned leader and innovator in the accounting profession.Tom Hood is the EVP of Business Engagement and Growth at the Association of International Certified Professional Accountants. He has been a pioneer in integrating technology into finance for over 24 years, and he shares his insights and advice on how you can do the same. In this episode, you will discover:How technology is reshaping the accounting and finance industry and what it means for you. How to start using generative AI today to automate tasks, generate insights, and create value.How to overcome the fear of failure and embrace risk-taking as a way to learn and grow.How generative AI will become more sophisticated and powerful in the near future and what you need to prepare for it.How to communicate effectively with your stakeholders and clients in the age of AI.Don't miss this opportunity to learn from one of the most influential voices in the accounting profession. Listen to this episode and find out how you can harness the power of technology and generative AI to transform your career and the future of finance.Follow Tom:LinkedIn: https://www.linkedin.com/in/tomhood/Company: https://blionline.org/Blog: http://blionline.org/blogAICPA & CIMA: http://www.cgma.org/Join hosts Glenn and Paul as they unravel the complexities of AI in finance:Follow Glenn:LinkedIn: https://www.linkedin.com/in/gbhopperiiiFollow Paul:LinkedIn: https://www.linkedin.com/in/thefpandaguyFollow QFlow.AI:Website - https://qflow.ai/future-financeFuture 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. Stay tuned for a deeper understanding of how AI is shaping the future of finance and what it means for businesses and individuals alike.In Today’s Episode:[01:38] - Latest AI developments and their impact on the finance industry[11:40] - Introduction to the episode and guest Tom Hood[12:58] - The intersection of technology and accounting[17:03] - Practical benefits and risks of generative AI in finance[21:03] - The future of generative AI in finance[30:28] - Advice for aspiring accountants[32:50] - Fun segment: get to know Tom Hood[36:55] - Conclusion and final thoughts

In this episode of Financial Modelers Corner, host Paul Barnhurst delves into the intricacies of financial modeling in the e-commerce industry with guest Drew Fallon, a seasoned e-commerce entrepreneur and co-founder of Iris, a cutting-edge FP&A tool for e-commerce businesses. The discussion offers valuable insights into the unique challenges of financial modeling in a rapidly evolving digital landscape, particularly in direct-to-consumer (DTC) businesses.Drew Fallon is an experienced entrepreneur in the e-commerce and CPG sectors. He began his career in equity research, working on high-profile IPOs like Airbnb and Corsair. Drew later co-founded and served as CFO for Mad Rabbit, an e-commerce brand that achieved significant growth under his leadership. Currently, he is the co-founder and CEO of Iris, a financial modeling platform that integrates AI to help e-commerce businesses automate their financial forecasting and analysis.Key takeaways from this week's episode include:The key components of effective financial modeling for e-commerce businesses.How cohort forecasting and customer retention play crucial roles in revenue prediction.The importance of understanding fulfillment costs and their impact on gross margins.Why many e-commerce brands fail due to poor financial modeling and how tools like Iris can help.Insights into Drew's journey from equity research to building successful startups in the e-commerce space.Here are a few quotes from Drew Fallon:"The number one thing to focus on with these e-comm businesses is the returning revenue number. If you mess up the forecast for your returning customer, it's the easiest way to mess up the gross profit forecast." - Drew Fallon"E-commerce is a tough business on working capital. It can be really challenging if you don't model out your cash flow accurately." - Drew Fallon"If you get the gross profit wrong, then you get the CAC wrong. And then all of a sudden you're losing money, and you die." - Drew FallonIn this insightful episode, Drew Fallon emphasizes the critical importance of precise financial modeling in the e-commerce sector, particularly in managing customer retention, fulfillment costs, and the dynamics of working capital. His experience in scaling e-commerce brands and developing Iris underscores the need for specialized tools and methodologies to navigate the complexities of this industry. Whether you're an entrepreneur, financial modeler, or simply interested in the intersection of finance and technology, this episode offers valuable lessons on how to build sustainable, profitable e-commerce businesses.Follow Drew:Website - https://www.irisfinance.co/LinkedIn - https://www.linkedin.com/in/drew-f-74947b117/  Follow Paul: Website - https://www.thefpandaguy.com  LinkedIn - https://www.linkedin.com/in/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=7079020077076905984Sign 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 the code “Podcast” to save 15% when you register.  In today’s episode: [01:10] - Introduction to the episode and guest Drew Fallon.[04:44] - Drew’s background and E-commerce journey[11:52] - Discussion on Drew’s passion for startups and its challenges and rewards[17:04] - Key elements of financial modeling specific to e-commerce[28:16] - Operational metrics and cost assumptions and how they affect overall financial health.[35:06] - The advantages of using Iris in e-commerce financial modeling.[41:53] - Quick insights into Drew's financial modeling preferences[47:08] - Drew’s advice for aspiring financial modelers[49:30] - Final thoughts and how to connect with Drew

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 this episode of FP&A Tomorrow, host Paul Barnhurst dives into the evolving role of FP&A (Financial Planning & Analysis) within organizations. The discussion focuses on the shift towards a more strategic and operations-focused approach to finance, exploring how modern finance professionals can become indispensable business partners. The conversation also touches on the concept of a "finance athlete" and the importance of being versatile and adaptable in today's dynamic business environment.This week’s guest is Zach Rial, the Senior Director of Finance and Strategy at Peak, a travel company based in Salt Lake City, Utah. With a background in finance, holding a bachelor's degree from Utah State and an MBA from the University of Utah, Zach brings a unique perspective to FP&A, blending operational insights with financial strategy. Known for his hands-on approach to finance, Zach shares his journey from operations to senior finance roles, emphasizing the importance of understanding the business from the ground up.Here is a summary of the key points from the discussion:What defines great FP&A and why partnerships are crucial for financial success.The concept of a "finance athlete" and how it applies to modern finance roles.The importance of intellectual curiosity and its role in driving business insights.How to manage tough conversations in the workplace with transparency and trust.The evolving role of finance professionals in strategic decision-making and operations.Quotes:Here are a few relevant quotes from the episode "Great FP&A is about great partnerships. It’s understanding the business, what drives different departments, and being a great partner to make things better." - Zach Rial"A finance athlete is someone who says, ‘I do finance,’ and that means many different things. It’s about helping the business in whatever way is needed." - Zach Rial"I consider myself an unusual finance person because I approach finance from an operations perspective—always asking, ‘What does this mean for the business?’” - Zach Rial "Finance is finance. Whether it's a software company or consumer goods, if you understand what drives the business, you can adapt and succeed." - Zach RialWorld-class Digital FP&A Course Bundle: Signup for over ten hours of video content with 4 different courses and 8 modules on FP&A topics including: Business Partnering, Data Analysis, Financial Modeling Design Principles, and Modern Excel. Use code Podcast to save 25%. What are you waiting for signup below: https://bit.ly/4decOf3Follow Zach:LinkedIn - https://www.linkedin.com/in/zacharyrial/Follow Paul: Website - https://www.thefpandaguy.com LinkedIn - https://www.linkedin.com/in/thefpandaguyEnroll for Financial Planning & Analysis Certificate Program:Level up your career and build skills for financial planning and analysis. Sign up for the 8 week online financial planning & analysis certificate program by Wharton Online and learn the art of forecasting, analysis, business partnering and financial storytelling: https://bit.ly/4debs46Earn Your CPE Credit For CPE credit please go to earmarkcpe.com, listen to the episode, download the app, and answer a few questions and earn your CPE certification. To earn education credits for FPAC Certificate, take the quiz on earmark and contact Paul Barnhurst for further details.In today's episode:[01:36] - Paul Barnhurst introduces the episode and the guest, Zach Rial.[02:27] - Overview of Zach Rial’s background and his approach to FP&A.[04:46] - Discussion about Zach’s unique path from operations to finance.[11:05] - Explanation of the "finance athlete" concept and its significance.[15:29] - Exploration of how modern CFOs are becoming more like CEOs, blending operations with finance.[26:34] - The role of finance in RevOps and how these functions can collaborate effectively.[34:37] - Zach shares his approach to handling difficult discussions in the workplace.[39:26] - Quick insights into essential skills and the future of FP&A.[42:52] - Personal insights into Zach’s hobbies, favorite books, and life philosophies.[46:44] - Final thoughts and closing remarks from Paul Barnhurst.

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 this episode, Paul Barnhurst delves into the intricate world of data integration, especially within financial modeling and FP&A. The discussion revolves around the practical challenges and solutions for accessing and automating data flows, a topic crucial for finance professionals who often grapple with multiple data sources and complex modeling tasks. The episode offers insights into the evolving landscape of data management tools and how they can streamline processes for businesses.Adam Rakich, a seasoned expert in the world of FP&A tools and data integration, joins the show. With a diverse background spanning social media marketing software, FP&A consultancy, and leadership roles at companies like Workday and OneStream, Adam now focuses on making data integration more accessible through his work at Data Blend. His deep understanding of the challenges accountants and financial modelers face with data management makes him a valuable resource for listeners looking to optimize their processes.Key takeaways from this week's episode include:The common pitfalls and solutions in financial modeling and data integration.When and why businesses should transition from spreadsheets to specialized planning tools.Practical strategies for automating data workflows, even when dealing with outdated or diverse systems.The importance of understanding APIs, SQL, and other technical aspects of data integration.How to build a business case for investing in data integration solutions.Follow Adam:LinkedIn - https://www.linkedin.com/in/rakich/Click the link below to claim your free book (For a limited time only): The Business User’s Guide to Data Integrationhttps://www.amazon.com/Business-Users-Guide-Data-Integration-ebook/dp/B0CMBMDCJ2/https://www.amazon.co.uk/dp/B0CMBMDCJ2/Follow Paul: Website - https://www.thefpandaguy.com  LinkedIn - https://www.linkedin.com/in/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=7079020077076905984Sign 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 the code “Podcast” to save 15% when you register. In today’s episode:[01:30] - Introduction and worst financial model experiences[07:18] - Adam shares his career path from economist to data integration expert[09:38] - Transitioning from spreadsheets to planning tools[16:56] - The challenges of data integration[26:01] - Hybrid approaches to data automation[28:55] - Tools and strategies for freelancers and small businesses[37:46] - Adam talks about his book and the key takeaways for readers.[44:32] - Rapid fire questions on financial modeling tools and techniques.[52:47] - Final thoughts and 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 this episode of FP&A Tomorrow, host Paul Barnhurst dives into the world of growth equity investing with Ryan Sanders, a seasoned investor from Mercato Partners. The conversation explores the critical role of FP&A (Financial Planning and Analysis) in supporting growth-stage companies, the nuances of growth equity investing, and how entrepreneurs can best position themselves for success. Ryan shares insights from his extensive experience, offering valuable lessons on what it takes to scale companies in today's competitive market.Ryan Sanders is a growth investor at Mercato Partners, a growth equity firm based in Salt Lake City, Utah. With a background in finance and an MBA in entrepreneurship from the University of Texas, Ryan has a deep understanding of what it takes to support and scale innovative companies. His career spans various roles in investment, and he is known for his strategic approach to partnering with entrepreneurs. Ryan also recently completed the Kauffman Fellows program, which has further enriched his expertise in venture capital and growth investing.Expect to Learn:The key attributes and skills that FP&A professionals need to excel in supporting growth-stage companies.The importance of customer-centric growth and why organic growth strategies often outperform inorganic ones.Insights into the investment process at Mercato Partners and how they identify and support promising companies.The role of AI in transforming FP&A functions and the broader finance industry.Practical advice for entrepreneurs on when and how to raise capital effectively.Quotes:Here are a few relevant quotes from the episode “For the CEO and for the board and for the investors, the FP&A is most often a partner, demonstrated through accuracy and speed. But perhaps as important are curiosity, comparison, and completeness.” - Ryan Sanders“The number one skill, in my opinion, for someone in FP&A has to be effective communication. We’re all in sales.” - Ryan Sanders“We’re in the age of AI, and I think AI eats the lunch of vertical functions. If finance believes their only value is debits and credits, I believe that will be obviated over time.” - Ryan Sanders“For me, I wanted three things from the Kauffman Fellows program: to be an active learner, to expand my network, and to learn how to become a better support for a CEO.” - Ryan Sanders“One of the most interesting exercises is to think about the business through a series or a set of stop lights. Red light, yellow light, green light—that accumulation of answers should drive the decision on the type of financing.” - Ryan SandersIn this insightful episode, Ryan Sanders shared invaluable lessons on growth equity investing and the critical role of FP&A in supporting successful business scaling. From the importance of curiosity, comparison, and completeness in FP&A to the strategic decision-making processes that drive value in growth-stage companies, Ryan’s expertise offers a roadmap for professionals and entrepreneurs alike. Whether you're an FP&A professional, an entrepreneur, or an investor, Ryan's experiences and advice provide actionable takeaways that can help you navigate the complexities of business growth.World-class Digital FP&A Course Bundle: Signup for over ten hours of video content with 4 different courses and 8 modules on FP&A topics including: Business Partnering, Data Analysis, Financial Modeling Design Principles, and Modern Excel. Use code Podcast to save 25%. What are you waiting for signup now: https://bit.ly/4decOf3Follow Ryan:LinkedIn - https://www.linkedin.com/in/sandersryan23/ Website - https://www.mercatopartners.com/Kauffman Fellows Program - https://www.kauffmanfellows.org/Follow Paul: Website - https://www.thefpandaguy.com LinkedIn - https://www.linkedin.com/in/thefpandaguyEnroll for Financial Planning & Analysis Certificate Program:Level up your career and build skills for financial planning and analysis. Sign up for the 8 week online financial planning & analysis certificate program by Wharton Online and learn the art of forecasting, analysis, business partnering and financial storytelling: https://bit.ly/4debs46 Earn Your CPE Credit For CPE credit please go to earmarkcpe.com, listen to the episode, download the app, and answer a few questions and earn your CPE certification. To earn education credits for FPAC Certificate, take the quiz on earmark and contact Paul Barnhurst for further details.In Today’s Episode[01:15] - Paul introduces the podcast and guest, Ryan Sanders.[02:26] - Ryan's background and career path[07:03] - The role of FP&A in growth investing[10:26] - The benefits of focusing on customer-driven, organic growth strategies over acquisitions.[14:51] - Insights into the technical and soft skills that FP&A

In this episode of the Future Finance Show, hosts Paul Barnhurst and Glenn Hopper sit down with Christian Martinez, a finance transformation expert and AI enthusiast, to explore the intersection of finance, artificial intelligence, and data analytics. The discussion covers the growing importance of AI and Python in finance, the benefits of leveraging dashboards for financial storytelling, and how professionals can enhance their skill sets to stay ahead in a rapidly evolving industry. Christian shares his journey, the practical applications of AI in FP&A, and offers insights into how Python, integrated with Excel, is revolutionizing finance functions.Christian Martinez is a Finance Transformation Senior Manager at Kraft Heinz, with extensive experience across Europe, Australia, and South America. Known for his expertise in combining finance, Python, AI, and machine learning, Christian is passionate about teaching others how to harness these tools to improve financial analysis and decision-making. He recently launched a newsletter, "AI for FP&A and Finance," where he shares practical AI applications tailored for finance professionals.In this episode, you will learn:The critical role of AI and Python in transforming financial planning and analysis (FP&A).How to leverage dashboards like Tableau and Power BI for effective financial storytelling.The evolving landscape of AI tools in finance and the growing need for data literacy.Practical tips on integrating Python with Excel to enhance financial operations.The importance of continuous learning and staying updated with the latest technology trends in finance.Follow Christian:LinkedIn:https://www.linkedin.com/in/christianmartinezthefinancialfox/Website: https://linktr.ee/ThefinancialfoxBlog: https://christianmartinezfinancialfox.medium.com/Join hosts Glenn and Paul as they unravel the complexities of AI in finance:Follow Glenn:LinkedIn: https://www.linkedin.com/in/gbhopperiiiFollow Paul:LinkedIn: https://www.linkedin.com/in/thefpandaguyFollow QFlow.AI:Website - https://qflow.ai/future-financeFuture 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. In Today’s Episode:[01:51] - Introduction and context setting for discussing the impact of AI on finance[08:01] - Introduction to Christian Martinez, highlighting his unique expertise in finance, Python, and AI.[09:12] - Christian’s newsletter and practical AI tools for finance professionals[15:39] - The Power of dashboards in financial analysis[25:05] - A discussion on the value of coding skills in finance[29:38] - Python in Excel: A game changer[37:51] - Getting personal: Christian’s hidden talents[41:52] - Final remarks from Christian and closing thoughts

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 this episode of Financial Modelers Corner, host Paul Barnhurst sits down with David Benaim, an Excel MVP and data consultant based in Cambodia. They delve into a comparative analysis of two of the most popular spreadsheet tools—Excel and Google Sheets. The discussion covers the strengths and weaknesses of each platform, providing listeners with insights into when and how to use these tools effectively in their financial modeling and data analysis work.David Benaim is a chartered accountant and Excel MVP who has made a name for himself as an expert in both Excel and Google Sheets. Originally from the UK, David now runs a data consulting firm in Cambodia, where he specializes in Excel training and data solutions. With a deep passion for spreadsheets, David is uniquely positioned to discuss the nuances of both platforms, making this episode a must-listen for anyone looking to optimize their use of Excel or Google Sheets.Key takeaways from this week's episode include:Key differences between Excel and Google Sheets, including tables, functions and data entry features.The strengths of Google Sheets in collaborative environments and its data validation capabilities.How to decide whether to use Excel or Google Sheets for different types of projects.Insights into the new table features in Google Sheets and how they compare to Excel’s tables.David’s tips on getting started with Google Sheets for those accustomed to Excel.Follow David:Website - https://www.xlconsulting-asia.com/LinkedIn - https://www.linkedin.com/in/davebenaim/ Follow Paul: Website - https://www.thefpandaguy.com  LinkedIn - https://www.linkedin.com/in/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=7079020077076905984Sign 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 the code “Podcast” to save 15% when you register.  In today’s episode:[01:21] - Introduction to the episode and guest David Benaim.[03:52] - David shares his unique global background and career journey from Deloitte to founding his own firm in Cambodia.[07:00] - Discussion about David’s transition from working at Deloitte to starting his own business in Cambodia and the challenges he faced.[14:38] - In-depth comparison of functions unique to Google Sheets, like “COUNTUNIQUE”, “FLATTEN”, and others not found in Excel.[23:35] - Criteria and scenarios where Google Sheets is the better tool, particularly in collaborative environments and data entry tasks.[30:25] - A look at the newly implemented table features in Google Sheets and how they stack up against Excel’s tables.[38:54] - David shares his decision-making process for choosing between Excel and Google Sheets based on project needs.[43:56] - Quick-fire questions where David shares his preferences on various Excel and Google Sheets functionalities.[49:31] - Tips and resources for users looking to improve their skills in Google Sheets.[50:47] - Final thoughts and how to connect with David Benaim.

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 this episode of FP&A Tomorrow, host Paul Barnhurst delves into the dynamic world of financial planning and analysis (FP&A). He is joined by Josh Aharonoff, an experienced finance professional who has navigated the complexities of FP&A, accounting, and entrepreneurship. The conversation offers insights into the current state of FP&A and its evolving future, with practical advice for both aspiring and seasoned finance professionals.Josh Aharonoff is a seasoned finance expert with a background in accounting and a wealth of experience in both big four accounting and startups. After obtaining his CPA and working in global banking services, Josh ventured into entrepreneurship, co-founding a startup and later establishing his own firm, Mighty Digits, specializing in outsourced finance and accounting services. Josh is also a prominent figure on LinkedIn, with nearly 400,000 followers, and runs a popular daily newsletter and YouTube channel.Here is a summary of the key points from the discussion:Understanding what makes financial planning and analysis effective and impactful.Josh’s professional journey from big four accounting to entrepreneurship and becoming a fractional CFO.Insights into the chaotic yet rewarding environment of early-stage companies.Essential technical and soft skills needed to excel in financial planning and analysis.How to leverage social media for professional growth and its impact on career opportunities.Quotes:Here are a few relevant quotes from the episode "Great FP&A is quick access to data that does not conflict with one another and easy inputs to see different scenarios, different outcomes." - Josh Aharonoff"If you're working for someone and you're thinking of going off on your own, it's a good idea to try to pick up some clients while you're still working." - Josh Aharonoff"In FP&A, it’s crucial to understand how to put together a forecast that not only tells the future but also showcases the past and allows you to easily tell the story of where the company has been." - Josh Aharonoff"People think that you create a financial model once. Okay, now you're done with it. In reality, every single month you should be updating your assumptions. You should be analyzing what exactly took place." - Josh AharonoffWorld-class Digital FP&A Course Bundle: Signup for over ten hours of video content with 4 different courses and 8 modules on FP&A topics including: Business Partnering, Data Analysis, Financial Modeling Design Principles, and Modern Excel. Use code Podcast to save 25%. What are you waiting for signup below:https://bit.ly/4decOf3Follow Josh:LinkedIn - https://www.linkedin.com/in/joshaharonoff/Website - https://www.mightydigits.com/Follow Paul: Website - https://www.thefpandaguy.com LinkedIn - https://www.linkedin.com/in/thefpandaguyEnroll for Financial Planning & Analysis Certificate Program:Level up your career and build skills for financial planning and analysis. Sign up for the 8 week online financial planning & analysis certificate program by Wharton Online and learn the art of forecasting, analysis, business partnering and financial storytelling:https://bit.ly/4debs46Earn Your CPE Credit For CPE credit please go to earmarkcpe.com, listen to the episode, download the app, and answer a few questions and earn your CPE certification. To earn education credits for FPAC Certificate, take the quiz on earmark and contact Paul Barnhurst for further details.In today's episode:[01:38] Introduction to the show and welcoming the guest[02:14] Josh shares his perspective on what constitutes great financial planning and analysis.[02:44] Josh discusses his career journey, from big four accounting to starting his own firm.[05:31] Josh explains why he enjoys working with startups and the unique challenges they present.[06:54] Josh shares memorable experiences with clients, particularly with the company Chili Piper.[09:25] Josh reflects on why big four accounting wasn’t the right fit for him and what he learned from the experience.[15:51] Discussion on the biggest challenges of working with startups, including fundraising and constant evolution.[21:48] Josh offers advice for those looking to start their own advisory services.[26:05] Josh talks about his favorite aspects of working in FP&A.[34:55] Josh shares his journey of growing a significant following on LinkedIn and being recognized as a top voice.[40:12] Josh discusses his recent recognition by Microsoft and what it means to him.[41:25] Quick insights into Josh’s technical and soft skills, favorite tools, and personal preferences.[50:53] Information on how listeners can reach out to Josh and learn more about his offerings.

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 this episode of the Financial Modelers Corner, host Paul Barnhurst delves into the intricate world of financial modeling with returning guest Christopher Reilly. The conversation centers around what is necessary to build robust financial models, highlighting the importance of three-statement models and cash flow forecasting. The episode is filled with practical insights, advanced techniques, and professional experiences that underscore the significance of simplicity, accuracy, and best practices in financial modeling.Christopher Reilly is a seasoned financial modeler with extensive experience in consulting, private equity, and financial modeling education. Starting his career during the financial crisis, Christopher worked on high-profile bankruptcies such as Lehman Brothers and Rescap. His journey took him from a senior analyst role at Hilton Worldwide to middle-market private equity, and eventually to founding his own financial modeling education business. Today, he focuses on teaching and building financial models, with his work being featured by Wharton Online, Wall Street Prep, and LinkedIn Learning among others.Key takeaways from this week's episode include:The importance of simplicity in financial models and how over-complicating can hinder their effectiveness.Practical steps and considerations for building robust three-statement financial models.Tips for auditing models to ensure accuracy and integrity.How to use advanced Excel functions and shortcuts to enhance modeling efficiency.Insights into the role of AI in financial modeling and how it may shape the future of the profession.Follow Christopher:Website - https://www.financialmodelingeducation.com/LinkedIn - https://www.linkedin.com/in/chris-reilly-mission-capital/  Follow Paul: Website - https://www.thefpandaguy.com  LinkedIn - https://www.linkedin.com/in/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=7079020077076905984Sign 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 the code “Podcast” to save 15% when you register.  In today’s episode:[01:11] - Paul introduces the episode and welcomes back Christopher Reilly.[02:31] - Christopher shares a story about a complex healthcare deal model that required significant simplification.[03:55] - Discussion on the importance of keeping models simple and useful.[05:01] - Christopher talks about his career journey and experiences over the past year.[08:31] - Christopher explains why he is passionate about teaching financial modeling.[11:43] - Why every finance professional should understand how to build a three-statement model.[14:20] - Steps to take when beginning to build a three-statement model.[22:17] - Tips on structuring models vertically and building essential checks to ensure accuracy.[28:07] - How to effectively use support schedules and detailed assumptions in modeling.[32:36] - Essential tips for error checking, building support schedules, and maintaining model integrity.[39:10] - Key Excel formulas and functions necessary for building financial models.[46:58] - Discussion on the potential impact of AI on financial modeling and its future integration.[49:53] - Final thoughts and details on Christopher Reilly’s courses and where to find them.

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 this episode of FP&A Tomorrow, host Paul Barnhurst explores the evolving landscape of Financial Planning and Analysis (FP&A) with expert insights from Ron Monteiro. The discussion centers on the crucial role of FP&A in shaping business strategies, driving financial performance, and fostering cross-functional collaboration within organizations.Ron Monteiro is a seasoned FP&A professional with extensive experience in the consumer goods industry. Having worked with major brands like Kraft Foods, Campbell Soup, and Kruger Products, Ron brings a wealth of knowledge in financial analysis, business partnership, and strategic decision-making. He now runs his own training business, helping finance teams worldwide enhance their skills and impact.Here is a summary of the key points from the discussion:The essential attributes of great FP&A and how it contributes to business success.Practical strategies for FP&A professionals to integrate themselves into business operations.The importance of building trust and cross-functional relationships in FP&A roles.Key operational metrics in the consumer goods industry and how to use them effectively.Tips for transitioning from accounting to FP&A and developing strong presentation skills.Follow Ron:LinkedIn - https://www.linkedin.com/in/ronmonteiro18/Website - https://www.kictinc.com/Follow Paul: Website - https://www.thefpandaguy.com LinkedIn - https://www.linkedin.com/in/thefpandaguyWorld-class Digital FP&A Course Bundle: Signup for over ten hours of video content with 4 different courses and 8 modules on FP&A topics including: Business Partnering, Data Analysis, Financial Modeling Design Principles, and Modern Excel. Use code Podcast to save 25%. What are you waiting for signup below:The FP&A Guy (thefpandaguy.com)Wharton FP&A Certificate ProgramFP&A Tomorrow Listeners are eligible to receive $300 off tuition for the FP&A Certificate Program from Wharton Online and Wall Street Prep.Learn More (use discount code THEFPAGUY300)The FP&A Certificate Program is a self-paced rigorous online program for professionals pursuing careers in corporate finance.PROGRAM AT A GLANCEFormat: Self-Paced & Live Office Hours (8 hours/week) Certificate: Issued by Wharton Online and Wall Street PrepClosing Ceremony in NYC (Attend Live or Virtually)Enrollment is currently open for the September 2024 cohort. Please note that the program is limited and filled on a first-come, first-served basis.In today's episode:[01:36] - Paul Barnhurst introduces the podcast and welcomes Ron Monteiro to the show.[02:17] -Ron shares some light-hearted and embarrassing stories about Paul.[03:43] - Discussion on what makes FP&A great and its role in business involvement.[04:35] -Ron talks about the importance of trust and getting involved with other business functions.[05:26] - Ron shares his career journey from the University of Toronto to his current role in training.[09:11] - Ron reflects on his time in the consumer goods industry and memorable product launches.[11:38] - The critical operational metrics in consumer goods and their significance.[14:40] - Challenges and advice for moving from accounting to an FP&A role.[27:28] - Ron's journey from being terrified of presenting to becoming a confident presenter, with tips for others.[33:23] - Why FP&A departments should invest in training and continuous learning.[38:03] - Insight into Ron’s upcoming book and its focus on finding joy and passion in your career.[41:01] - Quick answers on technical and soft skills, forecasting methods, and more.[46:20] - Final tips on being better business partners and embracing a growth mindset.[47:08] - Information on how listeners can reach out to Ron Monteiro. 

Future Finance: Unlocking the Power of AI for Finance Professionals With Jon Brewton TLDR: Jon Brewton, the founder and CEO of Data2, talks about how his company uses AI and machine learning to help clients in make better decisions and avoid errors.Each week we ask AI to generate our show notes and optimize them to get you interested in the story.  This week we used Microsoft CoPilot to write the shownotes.This episode of Future Finance features Jon Brewton, the founder and CEO of Data2, a company that provides AI and machine learning solutions for finance and other industries. He discusses how his company helps clients use AI to analyze data and make better decisions, as well as the challenges and risks of using AI in high-stakes contexts.Jon Brewton is an expert in AI and machine learning, with a rich background in operations management, digital transformation, and engineering. He has worked at major energy companies like BP and Chevron, and he is a US Air Force veteran and a graduate of some of the top universities in the world. He shares his insights and best practices on how to leverage AI and machine learning to enhance financial performance and outcomes, and how to avoid common pitfalls and errors that can arise from AI applications.In this episode, you will learn:· What Data2 does and what its goals and principles are in AI and machine learning.· Why traceability and explainability are crucial for AI applications in high-stakes industries like finance.· How Knowledge Graph technology can enhance financial data analysis and provide more context and meaning.· What AI hallucinations are and how they can affect financial decision-making.·  How to integrate advanced analytics and AI into your finance workflows and processes.This episode is a must-listen for anyone who wants to learn how AI and machine learning can help them make smarter decisions. Listen to the episode now and discover how you can use these technologies to your advantage.Follow Jon:LinkedIn: https://www.linkedin.com/in/jon-brewton-datasquared/ Website: https://www.data2.ai/Follow Glenn: LinkedIn: https://www.linkedin.com/in/gbhopperiiiFollow Paul: LinkedIn: https://www.linkedin.com/in/thefpandaguyFuture 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.Follow QFlow.AI:Website - https://qflow.ai/future-finance[01:50] Introduction to the episode[02:29] Opening remarks by Paul Barnhurst. [04:54] Why your job is safe for now[13:50] Introducing Jon Brewton and his extensive background.[14:51] Welcoming Jon Brewton to the show[15:31] Jon shares the story and mission of Data 2.[18:47] Discussing the critical features for financial institutions.[25:11] Exploring advanced applications and their benefits including generative AI and knowledge graphs.[34:24] Addressing AI hallucinations and how Data Squared tackles this issue to ensure reliable outcomes.[41:41] Advice for finance departments on adopting AI technologies.[46:28] Jon shares his most rewarding job and a cause he's passionate about.[48:54] Final thoughts and closing remarks.

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 this episode, Paul Barnhurst sits down with Ken Puls, a renowned expert in financial modeling and Excel. The discussion delves into the intricacies of financial modeling, the evolution of tools like Power Query and PowerPivot, and how they are revolutionizing data management and reporting. Ken shares insights from his extensive experience and offers practical advice for both novice and seasoned financial modelers.Ken Puls is a Chartered Professional Accountant (CPA) and a Microsoft Excel MVP. He is the founder of Excel Guru, a platform dedicated to Excel-based solutions, and the co-founder of Skill Wave Training, which offers comprehensive courses on Power Query, PowerPivot, and Power BI. With a career that bridges both finance and IT, Ken has become a leading voice in the world of financial modeling and data analysis.Key takeaways from this week's episode include:Ken's personal journey and how he became a leading figure in Excel and financial modeling.The importance of simplifying data entry and reducing errors through automation.Key features and benefits of Power Query and PowerPivot.Practical tips for financial modelers, including the use of VBA and dynamic arrays.Insights into the future of AI in financial modeling and its current limitations.Follow Ken:Website - http://www.excelguru.ca/LinkedIn - https://www.linkedin.com/in/kenpuls/Level up Your Skill with Ken’s book - https://excelguru.ca/master-your-data/ Follow Paul: Website - https://www.thefpandaguy.com  LinkedIn - https://www.linkedin.com/in/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=7079020077076905984In today’s episode:[01:15] - Introduction to the show [01:55] - Welcome to the guest[02:15] - Horror Stories in Financial Modeling: Ken and Paul share their worst financial modeling experiences.[04:50] - Lessons Learned: Key takeaways from those early modeling experiences.[06:02] - Ken’s Background: Detailed overview of Ken’s career and expertise.[08:24] - Current Projects: Ken discusses his current ventures, including Excel Guru and Skill Wave Training.[12:14] - Technology in Accounting: How being tech-savvy has benefited Ken in his accounting career.[16:04] - Discovery of Power Query: Ken shares how he first learned about Power Query and its impact on his work.[26:04] - Getting Started with Power Query: Recommendations for beginners on how to learn and use Power Query.[29:00] - Building Financial Statements with PowerPivot: Overview of Ken’s course and its benefits.[37:46] - Rapid Fire Questions: Ken answers quick questions about financial modeling preferences.[46:47] - AI and Financial Modeling: Discussion on the role of AI in the future of financial modeling. [48:59] - Conclusion: Final thoughts and where to find more information about Ken’s work.

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 Barnhurst is joined by Ken Lane, to discuss what makes great FP&A, the challenges and opportunities in mid-market companies, and the impact of technology and AI on finance.Ken, a seasoned financial controller and FP&A professioal from Ontario, provides valuable guidance about the importance of collaboration, the role of AI and technology, and why he feels mid-market companies allow you to make a bigger difference in the work you are doing. Here is a summary of the key points from the discussion:Great FP&A is about collaboration across all entities within a business. Understanding and addressing the bottlenecks in each area is crucial for driving meaningful business change.Discussion on the necessity for mid-market companies to upgrade their legacy systems to leverage the full value of future FP&A. He highlights the challenges and the importance of investing in technology to streamline data and improve decision-making.The episode delves into the ongoing supply chain issues post-COVID. Ken explains how these challenges necessitate holding more inventory, which impacts cash flow and requires careful management of cash conversion cycles.The discussion highlights how Gen Z's expectations for efficient and advanced systems are pushing companies to invest in better technology. This shift is essential for retaining top talent and staying competitive in the market.Ken stresses the importance of understanding the broader picture of the business and continuously learning. Whether it's through different industries or new technologies, staying adaptable and informed is key to succeeding in FP&A.Quotes:Here are a few relevant quotes from the episode "A lot of mid-market companies still have a lot of legacy systems or multiple legacy systems within a business, and they're going to need to upgrade and change those to get the full value of the future of FP&A.”“When I'm in mid-market companies, I feel like that when you're helping out or you're driving decision-making, you see that impact on the bottom line. When I was with large companies I would see a strategy that would come down from the corporate office, but didn't understand how what I did fed into that strategy.”Follow Ken:LinkedIn - https://www.linkedin.com/in/kennethlane/Website - https://smoothaccounting.ca/Follow Paul: Website - https://www.thefpandaguy.com LinkedIn - https://www.linkedin.com/in/thefpandaguyWorld-class Digital FP&A Course Bundle: Signup for over ten hours of video content with 4 different courses and 8 modules on FP&A topics including: Business Partnering, Data Analysis, Financial Modeling Design Principles, and Modern Excel.  Use code Podcast to save 25% .  What are you waiting for signup below: The FP&A Guy (thefpandaguy.com)In today's episode:[00:00] - Introduction[00:47] - Guest Introduction[02:01] - Anticipating Changes in FP&A[02:40] - The Challenge of Legacy Systems[03:35] - Guest’s Career Journey[06:51] - Impactful Mid-Market Examples[08:52] - Attraction to Manufacturing[09:57] - Key Metrics in Manufacturing[12:12] - Transition to FP&A[15:50] - Managing Technology on a Limited Budget[17:47] - Choosing the Right ERP Partner[20:19] - Real-Time Decision Making with AI[23:02] - Investing in Tech to Retain Talent[24:55] - Rapid Fire Session[25:57] - Role-Level Headcount Planning[27:10] - Importance of Clean Data[29:20] - Get to Know the guest[32:20] - Advice for Better Business Partnering[32:55] - Conclusion and Contact InformationFull Show Transcript:  Host: Paul Barnhurst:: Hello, everyone. Welcome to FP&A Tomorrow, where we delve into the world of financial planning and analysis, examining its current state and future prospects. I'm your host, Paul Barnhurst, guiding you through the evolving landscape of FP&A. Each week, we're joined by thought leaders, industry experts, and practitioners who share their insights and experiences helping us navigate today's complexities and tomorrow's uncertainties. Whether you're a seasoned professional or just starting your FP&A journey, this show has something for everyone. This week, I am thrilled to welcome to the show Ken Lane. Ken, welcome to the show. Guest: Ken Lane:: Oh, thank you for having me, Paul. Host: Paul Barnhurst:: Yes, excited to have you. So just a little bit of background about Ken and I'll allow him to introduce himself further in a few minutes. But he comes to us from Ontario, Canada. He is a financial controller. He spent most of his career either working as a controller or manager, finance, or accounting, and he spent most of it in the mid-market, in several different industries. So, Ken, we like to start the show with this question for all our guests? From your viewpoint, what does grade FP&A look like?

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.Lyndsey Weber, a seasoned expert in financial and supply chain modeling join us this week for a lively conversatio on both financial and supply chain modeling. She recounts her experience with some of the worst models she has encountered, the lessons learned, and the importance of organization and design in creating effective models. Lyndsey shares her journey from ExxonMobil to Quantrix, offering a deep dive into the art and science of financial modeling.Key takeaways from this week's episode include:Having a well-defined structure and approach is crucial for creating and maintaining effective financial models. Poorly organized models can lead to significant challenges and inefficiencies. A horror story about inheriting a model filled with bad practices, including hidden reference cells and broken VBA code. The experience teaches her the value of starting over and building a model from scratch with best practices.The importance of understanding stakeholder needs, both emotional and practical, and designing models that cater to these needs. This approach helps in building models that are not only functional but also user-friendly.The benefits of using Quantrix over traditional Excel, highlighting features like always-on pivoting, natural language formulas, and role-based access, which enhance efficiency and collaboration.One of Lyndsey's key pieces of advice is to prototype models on paper before building them. Mapping out inputs, outputs, and key calculations in plain English helps in creating a clear and effective model structure.Quotes:Here are a few relevant quotes from the episode on financial analysis and modeling:"This model that I inherited had, I feel every bad practice in the book, I vividly recall a couple of formulas where they just pointed to what I would call a cell island.”-Lyndsey Weber“Having a defined structure and approach that can be repeated, I think is essential.”-Lyndsey WeberIn this episode, Lyndsey provides valuable insights into the complexities of financial and supply chain modeling. She sheds light on the best practices and tools that can make a significant difference in model-building. This episode will help you enhance your modeling skills and create more effective and user-friendly models.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. Follow Lyndsey:LinkedIn - https://www.linkedin.com/in/lyndsey-weber/ Follow Paul: Website - https://www.thefpandaguy.com LinkedIn - https://www.linkedin.com/in/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=7079020077076905984In today’s episode:[00:55] - Introduction;[03:57] - Worst spreadsheet model horror story[04:43] - Key takeaway: Importance of organization in modeling[06:57] - Guest Backgrounds[12:10] - Evolution of modeling roles at ExxonMobil[14:20] - Differences between supply chain and financial modeling[20:30] - Overview of Quantrix as a modeling tool[22:00] - Advantages of Quantrix over Excel[28:40] - Areas for improvement in Quantrix[35:27] - Considerations for scalability and collaboration in modeling[38:50] - Excel Discusssion[44:58] - Rapid Fire Section[52:23] - Importance of prototyping models[53:00] - Get to know our guests personally and Conclusion

Welcome to a special episode of Financial Modeler’s Corner! Today, we're thrilled to bring you an exciting Podswap from FP&A Tomorrow. Stay tuned for an engaging conversation with Carl Seidman that you won't want to miss. Here are the show notes from our previous episode.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 a conversation with Carl Seidman to discuss why mastering presentation skills, and understanding the needs of the audience is crucial for excelling in your FP&A career.Carl is a premier FP&A and Fractional CFO expert, providing financial advisory and leadership development services to top companies including Deloitte, Verizon, and Walmart. Carl is known for his impactful training programs and advisory work that drive success in financial planning and analysis.Key takeaways from this week's episode include: :Here is a concise summary of the key points from the discussion:In FP&A, the ability to distill complex information into a concise, impactful message is paramount. It's not about how much you know, but what you can communicate effectively.The ability to distill complex information into a concise, impactful message is paramount. It's not about how much you know, but what you can communicate effectively.FP&A isn't just about numbers, it's about storytelling with data, painting a vivid picture of the financial landscape that guides strategic decisions and drives organizational successAnticipating potential disruptions or changes in the business environment is a fundamental aspect of FP&A. By identifying risks and developing strategies to mitigate them, FP&A professionals can help the organization stay ahead and adapt effectively.Quotes: Here are a few relevant quotes from the episode about FP&A mastery:"You're not going to go to a nice restaurant and pay a lot of money for a delicious dish, and then have it be delivered in a greasy brown paper bag. Right. So the deliverable matters a whole lot. It can actually significantly dismiss the credibility or value of everything that came up before at that point in time."-Carl Seidman"I think that Great FP&A looks like a team of people who are equipped, from a technical standpoint, to be able to execute the kinds of requests that are being asked of them."-Carl Seidman“The demands in business, the increasingly fast-moving environment, competition, the risks of getting some of this planning wrong are pushing the need of FP&A to be a whole lot more proactive, a lot more agile, a lot more well rounded and thinking instead of just being about financial planning and reporting."-Carl SeidmanFollow Carl:  LinkedIn - https://www.linkedin.com/in/carlseidmanWebsite - https://seidmanfinancial.coFor 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:25] Carl introduction;[02:42] Changing FP&A trend over the next five years:[10:00] Carl’s background:[12:05] Carl’s passion for presenting and communication[15:44] Favorite voice Carl can impersonate?[20:42] Becoming better speakers and why presentation matters[33:44] How you can be better at influencing[40:44] Most important skills for FP&A professionals[45:00] Carl’s LinkedIn learning course[47:15] Rapid Fire[51:35] Carl’s book recommendation[55:51] Parting words

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 with Andrew Jepson, to discuss the world of Financial Planning and Analysis.Andrew, founder of the FBPteam, has over 20 years of experience in financial planning and analysis, starting his career as an auditor and evolving into a sought-after business partner and trainer. As a passionate advocate for professional development, Andrew has authored a book on business partnering, facilitated numerous training programs worldwide, and is dedicated to elevating the capabilities of finance professionals.Here is a concise summary of the key points from the discussion:The great FP&A professionals go beyond just reporting numbers—they anticipate future trends and needs. This proactive approach is crucial for providing real value to the organization.Transitioning from a focus on being right to being effective is vital. Andrew shares his personal journey of learning to communicate better and build stronger relationships within the business.Business partnering involves working cohesively with other departments to solve real business problems and achieve strategic goals. Andrew outlines a framework for becoming an effective business partner, emphasizing understanding the business, effective communication, and building strong relationships.Time management, perception of finance, and systems and processes are common barriers to effective business partnering. Andrew provides practical advice on how to navigate and overcome these challenges.Mental Health and Work-Life Balance and the importance of seeking professional help. This episode highlights the need for self-awareness and taking care of one's mental health to maintain a successful career in finance.Quotes:Here are a few relevant quotes from the episode "You do have time. What you've got to decide is what you choose to do at that time.”-Andrew Jepson"It's not what you say, it's how you say it. Your energy, all that sort of stuff."-Andrew Jepson"I think FP&A has a spectrum from average to really good. I think the average FP&A person is generally just pumping out numbers to their organization."-Andrew JepsonIn this episode, Andrew shares his journey from auditor to business partner and offers valuable insights into the evolving landscape of FP&A. Remember to prioritize your mental health and continuously seek ways to improve your processes and time management.Link to courses: FP&A Business Partnering (thinkific.com)Modern Microsoft Excel (thinkific.com)Follow Andrew:LinkedIn - https://www.linkedin.com/in/financebusinesspartnering/Website - https://www.thefbpteam.com/Follow Paul: Website - https://www.thefpandaguy.com LinkedIn - https://www.linkedin.com/in/thefpandaguyIn today's episode:[01:01] - Introduction[01:43] - Guest Introduction[02:35] - Defining Great FP&A[03:34] - Anticipation in FP&A[05:21] - Andrew’s Career Journey[08:10] - Importance of Business Partnering[11:45] - Key Skills for FP&A Professionals[15:45] - Transitioning from Being Right to Being Effective[28:10] - Common Themes in FP&A Struggles[43:17] - Rapid Fire Session[50:01] - Get to know the Guest[53:15] - Conclusion

TLDR: Jim O'Neill, co-founder of SaaSWorks, discusses the critical role of AI in modern finance, emphasizing the importance of clean data, the convergence of AI with other technologies, and the need for businesses to adapt to an AI-driven landscape.These show notes were written by Claude.AI Sonnet LLM Model. Dive into the Future of Finance with AI Pioneer Jim O'NeillAre you ready to revolutionize your business with AI? Join us as we explore the cutting edge of financial technology with Jim O'Neill, co-founder of SaaSWorks and former HubSpot executive. In this eye-opening episode, Jim unveils the secrets to harnessing AI's power in finance and beyond.Key Insights:The make-or-break factor for AI success: pristine dataAI's game-changing fusion with quantum computing, nanotech, and gene editingWhy your company needs an AI budget – nowNavigating the ethical minefield of AI advancementCultivating an AI-driven culture of innovationDon't miss Jim's invaluable wisdom on preparing your business for the AI revolution. Learn how to stay ahead in a rapidly evolving technological landscape and transform your financial operations.Follow Jim:LinkedIn: https://www.linkedin.com/in/jim-oneill/Website: https://www.saasworks.com/Join hosts Glenn and Paul as they unravel the complexities of AI in finance. Follow them on LinkedIn:Glenn: https://www.linkedin.com/in/gbhopperiii Paul: https://www.linkedin.com/in/thefpandaguySponsored by QFlow.ai – Revolutionizing B2B revenue planning and analysis. Learn more at Qflow.ai/future-finance.In honor of having the show notes written by AI we have added the below sonnet as Claude.AI, Sonnet model wrote the notes. Sonnet:In finance's realm, where numbers reign supreme, A new force rises, born of silicon, Artificial minds, a waking dream, O'Neill speaks of change that's just begun.Clean data's key, the lifeblood of AI, As quantum leaps with nano-innovations dance, In gene-spliced futures, new worlds we'll spy, While ethics guard our technological advance.Businesses must adapt or fade away, Embracing risk and AI's transformative might, O'Neill's wisdom lights the coming day, Where human and machine in harmony unite.So heed this call, let Future Finance guide, To prosperous tides on which we'll proudly ride.In today's episode:[00:52] - Episode Overview and Sponsorship[01:38] - Monologue[07:31] - Your Job is Safe[08:56] - Importance of clean data for effective AI implementation[09:58] - Guest Introduction[15:30] - Founding SaaSWorks and its mission[18:11] - Common issues with spreadsheets and data management[21:09] - Discussion on generative AI in business operations[25:55] - Using AI for innovative and unexpected solutions[29:11] - Recommendations for companies adopting AI[32:07] - Discussion on AI adoption and Excel parallels[32:37] - Random AI-Generated get to know you questions[36:08] - 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.George Mount, Excel MVP and data analytics expert, with an extensive background in finance and data science, shares his insights into the evolution of Excel, the integration of Python, and the importance of data analytics for financial modelers.Key takeaways from this week's episode include:Excel's flexibility is both its greatest strength and weakness. While it allows for complex modeling, this same flexibility can lead to chaotic and error-prone spreadsheets if not managed properly.Today's Excel is vastly different from the Excel of a decade ago. With features like Dynamic Arrays, Power Query, and the integration of Python, Excel has become a powerful tool for modern data analysis and financial modeling.Python’s capabilities in handling time series analysis, data visualization, and complex computations complement Excel’s functionalities, making it a valuable skill for modelers.Excel excels in prototyping and wireframing due to its immediate data visibility and user-friendly interface. This makes it ideal for quickly iterating models and understanding data before moving on to more complex tools when necessary.George shares advice on how to get started learning Python and other analytical tools to take your analysis and modeling to new heights. A core principle for George is the importance of sharing what you know about Excel and data analytics. He emphasizes building a culture of knowledge sharing to foster growth and efficiency within teams.Quotes:Here are a few relevant quotes from the episode on financial analysis and modeling:"Excel’ greatest strength and weakness is its flexibility.”-George Mount“Excel is not the Excel of ten, 15 years ago. I often like to kind of think of it as modern Excel with Power "Query, Power Pivot, now Python, Dynamic Arrays, LAMBDA, LET, and other things.”-George Mount“The first rule of knowing Microsoft Excel is not to tell anyone that you're good at it.”-George MountIn this enlightening episode, George Mount provides valuable insights into the evolving world of Excel and data analytics. By integrating new tools like Python and embracing the advanced features of modern Excel, financial modelers can significantly enhance their analytical capabilities.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. Follow George:LinkedIn - https://www.linkedin.com/in/gjmount/ Follow Paul: Website - https://www.thefpandaguy.com  LinkedIn - https://www.linkedin.com/in/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:[01:06] - Introduction;[02:14] - Worst spreadsheet model horror story[04:49] - Importance of achievable modeling in Excel[05:16] - Guest Backgrounds[08:57] - Combining data science and data analytics in Excel[11:01] - Necessity of learning Python and R[17:19] - Recommended resources for learning Python[20:27] - Exciting new features in Excel[22:25] - AI's role in Excel and financial modeling[25:55] - Favorite function in Excel[29:00] - Rapid fire;[37:08] - Get to know the guest and 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 with Bonnie Tomei, in the discussion on what makes great FP&A, the future of AI in finance, and key strategies for aspiring CFOs.Bonnie, the CFO of Salience Labs and Chief Strategy Officer for K2X, has a wealth of experience in finance, strategic planning, and M&A activities, including being the former CFO of Spectra7, where she was voted Woman CFO of the Year for smaller public companies by FBI Silicon Valley.Here is a concise summary of the key points from the discussion:FP&A professionals should act as strategic partners to executives, helping them achieve financial roadmaps and objectives. Understanding both internal and external factors is crucial for effective financial planning and analysis.AI and software are transforming FP&A roles, pushing analysts to mature faster and providing deeper insights. Despite the rise of AI, the need for human intelligence to interpret data and make strategic decisions remains critical.FP&A is a strong pathway to becoming a CFO, but professionals need to understand the technical accounting side and have business acumen. Building strong relationships with the executive team and demonstrating strategic thinking are essential for aspiring CFOs.FP&A teams play a vital role in M&A activities, particularly in modeling and due diligence. Professionals should volunteer for tasks and demonstrate business intelligence to stay relevant during acquisitions.Technical skills like Excel are fundamental, but equally important are soft skills such as emotional intelligence (EQ) and effective communication.Understanding and defining key performance indicators (KPIs) is crucial for measuring success and aligning with strategic goals.Quotes:Here are a few relevant quotes from the episode "Every time they come up with something new I've always fallen back to the good old days of that quick shortcut the ctrl+C, ctrl+V anyway.”-Bonnie Tomei“Getting involved and understanding how you can help in looking at all of that and being a trusted advisor from a financial standpoint would help tremendously.”-Bonnie TomeiIn this episode, Bonnie Tomei provides a comprehensive look at the evolving landscape of FP&A, emphasizing the importance of strategic partnership, the impact of AI, and the essential skills needed to excel in the field. Bonnie's insights offer valuable guidance on navigating the complexities of financial planning and analysis. Stay curious, be proactive, and focus on building strong professional relationships to thrive in your FP&A career.Link to courses: FP&A Business Partnering (thinkific.com) Modern Microsoft Excel (thinkific.com)Follow Bonnie:LinkedIn - https://www.linkedin.com/in/bonnie-tomei-a288b91/Website - https://saliencelabs.ai/Follow Paul: Website - https://www.thefpandaguy.com LinkedIn - https://www.linkedin.com/in/thefpandaguyFor 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:01] - Introduction[01:43] - Guest Introduction[03:35] - Defining Great FP&A[05:21] - Future Changes in FP&A[07:00] - Career Progression to CFO[11:07] - Advice for FP&A During M&A Activities[13:19] - Transition to CFO[16:27] - FP&A as a Pathway to CFO[27:35] - Skills for Aspiring CFOs[30:55] - Being More Strategic in FP&A[34:02] - Rapid Fire Session[37:34] - Contact Information of the Guest[39:10] - Final Advice and 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.Raphael Benhamou, an independent consultant and fractional CFO explores the art and science of financial modeling. Raphael shares his experiences, insights, and a few horror stories from his extensive career, highlighting the importance of operational understanding and the advantages of using modern tools like Causal for financial modeling.Sample Causal Financial models if you want to review how Causal works:Subscription Model - https://www.benhamouconsulting.com/subscription-saas-revenuesPipeline Model - https://www.benhamouconsulting.com/pipeline-saas-revenuesKey takeaways from this week's episode include:Raphael emphasizes the critical need for regular audits of financial models to prevent errors and ensure accuracy. He shares a horror story about a model that wasn't audited for five years, leading to significant financial discrepancies.While Excel is known for its flexibility, Raphael discusses the trade-offs of using more structured tools like Causal, which can help reduce errors and provide more insightful analysis through its object-oriented approach and natural language variables.The importance of integrating operational data with financial models to provide actionable insights. He stresses that understanding business operations is crucial for building effective and useful models.Raphael shares his journey from using traditional Excel spreadsheets to adopting Causal, a modern financial modeling tool. He explains how Causal's dynamic dashboarding, probability distribution modeling, and seamless integration with other systems offer significant advantages over Excel.The discussion focuses on the potential of AI in financial modeling, Raphael notes that while AI can build models, the real question is whether it should. He also touches on the importance of human judgment and expertise in interpreting and using these models effectively.Quotes:Here are a few relevant quotes from the episode on financial analysis and modeling:"My perspective on this is what I was saying earlier about operating connecting to finance. I think to be a good financial modeler, you need to have a good understanding of what what's going on in the business as well, not just at the finance level.”- Raphael Benhamou“It gave me a great grounding in best practices for modeling across all modeling platforms, especially Excel. Because one of my big nitpicks with Excel and Google Sheets is that it's too freeform.”- Raphael BenhamouThis episode provides valuable insights into the evolving landscape of financial modeling. The discussion sheds light on the benefits of modern financial modeling tools like Causal, the necessity of regular audits, and the critical role of understanding business operations. Whether you're a seasoned financial modeler or just starting, this episode offers practical advice and thought-provoking perspectives on how to enhance your financial modeling practices.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. Follow Raphael:LinkedIn - https://www.linkedin.com/in/raphaelmibenhamou/Website - https://www.benhamouconsulting.com/ 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=7079020077076905984In today’s episode:[00:03] - Introduction[01:01] - Guest Introduction[03:47] - Key Takeaways from the Horror Story[04:55] - Guests’ Background[07:13] - Introduction to Causal[08:03] - Transition to Finance[12:29] - Love for Modeling[14:00] - Early Career and Tools[17:46] - Flexibility vs. Structure[23:50] - Types of Models Built in Causal[39:43] - Rapid-Fire Session[48:12] - Get to know the guest[49:46] - 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 Michael Dion on how FP&A goes beyond numbers and reports, focusing on collaboration and leveraging cutting-edge technology like generative AI to drive business success.Michael, a seasoned finance professional and senior manager at a Fortune 100 company, is passionate about storytelling and presentations, transforming traditional financial reviews into engaging, story-based approaches. As a finance leader with extensive experience in media and entertainment, his innovative use of generative AI and dedication to continuous learning set him apart as a visionary in the FP&A field.Key takeaways from this week's episode include:Here is a concise summary of the key points from the discussion:Great FP&A emphasizes collaboration across departments, enabling informed decision-making rather than merely generating reports and numbers. This approach fosters a more integrated and strategic business environment.Future FP&A professionals need to be technically proficient with tools like Python and generative AI. These technologies are crucial for handling and processing large data sets efficiently, enhancing overall effectiveness.Implementing automation and AI can streamline FP&A processes, increasing efficiency and productivity. This allows FP&A professionals to focus on more strategic tasks, driving greater impact within their organizations.Moving from traditional, number-heavy presentations to story-based approaches that incorporate insights from various departments can make financial reviews more engaging and actionable, leading to better business outcomes.Strong relationships with business partners are essential for FP&A professionals. These relationships enable them to provide valuable support and drive strategic decisions, ultimately benefiting the entire organization.Continuous learning and adapting to new technologies are critical for FP&A professionals to stay relevant. Embracing technological advancements ensures they can meet the evolving demands of the industry.Proactively providing useful insights and well-prepared reports can make life easier for business partners and managers. This approach fosters better collaboration, enhances strategic decision-making, and supports career growth for FP&A professionals.Quotes:Here are a few relevant quotes from the episode "We need to almost be pseudo IT professionals just like how you had to learn and transition into Excel 20 years ago”-Michael Dion“AI is going to make us in some ways more technical, not less.”-Michael Dion“I'm all about efficiency, and I've been using the generative AI to teach myself Python by learning its functionality by reviewing libraries of code.”-Michael Dion“My goal going in was to just engage people and make them, dare I say, excited about finance.” -Michael DionThis discussion with Michael Dion focuses on the evolving role of financial planning and analysis (FP&A) in modern organizations. Key topics include the importance of collaboration, the integration of advanced technologies, and practical strategies for FP&A professionals to enhance their effectiveness and impact.Exciting AnnouncementI 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 Michael:LinkedIn - https://www.linkedin.com/in/dionmichaelc/Website - https://www.f9finance.com/Follow Paul: Website - https://www.thefpandaguy.com LinkedIn - https://www.linkedin.com/in/thefpandaguyFor 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:20] - Introduction[02:00] - Guest Introduction[03:05] - Integrating Consumer Insights[04:44] - Preparing for Technological Changes[05:30] - How technology enhances the abilities of FP&A professionals[11:30] - Media Industry Passion[15:30] - Amortization of Film Costs[18:00] - Response to F9 Finance[24:00] - Transforming Business Reviews[28:34] - Advice for Story-Based Reporting[38:00] - Career Advice[39:00] - Rapid Fire Session[41:07] - Use of Generative AI[45:00] - Business Partnership[46:14] - Contact Information of the Guest[47:00] - Conclusion

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/gbhopperiiiFollow Paul: LinkedIn: https://www.linkedin.com/in/thefpandaguyFollow QFlow.AI:Website - https://qflow.ai/future-financeStay 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 VaddanIn 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=7079020077076905984In 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 AnnouncementI 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/thefpandaguyFor 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=7079020077076905984In 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 AnnouncementI 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/thefpandaguyFor 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 GeminiThe 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 PlanningWelcome 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/gbhopperiiiFollow Paul: LinkedIn: https://www.linkedin.com/in/thefpandaguyFollow QFlow.AI:Website: https://qflow.ai/future-financeStay 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 moreFuture 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=7079020077076905984In 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/philipawatsonWebsite - https://www.paddle.comFollow Paul: Website - https://www.thefpandaguy.com LinkedIn - https://www.linkedin.com/in/thefpandaguyFor 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=7079020077076905984In 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

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 Tyler Cypher, for a discussion on how generative AI is reshaping FP&A, the importance of business partnering, and optimizing cloud spend.Tyler, the founder and CEO of OpsCipher, shares his journey from Disney finance intern to leading FP&A at top cybersecurity firms. He is an expert in leveraging generative AI for strategic decision-making. Also a passionate advocate for effective business partnering and optimizing cloud spending.Key takeaways from this week's episode include:Here is a concise summary of the key points from the discussion:Generative AI simplifies data processing, enabling FP&A teams to focus more on strategic analysis and decision-making, ultimately enhancing their value to the organization.Success in FP&A hinges on understanding business challenges, effective communication, and building trust with stakeholders. Being curious and proactive is key to growth.Effective cloud spend management requires visibility, collaboration across teams, and financial stewardship from the early stages of product development to avoid unnecessary costs.Financial operations play a critical role in managing cloud costs. Establishing a dedicated FinOps team or center of excellence can provide significant benefits.How skills from varied roles like investment banking and consulting can enhance FP&A effectiveness. Exposure to various business aspects through FP&A provides a strong foundation for leadership roles.The discussion highlights the necessity of mastering copywriting to communicate effectively and set clear expectations with stakeholders. For FP&A professionals this skill helps in selling ideas and managing business relationships successfully.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 the FP&A Guy, that is TheFPandAGuy for an exclusive 25% discount on your first-year membership.Quotes:Here are a few relevant quotes from the episode "The people who are the most successful have a genuine curiosity about the business. It's very hard to go into those teams and try to be that analytical value-add extension if you can't understand their challenges."“If you think about software business, generally, the two biggest expenses are people and then the cost of running the software.”“FinOps as an organizational structure. So from the first part, I think, it's inherent in the word financial operations. It's a financial stewardship-driven culture in the first place.”Follow Tyler:LinkedIn - https://www.linkedin.com/in/tylercyphersWebsite - http://opscipher.comFollow Paul: Website - https://www.thefpandaguy.com LinkedIn - https://www.linkedin.com/in/thefpandaguyFor 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:(1:20) - Introduction(01:50) - Guest Introduction(02:26) - Defining Great FP&A(05:01) - Impact of Generative AI on FP&A(06:59) - Future of FP&A with AI(13:25) - Becoming A Strategic Business Partner(17:40) - Cash Flow for Coders Newsletter(21:30) - Optimizing Cloud Spend(30:12) - Advice for Managing Cloud Spend(44:12) - Rapid-Fire Session(46:40) - Essential Skills for FP&A Professionals(47:40) - Guest’s Personal Insights.(50:42) - Advice for FP&A Business Partners

TLDR: These show notes were optimized using Claude ChatGPT 4.0 and are designed to make you listen to the full episode. We also asked H4.0 to write a brief limerick summarizing the show notes.There once was a podcast on AI,Transforming accounting, oh my!With Mitchell's insight,Efficiency in sight,A must-listen for those on the fly.Show Notes:Welcome to Future Finance, with your hosts Paul Barnhurst and Glenn Hopper, where we focus on the technological advancements and emerging trends fueling the FP&A professionals. We bring you vital updates and insights into the technologies that are going to shape not just finance and accounting, but every sector of the world in the years ahead.In today’s episode, Paul and Glenn engage in a conversation with Mitchell Troyanovsky, Co-Founder of Basis, to discuss the transformative impact of AI on the accounting profession. The discussion highlights the differences between rule-based systems and generative AI.Highlights of the Episode:Generative AI vs. Rule-Based Systems: Generative AI offers contextual understanding and reasoning, unlike rule-based systems that rely on rigid if-then statements, making it more adaptable to complex accounting tasks.AI as a Digital Assistant: AI can create first drafts of accounting tasks, enabling accountants to review and refine the work, thus saving time and increasing productivity. "You'll start having accountants much more of their job, rather than being this kind of monotonous manual work, start to be like, okay, this work has been done for me as a first draft, let me now review it."Enhancing Strategic Value: AI acts as a digital assistant, supplementing the workforce rather than replacing it, and allowing accountants to provide more strategic value to their clients. "It is a tool for accountants. Explicitly, at the end of the day, the job that they can do the best is to advise their clients, help their clients, help them make better decisions, and be that partner, with them, rather than needing to be stuck in all the manual work needed to get to that actual real value add at the end of the day."Shifting Roles and Skills: The introduction of AI in accounting will shift the focus from data entry and basic tasks to more analytical and advisory roles, making the profession more appealing to new graduates.Addressing Trust Issues: While AI will make mistakes, just like human employees, it is essential to implement systems to catch errors and continuously improve AI performance through feedback and iteration.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-financeFollow Mitchell:LinkedIn: https://www.linkedin.com/in/mitchelltroyanovsky/Website: https://www.getbasis.ai/Follow Glenn:LinkedIn: https://www.linkedin.com/in/gbhopperiiiFollow Paul: LinkedIn: https://www.linkedin.com/in/thefpandaguyFollow QFlow.AI:Website: https://qflow.ai/future-financeIn today's episode:[01:32] Introduction[06:35] Real-world applications of ChatGPT 4.0 in financial analysis[08:50] Evolution of AI models and their impact on specialized financial tools[11:23] Guest’s background[13:43] Overview of Basis and the need for AI in accounting[17:10] Differences between rule-based systems and generative AI[20:22] How AI handles accounting workflows[26:42] Addressing fears and trust issues with AI in accounting[33:11] Fun rapid-fire Session[37:40] Contact information for more learning opportunities

Welcome to FP&A Tomorrow, where we discuss financial planning and analysis, examining its current state and future prospects, with your host Paul Barnhurst. The title sponsor for this week’s episode of FP&A Tomorrow is the Third Generation FP&A Tools Showcase. Join the Showcase and see the latest technology in FP&A planning software. Register for free today: https://www.accelevents.com/e/fpatoolsshowcaseIn today’s episode, Paul engages in a thought-provoking conversation with the awesome Jim Cook and Winnie Aoieong, for a fascinating discussion on the importance of decision-making systems, the value of trust in business partnerships, and the role of generative AI in modern FP&A.Jim Cook, former CFO of Mozilla with a rich history at Netflix and Intuit, shares his valuable insights on effective decision-making systems and the power of community building.Winnie Aoieong, VP of Business Finance at PowerSchool, discusses her experience in scaling financial operations and the critical balance of technical skills and business communication.Key takeaways from this week's episode include: :Here is a concise summary of the key points from the discussion:Great FP&A goes beyond data analysis to create effective decision-making systems, allowing businesses to make strategic decisions based on comprehensive insights.Building strong, trust-based relationships with business partners is essential for effective collaboration and achieving organizational goals.Discussion on harnessing the power of community and crowdsourcing can significantly enhance problem-solving and innovation within an organization.How to balance technical skills with effective communication is crucial for translating complex financial data into actionable business strategies.Adaptability to embrace a mindset of continuous improvement and learning from failures. Progress over perfection drives long-term success.Utilization of generative AI for tasks like meeting summaries and action item tracking can enhance efficiency and focus on high-value activities.Leadership development within the team and creating a safe environment for challenging assumptions encourages innovation and growth.Quotes:Here are a few relevant quotes from the episode about the importance of decision-making systems, building trust in business partnerships, and the role of generative AI in enhancing FP&A efficiency:"Great FP&A is the balance of technical skills and translating that into actionable plans to communicate with the business.""Ultimately what they're trying to do is partner with their department business unit and create excellent decision-making systems because that's what our data is eventually doing.""A relationship builds on trust. So trust comes from your capacity, your capabilities, but also your way of wanting to build that alliance with whoever you work with.""Mozilla taught me about how powerful communities are. Communities always win." "Perfection is a prison. It's about always progressing and improving because there is always room to get better." Follow Jim:LinkedIn - https://www.linkedin.com/in/cookflixWebsite- https://www.benchboard.comFollow Winnie:LinkedIn - https://www.linkedin.com/in/winnie-aoieong-6852212Website- https://www.powerschool.com Follow Paul: Website - https://www.thefpandaguy.com LinkedIn -https://www.linkedin.com/in/thefpandaguyFor 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:05] Introduction[01:20] Guest’s background[01:28] What Does Great FP&A Look Like?[02:13] Evolution of FP&A[02:45] Future of FP&A[10:30] Scaling a Company[12:00] Leadership Changes[16:00] Role of Finance in Business[21:32] Systems and Chart of Accounts[29:40] Safe Space for Innovation[40:52] FP&A Tools and Generative AI[42:00] Rapid Fire Questions[49:20] Get to Know Our Guests Personally