PLAY PODCASTS
The FP&A Guy Network

The FP&A Guy Network

357 episodes — Page 6 of 8

Excel Problem-Solving Strategies for Financial Modelers to Build Robust Models with Liam Bastick

In this engaging episode of Financial Modelers Corner, host Paul Barnhurst, aka "The FP&A Guy," sits down with Liam Bastick, Managing Director of Sum Product and a highly respected figure in financial modeling and Excel expertise. Known for his complex modeling work, quirky sense of humor, and love for a good challenge, Liam shares insights into the nuances of financial modeling, discusses his favorite Excel tips, and reveals his fascination with the evolving role of AI in modeling. Liam Bastick is a seasoned corporate trainer, author, and financial modeling expert, with a focus on Excel, Power BI, and AI applications. With a career that includes awards like Microsoft’s Most Valuable Professional and the inaugural Lifetime Achievement, international recognition, and extensive teaching, Liam provides listeners with both practical advice and fascinating anecdotes from his career.Expect to Learn:Excel optimization tips and learn how to effectively use Quick Access toolbar Circular references and financial modeling horror story insightsChallenges and advantages of modeling in Power BIHow AI is changing financial modeling and what the future might holdLiam’s approach to problem solving to stay at the forefront of innovationHere are a few quotes from Liam Bastick:“The best tip I can give is to put the tools you use most often on the Quick Access toolbar. It’s underused but incredibly helpful.”“If you've got circular references in your model, you’re already on thin ice. They can lead to wrong answers and complete chaos.”“With AI, you can do the front-end and back-end work in financial modeling, but it’s still not there yet for the mechanics in the middle.”In this insightful episode, Liam Bastick shared his passion for financial modeling, bringing both humor and depth to complex topics in Excel, Power BI, and AI. His reflections on adaptability, continuous learning, and challenging the limits of traditional tools serve as powerful reminders for anyone in finance or data analysis. Follow Liam:Website - https://www.sumproduct.com/LinkedIn - https://www.linkedin.com/in/liam-bastick-73a39114/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:52] – Introduction to guest Liam Bastick[03:44] – Liam’s Modeling Horror Stories[08:32] – Liam’s Professional Journey and Challenges[14:17] – Running a Business and Reinvention[16:05] – Discussing AI’s Impact on Financial Modeling[20:39] – Books and Teaching Tips[35:50] – Rapid Fire: Excel Best Practices[46:57] – Advanced Modeling Techniques and Final Tips[54:16] – Contact Information and Wrap Up

Nov 19, 202456 min

S1 Ep 34How FP&A Professionals Can Bridge the Gap Between Finance and Operations with Kathy Svetina

In this episode of FP&A Tomorrow, host Paul Barnhurst, also known as The FP&A Guy, dives deep into the world of financial planning and analysis with Kathy Svetina. As a fractional CFO for businesses, Kathy shares her expertise in transforming small to mid-sized companies’ financial health and operational efficiency. She discusses her five-part framework for building a solid financial foundation and shares insights on how smaller businesses can leverage FP&A to drive sustainable growth and avoid common financial pitfalls.Kathy Svetina is the founder of Newcastle Finance, specializing in fractional CFO services for businesses with $10 million+ in annual revenue. With over 14 years in senior-level FP&A roles in Fortune 500 companies, Kathy brings top-level financial acumen to smaller enterprises, helping them scale while improving financial stability and operational efficiency. Passionate about strategic finance, Kathy provides invaluable advice on how FP&A functions can help build resilient and thriving companies.Expect to LearnKathy’s five-part framework that structures financial health Practical approaches to FP&A for smaller businessesThe critical role of financial systems and processesThe importance of internal controls and risk managementTips for effective financial storytelling and influenceHere are a few relevant quotes from the episode:“I created Newcastle Finance to bring big-league financial savvy to smaller businesses that want to scale sustainably.” - Kathy Svetina“For small businesses, strong internal controls are essential to protect against risk and ensure financial security.” - Kathy Svetina“Good accounting and FP&A systems help the business see trends and understand what’s generating revenue against expenses.” - Kathy SvetinaKathy shows how establishing solid foundations—like effective bookkeeping, robust internal controls, and meaningful financial analysis—can drive growth and stability. Emphasizing the value of communication and active listening, Kathy encourages FP&A professionals to think beyond reporting and embrace their role as strategic partners within the organization. Streamline Financial Planning with Kepion: Scale and automate your financial planning beyond spreadsheets with Kepion—trusted by top industries to automate, customize, and optimize complex planning. Learn more at https://bit.ly/3YI5cfpFollow FP&A Tomorrow:Newsletter - Subscribe on LinkedIn - https://www.linkedin.com/build-relation/newsletter-follow?entityUrn=6957679529595162624 Follow Kathy:Website - https://www.newcastlefinance.us/LinkedIn - https://www.linkedin.com/in/ksvetina/ 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/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:57] – Kathy Svetina's Background[03:58] – Defining Great FP&A[07:07] – Why Kathy Left Corporate Finance[09:57] – A Success Story in Financial Transformation[19:26] – The Five-Part Financial Framework[32:10] – FP&A's Role in Bridging Business Silos[43:06] – Key Skills for FP&A Professionals[49:34] – Personal Insights and Interests[54:06] – Parting Advice on FP&A Excellence

Nov 14, 202458 min

Ep 17Finance & Technology Trends from FATE Conference with Paul & Glenn

In this episode of the Future Finance Show, hosts Paul Barnhurst and Glenn Hopper dive into the convergence of finance, technology, and AI. They reflect on their experiences at the recent Finance and Technology Expo in New York, where they were both speakers. Covering themes from AI integration to the role of data in financial planning, they explore how these emerging trends are transforming the finance landscape.The episode features Paul Barnhurst, known for his expertise in FP&A (Financial Planning & Analysis), and Glenn Hopper, author and finance tech expert currently on a speaking tour for his new book, AI Mastery for Finance Professionals. They’re joined by guests from the Finance and Technology Expo, including Alex Brower, CEO of Qflow.AI, and Liran Edelist, co-founder of the FP&A Hub, who share insights on technological innovation in finance.In this episode, you will discover:Frameworks for choosing FP&A tools that match different organizational needsThe real impact of AI on finance jobs and practical uses of AITop Takeaways from the Finance and Technology Expo Why consolidated data is crucial for effective AI and planning applications The importance of having policies for AI integration to prevent misuse In this episode, Listeners are reminded that as powerful as AI and tech tools can be, their impact hinges on having the right infrastructure, skills, and a strong strategy for integration. The hosts offer actionable advice on navigating today’s finance tech landscape and preparing for tomorrow. Follow Alex:LinkedIn: https://www.linkedin.com/in/alexbrower/Follow Liran:LinkedIn: https://www.linkedin.com/in/drliranedelist/Join hosts Glenn and Paul as they unravel the complexities of AI in finance:Follow Glenn:LinkedIn: https://www.linkedin.com/in/gbhopperiiiAI Mastery for Finance Professionals: https://a.co/d/hOEegnRFollow 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:[02:44] - Paul’s Monologue: People, Process, and Technology[05:32] - The Future of Jobs in the AI Era[08:45] - Reflections on the Finance and Technology Expo[14:15] - Alex Brower on Choosing the Right Finance Tools[19:17] - Insights from Paul’s Presentation[26:47] - Glenn on Effective AI Strategy for Finance Teams[31:47] - Modernization and Data-Driven Decision Making[38:01] - Latest AI Innovations and Predictions for 2025[45:35] - Wrap-Up and Closing Remarks

Nov 13, 202446 min

Why Skills & Storytelling Matter More Than Degrees in Financial Modeling – Rachit Jain

In this insightful episode of Financial Modelers Corner, host Paul Barnhurst (aka The FP&A Guy) welcomes financial modeling expert Rachit Jain. They delve into the nuances of financial modeling, exploring the art of building accurate, reliable models and the importance of critical thinking and lifelong learning in finance. Rachit shares real-world horror stories from his early career, reflects on the challenges of predictive modeling, and emphasizes the human elements that make models truly effective.Rachit Jain is a seasoned financial modeler with extensive experience in finance, auditing, and quantitative modeling. Having worked with firms like Hewlett Packard and Deloitte, Rachit brings a wealth of knowledge on creating models that inform decision-making and avoid critical pitfalls. His expertise spans FP&A, data science, and quantitative finance, making him an authority on building dynamic, real-world financial models.Expect to Learn:How to build trust in financial models through transparency and sound designWhy critical thinking and communication skills are crucial in financial modelingRachit’s career journey and his transition from audit to financial modelingThe role of data science in enhancing financial modeling capabilitiesStrategies for applying financial modeling in personal decision-makingHere are a few quotes from Rachit Jain:"The first step in financial modeling is critical thinking – you need to know what you want to achieve before you start building.""In financial modeling, curiosity is everything. It’s what drives you to improve and learn beyond the basics.""Before starting in financial modeling, understand what part of FP&A suits your skills. Not everyone is a ‘numbers person,’ and that’s okay."In this episode, Rachit Jain highlights financial modeling as both an art and science, emphasizing the importance of accuracy, clarity, and storytelling. Rachit’s approach shows that great financial modeling goes beyond numbers; it requires curiosity, critical thinking, and a balance between simplicity and sophistication.Follow Rachit:LinkedIn - https://www.linkedin.com/in/jainrachit1008/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:15] - Introduction to the Episode and Guest[05:26] - Rachit’s Background and Career Path[09:00] - Advice for Transitioning to Financial Modeling[11:01] - Lifelong Learning in Finance[13:17] - Financial Modeling as a Way of Thinking[18:15] - Unique Applications of Financial Modeling[22:23] - Building Models for Decision Making Process[26:57] - The Intersection of Data Science and Financial Modeling[33:40] - Rapid-Fire Financial Modeling Preferences[38:53] - Closing Advice and Wrap Up

Nov 12, 202441 min

S1 Ep 33How Data Storytelling Can Transform Your FP&A Strategy with Brent Dykes

In this episode of FP&A Tomorrow, host Paul Barnhurst, the FP&A Guy, dives deep into the art of data storytelling with analytics expert Brent Dykes. With extensive experience in data visualization and analytics, Brent shares insights on how finance professionals can effectively communicate data insights. He emphasizes that data storytelling is more than visuals—it's about crafting a compelling narrative that bridges data and decision-making.Brent Dykes is the founder of Analytics Hero, a consultancy dedicated to data storytelling. He's also an author and educator with years of experience in data analytics, consulting, and data visualization. Brent wrote the book Effective Data Storytelling and has taught data visualization at the University of Utah. His work focuses on enhancing how organizations use data to inform strategy and decisions.Expect to Learn:The core components of data storytelling: data, narrative, and visuals.Why narrative is often the missing link in data-driven presentations.The role of empathy and audience understanding in effective communication.Practical steps for creating a data-driven culture within your organization.How human intuition complements data in decision-making processes.Here are a few relevant quotes from the episode:"The last mile of analytics is where data storytelling lives. That’s where insights turn into action." - Brent Dykes"It’s the combination of data, narrative, and visuals that makes a message stick and drives action." - Brent Dykes"If you just present a problem without recommendations, you're leaving too much on the table. A story includes a path forward." - Brent DykesBy explaining the science behind storytelling and offering practical advice, Brent Dykes underscores that empathy, clarity, and audience engagement are at the heart of effective data storytelling. FP&A professionals are encouraged to embrace this skill, not only to communicate data effectively but to foster a more data-driven culture in their organizations. Streamline Financial Planning with Kepion: Scale and automate your financial planning beyond spreadsheets with Kepion—trusted by top industries to automate, customize, and optimize complex planning. Learn more at https://bit.ly/3YI5cfpFollow FP&A Tomorrow:Newsletter - Subscribe on LinkedIn - https://www.linkedin.com/build-relation/newsletter-follow?entityUrn=6957679529595162624 Follow Brent:Website - https://www.analyticshero.com/LinkedIn - https://www.linkedin.com/in/brentdykes/Book - https://www.effectivedatastorytelling.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 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:37] - Introduction to the episode[02:44] - The Importance of Clarity in FP&A[09:02] - The Last Mile of Analytics[11:25] - Defining Data Storytelling[20:03] - Creating a Data-Driven Culture[25:22] - The Psychology Behind Storytelling[36:03] - Lessons Learned from Early Data Communication Mistakes[42:36] - Getting Started with Data Storytelling[52:13] - Closing Thoughts and Course Announcement

Nov 7, 202455 min

Ep 16Why Finance Teams Resist Change And How to Fix It with Joe Manganelli

In this episode, the hosts Paul Barnhurst (aka The FP&A Guy) and Glenn Hopper welcome Joe Manganelli, Chief Revenue Officer at Amalgam and founder of Calculate, a consultancy for financial solutions in startups. Joe shares his entrepreneurial journey, explaining how Amalgam evolved from a simple Excel macro into a powerful tool that integrates with platforms like QuickBooks, Xero, and Shopify. The discussion turns to the role of technology in finance, how companies can better utilize data, and why AI will reshape the landscape of finance teams. Joe also offers insights into AI's impact on investing, risk management, and the growing importance of adaptable, tech-enabled tools in finance.Expect to Learn:How Amalgam helps businesses automate data processes without complex implementationsKey challenges in transitioning from simple tools to robust financial platformsThe role of AI in finance and how to prepare for its ongoing integrationJoe’s approach to investing in AI-focused startups and risk mitigationPractical steps finance teams can take today to become more tech-enabledJoe’s insights highlighted how simplicity, adaptability, and technology-driven solutions are redefining finance functions, especially for startups and agile teams. Whether you’re in finance, tech, or an entrepreneurial role, Joe’s practical advice offers a roadmap for leveraging technology to maximize efficiency and data security in finance.Follow Joe:LinkedIn: https://www.linkedin.com/in/joemanganelli/Website: https://www.amalgam.me/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:56] – The creation and purpose of Amalgam[02:07] – Challenges in scaling a product for the finance market[03:44] – How fractional CFOs and in-house finance teams leverage Amalgam[05:46] – Thoughts on agnostic, supportive, and proactive AI investments[11:09] – How not storing data directly adds value and simplicity[18:51] – Joe’s three-part approach for finance teams preparing for AI[21:19] – Moving beyond chatbots to a seamless integration in daily workflows[28:12] – Fun segment – “Get to Know You”[32:47] – Closing remarks and final thoughts

Nov 6, 202433 min

Fractional CFO Insights on Financial Modeling and Business Turnaround with Carl Seidman

In this episode, Paul Barnhurst, host of Financial Modeler’s Corner, is joined by Carl Seidman, an experienced financial consultant and financial modeling expert. Together, they explore the intricacies of financial modeling, discuss the art and strategy of dynamic cash flow modeling, and touch on the unique challenges and lessons Carl has gathered from his years in turnaround consulting. They also discuss the broader skills and mindset shifts required for modelers who aim to excel in the complex field of financial analysis and corporate finance.Carl Seidman is the founder of Seidman Financial and a recognized expert in financial planning, forecasting, and modeling. With experience in turnaround consulting and as a fractional CFO, Carl has worked extensively with underperforming companies and complex restructuring cases. He brings an in-depth understanding of the strategic nuances in financial modeling and cash flow management, which he shares in this episode.Key takeaways from this week's episode include:The importance of long-term, flexible thinking in financial modeling and planning.Carl’s top lesson learned from a modeling “horror story” and how it shaped his approach to dynamic modeling.How dynamic arrays are transforming cash flow modeling and how to implement them.Why operational knowledge is crucial for effective financial modeling in turnaround situations.The value of networking and formal certifications in restructuring and financial advisory roles.Here are a few quotes from Carl Seidman:"Financial modeling in complex situations is about facilitating discussions, not just presenting numbers." "A good model tells you the ‘what,’ but the analysis and conversations that follow tell you the ‘so what’ and ‘now what.’""It's important to know when to push the boundaries of what a model can do and when to keep things simple."In this insightful episode, Carl Seidman leaves listeners with practical advice and a fresh perspective on financial modeling’s role in modern business. He highlights the value of flexibility, clear communication, and a long-term mindset, particularly in the complex terrain of turnaround consulting. Follow Carl:Website - https://seidmanfinancial.com/LinkedIn - http://linkedin.com/in/carlseidmanFollow 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:12] – Introduction to the episode and guest[05:44] – Key Lessons in Modeling and Long-Term Strategy[10:36] – From PwC to Turnaround Consulting[16:02] – Certified Insolvency and Restructuring Advisor (CIRA)[20:20] – Diagnosing Cash Flow Issues in Underperforming Companies[28:52] – Embracing Dynamic Arrays for Efficient Cash Flow Modeling[32:40] – Modeling Mindset: Curiosity and Continuous Improvement[37:57] – Rapid-Fire Q&A: Financial Modeling Preferences[41:59] – Advice for Aspiring Modelers: Practice and Experiment[43:30] – Closing Remarks and Where to Connect

Nov 5, 202446 min

S1 Ep 32Why FP&A Should Be Your Strategic Powerhouse, Not a Reporting Tool – Olivia MacDonald

In this episode, host Paul Barnhurst (aka The FP&A Guy) dives deep into the evolving world of Financial Planning & Analysis with Olivia MacDonald, a highly skilled financial professional with a diverse background in FP&A process optimization and system implementation. The conversation explores what makes FP&A great, focusing on business partnerships and the strategic role FP&A can play beyond just reporting numbers.Olivia is a qualified CPA and ACA with a proven track record of delivering strategic solutions that drive efficiency, accuracy, and transparency across organizations. With a mastery of data extraction and transformation tools like MQL, SQL, and SOQL, Olivia has helped companies streamline operations, enhance financial transparency, and drive decision-making through data. Her non-traditional path into FP&A—from audit to FP&A consultancy—gives her a unique perspective on how finance can be a business driver, not just a reporting function.Expect to LearnWhat distinguishes great FP&A teams, with a focus on strategic business partnering.How audit and FP&A share common skills, and how auditors can leverage financial modeling experience.The importance of building strong relationships as an FP&A professional and working with different business units.Olivia’s unique career journey from auditing in Ireland to working in FP&A and the key lessons learned.Strategies to streamline the budgeting process and engage business partners in decision-making.Here are a few relevant quotes from the episode:“FP&A shouldn’t just be a reporting function. It needs to be a strategic business partner that helps drive decision-making.” - Olivia MacDonald“Having mentors who can tell you, ‘That’s a bad idea,’ is invaluable. It’s how I ended up taking risks in my career that paid off.” - Olivia MacDonald“When I got into FP&A, I realized how important it is to be a business partner, not just a numbers person.”  - Olivia MacDonaldThis episode with Olivia MacDonald takes us through the evolving role of FP&A where she emphasizes the importance of involving business partners in the budgeting process, learning from mentors, and embracing technology, including generative AI.Follow FP&A Tomorrow:Newsletter - Subscribe on LinkedIn - https://www.linkedin.com/build-relation/newsletter-follow?entityUrn=6957679529595162624 Follow Olivia:LinkedIn - https://www.linkedin.com/in/oliviarosemacdonald/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[02:13] Introduction to the episode and guest[04:22] What Does Great FP&A Look Like? [06:21] Olivia’s Journey from Auditing to FP&A [09:31] Learning from Audit to Excel in FP&A [12:31] Transition to Canada and FP&A Consulting[22:09] Data Skills and the Future of FP&A [29:03] Tips for Selecting FP&A Tools  [38:54] A Blitz Approach to Budgeting [46:55] Using Generative AI in FP&A [55:49] Closing Thoughts & Advice

Oct 31, 202457 min

Ep 15Empowering Fractional CFOs with AI and Automation for Better Financial Solutions with Joe Manganelli

In this episode of Future Finance, hosts Paul Barnhurst (The FP&A Guy) and Glenn Hopper welcome guest Joe Manganelli. Joe shares his journey from creating a simple Excel macro to founding Amalgam, now an integrated platform for financial automation. With rich insights on AI in finance, entrepreneurship, and investments, Joe discusses the evolution of his company, modern finance's future, and why simplifying processes is often key to innovation.Joe Manganelli is the Chief Revenue Officer of Amalgam and founder of Calculate, a finance and accounting consultancy for startups. With a background in finance and accounting for emerging businesses, Joe has deep expertise in building practical tech solutions for finance teams. His current focus with Amalgam is making financial data easily accessible, automating workflows, and developing tools that streamline the finance function.In this episode, you will discover:How Amalgam helps finance teams by simplifying and centralizing financial data through Excel.The steps finance functions can take to prepare for AI integration and data automation.Insights into the challenges of scaling a tech product from a macro to a platform.Joe’s perspective on investing in AI technology and the importance of aligning with market needs.The practical future of AI in finance, from predictive analysis to process automation.In this episode, Joe Manganelli offers a wealth of insights into the intersection of finance, automation, and AI, underscoring the importance of simplifying financial workflows for greater efficiency. Joe’s perspective as both a founder and investor provides valuable guidance for anyone navigating the evolving landscape of finance and technology.Follow Joe:LinkedIn: https://www.linkedin.com/in/joemanganelli/Website: https://www.amalgam.me/Join hosts Glenn and Paul as they unravel the complexities of AI in finance:Follow Glenn:LinkedIn: https://www.linkedin.com/in/gbhopperiiiAI Mastery for Finance Professionals: https://a.co/d/h8cTGeRFollow 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:47] – Real Use Cases of Generative AI[09:14] – Introduction to guest Joe Manganelli[11:13] – Overcoming Challenges and Scaling the Product[13:51] – Joe’s Investment Philosophy in AI and Startups[19:36] – Amalgam’s Data Security and Efficiency Approach[28:05] – The ‘Walk Before You Run’ Strategy for AI in Finance[30:33] – The Proactive Potential of Generative AI in Finance[35:16] – Future of Predictive Financial Analysis with AI[38:01] – Fun Q&A segment with Joe[42:01] – Closing Remarks and Wrap Up

Oct 30, 202442 min

The Secrets to Automating Data Integration and Reporting in Excel With Mark Proctor

In this episode of Financial Modelers Corner, host Paul Barnhurst (aka The FP&A Guy) is joined by guest Mark Proctor. Together, they delve into the intricacies of financial modeling and data analysis, with a focus on building efficient models and leveraging automation in Excel. Mark shares his deep expertise on why structure is key, how to automate tedious tasks, and how Excel continues to evolve to meet the demands of modern financial professionals.Mark Proctor is a seasoned financial professional with a background in accounting and finance, an Excel MVP, and the founder of Excel Off the Grid, a platform dedicated to improving efficiency and effectiveness in Excel. With decades of experience, Mark's insights are invaluable for anyone looking to optimize their use of Excel for financial modeling and beyond. He has helped countless professionals streamline their work through better data structure and automation techniques.Key takeaways from this week's episode include:Key differences between financial modeling and data analysisImportance of automation in Excel and how tools like Power Query and Power Pivot can drastically improve efficiency.Why traditional tools like Vlookup aren’t ideal for modern data analysis and what functions you should be using instead.How to approach building models that are flexible and easy to use, even when multiple stakeholders are involved.Practical strategies for reducing manual processes and eliminating the need for repetitive tasks in Excel.Here are a few quotes from Mark Proctor:"Hard coding is the enemy of a flexible financial model. Once you start hard coding, you lose the ability to see what's really driving the model.""One of the key takeaways from bad models is that manual adjustments should always be documented and trackable.""Automation should be about freeing up your time to focus on high-value tasks, not just about making things faster."As Excel continues to evolve with powerful features like dynamic arrays and advanced automation, the tools discussed in this episode are essential for anyone looking to keep pace with the future of financial modeling. Mark’s emphasis on mastering the basics and thinking structurally will help you work faster and more effectively.Follow Mark:Website - https://exceloffthegrid.com/LinkedIn - https://www.linkedin.com/in/markstephenproctor/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:54] - Financial Modeling Horror Stories[04:55] - Lessons from Bad Models[06:28] - Mark's Career Journey and Background[12:59] - Data Analysis vs. Financial Modeling[19:17] - Excel as a Data Analysis Tool: Key Innovations[22:55] - Automation in Excel and Practical Tips[33:59] - The Importance of Mastering Excel Basics[44:19] - Wrap-Up and Closing Remarks

Oct 29, 202448 min

S1 Ep 31Budgeting Strategies for Business Leaders to Maximize Growth and Efficiency with Aaron Goss

In this episode of FP&A Tomorrow, host Paul Barnhurst (aka The FP&A Guy) engages in a deep discussion with guest Aaron Goss where they explore the intricacies of effective FP&A from the perspective of a company leader. The conversation provides insights into how budgeting and forecasting evolve when a company transitions from privately owned to being backed by private equity. Aaron Goss is a seasoned executive with a unique career path. Starting as a part-time sales employee, Aaron quickly rose to the position of Chief Revenue Officer before becoming president of Brothers Paving and Concrete. With a background in public administration, Aaron brings a fresh perspective to leadership in the construction industry, having steered his company from small-scale operations to large-scale growth under private equity backing.Expect to LearnHow Aaron Goss defines good FP&A and what makes an ideal business partner for a CEO.The differences between budgeting in a privately owned company versus one backed by private equity.Leadership strategies to improve collaboration between finance and operations teams.Insights into transitioning from sales to executive leadership, and how skills from different fields translate into success.How empathy and understanding the challenges of other departments lead to better leadership and company culture.Here are a few relevant quotes from the episode:"There’s often a natural conflict between the CEO's broad vision and the finance team’s need for detail, but it’s essential to balance those perspectives." - Aaron Goss"Being a partner in solutions, rather than just a reporter of data, is what makes FP&A truly effective." - Aaron Goss"A great leader is a great coach, communicator, and someone who can build trust across teams, regardless of their technical expertise." - Aaron GossThis conversation with Aaron Goss offers a wealth of insight into team collaboration, effective FP&A, and executive leadership. He emphasizes the need for empathy, clear communication, and balancing details with the broader company vision.Follow FP&A Tomorrow:Newsletter - Subscribe on LinkedIn - https://www.linkedin.com/build-relation/newsletter-follow?entityUrn=6957679529595162624 Follow Aaron:Email - [email protected] - https://www.linkedin.com/in/aaron-goss-a06b36b/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:25] - Introduction to the episode [03:06] - What is great FP&A to a CEO?[10:24] - Budgeting process in different ownership structures[17:10] - Leadership and finance collaboration[23:08] - The importance of understanding operations[28:04] - Sales and finance relationship dynamics[31:52] - Key skills for FP&A professionals[43:11] - Final thoughts on business partnering[47:20] - Wrap up and contact information

Oct 24, 202448 min

Ep 14AI Tools for Finance Professionals to Automate Reporting & Forecasting Today with Nicolas Boucher

In this episode, the hosts Paul Barnhurst (aka The FP&A Guy) and Glenn Hopper explore how artificial intelligence, particularly generative AI, is transforming the world of corporate finance. The conversation dives into the practical applications of AI in finance, the current trends shaping the industry, and the steps finance professionals can take to embrace these new technologies. Nicolas Boucher, founder of the AI Finance Club, shares his expertise on how AI is helping finance teams work faster and more efficiently, with real-life examples and insights from his vast experience. With over 15 years of experience at global companies like PwC and Thales, Nicolas has trained more than 5,000 professionals on the power of AI in finance and is on a mission to reach a million finance leaders.Expect to Learn:How generative AI can revolutionize corporate financePractical examples of how AI tools can improve productivity for finance professionals.The importance of becoming a "citizen developer" in the finance industryThe role of Python in automating financial processes and making data-driven predictions.The best practices for finance professionals to adopt AI and integrate it securely Whether you’re already experimenting with AI or just starting to explore its potential, this discussion highlights the tools and strategies that can drive efficiency and innovation in your finance team. By adopting AI and automation, finance professionals can stay competitive in a rapidly evolving landscape. Nicolas’ advice and experience provide a valuable roadmap for leveraging these technologies effectively.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:[00:04] - Introduction of Nicolas Boucher[01:46] - Nicolas’ AI Discovery Journey[03:47] - Using AI in Day-to-Day Business[08:03] - The Role of Python and Automation in Finance[15:05] - Exciting AI-Powered Software in Finance[20:11] - Democratizing Finance Through AI[25:31] - How Finance Professionals Can Stay Ahead in AI[30:12] - Random Question Segment[36:28] - Closing Thoughts and contact information

Oct 23, 202438 min

Next-Level Financial Modeling with AI and Automation for CFOs with Chase Wright

In this episode of Financial Modeler’s Corner, host Paul Barnhurst dives into the evolution of financial modeling with guest Chase Wright. The discussion focuses on modern financial modeling tools and workflows, particularly a new spreadsheet tool called Equals, and how it compares to Excel and Google Sheets. Wright shares his journey from a finance background to working at startups, where he developed innovative methods to streamline financial operations using cutting-edge tools.Chase Wright is a seasoned finance executive with a decade of experience across startups and tech companies like GitLab, Instabug, and Red Hat. Currently the Head of Finance and Data at Uniqode, Chase has a unique blend of corporate finance, data science, and business management expertise. He’s also an advisor to Cacheflow and a limited partner at FOG Ventures. With an engineering background and deep experience in finance, Chase brings a fresh perspective on the challenges and innovations in financial modeling.Key takeaways from this week's episode include:How Chase Wright’s career journey led him to innovate in financial modelingThe role of modern spreadsheet tools like Equals in finance and data teamsHow to use tools like Equals to automate reporting and financial analysisThe importance of balancing curiosity and necessity when developing career skillsThe pros and cons of traditional modeling tools like Excel and Google Sheets versus newer alternativesHere are a few quotes from Chase Wright:“Equals is a modern spreadsheet for data and finance teams, connecting directly to your data sources.” - Chase Wright“Financial models are incredibly helpful, but at the end of the day, it's the intuition behind the model that really matters.” - Chase Wright“Slack integration in Equals makes communicating insights across the company incredibly simple.” - Chase Wright“AI in Equals acts as a copilot, making things like summing columns or adding borders incredibly intuitive.” - Chase WrightIn this episode, Chase Wright shares his journey from struggling with complex models in Excel to embracing the automation and connectivity that Equals offers highlights the growing need for more intuitive and efficient financial tools. He emphasizes that the right tools, combined with critical thinking, can not only improve workflows but also provide deeper insights that drive business success.Follow Chase:Website - https://www.uniqode.com/LinkedIn - https://www.linkedin.com/in/chasewright/Blog - https://medium.com/uniqode-secret-sauce/an-operators-guide-for-managing-your-saas-startup-s-cash-flow-c1dbfc3a1e71Follow 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:45] – Introduction to Chase Wright and his journey[02:54] – The nightmare of VBA models and lessons[04:24] – Educational Path: Finance to Engineering[07:01] – Equals: The modern spreadsheet tool[15:13] – How Equals Simplifies Data Integration[20:02] – Financial modeling: Critical Thinking in Action[31:03] – Rapid Fire Segment: Excel and Equals [39:37] – Conclusion and Final Thoughts

Oct 22, 202441 min

S1 Ep 30Leadership Skills for FP&A Professionals to Improve Forecasting and Analysis with Brett Hampson

In this episode, Paul Barnhurst dives deep into practical frameworks and leadership strategies for finance professionals with guest Brett Hampson. Brett discusses what he believes constitutes great FP&A and how grassroots finance transformations, rather than top-down technology implementations, can foster a proactive, value-creating FP&A culture. Brett Hampson has spent over a decade in corporate FP&A, working with some of the world’s largest companies. He is the author of The FP&A Operating System, a book that outlines his approach to establishing a high-functioning FP&A department. Brett is also the founder of Forecasting Performance, a platform that promotes best practices in financial analysis and forecasting.Expect to LearnWhat grassroots finance transformation entails and why it’s preferable to technology-centric approaches.How to implement Brett’s FP&A Operating System and FP&A Flywheel framework to drive efficiency and value.The importance of setting a clear vision and objectives for FP&A teams to move from reactive to proactive operations.How to leverage attribution analysis and storytelling to enhance FP&A’s influence on business decisions.Tips on creating a culture of continuous improvement within FP&A by focusing on people, processes, and technology in that order.Here are a few relevant quotes from the episode:“Grassroots finance transformation happens when each person on the team has their own vision and works towards solving specific challenges.” - Brett Hampson“Technology alone doesn’t solve problems. It might fix one, but often creates new ones if cultural issues aren’t addressed first.” - Brett Hampson“Our greatest challenge in FP&A is often ourselves – we need to avoid being too introspective and focus on the business.” - Brett HampsonWith insights into creating effective FP&A systems and teams, Brett Hampson provides a refreshing perspective on FP&A transformation. He highlights the importance of people, process, and then technology, in that order, as the foundation for a high-performing FP&A team.Follow FP&A Tomorrow:Newsletter - Subscribe on LinkedIn - https://www.linkedin.com/build-relation/newsletter-follow?entityUrn=6957679529595162624 Follow Brett:Website - https://bretthampson.gumroad.com/l/proactiveLinkedIn - https://www.linkedin.com/in/brett-hampson/Newsletter - https://blog.forecastingperformance.com/subscribeFollow 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[02:12] - Brett’s Background and Introduction[05:17] - The Creation of The FP&A Operating System[08:04] - Developing a Proactive FP&A Culture[13:22] - Grassroots FP&A Transformation[16:32] - People and Process Before Technology[29:28] - Building the Right Team and Culture[35:11] - Establishing Efficient Processes with the FP&A Flywheel[39:52] - Case Study: Turning Around Forecast Accuracy[52:16] - Final Advice and Wrap-Up

Oct 17, 202454 min

Ep 13AI Investment Strategies for Retail Investors to Outperform the Market with Andrew Einhorn

In this episode of Future Finance, hosts Paul Barnhurst and Glenn Hopper delve into the world of AI-driven financial analysis with Andrew Einhorn. From anecdotes about early AI experiments to deep insights on leveraging data, Andrew shares how his platform helps investors move beyond opinions and make data-backed decisions. Andrew Einhorn is an entrepreneur and data scientist with over a decade of experience in creating technology companies. As the CEO and Co-Founder of Level Fields, Andrew's mission is to make sophisticated investment analysis accessible to everyday investors. His background spans epidemiology, regulatory science, and technology, with a focus on using data to simplify complex financial landscapes. He is passionate about solving problems and democratizing investment strategies.In this episode, you will discover:How AI can analyze real-time events to provide actionable investment insights for retail investorsThe role of data in replacing opinion-based decisions with factual, evidence-driven analysis Strategies for successfully integrating AI tools into financial decision-making processesInsights into the challenges and rewards of being a startup entrepreneur in the fintech spaceKey factors in building AI models specific to financial services and tailoring models to sector-specific needsThe conversation offers valuable perspectives on the transformative role AI plays in the financial industry today. Andrew’s insights emphasized the importance of moving past traditional investment analysis methods and adopting cutting-edge technology to unlock greater market opportunities.Follow Andrew:LinkedIn: https://www.linkedin.com/in/einhorn/Website: https://www.levelfields.ai/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:[02:09] – Why your company needs an AI strategy[09:59] – Navigating the pitfalls of early AI adoption[16:50] – Introducing Andrew Einhorn and Level Fields[18:01] – The entrepreneurial drive and startup challenges[24:02] – From epidemiology to AI in finance[33:14] – How level fields makes advanced investment analysis accessible[40:27] – Leveraging proprietary AI models in financial analysis[44:05] – Quick-fire personal questions with Andrew[47:12] – Closing remarks and wrap up

Oct 16, 202448 min

A Ground Breaking AI Generated Podcast on Financial Modeling with Paul Barnhurst

In this innovative episode, Paul Barnhurst experiments with Google’s AI tool, Notebook LM, and transforms previous guest interviews into an AI-generated episode. He explores the insights and best practices in financial modeling, as shared by veterans Scott Rostan, founder of Training the Street, and Ian Bennett, a PwC Australia leader with extensive experience in managing large modeling teams. By leveraging AI, this episode explores how technology can recreate meaningful conversations with industry leaders, providing an interactive look at best practices, common pitfalls, and the evolving landscape of financial modeling. Paul explores advanced technical skills and the human elements that are essential to successful financial modeling.Key takeaways from this week's episode include:Four essential key pillars for excelling in financial modelingStrategies for maintaining simplicity and auditability in financial modelsEmerging tools in Excel and functionality of traditional financial modelingHow financial modeling expertise goes beyond technical skills Insights on the potential future of financial modeling with AI advancements Quotes from the Episode:"Even in the world of complex finance, sometimes the simplest approach is the best approach." - Scott Rostan"It’s about seeing the big picture, understanding your client’s needs and using your modeling skills to craft a solution, not just a spreadsheet." - Ian Bennett"AI will get really good at those technical tasks, cleaning up data, maybe running some basic forecasts, but that just frees us humans up to focus on the stuff that requires creativity, critical thinking, and emotional intelligence." - AIIn this special AI-driven episode, Paul Barnhurst invites listeners to consider how the field of financial modeling is both grounded in foundational skills and evolving with new technologies. It’s about connecting with clients, asking the right questions, and using your skills to drive better business decisions.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:17] Introduction to the episode[03:57] Lessons from modeling mistakes[06:29] Four key pillars of financial modeling[08:51] Managing large-scale models[13:40] Excel’s power stack and future enhancements[15:14] Modeling standards and best practices[19:38] Excel’s longevity and AI’s role[22:44] The World of fractional FP&A [27:38] AI’s place in financial modeling[33:16] Wrap-up and invitation for feedback

Oct 15, 202435 min

S1 Ep 29How to Communicate Complex Financial Data Like a Pro with Soufyan Hamid

In this episode of FP&A Tomorrow, host Paul Barnhurst dives into the future of Financial Planning and Analysis (FP&A) with guest Soufyan Hamid. The discussion focuses on the evolving role of FP&A, from its traditional technical functions to a more business-focused and communicative role. Soufyan shares his journey and insights into improving presentation skills, communication, and becoming a valued business partner in the finance world.Soufyan Hamid has over 17 years of corporate experience in finance, starting in auditing and consulting with PwC before becoming a finance business partner. Today, he leads The Finance Circle, where he trains finance professionals on improving their storytelling and presentation skills, a key aspect often missing in FP&A. Soufyan is known for his Financial Storytelling Program and his popular LinkedIn presence, where he shares tips with over 75,000 followers.Expect to LearnWhy it's not just about numbers but adding strategic value to the business.How effective storytelling can turn data into impactful business insights.Soufyan’s transition from corporate finance to entrepreneurship.How to prepare messages that resonate and drive action.Overcoming the habit of over-detailing and shifting focus to clear communication.Here are a few relevant quotes from the episode:“Great FP&A today is about balancing technical skills with business partnering to add real value beyond the numbers.” - Soufyan Hamid“In finance, it’s not just about the analysis, it’s about what you do with it and how you communicate it to others.” - Soufyan Hamid“Storytelling in finance is essential because it helps non-financial people understand the business impact behind the numbers.” - Soufyan Hamid“You need to focus on what’s important to your audience, not just what you think is important in the data.” - Soufyan HamidThis episode underscores the power of clear, concise communication in transforming financial analysis into business value. Soufyan provides practical tips and frameworks, such as the "what, so what, now what" method, and shares actionable insights for FP&A professionals looking to make a greater impact.Follow FP&A Tomorrow:Newsletter - Subscribe on LinkedIn - https://www.linkedin.com/build-relation/newsletter-follow?entityUrn=6957679529595162624 Follow Soufyan:Website - www.thefinancecircle.comLinkedIn - https://www.linkedin.com/in/soufyanhamid/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:38] – Introduction to the episode[04:04] – What makes great FP&A today[05:30] – Key lessons from auditing[08:10] – A passion for finance business partnering[12:08] – Soufyan’s transition to entrepreneurship[18:59] – Discovering the power of storytelling[27:24] – The four-step framework for presentations[40:56] – Standard FP&A questions and insights[46:36] – Personal insights: hobbies and favorite book[52:18] – Closing and how to connect

Oct 10, 202453 min

How to Build Superior Financial Models for M&A With Patrick McMillan

In this episode of Financial Modelers Corner, host Paul Barnhurst dives deep into the world of Quality of Earnings (QofE) with expert guest Patrick McMillan, a seasoned CFO and transaction advisor. The conversation explores the intricacies of QofE, its importance in financial transactions, and the role it plays in assessing a company's financial health during mergers and acquisitions. Patrick shares real-world examples and insights into how financial professionals can use QofE to make informed decisions.Patrick McMillan is a fractional CFO and transaction advisor at Amplēo, a Utah-based firm specializing in providing executive support to growing companies. With over two decades of experience in guiding businesses through periods of growth and M&A transactions, Patrick is known for his expertise in Quality of Earnings analysis. He brings a dynamic and passionate approach to finance, blending technical skill with strong storytelling abilities to help businesses navigate complex financial landscapes.Key takeaways from this week's episode include:The role of Quality of Earnings (QofE) in mergers and acquisitions, and how it differs from an audit.How to differentiate between non-recurring and operating items when analyzing financial statements.The importance of normalizing earnings for better understanding of a company’s performance.Why soft skills like communication and storytelling are crucial in financial analysis.Insights into how personal finance modeling can improve your financial modeling skills.Here are a few quotes from Patrick McMillan:"Quality of earnings isn't just an audit; it shows you how and why a company is performing in a certain way." - Patrick McMillan"Understanding non-operating and non-recurring items is crucial to a quality of earnings report." - Patrick McMillan"Patience is the most important lesson I’ve learned in my career, especially in communication." - Patrick McMillan"Modeling your own personal finances is a great way to practice financial modeling skills." - Patrick McMillanWith actionable advice on financial modeling, transaction strategies, and lessons learned from his personal experiences, Patrick’s insights will resonate with professionals looking to sharpen their financial skills and improve decision-making in dynamic business environments.Follow Patrick:Website - https://ampleo.com/contact/LinkedIn - https://www.linkedin.com/in/patrickmcmillan/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 Patrick McMillan [04:25] - Worst Financial Model Story[07:30] - Quality of Earnings vs. Audits[09:30] - Identifying Non-Recurring vs. Operating Items[13:31] - Patrick’s Journey to Becoming the "QofE Guy"[17:57] - The technical understanding of QofE[24:51] - Patrick’s decision for MBA[29:56] - Importance of soft skills in QofE[35:20] - Rapid-Fire Financial Modeling Tips[38:44] - Personal Insights: Mountain Biking and Life Lessons

Oct 8, 202444 min

S1 Ep 28Essential Soft Skills for FP&A Analysts to Influence Decisions and Build Strong Relationships

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

Oct 3, 202438 min

Ep 12The Role of AI in Shaping the Future of Finance Automation and Innovation with Nicolas Boucher

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

Oct 2, 202448 min

The Future of Financial Modeling with AI Usability and Best Practices featuring Ruby Liu

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

Oct 1, 202451 min

S1 Ep 27Optimizing Cash Flow & Simplifying Financial Models with Brian Lanier

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

Sep 26, 202452 min

VBA, AI, and Excel - Paul Barnhurst’s Key Takeaways from 40 Episodes

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

Sep 24, 202432 min

S1 Ep 26Leadership, Strategy, and the Evolving CFO Role in Modern Finance with Jack McCullough

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

Sep 19, 202454 min

Ep 11The Future of AI in Business Mastering Effective Interaction and Resource Planning with Conor Grennan

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

Sep 19, 202443 min

The Power of Data Automation in Financial Models and Tools for Corporate Success with Paul Medici

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

Sep 17, 202447 min

S1 Ep 25Finance secrets for driving business success through FP&A with Jim Caltabiano

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

Sep 12, 202451 min

Quantrix Approach to Simplify Complex Financial Problems with Gilbert Hangartner

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

Sep 10, 202449 min

S1 Ep 24What Every FP&A Leader Must Know About Driving Change with Leslie Stuart

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

Sep 5, 202450 min

Ep 10Revolutionizing Finance through AI and Data Science with Gabriela Gutierrez

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

Sep 4, 202431 min

Discover the Power of Simplicity in Financial Modeling With Giles Male

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

Sep 3, 202448 min

S1 Ep 23AI, Technology & The Modern FP&A Mindset – Insights with Dr. Liran

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

Aug 29, 202446 min

Continuous Planning vs. Annual Budgets | Randy Brown’s Game-Changing FP&A Insights

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

Aug 27, 202452 min

S1 Ep 22Don’t Let Your Startup Fail – Essential Financial Tips For Entrepreneurs with Renato Villanueva.

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

Aug 22, 202449 min

Ep 9A Bold Prediction for the Future of Accounting in the AI Era By Tom Hood

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

Aug 21, 202437 min

E-Commerce Growth vs. Profit – Drew Fallon's Insights.

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

Aug 20, 202450 min

S1 Ep 21How to Become a Finance Athlete with Zach Rial

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.

Aug 15, 202447 min

The Art of Financial Modeling and Data Management with Adam Rakich

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

Aug 13, 202454 min

S1 Ep 20The Critical Role of FP&A in Today's Market with Ryan Sanders

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

Aug 8, 202452 min

Ep 8Why AI is a Game-Changer for Finance Professionals - Insights from Christian Martinez

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

Aug 7, 202442 min

Learn Best Practices with Excel and Google Sheets - David Benaim

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.

Aug 6, 202453 min

S1 Ep 19Strategic FP&A Moves That Transform Businesses With Josh Aharonoff

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.

Aug 1, 202453 min

Managing Complex Models with Structure with Christopher Reilly

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.

Jul 30, 202452 min

S1 Ep 18The Secret to Transforming FP&A into Business Strategy with Ron Monteiro

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. 

Jul 25, 202448 min

Ep 7Unlock Financial Success with AI With Jon Brewton

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.

Jul 24, 202449 min

Power Query Magic to Become a Financial Modeling Master with Ken Puls.

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.

Jul 23, 202449 min

S1 Ep 17Modernizing FP&A in 2024 With Ken Lane

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?

Jul 18, 202436 min

Quantrix vs. Excel - Financial Modeling with Lyndsey Weber

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

Jul 16, 202454 min

The Importance of Predicting and Influencing in FP&A with Carl Seidman

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

Jul 12, 202456 min

S1 Ep 16The Power of Partnerships in Finance With Andrew Jepson

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

Jul 11, 202454 min