The FP&A Guy Network

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 Fallon

In 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=7079020077076905984

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 the code “Podcast” to save 15% when you register.  

In today’s episode:

[01:10] - Introduction to the episode and guest Drew Fallon.

[04:44] - Drew’s background and E-commerce journey

[11:52] - Discussion on Drew’s passion for startups and its challenges and rewards

[17:04] - Key elements of financial modeling specific to e-commerce

[28:16] - Operational metrics and cost assumptions and how they affect overall financial health.

[35:06] - The advantages of using Iris in e-commerce financial modeling.

[41:53] - Quick insights into Drew's financial modeling preferences

[47:08] - Drew’s advice for aspiring financial modelers

[49:30] - Final thoughts and how to connect with Drew

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

In this episode of FP&A Tomorrow, host Paul Barnhurst dives into the evolving role of FP&A (Financial Planning & Analysis) within organizations. The discussion focuses on the shift towards a more strategic and operations-focused approach to finance, exploring how modern finance professionals can become indispensable business partners. The conversation also touches on the concept of a "finance athlete" and the importance of being versatile and adaptable in today's dynamic business environment.

This week’s guest is Zach Rial, the Senior Director of Finance and Strategy at Peak, a travel company based in Salt Lake City, Utah. With a background in finance, holding a bachelor's degree from Utah State and an MBA from the University of Utah, Zach brings a unique perspective to FP&A, blending operational insights with financial strategy. Known for his hands-on approach to finance, Zach shares his journey from operations to senior finance roles, emphasizing the importance of understanding the business from the ground up.

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

1. What defines great FP&A and why partnerships are crucial for financial success.
2. The concept of a "finance athlete" and how it applies to modern finance roles.
3. The importance of intellectual curiosity and its role in driving business insights.
4. How to manage tough conversations in the workplace with transparency and trust.
5. 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 Rial

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 below: https://bit.ly/4decOf3

Follow Zach:

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

Follow Paul:

Website - https://www.thefpandaguy.com 

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

Enroll 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:36] - Paul Barnhurst introduces the episode and the guest, Zach Rial.

[02:27] - Overview of Zach Rial’s background and his approach to FP&A.

[04:46] - Discussion about Zach’s unique path from operations to finance.

[11:05] - Explanation of the "finance athlete" concept and its significance.

[15:29] - Exploration of how modern CFOs are becoming more like CEOs, blending operations with finance.

[26:34] - The role of finance in RevOps and how these functions can collaborate effectively.

[34:37] - Zach shares his approach to handling difficult discussions in the workplace.

[39:26] - Quick insights into essential skills and the future of FP&A.

[42:52] - Personal insights into Zach’s hobbies, favorite books, and life philosophies.

[46:44] - Final thoughts and closing remarks from Paul Barnhurst.

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

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

In this episode, Paul Barnhurst delves into the intricate world of data integration, especially within financial modeling and FP&A. The discussion revolves around the practical challenges and solutions for accessing and automating data flows, a topic crucial for finance professionals who often grapple with multiple data sources and complex modeling tasks. The episode offers insights into the evolving landscape of data management tools and how they can streamline processes for businesses.

Adam Rakich, a seasoned expert in the world of FP&A tools and data integration, joins the show. With a diverse background spanning social media marketing software, FP&A consultancy, and leadership roles at companies like Workday and OneStream, Adam now focuses on making data integration more accessible through his work at Data Blend. His deep understanding of the challenges accountants and financial modelers face with data management makes him a valuable resource for listeners looking to optimize their processes.

Key takeaways from this week's episode include:

• The common pitfalls and solutions in financial modeling and data integration.
• When and why businesses should transition from spreadsheets to specialized planning tools.
• Practical strategies for automating data workflows, even when dealing with outdated or diverse systems.
• The importance of understanding APIs, SQL, and other technical aspects of data integration.
• How to build a business case for investing in data integration solutions.

Follow Adam:

• LinkedIn - https://www.linkedin.com/in/rakich/
• Click the link below to claim your free book (For a limited time only): The Business User’s Guide to Data Integration
• https://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=7079020077076905984

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 the code “Podcast” to save 15% when you register. 

In today’s episode:

[01:30] - Introduction and worst financial model experiences

[07:18] - Adam shares his career path from economist to data integration expert

[09:38] - Transitioning from spreadsheets to planning tools

[16:56] - The challenges of data integration

[26:01] - Hybrid approaches to data automation

[28:55] - Tools and strategies for freelancers and small businesses

[37:46] - Adam talks about his book and the key takeaways for readers.

[44:32] - Rapid fire questions on financial modeling tools and techniques.

[52:47] - Final thoughts and contact information

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

In this episode of FP&A Tomorrow, host Paul Barnhurst dives into the world of growth equity investing with Ryan Sanders, a seasoned investor from Mercato Partners. The conversation explores the critical role of FP&A (Financial Planning and Analysis) in supporting growth-stage companies, the nuances of growth equity investing, and how entrepreneurs can best position themselves for success. Ryan shares insights from his extensive experience, offering valuable lessons on what it takes to scale companies in today's competitive market.

Ryan Sanders is a growth investor at Mercato Partners, a growth equity firm based in Salt Lake City, Utah. With a background in finance and an MBA in entrepreneurship from the University of Texas, Ryan has a deep understanding of what it takes to support and scale innovative companies. His career spans various roles in investment, and he is known for his strategic approach to partnering with entrepreneurs. Ryan also recently completed the Kauffman Fellows program, which has further enriched his expertise in venture capital and growth investing.

Expect to Learn:

1. The key attributes and skills that FP&A professionals need to excel in supporting growth-stage companies.
2. The importance of customer-centric growth and why organic growth strategies often outperform inorganic ones.
3. Insights into the investment process at Mercato Partners and how they identify and support promising companies.
4. The role of AI in transforming FP&A functions and the broader finance industry.
5. 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 Sanders

In 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/4decOf3

Follow 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/thefpandaguy

Enroll 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 professionals should develop 

[24:48] - Strategic decision making and financial planning & how FP&A can support this process.

[35:20] - Kauffman Fellows Program Experience

[41:30] - The Impact of generative AI on finance

[51:10] - Conclusion and contact information about Ryan

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/Thefinancialfox

Blog: 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/gbhopperiii

Follow Paul:

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

Follow QFlow.AI:

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

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

In Today’s Episode:

[01:51] - Introduction and context setting for discussing the impact of AI on finance

[08:01] - Introduction to Christian Martinez, highlighting his unique expertise in finance, Python, and AI.

[09:12] - Christian’s newsletter and practical AI tools for finance professionals

[15:39] - The Power of dashboards in financial analysis

[25:05] - A discussion on the value of coding skills in finance

[29:38] - Python in Excel: A game changer

[37:51] - Getting personal: Christian’s hidden talents

[41:52] - Final remarks from Christian and closing thoughts

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

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

In this episode of Financial Modelers Corner, host Paul Barnhurst sits down with David Benaim, an Excel MVP and data consultant based in Cambodia. They delve into a comparative analysis of two of the most popular spreadsheet tools—Excel and Google Sheets. The discussion covers the strengths and weaknesses of each platform, providing listeners with insights into when and how to use these tools effectively in their financial modeling and data analysis work.

David Benaim is a chartered accountant and Excel MVP who has made a name for himself as an expert in both Excel and Google Sheets. Originally from the UK, David now runs a data consulting firm in Cambodia, where he specializes in Excel training and data solutions. With a deep passion for spreadsheets, David is uniquely positioned to discuss the nuances of both platforms, making this episode a must-listen for anyone looking to optimize their use of Excel or Google Sheets.

Key takeaways from this week's episode include:

• Key differences between Excel and Google Sheets, including tables, functions and data entry features.
• The strengths of Google Sheets in collaborative environments and its data validation capabilities.
• How to decide whether to use Excel or Google Sheets for different types of projects.
• Insights into the new table features in Google Sheets and how they compare to Excel’s tables.
• David’s tips on getting started with Google Sheets for those accustomed to Excel.

Follow David:

• Website - https://www.xlconsulting-asia.com/
• LinkedIn - https://www.linkedin.com/in/davebenaim/

 Follow Paul: 

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

Follow Financial Modeler's Corner  

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

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 the code “Podcast” to save 15% when you register.  

In today’s episode:

[01:21] - Introduction to the episode and guest David Benaim.

[03:52] - David shares his unique global background and career journey from Deloitte to founding his own firm in Cambodia.

[07:00] - Discussion about David’s transition from working at Deloitte to starting his own business in Cambodia and the challenges he faced.

[14:38] - In-depth comparison of functions unique to Google Sheets, like “COUNTUNIQUE”, “FLATTEN”, and others not found in Excel.

[23:35] - Criteria and scenarios where Google Sheets is the better tool, particularly in collaborative environments and data entry tasks.

[30:25] - A look at the newly implemented table features in Google Sheets and how they stack up against Excel’s tables.

[38:54] - David shares his decision-making process for choosing between Excel and Google Sheets based on project needs.

[43:56] - Quick-fire questions where David shares his preferences on various Excel and Google Sheets functionalities.

[49:31] - Tips and resources for users looking to improve their skills in Google Sheets.

[50:47] - Final thoughts and how to connect with David Benaim.

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

In this episode of FP&A Tomorrow, host Paul Barnhurst delves into the dynamic world of financial planning and analysis (FP&A). He is joined by Josh Aharonoff, an experienced finance professional who has navigated the complexities of FP&A, accounting, and entrepreneurship. The conversation offers insights into the current state of FP&A and its evolving future, with practical advice for both aspiring and seasoned finance professionals.

Josh Aharonoff is a seasoned finance expert with a background in accounting and a wealth of experience in both big four accounting and startups. After obtaining his CPA and working in global banking services, Josh ventured into entrepreneurship, co-founding a startup and later establishing his own firm, Mighty Digits, specializing in outsourced finance and accounting services. Josh is also a prominent figure on LinkedIn, with nearly 400,000 followers, and runs a popular daily newsletter and YouTube channel.

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

1. Understanding what makes financial planning and analysis effective and impactful.
2. Josh’s professional journey from big four accounting to entrepreneurship and becoming a fractional CFO.
3. Insights into the chaotic yet rewarding environment of early-stage companies.
4. Essential technical and soft skills needed to excel in financial planning and analysis.
5. 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 Aharonoff

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 below:

https://bit.ly/4decOf3

Follow 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/thefpandaguy

Enroll 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:38] Introduction to the show and welcoming the guest

[02:14] Josh shares his perspective on what constitutes great financial planning and analysis.

[02:44] Josh discusses his career journey, from big four accounting to starting his own firm.

[05:31] Josh explains why he enjoys working with startups and the unique challenges they present.

[06:54] Josh shares memorable experiences with clients, particularly with the company Chili Piper.

[09:25] Josh reflects on why big four accounting wasn’t the right fit for him and what he learned from the experience.

[15:51] Discussion on the biggest challenges of working with startups, including fundraising and constant evolution.

[21:48] Josh offers advice for those looking to start their own advisory services.

[26:05] Josh talks about his favorite aspects of working in FP&A.

[34:55] Josh shares his journey of growing a significant following on LinkedIn and being recognized as a top voice.

[40:12] Josh discusses his recent recognition by Microsoft and what it means to him.

[41:25] Quick insights into Josh’s technical and soft skills, favorite tools, and personal preferences.

[50:53] Information on how listeners can reach out to Josh and learn more about his offerings.

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

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

In this episode of the Financial Modelers Corner, host Paul Barnhurst delves into the intricate world of financial modeling with returning guest Christopher Reilly. The conversation centers around what is necessary to build robust financial models, highlighting the importance of three-statement models and cash flow forecasting. The episode is filled with practical insights, advanced techniques, and professional experiences that underscore the significance of simplicity, accuracy, and best practices in financial modeling.

Christopher Reilly is a seasoned financial modeler with extensive experience in consulting, private equity, and financial modeling education. Starting his career during the financial crisis, Christopher worked on high-profile bankruptcies such as Lehman Brothers and Rescap. His journey took him from a senior analyst role at Hilton Worldwide to middle-market private equity, and eventually to founding his own financial modeling education business. Today, he focuses on teaching and building financial models, with his work being featured by Wharton Online, Wall Street Prep, and LinkedIn Learning among others.

Key takeaways from this week's episode include:

• The importance of simplicity in financial models and how over-complicating can hinder their effectiveness.
• Practical steps and considerations for building robust three-statement financial models.
• Tips for auditing models to ensure accuracy and integrity.
• How to use advanced Excel functions and shortcuts to enhance modeling efficiency.
• Insights into the role of AI in financial modeling and how it may shape the future of the profession.

Follow Christopher:

• Website - https://www.financialmodelingeducation.com/
• LinkedIn - https://www.linkedin.com/in/chris-reilly-mission-capital/ 

 Follow Paul: 

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

Follow Financial Modeler's Corner  

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

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

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 the code “Podcast” to save 15% when you register.  

In today’s episode:

[01:11] - Paul introduces the episode and welcomes back Christopher Reilly.

[02:31] - Christopher shares a story about a complex healthcare deal model that required significant simplification.

[03:55] - Discussion on the importance of keeping models simple and useful.

[05:01] - Christopher talks about his career journey and experiences over the past year.

[08:31] - Christopher explains why he is passionate about teaching financial modeling.

[11:43] - Why every finance professional should understand how to build a three-statement model.

[14:20] - Steps to take when beginning to build a three-statement model.

[22:17] - Tips on structuring models vertically and building essential checks to ensure accuracy.

[28:07] - How to effectively use support schedules and detailed assumptions in modeling.

[32:36] - Essential tips for error checking, building support schedules, and maintaining model integrity.

[39:10] - Key Excel formulas and functions necessary for building financial models.

[46:58] - Discussion on the potential impact of AI on financial modeling and its future integration.

[49:53] - Final thoughts and details on Christopher Reilly’s courses and where to find them.

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

In this episode of FP&A Tomorrow, host Paul Barnhurst explores the evolving landscape of Financial Planning and Analysis (FP&A) with expert insights from Ron Monteiro. The discussion centers on the crucial role of FP&A in shaping business strategies, driving financial performance, and fostering cross-functional collaboration within organizations.

Ron Monteiro is a seasoned FP&A professional with extensive experience in the consumer goods industry. Having worked with major brands like Kraft Foods, Campbell Soup, and Kruger Products, Ron brings a wealth of knowledge in financial analysis, business partnership, and strategic decision-making. He now runs his own training business, helping finance teams worldwide enhance their skills and impact.

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

• The essential attributes of great FP&A and how it contributes to business success.
• Practical strategies for FP&A professionals to integrate themselves into business operations.
• The importance of building trust and cross-functional relationships in FP&A roles.
• Key operational metrics in the consumer goods industry and how to use them effectively.
• Tips for transitioning from accounting to FP&A and developing strong presentation skills.

Follow Ron:

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

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

Follow Paul:

Website - https://www.thefpandaguy.com 

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

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 below:

The FP&A Guy (thefpandaguy.com)

Wharton FP&A Certificate Program

FP&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 GLANCE

• Format: Self-Paced & Live Office Hours (8 hours/week) 
• Certificate: Issued by Wharton Online and Wall Street Prep
• Closing Ceremony in NYC (Attend Live or Virtually)

Enrollment is currently open for the September 2024 cohort. Please note that the program is limited and filled on a first-come, first-served basis.

In today's episode:

[01:36] - Paul Barnhurst introduces the podcast and welcomes Ron Monteiro to the show.

[02:17] -Ron shares some light-hearted and embarrassing stories about Paul.

[03:43] - Discussion on what makes FP&A great and its role in business involvement.

[04:35] -Ron talks about the importance of trust and getting involved with other business functions.

[05:26] - Ron shares his career journey from the University of Toronto to his current role in training.

[09:11] - Ron reflects on his time in the consumer goods industry and memorable product launches.

[11:38] - The critical operational metrics in consumer goods and their significance.

[14:40] - Challenges and advice for moving from accounting to an FP&A role.

[27:28] - Ron's journey from being terrified of presenting to becoming a confident presenter, with tips for others.

[33:23] - Why FP&A departments should invest in training and continuous learning.

[38:03] - Insight into Ron’s upcoming book and its focus on finding joy and passion in your career.

[41:01] - Quick answers on technical and soft skills, forecasting methods, and more.

[46:20] - Final tips on being better business partners and embracing a growth mindset.

[47:08] - Information on how listeners can reach out to Ron Monteiro. 

Future Finance: Unlocking the Power of AI for Finance Professionals With Jon Brewton

TLDR: Jon Brewton, the founder and CEO of Data2, talks about how his company uses AI and machine learning to help clients in make better decisions and avoid errors.

Each week we ask AI to generate our show notes and optimize them to get you interested in the story.  This week we used Microsoft CoPilot to write the shownotes.

This episode of Future Finance features Jon Brewton, the founder and CEO of Data2, a company that provides AI and machine learning solutions for finance and other industries. He discusses how his company helps clients use AI to analyze data and make better decisions, as well as the challenges and risks of using AI in high-stakes contexts.

Jon Brewton is an expert in AI and machine learning, with a rich background in operations management, digital transformation, and engineering. He has worked at major energy companies like BP and Chevron, and he is a US Air Force veteran and a graduate of some of the top universities in the world. He shares his insights and best practices on how to leverage AI and machine learning to enhance financial performance and outcomes, and how to avoid common pitfalls and errors that can arise from AI applications.

In this episode, you will learn:

· What Data2 does and what its goals and principles are in AI and machine learning.

· Why traceability and explainability are crucial for AI applications in high-stakes industries like finance.

· How Knowledge Graph technology can enhance financial data analysis and provide more context and meaning.

· What AI hallucinations are and how they can affect financial decision-making.

·  How to integrate advanced analytics and AI into your finance workflows and processes.

This episode is a must-listen for anyone who wants to learn how AI and machine learning can help them make smarter decisions. Listen to the episode now and discover how you can use these technologies to your advantage.

Follow Jon:

LinkedIn: https://www.linkedin.com/in/jon-brewton-datasquared/

Website: https://www.data2.ai/

Follow Glenn:

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

Follow Paul:

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

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

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.