The FP&A Guy Network

Welcome to the Financial Modeler's Corner (FMC), where we discuss the Art and Science of Financial Modeling with your host Paul Barnhurst.Financial Modeler's Corner is sponsored by the Financial Modeling Institute (FMI), the most respected accreditation in Financial Modeling globally.In today’s episode, Paul engages in a conversation with Stephen Aldridge, to discuss developing and implementing Financial Modeling standards and best practices, including insights from his work on the Financial Modelling Code. This conversation is packed with practical advice and fascinating anecdotes.Stephen, the founder of Numeritas, has over 20 years of experience in Financial Modeling. Stephen has worked with and for top firms like KPMG and Deloitte. With a background in engineering, sales, and corporate management, he offers a unique perspective on Financial Modeling standards and best practices.Key takeaways from this week's episode include:Standards in Financial Modeling ensure consistency and reliability in financial models. Having an agreed-upon approach within a firm allows for seamless transitions when different individuals work on the same model, promoting accuracy and ease of understanding.Financial modeling involves various acceptable methodologies, making consensus on best practices challenging. Flexible guidelines, like the Financial Modeling Code, help streamline processes and ensure consistency across different approaches.Prototyping in Financial Modeling bridges the gap between modelers and users by creating early mock-ups of input areas. This approach ensures the model meets user expectations and captures necessary inputs accurately, saving time and resources in the long run.Human factors, such as biases and assumptions, significantly impact financial modeling. Effective communication and understanding stakeholder interactions are crucial for creating accurate and practical models.In implementing Modeling Standards, Firms should adapt modeling standards to their specific needs with a focus on basic principles like avoiding hard coding and maintaining consistency to enhance model quality and reliability.Quotes:  Here are a few relevant quotes from the episode on financial analysis and modeling:“I suppose a few things within a firm, you probably want a house style, at least an agreed approach, so that if somebody else picks up the model, has to work on it or somebody leaves, then you've got continuity.”“Prototyping helps the user to see what they like to get. If they think, oh no, this isn't what I would imagine, what about these things then? You're getting all that out in the open before you start coding.”“It's very important to think about the human aspect of modeling and what goes around it as well, and the assumptions we make and the bias that can creep in and all these sorts of things.”“Keep the user at the center of everything you do, keep them at the center of your thinking, and that way you'll produce a model that's much easier to use, and likely to have a longer life.”Sign up for the Advanced Financial Modeler Accreditation Today and receive 15% off by using the special show code ‘Podcast’. Visit www.fminstitute.com/podcast and use code “Podcast” to save 15% when you register.Go to https://earmarkcpe.com, download the app, take the quiz and you can receive CPE credit. View and download the Financial Modeling Code at financial-modelling-code.ashx (icaew.com)Follow Stephen:LinkedIn -  https://www.linkedin.com/in/stephenaldridge/Website - https://numeritas.co.uk/ Follow Paul:Website - https://www.thefpandaguy.com  LinkedIn - https://www.linkedin.com/in/thefpandaguy  TikTok - https://www.tiktok.com/@thefpandaguy YouTube - https://www.youtube.com/@thefpaguy8376  Follow Financial Modeler's Corner  LinkedIn Page- https://www.linkedin.com/company/financial-modeler-s-corner/?viewAsMember=true  Newsletter- Subscribe on LinkedIn- https://www.linkedin.com/build-relation/newsletter-follow?entityUrn=7079020077076905984    In today’s episode:  (00:50) Introduction(01:40) Guest Introduction(01:45) Horrifying Financial Models(04:10) Approach to Financial Modeling(05:25) Guest's Background and Career Journey(08:20) Developing Modeling Standards(15:09) Divergent Views and Common Agreements(18:15) Best Practices and Lessons Learned(24:30) Importance of Prototyping(28:00) Most Enjoyable Modeling Project(30:30) Joking on Big Numbers(33:20) Rapid-Fire Question Round(44:20) Guest's Advice for Aspiring Financial Modelers(44:47) Guest's Contact Information

In today’s episode, Paul engages in an insightful interaction with Julian Castelli, for a discussion about the transformative role of FP&A and evolution from basic finance to a strategic role influencing business decisions and investor relations, highlighting his leadership experiences and the importance of core values.Julian is currently serving as a board director and board chair. With experience as a board director and operating partner many times over, Julian assists SaaS and Marketplace technology companies in areas like strategy, team development, growth execution, fundraising, executive coaching, and board governance. He began his career in investment banking at Goldman Sachs and later worked as a consultant at McKinsey & Company. Key takeaways from this week's episode include: :Here is a concise summary of the key points from the discussion:The competitive dynamics and funding needs of marketplace and SaaS (Software as a Service) businesses. SaaS businesses can be more capital efficient and have multiple successful players compared to winner-take-most marketplaces.The transformative power of adhering to and actively promoting company values, even in crisis, which can galvanize a team and reinforce commitment to the organization's mission and customer service.Growth-stage companies need sophisticated FP&A to meet investor expectations and aid decision-making. FP&A should influence a company's financial and strategic decisions, not just report on them.Promoting company values strengthens internal culture and aligns team actions with the organization's mission. Companies must evolve from managing daily finances to integrating broad strategic financial planning.How skills from varied roles like investment banking and consulting can enhance FP&A effectiveness. Exposure to various business aspects through FP&A provides a strong foundation for leadership roles.The discussion highlights the necessity of presenting financials in a way that aligns with investor expectations, which is often different from traditional accounting reports. The title sponsor for this week’s episode of FP&A Tomorrow is the Plan Buddies. Join Plan Buddies. Plan Buddies, where professionals meet excellence. This isn't just any community. It is a community run by and for planning professionals. At Plan Buddies we’re all about fostering connections, sharing knowledge, and providing mentorship among FP&A experts. Ready to elevate your career? Visit plan-buddies.com and become a member today. Here's a special treat. Use the promo code the FP&A Guy, that is TheFPandAGuy for an exclusive 25% discount on your first-year membership.Quotes:Here are a few relevant quotes from the episode about FP&A's transition from basic finance to a strategic role, the critical importance of financial planning and analysis, and the influence of leadership and core values in navigating business challenges."So without FP&A, you can't see what's ahead of you.""But if you present a P&L like that [Natural Account Line] to an investor, you might end the meeting right there.""Unfortunately, I'm kind of shocked that the ERPs out there make it so difficult to actually produce financial reporting the way the investors want.""FP&A is not just a luxury; it's essential as you scale and begin dealing with institutional investors."Follow Julian:LinkedIn - https://www.linkedin.com/in/juliancastelli1Follow Paul: Website - https://www.thefpandaguy.com LinkedIn - https://www.linkedin.com/in/thefpandaguyFor CPE credit please go to earmarkcpe.com, listen to the episode, download the app, and answer a few questions. For AFP FPAC certification answer the questions and contact Paul Barnhurst for further details.In today's episode:[01:16] Introduction[03:20] Guest’s background[05:50] How did previous experiences prepare Julian for FP&A expertise[08:35] Turning critical information into actionable reporting[11:05] How the value of FP&A goes beyond controller or bookkeeping[28:20] Guest’s view about the evolution of FP&A [30:22] Interesting facts and differences between SaaS and Marketplace[41:49] Guest’s career journey and previous experiences[48:27] Upcoming event promotion[49:56] Rapid-fire session[52:24] Guest’s personal insights.[55:27] Advice for being a better business partner [57:27] Conclusion

TLDR: These show notes were optimized using Claude AI Haiku and are designed to make you listen to the full episode. We even asked Haiku to provide a Haiku summarizing the show notes for your reading pleasure.Haiku:Finance takes new shape,AI-driven transformation,Shaping the future. Prepare to be captivated as hosts Paul Barnhurst and Glenn Hopper welcome Sasha Orloff, CEO of Puzzle, to uncover the technological advancements reshaping the world of finance and accounting. In this eye-opening episode, you'll discover:How generative AI is seamlessly integrating into everyday software, automating tasks and delivering data-driven insights.The rise of "AI agents" in 2024 - advanced systems designed to autonomously process complex problems and provide tailored solutions.Sasha's visionary project, Puzzle, modernizing accounting software with real-time, flexible financial data processing.The transformative potential of blockchain technology to enhance transparency and traceability of financial transactions.The future of finance reimagined through AI and predictive analytics, empowering more precise forecasting and strategic decision-making.Sasha shares his insightful perspective:"I'm building Puzzle, which is modern accounting software for growing companies.""We may not yet be at a point where AI is going to take our jobs, but the future will be divided into two camps: people who use AI and those who don't. One of these groups is going to be left behind."Don't miss this captivating conversation that explores the intersection of finance, technology, and AI. Gain invaluable insights to stay ahead of the curve and thrive in the rapidly evolving world of corporate finance.Follow the Conversation:Glenn Hopper (LinkedIn: https://www.linkedin.com/in/gbhopperiii)Paul Barnhurst (LinkedIn: https://www.linkedin.com/in/thefpandaguy)Sasha Orloff (LinkedIn: https://www.linkedin.com/in/saor/)Puzzle (LinkedIn: https://www.linkedin.com/company/puzzlefin, Website: https://puzzle.io)Future Finance is sponsored by QFlow.ai, the strategic finance platform solving the toughest part of planning and analysis: B2B revenue. Align sales, marketing, and finance, speed up decision-making, and lock in accountability with QFlow.ai. Learn more at Qflow.ai/future-finance In today's episode:[01:53] Introduction[03:34] The latest phase of AI revolution[04:51] Pros and cons of chatbots and the rise and evolution of AI agents[09:17] Recent updates about AI[13:52] Guest’s background[15:30] Insights from guest’s career[17:51] Introduction of Puzzle and future of general ledger in accounting[25:12] How blockchain can be an effective tool for accounting[30:24] How AI and predictive analytics can change finance in upcoming years[34:34] Democratization of data science and various uses of machine learning[39:05] Lighting Round Questions!

New show coming soon...

Welcome to FP&A Tomorrow, where we discuss financial planning and analysis, examining its current state and future prospects, with your host Paul Barnhurst.The title sponsor for this week’s episode of FP&A Tomorrow is the Third Generation FP&A Tools Showcase. Join the Showcase and see the latest technology in FP&A planning software. Register for free today at https://www.accelevents.com/e/fpatoolsshowcaseIn today’s episode, Paul Barnhurst engages Trevor Anthony, for a fascinating discussion on the evolution of financial planning and analysis (FP&A) and how artificial intelligence (AI) is shaping its future.Trevor, a seasoned Chief of Staff at FranConnect, excels in transforming FP&A roles into powerful business partnerships that drive organizational success. With a rich background in private equity-backed software companies, Trevor is known for his expertise in creating simple and impactful financial models, he simplifies complex financial data into actionable intelligence.Key takeaways from this week's episode include: :Here is a concise summary of the key points from the discussion:How AI could significantly reduce costs and streamline operational processes, positioning FP&A to be more efficient and strategically integral to businesses.The importance of mastering the skill of creating clean and straightforward financial models for FP&A professionals. By prioritizing simplicity and clarity, these models become crucial tools for delivering precise financial data for business insights.The value of experience, mentorship, and strategic thinking in the evolution of FP&A professionals. It stresses how these elements help transition from traditional analytical roles to more influential positions. How private equity (PE) impacts FP&A operations, setting high expectations for teams to act as the definitive source of truth within companies.The discussion highlights how PE firms demand thorough, detailed financial reporting and forecasts, reflecting their reliance on FP&A teams to provide thorough insights and accurate analysis to guide investment decisions and business strategies.The discussion also highlights the anticipation of a future where AI not only supports but enhances the FP&A functions across various industries.Quotes:Here are a few relevant quotes from the episode about the strategic thinking around technology investment, the value of networking, the importance of responsiveness in professional settings, and the encouragement for community engagement:"The best FP&A groups, I've seen, have solidified themselves as a mission-critical function, not just to check the box type of group.""First and foremost, keep it simple. I think in the sales process, they demo flashy things... focus on what the tool does.""The beginning of what I'd call a business partnering relationship was when I'd sit down with the business owner and have to intimately understand their business and their financials."“Dealing with ambiguity, especially when you're working with senior leaders, they constantly vaguely describe things. You, as a professional, need to understand what that means.”“If you're like a traditional corporate FP&A person or you're just a data analyst, find those opportunities."Follow Trevor:LinkedIn - https://www.linkedin.com/in/trevoranthonyWebsite - https://www.franconnect.comFollow Paul: Website - https://www.thefpandaguy.com LinkedIn - https://www.linkedin.com/in/thefpandaguyFor CPE credit please go to earmarkcpe.com, listen to the episode, download the app, and answer a few questions. For AFP FPAC certification answer the questions and contact Paul Barnhurst for further details.

Welcome to the Financial Modeler's Corner (FMC), where we discuss the art and science of financial modeling with your host Paul Barnhurst.Financial Modeler's Corner is sponsored by the Financial Modeling Institute (FMI), the most respected accreditation in Financial Modeling globally.In today’s episode, Paul engages in an interaction with Carolina Lago and discusses the essential tips for transforming data into actionable insights and the strategic approach to avoiding common modeling pitfalls. This discussion offers valuable wisdom that will enhance your analytical skills and financial acumen.Carolina, a seasoned FP&A professional with over 15 years of international experience, shares profound insights from her extensive career, including her role in a significant IPO and leading software implementation across global departments.Key takeaways from this week's episode include:An early career encounter with a poorly designed financial model, filled with hard-coded numbers, underscores the necessity for creating flexible and dynamic financial models that can adapt to changing business needs.The discussion highlights the critical need to avoid hardcoded data and external links in financial models, which can lead to rigidity and errors.Insights from the financial modeling newsletter and courses show a wide range of professionals benefiting, from newcomers to seasoned directors. This variety demonstrates the widespread need for improved modeling skills.The discussion focuses on the importance of transforming data into actionable insights. It's stressed that without the ability to analyze and interpret data effectively, its value is minimal.The conversation sheds light on techniques for deriving actionable insights from complex data, crucial for any financial modeler. It also discusses the value of formal certifications like the Advanced Financial Modeler Certification as tools for professional development and skill validation.Quotes:  Here are a few relevant quotes from the episode on financial analysis and modeling:“I inherited one, and I had to try to change it. I spent probably a couple of weeks trying to make it better, and I couldn't. It was just too full of hardcoded numbers and I had to find everything the way around and no design at all.”“The first thing I learned about financial modeling was not to use hard codes and don't link outside of the spreadsheet.”“Data is only useful if it can be transformed into actionable insights.”“The TACTIC is (Targets, Assets, Calculations, Tools, Insights, and Correlations.) You start with the target which is the question that you need to answer with that financial model.” “That's why I like financial modeling so much because it can transform data into something. So you can make decisions on top of that data.”Sign up for the Advanced Financial Modeler Accreditation or FMI Fundamentals Today and receive 15% off by using the special show code ‘Podcast’. Visit www.fminstitute.com/podcast and use code Podcast to save 15% when you register.  Go to https://earmarkcpe.com, download the app, take the quiz and you can receive CPE credit. Follow Carolina:LinkedIn - https://www.linkedin.com/in/s-carolinalagoWebsite - https://www.tacticfinancial.comFollow Paul:Website - https://www.thefpandaguy.com  LinkedIn - https://www.linkedin.com/in/thefpandaguy  TikTok - https://www.tiktok.com/@thefpandaguy  YouTube - https://www.youtube.com/@thefpaguy8376  Follow Financial Modeler's Corner  LinkedIn Page- https://www.linkedin.com/company/financial-modeler-s-corner/?viewAsMember=true  Newsletter - Subscribe on LinkedIn- https://www.linkedin.com/build-relation/newsletter-follow?entityUrn=7079020077076905984    In today’s episode:  (00:04) Introduction(00:50) Guest Introduction(01:00) Horrifying Financial Models(02:00) Insights from Guest’s Early Career Challenges(03:10) Guest’s Career Journey and Global Experience(05:00) Turning Data into Actionable Insights(07:30) Introduction of the Tactic Framework(09:50) Audience Engagement and Learning Opportunities(20:00) Certification and Continuing Education(22:40) Rapid-Fire Round(24:50) Advice for Aspiring Financial Modelers(26:00) Contact information to learn more about various modeling techniques and tools.

Welcome to FP&A Tomorrow, where we discuss financial planning and analysis, examining its current state and future prospects, with your host Paul Barnhurst. The title sponsor for this week’s episode of FP&A Tomorrow is Wharton Online, one of the world's leading business schools. The gateway to mastering financial planning and analysis through a rigorous, comprehensive curriculum crafted by industry experts is only a click away- https://wallstreetprep.wharton.upenn.eduIn today’s episode, Paul Barnhurst engages Christian Wattig on the journey into the evolving world of financial planning and analysis.Christian Wattig, a seasoned FP&A professional and educator. As the program director for the Wharton Online and Wall Street Prep FP&A Certificate, Christian brings a wealth of experience and innovative strategies to the table. He shares how AI and technology are transforming the field.Key takeaways from this week's episode include: :Here is a concise summary of the key points from the discussion:How excellent FP&A practice hinges on making solid business recommendations from detailed analysis and storytelling, emphasizing the importance of implementing and monitoring these recommendations for impactful outcomes.The discussion is on how AI and new planning tools are revolutionizing FP&A by streamlining data collection and reporting, thus allowing analysts to concentrate more on strategic analysis and business partnerships.Insights into a career that transitioned from major corporations to spearheading an FP&A education venture, sharing valuable lessons from varied professional experiences.Introduction to a new certificate program that merges technical FP&A skills with interpersonal development, designed to equip professionals with comprehensive financial planning and analysis expertise.The discussion highlights the importance of digging beyond the surface of financial data to find actionable insights and the art of crafting these insights into stories that drive strategic business decisions.The reflection on the personal gratification from teaching and mentoring in FP&A, and anticipation of the future developments in the field as technology and analytical methods advance.Quotes:Here are a few relevant quotes from the episode about FP&A skills and making concrete, impactful business recommendations:"FP&A is at its best when you make a concrete recommendation that helps the business move forward.""With AI and not just with AI, but also with FP&A and planning tools and software, it will be possible that you don't have to pull data from lots of different sources.""When you're just taking people and walking them step by step through how I build a financial model from scratch, it's a different way of teaching."“Give them those metrics, those insights, or you can get them something that gets them at least halfway there. By doing that, you can demonstrate that you want to do more than just cutting budgets and updating forecasts.”Follow Christian:LinkedIn - https://www.linkedin.com/in/christian-wattig/Website - https://wallstreetprep.wharton.upenn.edu/ Follow Paul: Website - https://www.thefpandaguy.com LinkedIn -https://www.linkedin.com/in/thefpandaguyFor CPE credit please go to earmarkcpe.com, listen to the episode, download the app, and answer a few questions.  For AFP FPAC certification answer the questions and contact Paul Barnhurst for further details.

Welcome to FP&A Tomorrow, where we discuss financial planning and analysis, examining its current state and future prospects, with your host Paul Barnhurst. The title sponsor for this week’s episode of FP&A Tomorrow is Abacum, the leading mid-market FP&A solution trusted by hundreds of companies to eliminate the spreadsheet struggle. https://www.abacum.ioIn today’s episode with Tom Schultz, Paul had an insightful conversation about the evolving landscape of financial planning and analysis (FP&A) and its implications for fractional CFOs.Tom Schultz, founder and CFO of NextGen CFO, sheds light on the crucial skills behind successful financial analysis and the evolving role of technology in finance. From his extensive experience, Tom shares invaluable insights into transitioning from traditional FP&A roles to becoming a sought-after fractional CFO.Key takeaways from this week's episode include: :Here is a concise summary of the key points from the discussion:Professionals in financial planning and analysis are tasked with translating real-world events into financial data, forecasting, and modeling these numbers to plan for future outcomes strategically.The discussion concerns how advancements like AI and prebuilt dashboards might impact the depth of learning traditionally required in FP&A roles. Integrating new technologies poses challenges and opportunities for professionals in the field.The evolution of a career in finance, emphasizing the shift towards providing strategic fractional CFO consultancy.With the increasing demand for fractional CFOs, there's a spotlight on the advantageous position of FP&A professionals looking to transition into these roles.The intent is to offer a comprehensive resource for those interested in the niche, inspired by numerous informal mentorship interactions.The strategic adoption of technology in financial practices, highlighting the importance of aligning technology use with client needs and exploring the capabilities of generative AI to streamline writing and documentation processes in finance.Quotes:Here are a few relevant quotes from the episode about FP&A and CFO insights:"A great FP&A person in my mind is someone who knows what's behind the numbers.""It's more in private companies that are slow to hire a professional CFO. I think if you're out there fundraising and I've seen pre-revenue hire a fractional CFO just because they need navigation for investors.""The young people coming into this profession, I'm concerned that they'll take that stuff for granted and learn down to the root that we learned.""If you look at the CFO in the finance department, the controller and everyone below them tend to look backward in history. The CFO tends to look forward, so the FP&A person is more forward-looking than anyone else in the finance department."Join Plan BuddiesPlan Buddies, where professionals meet excellence. This isn't just any community. It is a community run by and for planning professionals. At Plan Buddies were all about fostering connections, sharing knowledge, and providing mentorship among FP&A experts. Ready to elevate your career? Visit plan-buddies.com and become a member today. Here's a special treat. Use the promo code "TheFPandAGuy", that is the FP&A Guy for an exclusive 25% discount on your first-year membership. Follow Tom:  LinkedIn - https://www.linkedin.com/in/tom-schultz-5926815Website - https://www.nextgencfo.com Follow Paul: Website - https://www.thefpandaguy.com LinkedIn - https://www.linkedin.com/in/thefpandaguyFor CPE credit please go to earmarkcpe.com, listen to the episode, download the app, and answer a few questions.  For AFP FPAC certification answer the questions and contact Paul Barnhurst for further details. 

Welcome to FP&A Tomorrow, where we discuss financial planning and analysis, examining its current state and future prospects, with your host Paul Barnhurst.The title sponsor for this week’s episode of FP&A Tomorrow is Abacum, the leading mid-market FP&A solution trusted by hundreds of companies to eliminate the spreadsheet struggle. https://www.abacum.ioIn today’s episode, Paul sits down with Jon Laudie, to discuss integrating FP&A into strategic planning and decision-making across businesses.With Jon Laudie, CFO at Zerorez, plunge into Financial Planning & Analysis (FP&A) and learn from Jon's rich experience and strategic insights. From his initial roles in investment banking to his current position as CFO, Jon shares his valuable lessons.Key takeaways from this week's episode include:Here is a concise summary of the key points from the discussion:The transition challenges and learnings involved in moving to a CFO position, including dealing with complex financial operations and integrating multiple acquisitions.FP&A functions are evolving to become more aligned with strategic finance, significantly enhancing their impact on business decision-making.Emerging technologies are streamlining FP&A processes, making them more efficient and reducing reliance on manual tasks.Strategies for FP&A professionals to become more strategic and operationally focused are discussed, including building relationships outside of finance and understanding the broader business context.Quotes:Here are a few relevant quotes from the episode about FP&A and CFO insights:“I think great FP&A in my mind is a function that is deeply integrated into the strategic planning and the decision-making of any organization.”“We still come across things that surprise us, like, 'Oh, we didn't realize how this is or this contract existed.”Follow Jon: LinkedIn - https://www.linkedin.com/in/jonlaudieWebsite - https://www.zerorez.com Follow Paul: Website - https://www.thefpandaguy.com LinkedIn - https://www.linkedin.com/in/thefpandaguyFor CPE credit please go to earmarkcpe.com, listen to the episode, download the app, and answer a few questions. For AFP FPAC certification answer the questions and contact Paul Barnhurst for further details. 

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. https://www.abacum.ioIn today’s episode, Paul engages in a conversation with Geoff Robinson, to discuss the financial modeling world, blending technical skills with behavioral economics to enhance decision-making in finance.Geoff Robinson, founder of TheInvestmentAnalyst.com and seasoned financial modeler with a rich background in investment banking and education, notably as a former managing director at UBS.Key takeaways from this week's episode include:An unconventional entry into investment banking at 43, highlighting how the background in education enriches the approach to financial analysis and modeling, emphasizing the crossover skills between teaching and financial analysis. This highlights how teaching skills are transferable and beneficial in the financial analysis and modeling sectors.An anecdote about a significant error in a financial model, which failed to detect a $29 billion discrepancy, underscoring the critical importance of rigorous validation and diagnostic checks in financial modeling.In the role of behavioral factors in financial modeling, adopting a stance of professional skepticism and the need for understanding and questioning the assumptions underlying a model before trusting its output.For simplicity and planning in financial modeling, the most effective models are those that are straightforward, well-planned, and can communicate complex financial insights in an accessible manner.Strategies for mitigating bias, such as incorporating different perspectives and rigorous testing of hypotheses, as the influence of cognitive biases on financial modeling to enhance the reliability of financial models.Quotes:Here are a few relevant quotes from the episode on financial analysis and modeling:"The diagnostic on this model was said if total assets equal total liabilities and equity, okay. So no matter what happened, your balance sheet, even if it was mashed up, the diagnostics said it was fine and when you went into the detail, there was a $29 billion hole in that balance sheet.""Financial models are a real kind of insight and window into the personality of the modeler. You can see how they think, you can see how they overcomplicate things. You can see if they're sloppy."“Models are question-asking tools. One of your questions was is it a primary decision maker, a financial model? I don't think models are decision-makers. I think models are the way you test a hypothesis.”"I suppose the blunt thing to say is don't trust anything until you understand it."Follow Geoff:LinkedIn - https://www.linkedin.com/in/geofftheinvestmentanalystWebsite - https://theinvestmentanalyst.comFollow Paul:Website - https://www.thefpandaguy.com LinkedIn - https://www.linkedin.com/in/thefpandaguyFor an experienced-based approach to financial modeling, emphasizing skepticism, the effective communication of complex financial data, and the intersection of analytical rigor, educational techniques, and behavioral economics, visit FMI at www.fminstitute.com/podcast and use code ‘Podcast’ to save 15% when you register. Contact Paul Barnhurst for further details.In today’s episode:(01:58) Introduction(02:44) Guest Introduction(03:00) Horrifying Financial Models(04:01) Joking on Big Numbers(04:24) Approach to Financial Modeling(05:14) Behavioral Insights in Modeling(05:56) Best Practices and Lessons Learned(42:40) Rapid-Fire Question Round(47.09) Guest's advice for aspiring financial modelers(47.38) Contact information to learn more about various modeling techniques and tools

Welcome to FP&A Tomorrow, where we discuss financial planning and analysis, examining its current state and future prospects, with your host Paul Barnhurst. The title sponsor for this week’s episode of FP&A Tomorrow is Abacum, the leading mid-market FP&A solution trusted by hundreds of companies to eliminate the spreadsheet struggle. https://www.abacum.ioIn today’s episode, Paul engages in a conversation with Richard Tame, to discuss the essential elements that define excellent financial planning and analysis.Richard, CFO of Coeus Institute, with over 25-plus years of experience in finance across various sectors, including his significant role at Aurora, brings a wealth of knowledge and a unique perspective to the evolving landscape of FP&A.Key takeaways from this week's episode include: :Here is a concise summary of the key points from the discussion:FP&A is rooted in having the right team. The focus is on hiring the right people with the necessary skills and ensuring they work well together.FP&A teams are not just about number crunching, they should also influence business decisions. The ability of FP&A to be involved in strategic discussions varies by company culture, from being central to decision-making to being viewed as a back-office function.FP&A professionals adapt their strategies to fit the culture of the company, whether it's a traditional corporation or a fast-paced tech startup.It is important to prepare an organization structurally and financially for potential public offerings or other major corporate transitions.Quotes:Here are a few relevant quotes from the episode about FP&A mastery:"I've been in companies whereby finance has a really strong seat at the table and you know, you can't blow your nose unless finance is holding the handkerchief. Then I've been in companies where finance is seen as an inconvenience at best.""You have to make the relationships not about you. You're there to partner with the business, and invariably the business knows more about the business. You need to have a relationship such that you can influence them. You're serving them."We had built the company in a way that we would have expected to go public at some point, and one of the things that I'd seen at Lyft, for example, I joined Lyft the day after the IPO, and it became clear that perhaps they hadn't built the infrastructure in the way that they could of to make life easier and that was very messy."Follow Richard:  LinkedIn - https://www.linkedin.com/in/richardtameWebsite - https://coeus.institute Follow Paul: Website - https://www.thefpandaguy.com LinkedIn - https://www.linkedin.com/in/thefpandaguyFor CPE credit please go to earmarkcpe.com, listen to the episode, download the app, and answer a few questions.  For AFP FPAC certification answer the questions and contact Paul Barnhurst for further details. 

Welcome to FP&A Tomorrow, where we discuss financial planning and analysis, examining its current state and future prospects, with your host Paul Barnhurst. The title sponsor for this week’s episode of FP&A Tomorrow is Abacum, the leading mid-market FP&A solution trusted by hundreds of companies to eliminate the spreadsheet struggle. https://www.abacum.ioIn 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 and product working together effectively:"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.""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."“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."Follow Carl: LinkedIn - https://www.linkedin.com/in/carlseidmanWebsite - https://seidmanfinancial.comFollow Paul:Website - https://www.thefpandaguy.comLinkedIn - https://www.linkedin.com/in/thefpandaguyFor CPE credit please go to earmarkcpe.com, listen to the episode, download the app, and answer a few questions. For AFP FPAC certification answer the questions and contact Paul Barnhurst for further details.

Welcome to the Financial Modeler's Corner (FMC), where we discuss the art and science of financial modeling with your host Paul Barnhurst. Financial Modeler's Corner is sponsored by the Financial Modeling Institute (FMI), the most respected accreditation in Financial Modeling globally.In today’s episode, Paul engages in a conversation with Scott Rostan, Founder of Training The Street.Scott found his passion for finance with his dedication to teaching and has been driving innovation in financial training ever since. As CEO of Training The Street and as an adjunct professor at UNC Kenan-Flagler Business School, he inspires the next generation of finance professionalsThrough his leadership as CEO of Training The Street, Scott has reshaped the landscape of financial education, equipping individuals with the skills and knowledge needed to thrive.In this episode, expect to learn:The significance of technical skills, such as financial modeling, accounting, and Excel proficiency, in the finance industryHow specialized training programs can help individuals enhance their financial knowledge and technical abilitiesThe evolving role of AI in finance and how it complements human expertise rather than replacing itThe balance between technical proficiency and interpersonal skills to excel in their careersHow individuals can build trust with clients, colleagues, and stakeholders, ultimately contributing to the integrity and credibility of the finance profession.Quotes:  “It's really easy to start throwing stuff together and writing a nasty old nested if formula or whatever it might be, but that doesn't always mean it's clean or effective or meets those requirements we talk about.”“And when you get good with the prompt engineering typing, questions, and answers, you can get a lot more productive and faster.”“It's not ideal because circular references can make your model more complex and harder to understand, but in certain situations, they're necessary for accuracy.”“If you just blindly took the financial information from this database, it could be off by a big factor. So again understanding what's going on, understanding the nuance, understanding the limitations is going to be much more valuable.”“They're going to trust you and value you to distill what's important and then present it in an easy-to-digest way so that they can understand in simple terms what is happening. The analysis comes from the model, but the story is going to come from you.”Sign up for the Advanced Financial Modeler Accreditation or FMI Fundamentals Today and receive 15% off by using the special show code ‘Podcast’. Visit www.fminstitute.com/podcast and use code Podcast to save 15% when you register.  Go to https://earmarkcpe.com, download the app, take the quiz and you can receive CPE credit.  Follow Scott:  LinkedIn - https://www.linkedin.com/in/scott-rostan-86b44417aWebsite - https://trainingthestreet.com/ Follow Paul: Website - https://www.thefpandaguy.com/  LinkedIn - https://www.linkedin.com/in/thefpandaguy/  TikTok - https://www.tiktok.com/@thefpandaguy  YouTube - https://www.youtube.com/@thefpaguy8376  Follow Financial Modeler's Corner  LinkedIn Page- https://www.linkedin.com/company/financial-modeler-s-corner/?viewAsMember=true  Newsletter - Subscribe on LinkedIn- https://www.linkedin.com/build-relation/newsletter-follow?entityUrn=7079020077076905984   In today’s episode:  [00:45] Introduction;[01:00] Scott’s horror story of the worst Financial Model;[01:58] The KISS principle;[03:53] Scott’s background;[05:56] Key projects that helped Scott;[19:17] Training the Street courses;[21:02] How is AI changing modeling;[28:59] Skills required for a great modeler;[42:50] Scott’s favorite Excel shortcut;[44:18] Rapid fire;[48:55] Scptt’s final piece of advice;

Welcome to this episode of FP&A Tomorrow, a podcast where we explore the currency state of financial planning and analysis (FP&A) and the future of business operations. Hosted by Paul Barnhurst, also known as the FP&A Guy, this episode is sponsored by Abacum, the leading mid-market FP&A solution. This week, we're diving into the crucial relationship between FP&A and product management, featuring insights from three distinguished guests: Dara Goroff, Navya Rehani Gupta, and Urvi Kapadia.This special episode focuses on the synergy between FP&A and product management, addressing the essential qualities of a fruitful partnership that drives business growth and product success.A little about our guests:Dara Goroff: Specializes in product management within the automotive space, currently leading initiatives at I-CAR to standardize collision repair education.Navya Rehani Gupta: Chief Product Officer at Peek, with a rich background in engineering, finance, and high-growth startups.Urvi Kapadia: FP&A Manager at Netdocuments, bringing an accounting perspective to tech and product finance, with experience in various industries including manufacturing.Expect to Learn:The Art of Possibility: Understanding how FP&A can support product management through the lens of future potential, not just immediate financials.Customer-Centric Financial Planning: The importance of FP&A professionals familiarizing themselves with customer needs and product value propositions.Strategic Alignment and Empathy: Both teams striving for mutual understanding and alignment on business objectives to ensure cohesive movement towards shared goals.Analytical Collaboration: Leveraging analytical skills in both domains to iterate product features and pricing strategies that align with market demands and financial realities.Early Involvement and Transparency: The significance of involving FP&A in product planning stages for better financial planning and risk management.This episode promises a comprehensive look into how FP&A and product management can collaborate more effectively, emphasizing strategic alignment, empathy, and a shared vision for the future. Whether you're deeply embedded in FP&A, just beginning your journey, or part of a product team, these insights will guide you in fostering stronger, more productive relationships across these critical business functions.Some Insightful quotes:On Strategic Partnership:“True excellence in FP&A comes from not just understanding the numbers, but from understanding the story behind the numbers. It's about being a strategic partner who can translate data into actionable insights." - This highlights the evolving role of FP&A professionals from number crunchers to strategic advisors who can guide decision-making processes.On Collaboration with Product Management:"The magic happens when FP&A and product management see the art of the possible together. It’s not just about balancing the books; it’s about understanding and investing in the future of the product." - This quote encapsulates the importance of collaboration between FP&A and product teams, emphasizing a shared vision for innovation and growth.On Analytical Prowess:"An FP&A professional’s strength lies in their ability to see beyond the immediate financials to the broader business implications. It’s about connecting the dots in ways that others haven’t yet seen." - This quote reflects the analytical prowess required in FP&A, highlighting the need to provide insights that drive forward-thinking strategies.On the Importance of Customer Understanding:"FP&A isn't just about internal metrics and forecasts; it's about deeply understanding the market and customer needs. Our financial planning must align with delivering value to our customers." - This underscores the necessity for FP&A professionals to have a customer-centric approach, ensuring that financial plans are always aligned with customer value.On Empathy and Alignment:"Effective FP&A requires empathy towards the teams we partner with. Understanding their challenges and aligning on common goals is essential for moving the business in the right direction together." - This quote highlights the soft skills needed in FP&A, particularly the importance of empathy and alignment with other departments to achieve shared business objectives.Abacum is the leading mid-market FP&A solution trusted by hundreds of companies to eliminate the spreadsheet struggle. Visit Abacum.io today and multiply the impact of your finance team.Go to https://earmarkcpe.com, download the app, take the quiz and you can receive CPE credit.Checkout Our Amazing Guests:Dara: https://www.linkedin.com/in/dara-goroff-pmp-0228691Navya: https://www.linkedin.com/in/navyarehani/ Urvi: https://www.linkedin.com/in/urvi-kapadia-fpna/Follow Paul:Website - https://www.thefpandaguy.com/LinkedIn - https://www.linkedin.com/in/thefpandaguy/

FP&A Tomorrow is where we discuss what FP&A looks like today and help shape what it should look like tomorrow by interviewing the best and brightest people in FP&A globally. Go to https://earmarkcpe.com, download the app, take the quiz and you can receive CPE credit.Follow Paul:Website - https://www.thefpandaguy.com/LinkedIn - https://www.linkedin.com/in/thefpandaguy/TikTok - https://www.tiktok.com/@thefpandaguyYouTube - https://www.youtube.com/@thefpaguy8376

Welcome to the Financial Modeler's Corner (FMC), where we discuss the art and science of financial modeling with your host Paul Barnhurst. Financial Modeler's Corner is sponsored by the Financial Modeling Institute (FMI), the most respected accreditation in Financial Modeling globally.In today’s episode, Paul engages in a conversation with Roderick McKinley, blockchain & Tokenomics advisor of Rmckinley.netRoderick, a crypto expert, discusses financial modeling in the crypto space, highlighting challenges like token volatility and treasury management. He emphasizes aligning incentives for healthy exchanges and discusses his online course on Tokenomics Modeling and fundraising.Roderick also offers strategic guidance, product development, and Tokenomic design services for various blockchain applications, including DeFi, blockchain games, and Layer 1 protocols. He assists in developing tokenized business models, designing token utilities, and structuring token allocations for successful capital raises.In this episode, these are your learnings:Understand the integration of finance and blockchain and Tokenomics and strategic guidance for blockchain projects.Gain insights into challenges and opportunities in transitioning from traditional finance to the crypto space.Learn how to navigate complexities like token volatility and incentive alignment in blockchain projects.Obtain practical tips on developing tokenized business models, designing token utilities, and structuring token allocations for successful fundraising.Acquire valuable knowledge for navigating the evolving landscape of blockchain and cryptocurrency.Quotes: “Financial modeling often has a lot to do with client and industry expectations. What passes as good work or what passes as enough can change very dramatically from country to country and sector to sector.”“Some of the stuff they teach you is that, well, the world's this way because it can't be any other way. And you pass exams sort of like explaining why it's impossible to fix things but suddenly blockchain technology actually gives you a completely different kind of tool chest that opens that up again.”“Try and look for the shortest and most efficient way to express your calculations. Try and maximize the speed of your model.”Sign up for the Advanced Financial Modeler Accreditation or FMI Fundamentals Today and receive 15% off by using the special show code ‘Podcast’.Visit www.fminstitute.com/podcast and use code Podcast to save 15% when you register.Go to https://earmarkcpe.com, download the app, take the quiz and you can receive CPE credit.Follow Roderick McKinley: Linkedin: https://www.linkedin.com/in/roderickmckinleyWebsite: https://rmckinley.net/Follow Paul:Website - https://www.thefpandaguy.com/LinkedIn - https://www.linkedin.com/in/thefpandaguy/TikTok - https://www.tiktok.com/@thefpandaguyYouTube - https://www.youtube.com/@thefpaguy8376Follow Financial Modeler's CornerLinkedIn Page- https://www.linkedin.com/company/financial-modeler-s-corner/Newsletter - Subscribe on LinkedIn- https://www.linkedin.com/build-relation/newsletter-follow?entityUrn=7079020077076905984In today’s episode:01:10 Introduction01:55 Rodrick’s horror story03:55 Rodrick’s background05:25 Getting stuck on a tropical island06:08 Rodrick’s love of problem-solving, geeky coding, and number-crunching11:50 Interview with Boris Johnson13:17 Definition of token economics21:39 How do crypto companies manage their treasury?28:04 Simplifying Tokenomics modeling30:01 Deciding on tool selection35:51 Rodrick’s Favorite and Most Valuable Excel Shortcuts37:25 Rapid fire42:42 Wrap up

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 is joined by Ian Bennett, Partner, Deals Modelling team at PwC, Australia.With over 20 years of experience as a professional financial modeler, Ian has constructed and assessed models critical for major transactions, infrastructure projects, and routine forecasting and reporting. Today Ian leads the deal modeling practice for Pwc Australia.In addition to being a world-class Modeller Ian is incredibly dedicated to diversity, inclusion, and wellbeing (DI&W). This has propelled him through various positions within PwC and beyond. As a proud LGBTIQ+ ally, he serves on the Steering Committee of Shine@PwC, the firm's LGBTIQ+ employee network, and currently holds the role of wellbeing lead for the Financial Advisory business.In this episode, expect to learn:Why understanding the stakeholders involved in a project is vitalWhy it's essential to listen actively to clients, understand their needs, and ask the right questionsHow to analyze the success and effectiveness of the financial modeling processWhat are the tools and technologies available in the marketWhat are the new technologies and methodologies for financial modelers to stay effective and successful in their rolesQuotes: “You need a desire to understand the power of the things you have in front of you and not be scared.”“Every model tells a story, and that story is known at the start of the project, and the questions that the model will be able to answer.”“Models are built for a single primary purpose at the time that they are conceived’Sign up for the Advanced Financial Modeler Accreditation or FMI Fundamentals Today and receive 15% off by using the special show code ‘Podcast’.Visit www.fminstitute.com/podcast and use code Podcast to save 15% when you register.Go to https://earmarkcpe.com, download the app, take the quiz and you can receive CPE credit.Follow Ian Bennett: Linkedin: https://www.linkedin.com/in/ianrbennettWebsite: https://www.pwc.com.au/deals/modelling.htmlFollow Paul:Website - https://www.thefpandaguy.com/LinkedIn - https://www.linkedin.com/in/thefpandaguy/TikTok - https://www.tiktok.com/@thefpandaguyYouTube - https://www.youtube.com/@thefpaguy8376Follow Financial Modeler's CornerLinkedIn Page- https://www.linkedin.com/company/financial-modeler-s-corner/Newsletter - Subscribe on LinkedIn- https://www.linkedin.com/build-relation/newsletter-follow?entityUrn=7079020077076905984In today’s episode:00:20: Introduction01:10: Problem that bettered Ian03:00: Ian’s insights on financial models05:18: Ian’s story07:13: What is MFM and why did Ian pursue it?08:35: Ian’s experience in the Global Excel Summit10:49 Why Ian is passionate about financial modeling11:52: Ian’s favorite industry that he likes to model13:13: What makes a good financial modeler?16:49: Things beyond the model that help in a project?22:05: Approach and methodology 27:00: Tools beyond Excel34:40: Technical nugget when building new models36:50:  Rapid fire 39:08: Ian’s favorite function45:00: Ian’s advice to become a better financial modeler45:36: Wrap up

In this episode, Paul Barnhurst is joined by Derek Baker, who is drawn to really hard problems. Derek discovered early in his career that he loves startups and building companies.He began his career working for SaaS startups, building out their core FP&A processes. For many of the companies he worked with, he was building their very first financial model to help them operate the business and make capital allocation decisions. He found that every business - regardless of stage - can improve performance with excellent FP&A. Today, he works at Neighbor.com, a Series B startup, building the “Airbnb” of personal storage. Building the FP&A function for a marketplace has been the biggest challenge of his career, and he is loving every minute of it. Listen to this episode as Derek shares: How he got into financial modeling for SaaS companies His advice for building robust SaaS Models. The importance of understanding a business to build better Models. Everything about SaaS and SaaS Companies. His position on controversial modeling issues, including circular references, dynamic arrays, modeling standards, AI in modeling, and more. Quotes: “ The only way you're really going to learn how to build a model is by building it. You can do all the study you want, but at the end of the day, it's like anything, without practice, it's just theory. ” “ The better you know an industry, the better you know the operations of the business, the easier it is to build a model.” “ [ What separates good FP &A from great FP & A] I think it's 1- business acumen and 2- business partnering. Anyone can build a model in Excel and can learn those technical skills. But using those technical skills to help the business and partner with the business to help them understand the business better and grow the business is exactly what FP&A should be doing....” Sign up for the Advanced Financial Modeler Accreditation or FMI Fundamentals Today and receive 15% off by using the special show code ‘Podcast’. Visit https://fminstitute.com/podcast/and use code Podcast to save 15% when you register. Go to https://earmarkcpe.com , download the app, take the quiz and you can receive CPE credit. Follow Derek: LinkedIn - https://www.linkedin.com/in/derek-d-baker/Website - https://community.plan-buddies.com/home Follow Paul: Website - https://www.thefpandaguy.com/LinkedIn - https://www.linkedin.com/in/thefpandaguy/TikTok - https://www.tiktok.com/@thefpandaguyYouTube - https://www.youtube.com/@thefpaguy8376 Follow Financial Modeler's Corner LinkedIn Page- https://www.linkedin.com/company/financial-modeler-s-corner/?viewAsMember=trueNewsletter - Subscribe on LinkedIn- https://www.linkedin.com/build-relation/newsletter-follow?entityUrn=7079020077076905984 In today’s episode: (00:22) Intro; (00:45) Welcoming Derek; (01:00) The worst Financial Model Derek has ever seen ; (02:00) Key takeaways from the worst Financial Model; ...

In this episode, Paul Barnhurst is joined by Lance Rubin, who has a wealth of financial modeling experience including working for PwC & KPMG, Investec Bank Corporate Finance & Advisory, National Australia Bank, and starting his own practice.Lance spent two decades working for corporations (PwC & KPMG, Investec Bank Corporate Finance & Advisory, National Australia Bank). It was during this time he gained a love of modeling. Lance was previously the CFO of fin-tech start-up Banjo (SME lender) and Sequel CFO whilst founding Model Citizn, a financial modeling, analytics, and automation consultancy firm following his 20 years in corporate. He has delivered a number of online training workshops in financial modeling and Power BI whilst also being a certified trainer for the FMI and he wrote a large portion of the CA (ANZ) study guide on financial modeling. He was also a judge at the world’s first Financial Modeling Innovation Awards and he presented at the Power BI Global Summit in 2022. Listen to this episode as Lance shares: His learning from the worst models he has come across.His journey into Financial Modeling and how he fell in love with modeling.The key to Financial Transformations.The HACK Framework.The importance of Power BI and similar tech.His advice on the use of tools and shortcuts.His position on controversial modeling issues, including circular references, dynamic arrays, modeling standards, AI in modeling, and more.Quotes: “Financial Transformation is the combination of process, tech, and people. With people being the most important.” “The HACK Framework (Hygiene, Automation, Capability, Knowledge) allows you to bring technical skills and soft skills. together...You need to develop capability and knowledge and you need to bring that together with hygiene and automation.” “Data Modeling and Financial Modeling sound the same but are fundamentally quite different.” Sign up for the Advanced Financial Modeler Accreditation or FMI Fundamentals Today and receive 15% off by using the special show code ‘Podcast’. Visit www.fminstitute.com/podcast and use code Podcast to save 15% when you register. Go to https://earmarkcpe.com, download the app, take the quiz and you can receive CPE credit. Follow Lance: Website - https://www.modelcitizn.com/LinkedIn - https://www.linkedin.com/in/financial-modelling/Follow Paul: Website - https://www.thefpandaguy.com/ LinkedIn - https://www.linkedin.com/in/thefpandaguy/ TikTok - https://www.tiktok.com/@thefpandaguy YouTube - https://www.youtube.com/@thefpaguy8376 Follow Financial Modeler's Corner LinkedIn Page- https://www.linkedin.com/company/financial-modeler-s-corner/?viewAsMember=true Newsletter - Subscribe on LinkedIn- https://www.linkedin.com/build-relation/newsletter-follow?entityUrn=7079020077076905984 In today’s episode: (00:22) Intro;(00:47) Welcoming Lance;(01:00) The worst financial model Lance has ever seen;(05:14) Takeaway from the worst financial model;(08:02) Lance’s background;(11:27) Key to Finance Transformation;(17:37) The Hack Framework;(18:43 - 19:29) Validate your Financial Modeling Skills with FMI’s Accreditation Program (ad);(19:30) What led to Lance’s love for Modeling?;(22:38) The most interesting model;(26:30) Importance of Power BI and similar Tech;(31:51) AI and Financial Modeling;(36:10) The learning that saved Lance a lot time while Modeling;(41:16) Rapid Fire;(46:58) Connect with Lance;(48:15) Outro;

In this episode, we have another special treat for you which is part two of the Financial Modeling World Cup (FMWC) and the Microsoft Excel Collegiate Challenge (MECC). Paul attended modeling competitions in Arizona and Las Vegas watching competitors compete&nbsp;and talking to the commentators, spectators, and faculty, and we have brought you a few of those interviews. Listen to this episode as : Andrew Ngai shares how amazing it was to look out at the facility, the HyperX arena in Vegas, and realize that this was his hobby. The founder of FMWC, Andrew Grigolyunovich talks about how it fulfilled a dream of his to talk about that. Competitors share why learning Excel is so important for your career. The students share some of their experiences, favorite Excel formulas, and why they're such big fans of Excel and financial modeling. Quotes: “Our slogan is “Learn, Train, Compete” for the Financial Modeling World Cup.” Andrew Grigolyunovich "It was the dream come true...that was exactly the moment that the thing that I was dreaming of, probably since back in 2016." Andrew Grigolyunovich "You're able to just help each other out. So, yeah, for me, my favorite part was the collaboration, just interacting."Zach Sign up for the Advanced Financial Modeler Accreditation or FMI Fundamentals Today and receive 15% off by using the special show code ‘Podcast’. Visit www.fminstitute.com/podcast and use code Podcast to save 15% when you register. Go to https://earmarkcpe.com, download the app, take the quiz and you can receive CPE credit. Follow Andrew Ngai : LinkedIn - https://www.linkedin.com/in/andrewngai Follow Andrew Grigolyunovich : LinkedIn - https://www.linkedin.com/in/andrewgrig/ Follow Paul Wagner: LinkedIn - https://www.linkedin.com/in/phwagner/ Follow Paul: Website - https://www.thefpandaguy.com/LinkedIn - https://www.linkedin.com/in/thefpandaguy/TikTok - https://www.tiktok.com/@thefpandaguyYouTube - https://www.youtube.com/@thefpaguy8376 Follow Financial Modeler's Corner LinkedIn Page- https://www.linkedin.com/company/financial-modeler-s-corner/?viewAsMember=true Newsletter - Subscribe on LinkedIn- https://www.linkedin.com/build-relation/newsletter-follow?entityUrn=7079020077076905984 In today’s episode: (00:45) Intro; <p paraid="1445039319"...

Welcome to 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 Financial Modeling Institute (FMI) the most respected accreditation in Financial Modeling globally. In this episode, we have a special treat for you with multiple guests who attended the Microsoft Excel Collegiate Challenge (MECC). At the beginning of November, Paul had the opportunity to spend a day at the University of Arizona campus and watch these students compete and talk to commentators, spectators, competitors, and faculty, and we have brought you a few of those interviews. Listen to this episode as:&nbsp;Excel MVPs, Oz Du Soleil and Jon Acampora share why they attended the show, what they love about the competition, and the magic of Power QueryThe host of this competition, Prof David Brown talks about MECC.The winner, Patrick Chatain and 3rd-place finisher Benjamin Weber share their experiences.Missy and Teresa from Salve Regina University, talk about why they started with Excel as they were building out a data analytics business program.Craig Hatmaker shares everything about LAMBDA's and 5G modeling components.Quotes: &nbsp;&nbsp; “[How does MECC benefit students in the real world] Sometimes we get sponsors to actually write cases that are based on what they do . S o it gives them real-world experience of what they would be doing, which is invaluable w hen you're interviewing for a job . ....... ” - Professor&nbsp;David Brown &nbsp; “ [Do you feel like you're better in Excel today for having competed] When I started competing, I didn't even know what Lambda, let alone dynamic arrays and all of that was. Now I know most of them and I think those are pretty good functions with pretty good use cases. So I think that made me a much better user in Excel. ” - 3rd Place Finisher&nbsp;Benjamin Weber&nbsp;&nbsp; Sign up for the Advanced Financial Modeler Accreditation or FMI Fundamentals 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. &nbsp; Go to https://earmarkcpe.com , download the app, take the quiz and you can receive CPE credit.&nbsp; &nbsp; Follow Oz du Soleil : &nbsp;&nbsp;&nbsp; YouTube - https://www.linkedin.com/in/ozdata/ LinkedIn - https://www.youtube.com/channel/UCZgOVykPoRbSZQfY9YysiRQ Follow Jon Acampora : &nbsp;&nbsp;&nbsp; Website - https://www.excelcampus.com/ LinkedIn - https://www.linkedin.com/in/jonacampora Follow David Brown: &nbsp;&nbsp;&nbsp; LinkedIn - https://www.linkedin.com/in/dr-david-c-brown/?trk=public_post_feed-actor-name Follow Craig Hatmaker : &nbsp;&nbsp;&nbsp; LinkedIn: https://www.linkedin.com/in/craig-hatmaker-4449879/ Website: https://sites.google.com/site/beyondexcel/home YouTube: https://www.youtube.com/@CraigHatmakerBXL Building with Fast + 5G- https://www.youtube.com/watch?v=8Zl3yURsvdE&amp;t=1s Demo using 5G Components- Intro 5G - Watch an Excel Model do something incredible using 5G methods - YouTube Gist site to download Craig Hatmakers LAMBDAs for 5G modeling- https://gist.github.com/CHatmaker &nbsp; Follow Paul: Website - https://www.thefpandaguy.com/&nbsp; &nbsp; LinkedIn - https://www.linkedin.com/in/thefpandaguy/&nbsp; TikTok - https://www.tiktok.com/@thefpandaguy&nbsp; YouTube - https://www.youtube.com/@thefpaguy8376 &nbsp; &nbsp; Follow Financial Modeler's Corner&nbsp; LinkedIn Page- https://www.linkedin.com/company/financial-modeler-s-corner/?viewAsMember=true &nbsp; Newsletter - Subscribe on LinkedIn- https://www.linkedin.com/build-relation/newsletter-follow?entityUrn=7079020077076905984 &nbsp; &nbsp; In today’s episode: &nbsp; (00:43) Intro; (01:44) Interview with Oz Du Soleil and Jo n A campora ; (19:51) Everything about MECC with David Brown; (25:43 - 26:30) Validate your Financial Modeling Skills with FMI’s Accreditation Program (ad); (27:30) Interview with Benjamin Weber ; (36:34) Interview with Patrick Chat ain ; (41:28) Interview with Missy and Teresa ; (48:38) Interview with Craig Hatmaker; (54:00) Outro.&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;

Welcome to 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 Financial Modeling Institute (FMI) the most respected accreditation in Financial Modeling globally. In this episode, Paul Barnhurst is joined by Sam Sivarajan , who is a Speaker, Wealth Management Consultant, Behavioral Scientist, Stoicism Padawan, Fintech Advisor, Podcast Host, Bestselling Author and an Adventurer. He has a law degree, an MBA, a PhD in behavioral science, and has also earned a CFP. &nbsp; Sam’s work is focused on how we can make&nbsp; better decisions &nbsp;so that we can get to&nbsp; better results&nbsp; – in investing, in leadership, and in our personal lives. &nbsp; Listen to this episode as Sam shares:His journey working in Telecom during the tech boom.Advice on balancing the art and science of Modeling.His advice on making smart assumptions.The importance of Decision Making.How to think critically when building a model and making assumptions.Everything about his books ‘Making your money work’, ‘Uphill’ and ‘Am I Ok?’His position on controversial modeling issues, including circular references, dynamic arrays, modeling standards, AI in modeling, and more . Quotes: &nbsp; “ Never forget and lose sight of why you're creating the model, and who will use it....... ” “ In my view, the model is simply a numerical representation of some prior deep-rooted strategic thinking , a nd you're bringing that to bear in that model as a representation . ” &nbsp; “ A model is a simplification of reality. It isn't reality. And to remember that the model is but one tool in making key decisions. It shouldn't be the be all and end all...... ” &nbsp; Sign up for the Advanced Financial Modeler Accreditation or FMI Fundamentals 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. &nbsp; Go to https://earmarkcpe.com , download the app, take the quiz and you can receive CPE credit.&nbsp; Am I Ok? - https://www.amazon.co.uk/Am-Essential-Questions-Investors-Financial-ebook/dp/B0CKY6XB4K?ref_=ast_author_mpb &nbsp; Uphill - https://www.amazon.co.uk/Uphill-Ancient-Science-Choices-Challenges-ebook/dp/B0BGMJX9VN?ref_=ast_author_dp&amp;dib=eyJ2IjoiMSJ9.fVxD2IJYvz1m0ZgBXJmkb595Ei0TtF8Wjx2TMOwZWzVdTmpjGxlD9-zbKVPzvrFn.gUxmNYfh-t6jXwKbr2EqugQZ4LBWXPOLoX6DrlNEsU0&amp;dib_tag=AUTHOR Follow Sam: &nbsp;&nbsp;&nbsp; Website - https://www.samsivarajan.com/ LinkedIn - https://ca.linkedin.com/in/samsivarajan Podcast - https://www.samsivarajan.com/podcast Twitter - https://twitter.com/SamSivarajan &nbsp; Sam’s books: &nbsp; Making your Money Work - https://www.amazon.co.uk/Making-Your-Money-Work-Financial-ebook/dp/B0B36PDQLX?ref_=ast_author_dp&amp;dib=eyJ2IjoiMSJ9.fVxD2IJYvz1m0ZgBXJmkb595Ei0TtF8Wjx2TMOwZWzVdTmpjGxlD9-zbKVPzvrFn.gUxmNYfh-t6jXwKbr2EqugQZ4LBWXPOLoX6DrlNEsU0&amp;dib_tag=AUTHOR &nbsp; Follow Financial Modeler's Corner&nbsp; LinkedIn Page- https://www.linkedin.com/company/financial-modeler-s-corner/?viewAsMember=true &nbsp; Newsletter - Subscribe on LinkedIn- https://www.linkedin.com/build-relation/newsletter-follow?entityUrn=7079020077076905984 &nbsp; &nbsp; In today’s episode: &nbsp; (00:22) Intro; (00:45) Welcoming Sam; (01:01) The worst financial model Sam has ever seen ; (02:57) Sam’ s background; (04:22) Sam’s experience at Telecom; (10:27) How to balance the art of Art and Science of Modeling ; (12:27) Why is the process often more important than the actual Model? ; (17:07) Advice on Assumptions; (21:51) Sam’s technique to get better at Modeling; (22:30 - 23:15) Validate your Financial Modeling Skills with FMI’s Accreditation Program (ad); (23:21) How people think about making decisions; (24:35) How to make better decisions; (27:40) Frameworks that help with Decision Making; (31:57) Sam’s experience while writing his books - Making your Money Work, Uphill and Am I Ok?; (34:20) Rapid Fire; (37:38) Connect with Sam; (38:17) Sam’s advice on being a successful Modeler; (39:34) Paul’s Top Picks - The importance of the Thinking Process - Validating Assumptions (41:00) Outro&nbsp;

Welcome to 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 Financial Modeling Institute (FMI) the most respected accreditations in Financial Modeling globally. &nbsp; In this LinkedIn Live, Paul Barnhurst is joined by three amazing Modelers, Dave Hallwood, Giles Male and Rafa ë l Le Saux. &nbsp; Dave is the Group Finance Director at Aldrich Group Ltd . He is a Chartered Certified Accountant, Commercially minded with a background in Accounting and Business in SMEs Dave took the AFM last year and the CFM this year. Giles Male is a co-founder of Full Stack Modeler - an award-winning training program and community for Modelers at every level, with an opportunity to gain Full Stack Modeler accreditation. He will also be taking on a limited number of coaching clients in 2024. Giles took his AFM 2 years ago and is awaiting the result of CFM. Rafaël Le Saux is a Director and Valuation &amp; Modeling Advisory Lead at PwC Luxembourg / LVPA Board Member. He is passionate about Valuation and Modeling disciplines and has piloted his professional path toward amassing sufficient knowledge to support clients in solving complex valuation problems across different asset classes, industries, and geographies. &nbsp; Listen to this episode as the guests talk about:&nbsp;Their experiences in Modeling.&nbsp;The value of Financial Modeling Accreditation.How to improve your Financial Modeling skillsTheir position on controversial modeling issues, including circular references, dynamic arrays, modeling standards, AI in modeling, and more. Quotes: &nbsp;&nbsp; “this job is about people, it's about talking to people, it's about giving them information instead of data” &nbsp; “One of the really good things about FMI is if you have got both AFM and CFM on your CV, that’s the level of credibility that reflects what you are doing.” &nbsp; "Simple is hard, complex is easy"&nbsp; Sign up for the Advanced Financial Modeler Accreditation or FMI Fundamentals 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. &nbsp; Go to https://earmarkcpe.com , download the app, take the quiz and you can receive CPE credit.&nbsp; &nbsp; Follow Dave: &nbsp;&nbsp;&nbsp; LinkedIn - https://www.linkedin.com/in/david-hallwood-fcca-87270449/ Follow Giles: &nbsp;&nbsp;&nbsp; LinkedIn - https://www.linkedin.com/in/giles-male-30643b15/Apply to get Coached - https://fullstackmodeller.typeform.com/to/RezB1GRA Follow Rafaël: LinkedIn - https://www.linkedin.com/in/rafael-le-saux/ &nbsp; Follow Paul: Website - https://www.thefpandaguy.com/&nbsp; &nbsp; LinkedIn - https://www.linkedin.com/in/thefpandaguy/&nbsp;TikTok - https://www.tiktok.com/@thefpandaguy&nbsp;Twitter - https://twitter.com/TheFPandAGuy&nbsp;YouTube - https://www.youtube.com/@thefpaguy8376 &nbsp;&nbsp; Follow Financial Modeler's Corner&nbsp; LinkedIn Page- https://www.linkedin.com/company/financial-modeler-s-corner/?viewAsMember=true &nbsp;&nbsp;Newsletter - Subscribe on LinkedIn- https://www.linkedin.com/build-relation/newsletter-follow?entityUrn=7079020077076905984 &nbsp;&nbsp; In today’s episode: &nbsp; (00:22) Intro; (00:46) Background of the guests - Dave, Giles, Rapha ë l; (02:36) How did they become interested in building Financial Models?; (06:40) Rapid Fire; (14:55) What led these guys to take the FMI?; (21:45) Why are they a fan of Financial Modeling World Cup?; (23:36) How FMI helped them professionally?; (24:45 - 25:30) Validate your Financial Modeling Skills with FMI’s Accreditation Program (ad); (27:18) What makes FMI unique?; (37:36) When must someone take AFM and CFM?; (41:03) FMI as a part of regular Graduation; (46:08) Advice on being a better Financial Modeler; (49:26) Connect with Dave, Giles and Rapha ë l ; (50:40) Outro

Welcome to 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 Financial Modeling Institute (FMI) the most respected accreditations in Financial Modeling globally. In this episode, Paul Barnhurst is joined by Dr. Andy Temte . &nbsp; Dr. Andrew Temte, CFA, is the former CEO of Kaplan Professional and author of “Balancing Act: Teach, Coach, Mentor, Inspire,” and "The Balanced Business: Building Organizational Trust and Accountability through Smooth Workflows." He is also a board member and senior advisor at the FMI. &nbsp; A thought leader on financial education and issues related to organizational health, continuous improvement, and workforce re-skilling, his articles have appeared in a number of media outlets, including Chief Executive and Chief Learning Officer. &nbsp; This blend of higher education and professional education experience gives Dr. Temte a unique perspective when it comes to financial education and financial modeling &nbsp; Listen to this episode as Andy shares:&nbsp; His learning from the worst models he has come across.His experience reviewing financial models for acquisitions.His experience as a Member of the Board of FMI.The value of Financial Modeling Accreditation.Why he wrote his book ‘The Balancing Act’.His position on controversial modeling issues. Quotes: &nbsp; “FMI is one of the only institutes that’s delivering a truly experiential credentialing process.” &nbsp; “At the end of the day, modeling is about communication because you're helping communicate insights, derived from data and assumptions to drive behavior or changes or decisions. And so it's all about communicating.” Sign up for the Advanced Financial Modeler Accreditation or FMI Fundamentals 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. &nbsp; Go to https://earmarkcpe.com , download the app, take the quiz and you can receive CPE credit.&nbsp; &nbsp; Follow Andy Temte: &nbsp;&nbsp;&nbsp; LinkedIn - https://www.linkedin.com/in/atemte/ Podcast - Balancing Act Website - https://www.andrewtemte.com/ &nbsp; Andy’s books: &nbsp; Balancing Act - https://www.amazon.com/Audible-Balancing-Act/dp/B0CFCZT4HN/ref=sr_1_2?crid=17K8UI3208G9Q&amp;keywords=Andy+Temte&amp;qid=1701342458&amp;sprefix=andy+temte%2Caps%2C150&amp;sr=8-2 &nbsp; The Balanced Business: Building Organizational Trust and Accountability through Smooth Workflows - https://www.amazon.com/Balanced-Business-Organizational-Accountability-. &nbsp; Follow Paul: Website - https://www.thefpandaguy.com/&nbsp; &nbsp; LinkedIn - https://www.linkedin.com/in/thefpandaguy/&nbsp; Instagram - https://www.instagram.com/thefpandaguy/ &nbsp; TikTok - https://www.tiktok.com/@thefpandaguy&nbsp; Twitter - https://twitter.com/TheFPandAGuy&nbsp; YouTube - https://www.youtube.com/@thefpaguy8376 &nbsp; &nbsp; Follow Financial Modeler's Corner&nbsp; LinkedIn Page- https://www.linkedin.com/company/financial-modeler-s-corner/?viewAsMember=true &nbsp; Newsletter - Subscribe on LinkedIn- https://www.linkedin.com/build-relation/newsletter-follow?entityUrn=7079020077076905984 &nbsp; &nbsp; In today’s episode: &nbsp; (00:22) Intro; (00:46) Welcoming Andy; (01:05) The worst financial model Andy has ever seen ; (01:52) Andy’s key learning experience from the worst financial model ; (02:45) Andy ’s background; (05:07) Andy’s journey as a professor; (07:16) Andy’s motivation to teach Finance ; (11:02) Time at Kaplan; (13:55) Andy’s views on the CFA program; (17:27 - 18:13) Validate your Financial Modeling Skills with FMI’s Accreditation Program (ad); (18:18) Andy’s experience as a Member of the Board of FMI; (20:03) Value of Financial Modeling Accreditation; (25:23) Andy’s motivation behind writing the book “The Balancing Act”; (33:17) What motivated Andy to start a Podcast?; (34:54) Rapid Fire; (37:27) Advice on being a successful Modeler; (39:32) Connect with Andy; (40:10) Outro.

This week, we are bringing you another special bonus episode. This week, we are sharing a podcast that our host, Paul Barnhurst, recommends. The Run the Numbers podcast is hosted by CJ Gustafson. The podcast is designed to talk about things he wishes he knew during the early days of his career that no amount of Googling would answer. This week's Show Notes: Sebastian Duesterhoeft, partner at Lightspeed Ventures, joins CJ to talk about anything and everything start-up operators need to know about your Total Addressable Market. Request from you, the audience: We are constantly working to improve Financial Modeler’s Corner, and this week, I would like to ask for your help completing the survey about the podcast. This will help us make future episodes better for you, the listener. The survey will only take a few minutes to complete, and your response is invaluable to the team at Financial Modeler’s Corner. Link to survey: https://forms.office.com/r/K2fHfSUvFp TIMESTAMPS: (00:00) Episode Preview (00:55) SEGMENT: CJ's opening “Off the Books” monologue - the Billion Dollar outcome (02:59) Start of interview (04:38) Why is TAM so important to investors? (09:19) Is a $2B TAM not good enough? (12:06) How big is enough TAM? (13:23) Sponsor: NetSuite (14:44) Frameworks to calculate TAM (19:19) Second and third growth engines (25:18) On "maturity of the market" (28:36) On extensibility (32:27) Why your initial insertion point is crucial to your business (36:22) ServiceNow and Datadog: why these companies are shining examples of expanding their TAM (45:03) SEGMENT: Long-ass Lightning Round (48:43) SEGMENT: Rep Yo Stack - Sponsored by Tropic

Welcome to 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 Financial Modeling Institute (FMI) the most respected accreditations in Financial Modeling globally. In this episode, Paul Barnhurst is joined by Brian Egger . &nbsp; Brian is the Global Head of Financial Modeling, Senior Gaming/Lodging Analyst at Bloomberg Intelligence.&nbsp; &nbsp; He has been publishing models professionally and writing investment research since the 90s on the sell-side as a brokerage analyst. His industry focus has always been broadly centered around consumer gaming, lodging, and leisure. &nbsp; Brian has also worked in player-coach roles, whether it's being a research director or team leader or his current role, head of financial modeling, and outside the realm of being a practitioner, he has experience teaching as well. &nbsp; Listen to this episode as Brian shares:&nbsp;His experience with finding the right balance as a ModelerHis learning from the worst models he has come across.His role as the Global Head of Financial Modeling at BloombergEverything about Bloomberg’s Interactive Calculator.Trends of the Industry over the years.His thoughts on the FMI program and why continuous learning is so important.His position on controversial modeling issues, including circular references, dynamic arrays, modeling standards, AI in modeling, and more . Quotes: &nbsp; “ Models should be dynamic and not static, they should be integrated and not sort of siloed pieces not speaking to each other. ” &nbsp; " There's a lot of merit just to continuously reinvesting in both your skill set and your credentials, and that it's really important to never stop doing that. The FMI has created a really intriguing platform as a way to do that. ” &nbsp; “ The CFA exam prepares you in many ways to be a capable securities analyst. ” &nbsp;&nbsp; Sign up for the Advanced Financial Modeler Accreditation or FMI Fundamentals 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. &nbsp; &nbsp; Join Paul in Vegas for the FMI World Cup Championship from December 7, 2023 - December 9, 2023. &nbsp; Sign up for the event today and receive 10% off by using the special code ‘FP&amp;AGUY10’ . &nbsp; Go to https://earmarkcpe.com, download the app, take the quiz and you can receive CPE credit.&nbsp; &nbsp; Follow Brian Egger: &nbsp;&nbsp;&nbsp; LinkedIn - https://www.linkedin.com/in/brianegger/ &nbsp; Brian’s article on the balance between complexity and simplicity -https://www.linkedin.com/pulse/what-level-detail-enough-financial-model-brian-egger/?trackingId=08lGH6pSQ865qLFJar2nzQ%3D%3D &nbsp; Follow Paul: Website - https://www.thefpandaguy.com/&nbsp;&nbsp; LinkedIn - https://www.linkedin.com/in/thefpandaguy/&nbsp; Instagram - https://www.instagram.com/thefpandaguy/ TikTok - https://www.tiktok.com/@thefpandaguy&nbsp;&nbsp; Twitter - https://twitter.com/TheFPandAGuy YouTube - https://www.youtube.com/@thefpaguy8376 &nbsp; Follow Financial Modeler's Corner&nbsp; LinkedIn Page- https://www.linkedin.com/company/financial-modeler-s-corner/?viewAsMember=true &nbsp; Newsletter - Subscribe on LinkedIn- https://www.linkedin.com/build-relation/newsletter-follow?entityUrn=7079020077076905984 &nbsp; &nbsp; In today’s episode: &nbsp; (00:22) Intro; (00:46) Welcoming Brian; (01:02) The worst financial model Brian has ever seen ; (02:37) Brian’s key learning experience from the worst financial model ; (03:13) Brian ’s background; (05:05) Role as a Global Head of Financial Modeling at Bloomberg; (06:19) How to find the right balance while Modeling? ; (08:08) Signs that a Model is too detailed; (10:57) Signs that a Model is too simple to make decisions; (13:43 - 14:30) Validate your Financial Modeling Skills with FMI’s Accreditation Program (ad); (14:39) About Bloomberg’s Interactive Calculator; (15:58) Brian’s key learning from that Project; (20:25) Guidelines on Balance; (23:52) Brian’s thoughts on FMI; (27:44) Trends of the Industry over the years; (29:58) Rapid Fire; (34:31) Advice on being a successful Modeler; (35:23) Connect with Brian; (35:50) Paul’s Top Picks - Finding the balance between complexity and simplicity (39:32) Outro.

Welcome to 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 Financial Modeling Institute (FMI) the most respected accreditations in Financial Modeling globally. In this episode, Paul Barnhurst is joined by Emilie Williams. &nbsp; Emilie holds a Bachelor of Engineering (B.Eng.) in Mining, a Masters degree in (M.A.Sc.), Civil Engineering, a nd has earned her Level I and II FMI modeling certifications. &nbsp; She has been bridging the gap between mine engineers, operations, finance, and management for more than 15 years. She has real-world, industry experience working on mine project strategies, diagnosing, and solving for factors that lead to project delays and inefficiencies, and creating best-practice tools and models to help her clients manage their operations, costs and realize their objectives. &nbsp; Listen to this episode as Emilie shares:&nbsp; Her journey from mine engineer to full-time financial modelHer learnings from the worst models she has come acrossThe unique challenges of modeling in the mining industryHer experience with competing in ESPN’s most recent Excel BattleThe importance of practicing to be a better modelerHer position on controversial modeling issues, including circular references, dynamic arrays, modeling standards, AI in modeling, and more Quotes: &nbsp; “ The dependencies on physical constraints are not always easy to model. ” "[Attending an FMI Course was] the first time I realized that there was actually a way to do it and actually the structure of modeling was a real thing, as opposed to, let's just stick things in our Excel spreadsheet …” &nbsp;&nbsp;Sign up for the Advanced Financial Modeler Accreditation or FMI Fundamentals 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. &nbsp;Join Paul in Vegas for the FMI World Cup Championship from December 7, 2023 - December 9, 2023 . Sign up for the event today and receive 10% off by using the special code ‘FP&amp;AGUY10’.Click on the link to register:&nbsp;Financial Modeling World Cup Go to https://earmarkcpe.com , download the app, take the quiz and you can receive CPE credit.&nbsp; Follow Emilie Williams: &nbsp; &nbsp;&nbsp; LinkedIn - https://www.linkedin.com/in/emilie-williams-06582761/ Website - https://cvmconsultants.ca/ &nbsp; Follow Paul: Website - https://www.thefpandaguy.com/ &nbsp;&nbsp; LinkedIn - https://www.linkedin.com/in/thefpandaguy/&nbsp;&nbsp; Instagram - https://www.instagram.com/thefpandaguy/&nbsp;&nbsp; TikTok - https://www.tiktok.com/@thefpandaguy&nbsp;&nbsp; Twitter - https://twitter.com/TheFPandAGuy&nbsp;&nbsp; YouTube - https://www.youtube.com/@thefpaguy8376&nbsp;&nbsp; &nbsp; Follow Financial Modeler's Corner&nbsp; LinkedIn Page- https://www.linkedin.com/company/financial-modeler-s-corner/?viewAsMember=true &nbsp; Newsletter - Subscribe on LinkedIn- https://www.linkedin.com/build-relation/newsletter-follow?entityUrn=7079020077076905984 &nbsp;

Special EpisodeThis week we are bringing you a unique episode.&nbsp; This episode is a Breaking Into Finance podcast episode hosted by Craig Thompson featuring Paul Barnhurst.&nbsp;Show Notes from Breaking Into FinanceLast episode we teed up the topic of exit opportunities and the types of careers paths available to finance professionals. Today we're excited to be joined by Paul Barnhurst AKA The FP&amp;A Guy, host of FP&amp;A Today and Financial Modeler's Corner. Financial Planning &amp; Analysis ("FP&amp;A") drives the strategic finance function at corporates and is an increasingly popular next step for ex-bankers. Paul is a thought leader in the space who helps break down the FP&amp;A role, the skills you need to be successful, and his thoughts on the future of financial modeling.For more Breaking Into Finance Episodes click herehttps://open.spotify.com/show/3KtwQ1mhwj7X0HKK7RyJHc?si=8e9eeeed0c18463f

Welcome to 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 Financial Modeling Institute (FMI)&nbsp; the most respected accreditations in Financial Modeling globally.&nbsp;In this episode, Paul Barnhurst is joined by Rob Langrick. &nbsp; Rob Langrick, CFA, CIPM, is the General Manager of the CFA Program. He was previously Head of Practice Analysis, overseeing annual curriculum updates to the CFA Program. &nbsp; Before joining CFA Institute, he lead Bloomberg’s finance education division, where he built and launched Bloomberg’s certification product. He began his career as a sell-side equity research analyst in London and, after earning his MBA from Dartmouth worked in the private equity diligence unit of Bain &amp; Company in New York. List to this episode as Rob Shares:His learnings from the worst models he has seen in his career&nbsp;&nbsp;His experience as an Equity AnalystThe CFA Program and why they modified the program to include new contentThe value of FMI's financial modeling content to the new CFA ProgramThe importance of learning about Financial Models His views on why financial models are one of if not the most important corporate decision making tool Sign up for the Advanced Financial Modeler Accreditation or FMI Fundamentals 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. &nbsp; Go to https://earmarkcpe.com , download the app, take the quiz and you can receive CPE credit.&nbsp; Quotes: &nbsp;&nbsp; “Often the best way to learn something is to teach it to others.” “Modeling is just another branch of logic, reason and rationality.” Follow Rob Langrick: &nbsp;&nbsp;&nbsp; LinkedIn - https://www.linkedin.com/in/rob-langrick-cfa-cipm-b16736/ &nbsp; Follow Paul: Website - https://www.thefpandaguy.com/ &nbsp; &nbsp;LinkedIn - https://www.linkedin.com/in/thefpandaguy/Instagram - https://www.instagram.com/thefpandaguy/&nbsp;&nbsp;TikTok - https://www.tiktok.com/@thefpandaguyTwitter - https://twitter.com/TheFPandAGuy&nbsp;YouTube - https://www.youtube.com/@thefpaguy8376 &nbsp;&nbsp; Follow Financial Modeler's Corner&nbsp; LinkedIn Page- https://www.linkedin.com/company/financial-modeler-s-corner/?viewAsMember=trueNewsletter - Subscribe on LinkedIn- https://www.linkedin.com/build-relation/newsletter-follow?entityUrn=7079020077076905984 &nbsp;&nbsp; In today’s episode: &nbsp; (00:22) Intro; (00:48) Welcoming Rob; (01:00) The worst financial model Rob has ever seen ; (02:33) Rob’s key learning experience from the worst financial model ; (04:20) Rob’s background; (06:28) Rob’s experience as an Equity Analyst; (08:53) What motivated Rob to move into Education; (10:27) What lead Rob to join the CFA Institute; (11:55) Roles Rob had at CFA; (14:33 - 15:19) Validate your Financial Modeling Skills with FMI’s Accreditation Program (ad); (15:20) Changes to the Practical Skills Modules; (16:43) People’s response to change; (19:20) Changes apart from Practical Skills; (22:22) The main benefit to Charter Holders; (24:55) Experience with FMI; (26:24) Why is it important for everyone in finance to learn the basics of financial modeling ; (28:33) Rapid Fire; (32:47) Advice to college students; (34:27) Connect with Rob;

Welcome to 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 Financial Modeling Institute (FMI) the most respected accreditations in Financial Modeling globally. In this episode, Paul Barnhurst is joined by three distinguished modeling experts: Colin Human, David Thompson, and Prem Beejan. Colin Human started out his financial career as a 22-year-old chartered accountant in South Africa. Today, he is the CEO of Goalfix and provides financial modeling consulting and training. David Thompson is an independent financial consultant who provides expert financial modeling, financial planning &amp; analysis, independent valuations, strategy, and corporate development services to both the public and private sectors. &nbsp; Prem Beejan is the Chairman at Maubank Holdings LTD and the Co-founder of the Financial Modeling Centre in Mauritius. FMI recently awarded Prem the Master Financial Modeler, and he is one of only 6 people globally to be awarded the designation. Listen to this episode as they share about:&nbsp; How they got started in financial modelingTheir experience and learning from the worst models that they came across&nbsp;Financial modeling over the years and how it has changed.The various Modeling tools used by themThe impact of Generative AI on ModelsThe importance of Formal AccreditationTheir position on controversial modeling issues, including circular references, dynamic arrays, modeling standards, and moreSign up for the Advanced Financial Modeler Accreditation or FMI Fundamentals Today and receive 15% off by using the special show code ‘Podcast’. Visit www.fminstitute.com/podcast and use code Podcast to save 15% when you register. Go to https://earmarkcpe.com , download the app, take the quiz and you can receive CPE credit.&nbsp; &nbsp; Follow Colin Human: &nbsp;&nbsp;&nbsp; Website - https://goalfixglobal.com/staff/colin-human/ LinkedIn - https://www.linkedin.com/in/colin-human-b8072812/ &nbsp; Follow Prem Beejan: &nbsp;&nbsp;&nbsp; Website - https://www.fmcmauritius.com/ LinkedIn - https://www.linkedin.com/in/prem-beejan-msc-mfm-5a921025/ &nbsp; Follow David Thompson: &nbsp;&nbsp;&nbsp; Website - https://tghcorp.com.au/ LinkedIn - https://www.linkedin.com/in/strategy-finance-valuations-modelling/ &nbsp; Follow Paul Barnhurst: Website - https://www.thefpandaguy.com/ &nbsp;&nbsp; LinkedIn - https://www.linkedin.com/in/thefpandaguy/ &nbsp; Instagram - https://www.instagram.com/thefpandaguy/ &nbsp; TikTok - https://www.tiktok.com/@thefpandaguy &nbsp; Twitter - https://twitter.com/TheFPandAGuy &nbsp; YouTube - https://www.youtube.com/@thefpaguy8376 &nbsp; &nbsp; Follow Financial Modeler's Corner&nbsp; LinkedIn Page - https://www.linkedin.com/company/financial-modeler-s-corner/?viewAsMember=true &nbsp; Newsletter - Subscribe on LinkedIn https://www.linkedin.com/build-relation/newsletter-follow?entityUrn=7079020077076905984 &nbsp; &nbsp; Quotes: &nbsp;&nbsp; “ Strategic thinking is really crucial for financial modelers as it allows them to create dynamic, adaptable, insightful models that can support a company's strategy and decision-making . ” - David “ Unquantified strategy is just wishful thinking. It's as simple as that. ” - Colin &nbsp; “ I am not saying that we cannot build models in other tools , t here could be other tools to build financial models , b ut the best, the easiest, the most accepted, the way it's made, the presentation, the reporting , and everything, it's all Excel. ” - Prem &nbsp; In today’s episode: &nbsp; (00:22) Intro; (00:55) Welcoming the Guests - Colin, Prem and David; (01:33) The worst financial model David has ever seen ; (02:31) The worst financial model Colin has ever seen ; (04:16) The worst financial model Prem has ever seen ; (05:44) David’s key learning experience from the worst financial model ; (06:23) Colin’s key learning experience from the worst financial model ; (07:16) Prem’s key learning experience from the worst financial model ; (08:00) David’s background; (09:01) Colin’s background; (10:51) Prem’s background; (13:48) First Model Colin built; (17:10) First Model David built; (19:27) First Model Prem built; (21:55) First Model Paul built; (22:39) Changes seen over the years in Modeling ;&nbsp; (24:52) Tools used in Modeling; (28:19 - 29:05) Validate your Financial Modeling Skills with FMI’s Accreditation Program (ad); (29:06) What kept David interested in Modeling; (31:08) Prem’s take on the impact of Generative AI on Models; (32:24) Colin’s take on the impact of Generative AI on Models; (34:48) David’s take on the impact of Generative AI on Models; (36:20) Important skills to be a great Financial Modeler - David; (37:29) Important skills to be a great Financial Modeler - Colin; (38:53) Important skills to be a great Financial Modeler - Prem; (40:37) The need for Formal Accreditation’s; (43:19) Why Prem decided to earn the designation of Master

Welcome to 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 Financial Modeling Institute (FMI) the most respected accreditations in Financial Modeling globally. In this episode, Paul Barnhurst is joined by Zainab Nwachuku , who is the Managing Director and the lead Financial Modeler of The Intellectual Plug which is a consulting firm in Nigeria that helps founders get ready for funding with investors. &nbsp; Zainab is extremely passionate about financial modeling and hopes more women who are fond of numbers choose to join the profession. &nbsp; Listen to this episode as Zainab shares:&nbsp;Her journey from accounting to financial modelingHer experience and learnings from the worst models she has come across Her experience working with founders to help turn their ideas into a financial model that can help make their dreams a realityThe horror story of linking workbooks in ExcelHer unwavering passion for ModelingHer position on controversial modeling issues, including circular references, dynamic arrays, modeling standards, and moreSign up for the Advanced Financial Modeler Accreditation or FMI Fundamentals Today and receive 15% off by using the special show code ‘Podcast’. Visit www.fminstitute.com/podcast and use code Podcast to save 15% when you register. Go to https://earmarkcpe.com , download the app, take the quiz and you can receive CPE credit.&nbsp; Quotes: &nbsp; “ I feel like you actually have to make those mistakes yourself to even get it to understand because otherwise, you know, how do you even know that o h, it's not a model ?” “ Simply being able to actually build a financial model has really taught me a lot about communication. ” &nbsp; “ If you're not listening to the founder, whether or not they can implement some strategies i f you don't understand that from the founder, the model isn't going to make sense .” Follow Zainab: &nbsp;&nbsp;&nbsp; Website - https://theintellectualplug.com/ LinkedIn - &nbsp;https://www.linkedin.com/in/mszainababu/ &nbsp; Follow Paul: Website - https://www.thefpandaguy.com/ LinkedIn - https://www.linkedin.com/in/thefpandaguy/ Instagram - https://www.instagram.com/thefpandaguy/ TikTok - https://www.tiktok.com/@thefpandaguy Twitter - https://twitter.com/TheFPandAGuy YouTube - https://www.youtube.com/@thefpaguy8376 Follow Financial Modeler's Corner&nbsp; LinkedIn Page - https://www.linkedin.com/company/financial-modeler-s-corner/?viewAsMember=true &nbsp; Newsletter - Subscribe on LinkedIn https://www.linkedin.com/build-relation/newsletter-follow?entityUrn=7079020077076905984 &nbsp; Must follow LinkedIn Profiles: &nbsp; Financial Modeling World Cup https://www.linkedin.com/company/financial-modeling-world-cup/ &nbsp; Financial Modeling Institute https://www.linkedin.com/company/fminstitute/ &nbsp; Chris Reilly https://www.linkedin.com/in/chris-reilly-mission-capital/ &nbsp; Danielle Stein Fairhurst https://www.linkedin.com/in/daniellesteinfairhurst/ Hedieh Kianyfard https://www.linkedin.com/in/hediehkianyfard/ &nbsp; Lance Rubin https://www.linkedin.com/in/financial-modelling/ &nbsp; Giles Male https://www.linkedin.com/in/giles-male-30643b15/ In today’s episode: &nbsp; (00:22) Intro; (00:51) Welcoming Zainab; (01:06) The worst financial model Zainab has ever seen ; (02:27) Zainab’s key learning experience from the worst financial model ; (03:30) Zainab’s background; (05:00) What is fun and challenging about Modeling; (07:05) About the Financial Modeling Group for women;&nbsp; (09:50) Women in Modeling; (11:17) About The Intellectual Plug; (12:38) Common Company challenges;&nbsp; (14:21) Funding routes for Start-ups in Nigeria; (16:10 - 16:57) Validate your Financial Modeling Skills with FMI’s Accreditation Program (ad); (16:58) What does Zainab love about working with these start-ups; (18:36) Challenges Zainab faced to build a model for early stage companies; (20:57) Advice on building models for early stage companies; (24:16) Rapid Fire; (28:07) Nugget on Financial Modeling; (29:45) Connect with Zainab; (30:30) Paul’s best picks&nbsp;The way Zainab talks about terrible models.The way she communicates her journey of building models.The horror story of workbooksAnd her incredible passion for Modeling.&nbsp; (32:00) Rapid Fire: The Pattern So Far; (35:18) Must Follow LinkedIn Profiles (37:22) CPE Credit (37:40) Outro &nbsp;

Welcome to 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 Financial Modeling Institute (FMI), the most respected accreditations in Financial Modeling globally. In this episode, your host, Paul Barnhurst is joined by 4 fabulous guests, namely, Jeff Robson, Danielle Stein Fairhurst, Craig Hatmaker &amp; Ian Schnoor. They are all highly accomplished and respected modelers in the Financial Modeling profession. In this episode they share thoughts on Dynamic Arrays and LAMBDAs. &nbsp; Jeff is a Financial Modeler, Business Analyst, International Trainer &amp; Presenter. Danielle is a Financial Modeler, Author, and Corporate Trainer based in Australia. Craig is a retired Financial Modeler and is a 5G (fifth generation) modeling enthusiast, and Ian is the&nbsp;Executive Director at the Financial Modeling Institute (FMI), which is also the sponsor of this Podcast. &nbsp; Listen to this episode as the guests talk about: Why it is important to keep current on the latest developments in modelingLAMBDAs what they are and how they could revolutionize financial modelingDynamic Arrays, what they are, how they work, and what it is like to build a model using Dynamic ArraysHow Dynamic Arrays will make auditing models easierThe guest's favorite Dynamic Array formulas Sign up for the Advanced Financial Modeler Accreditation or FMI Fundamentals Today and receive 15% off by using the special show code ‘Podcast’. Visit www.fminstitute.com/podcast and use code Podcast to save 15% when you register. Go to https://earmarkcpe.com , download the app, take the quiz and you can receive CPE credit with this episode. Follow Jeff Robson: Linkedin: https://www.linkedin.com/in/jeffrobson/ Website: www.accessanalytic.com.au YouTube: https://www.youtube.com/@AccessAnalytic Follow Danielle Stein Fairhurst: Linkedin: https://www.linkedin.com/in/daniellesteinfairhurst/ Website: https://plumsolutions.com.au/ Upcoming Events for Danielle Stein FairhurstDanielle is speaking at the global excel summit - Global Excel Summit 2024 | Microsoft Excel Event | WelcomeUpcoming webinar on Scalable models - https://www.linkedin.com/events/scalablemodelling-usingmsfabric7106464501708840960/ Follow Craig Hatmaker: Linkedin: https://www.linkedin.com/in/craig-hatmaker-4449879/ Website: https://sites.google.com/site/beyondexcel/home YouTube: https://www.youtube.com/@CraigHatmakerBXL Building with Fast + 5G- https://www.youtube.com/watch?v=8Zl3yURsvdE&amp;t=1s Demo using 5G Components- Intro 5G - Watch an Excel Model do something incredible using 5G methods - YouTube Gist site to download Craig Hatmakers LAMBDAs for 5G modeling- https://gist.github.com/CHatmaker Follow Ian Schnoor: Linkedin: https://www.linkedin.com/in/ianschnoor/ Website: https://fminstitute.com/ Follow Paul: Website - https://www.thefpandaguy.com/ &nbsp;&nbsp; LinkedIn - https://www.linkedin.com/in/thefpandaguy/ &nbsp; Instagram - https://www.instagram.com/thefpandaguy/ TikTok - https://www.tiktok.com/@thefpandaguy Twitter - https://twitter.com/TheFPandAGuy YouTube - https://www.youtube.com/@thefpaguy8376 &nbsp; Follow Financial Modeler's Corner&nbsp; LinkedIn Page - https://www.linkedin.com/company/financial-modeler-s-corner/?viewAsMember=true Subscribe to our Newsletter- https://www.linkedin.com/build-relation/newsletter-follow?entityUrn=7079020077076905984 &nbsp; &nbsp; Quotes: &nbsp; “Python brings a suite of libraries that can do some amazing things.” &nbsp; “You don’t have to learn Python, Dynamic Arrays, or LAMBDAs for Financial Modeling, but you need to know it exists to stay relevant.” “ Dynamic arrays force you to have consistent formulas. ” “ LAMBDAs are functions that write functions using native excel functions. ” “Learn the basics and start experimenting.” &nbsp; In today’s episode: &nbsp; (00:22) Intro; (00:39) Introduction of Guests; (03:30) Take on Python into Excel ; (06:49) Addressing Security Issues ; (07:32) What are Dynamic Arrays ; (09:58) Use case of Dynamic Arrays; (11:45) What is LAMBDA; &nbsp; (18:20) FMI exams and Dynamic Arrays; (21:57) LAMBDAs for 5G modeling ; (24:13) How to use 5G modeling;&nbsp; (26:29 - 27:15) Validate your Financial Modeling Skills with FMI’s Accreditation Program (ad); (28:59) Auditing Dynamic Array Models; (33:30) Favorite spillable functions; (36:58) The potential of a standard to use LAMBDAs and Dynamic Arrays; (39:45) AI building Models; (44:20) Advice for the audience; (46:59) Advice on LAMBDAs; (49:15) Advice for Modelers; (51:42) Connect with Jeff, Danielle, Craig &amp; Ian (52:57) Outro &nbsp;&nbsp;&nbsp;&nbsp;

Welcome to 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 Financial Modeling Institute (FMI) the most respected accreditations in Financial Modeling globally. In this episode, Paul Barnhurst is joined by Hedieh Kianyfard, who is the founder of Finexmod. This is the website where Hedieh shares her views on financial modeling and shows that it’s possible to have fun with finance. Hedieh is passionate about economic development and aims to make financial modeling easy and fun for everyone. Listen to this episode as Hedieh shares: Her journey and background in financial modeling Her experience and learning from the worst models that she came across How Hedieh considers Modeling as a great career and more than a stepping stone. Responsibility as a modeler to reject bad projects and help ensure good projects are accepted. Everything about her book- Financial Modeling Detective 10 Financial Modeling Commandments Why people should avoid circular references – hint they are the devil 😊 The importance of having a decision-making mindset Her position on controversial modeling issues, including circular references, dynamic arrays, modeling standards, and more Sign up for the Advanced Financial Modeler Accreditation or FMI Fundamentals 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. Quotes: “A Financial Modeler is like a Fortune Teller.” “Modeling is a great career and more than a stepping stone.” “ It’s important to put yourself, in the end, users' shoes to understand their needs better. ” “ As modelers we have a responsibility to reject bad projects and help ensure good projects are accepted. ” Follow Hedieh: Website - https://www.finexmod.com/ LinkedIn - http://linkedin.com/in/hediehkianyfard Instagram - https://instagram.com/finexmod Facebook - https://m.facebook.com/people/Finexmod/100063965894693/ Youtube - https://youtube.com/@FinancialModelDetective The Interpolate-Lookup function as explained by Professor Edward Bodmer- https://edbodmer.com/interpolate-lookup-function/ Financial Model Detective Book: Financial Model Detective: Hints and tricks for review of financial models: Kianyfard, Hedieh: 9781074174606: Amazon.com: Books &nbsp;Follow Paul: Website - https://www.thefpandaguy.com/ LinkedIn - https://www.linkedin.com/in/thefpandaguy/ Instagram - https://www.instagram.com/thefpandaguy/ TikTok - https://www.tiktok.com/@thefpandaguy Twitter - https://twitter.com/TheFPandAGuy YouTube - https://www.youtube.com/@thefpaguy8376 Follow Financial Modeler's Corner LinkedIn Page - https://www.linkedin.com/company/financial-modeler-s-corner/?viewAsMember=true Newsletter - Subscribe on LinkedIn https://www.linkedin.com/build-relation/newsletter-follow?entityUrn=7079020077076905984 &nbsp;In today’s episode: (00:22) Intro; (00:45) Welcoming Hedieh;(01:06) The worst financial model Hedieh has ever seen ;(03:26) Hedieh’s key learning experience from the worst financial model ;(06:23) Hedieh’s background;(09:35) About Hedieh’s website - Finexmod(10:23) About Hedieh’s book - Financial Modeling Detective(12:25) Why is it important to have someone audit Financial Models(16:12) Financial Model Ten Commandments(17:31) Rule 9 - Why people should avoid circular references(19:21) Rule 10 - The Modeler shouldn’t be selfish(21:15 - 22:02) Validate your Financial Modeling Skills with FMI’s Accreditation Program (ad); (22:03) The decision makers mindset; (26:31) How to develop that decision making mindset; (28:30) What is the process of infrastructure project; (30:58) Rapid Fire; (35:31) When did Hedieh realize Financial Modeling as a career (37:31) Connect with Hedieh; (38:32) Paul’s best picks: (40:50) CPE Credit with this episode; (41:20) Outro...

Welcome to 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 Financial Modeling Institute (FMI), the most respected accreditations in Financial Modeling globally. In this episode, Paul Barnhurst is joined by Chris Reilly, who is the founder of Financial Modeling Education. Chris spent many years working in private equity, and today, he runs his own business focused on providing financial modeling education and financial modeling consulting services. &nbsp; Chris is very passionate about Financial Modeling and helping others learn to build robust financial models focused on the 3-financial statements. &nbsp; Listen to this episode as Chris shares: The worst model he ever built; hint it involves using his phone :)His journey and background into ModelingThe importance of simple, uncomplicated model designHow being a part of a financial modeling community like FMI can help modelersThe revolver approach for managing cash and why it is important in modelingThe benefits and challenges of using EBITDA to value a companyHis position on controversial modeling issues, including circular references, dynamic arrays, modeling standards, and more Sign up for the Advanced Financial Modeler Accreditation or FMI Fundamentals Today and receive 15% off by using the special show code&nbsp;Podcast. Visit www.fminstitute.com/podcast and use code Podcast to save 15% when you register. &nbsp; Follow Chris: &nbsp; &nbsp; Website - https://www.financialmodelingeducation.com/ LinkedIn -&nbsp; https://www.linkedin.com/in/chris-reilly-mission-capital/ Newsletter -&nbsp; https://financialmodelingeducator.com/Follow Financial Modeler's Corner LinkedIn Page &amp; Subscribe to NewsletterLinkedin Page -&nbsp; https://www.linkedin.com/company/financial-modeler-s-corner/?viewAsMember=true LinkedIn Newsletter - https://www.linkedin.com/build-relation/newsletter-follow?entityUrn=7079020077076905984 Follow Paul: Website - https://www.thefpandaguy.com/ LinkedIn - https://www.linkedin.com/in/thefpandaguy/ Instagram - https://www.instagram.com/thefpandaguy/ TikTok - https://www.tiktok.com/@thefpandaguy Twitter - https://twitter.com/TheFPandAGuy YouTube - https://www.youtube.com/@thefpaguy8376 Quotes: “ A poor design leads to a poor output. ” &nbsp; “ Schedules feed the structure. Once you have that dialed in your head you can build whatever you want. ” “ It’s nice to have a community where you can get some live feedback on your search as opposed to going down the internet rabbit hole. ” “To learn to be a modeler you need to model. Spend time finding ways to improve your modeling skills.” In today’s episode: (00:22) Intro; (00:47) Welcoming Chris Reilly; (01:00) The worst financial model Chris has ever seen ; (03:01) Chris’s takeaway from the worst financial model ; (05:56) Chris ’s background; (07:40) What Chris wished he had known that he knows now; (11:52) FMI’s Premier Modeling Community; (14:33 - 15:20) Validate your Financial Modeling Skills with FMI’s Accreditation Program (ad); (15:21) Hardest concept for people to grasp; (18:23) Reasons why balance sheets do not work; (20:00) The Revolver Approach; (21:48) The most important skill to build a Financial Model; (23:22) The value of EBITDA and its pitfalls; (29:07) Rapid Fire; (31:35) Chris’s take on Circular References (33:23) Nugget on how to become a better modeler; (36:36) Connect with Chris; (37:48) Paul’s best picks- how Chris learned from his initially not so perfect models and how those mistakes helped him become the best educator. (38:56) CPE Credit with this episode; (39:07) Outro. &nbsp; Go to https://earmarkcpe.com , download the app, take the quiz and you can receive CPE credit.

Welcome to 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 Financial Modeling Institute (FMI) the most respected accreditations in Financial Modeling globally. In this episode, Paul Barnhurst is joined by David C. Brown, an Associate Professor of Finance. David focuses on teaching finance and financial modeling, bringing his real-world experience to the classroom with his students. He is also heavily involved in helping students improve Excel skills, including running the Microsoft Excel Collegiate Championship (MECC) He is very passionate about research and his work has been highlighted by the Wall Street Journal and MarketWatch. &nbsp; Listen to this episode as David shares: His journey and background into Modeling His experience starting and running the Microsoft Excel Collegiate Challenge How Financial Modeling competitions help you grow and learn The key differences between modeling for competition and modeling for work His learning from his research and years of experience How he would structure the college finance program if he were in charge His latest research on Target Date Funds and how they perform relative to other retirement portfolios His position on controversial modeling issues, including circular references, dynamic arrays, modeling standards, and more Sign up for the Advanced Financial Modeler Accreditation or FMI Fundamentals Today and receive 15% off by using the special show code podcast. Visit www.fminstitute.com/podcast and use code podcast&nbsp;to save 15% when you register. Go to https://earmarkcpe.com , download the app, take the quiz and you can receive CPE credit. &nbsp; Follow David: &nbsp; YouTube - https://www.youtube.com/@docbrownexcels &nbsp; Website - https://www.davidclaytonbrown.com/ E-mail - [email protected] &nbsp; · &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; To learn more about Microsoft Excel Collegiate Challenge, visit this website- https://mecc.college/ &nbsp; Follow Paul: Website - https://www.thefpandaguy.com/ LinkedIn - https://www.linkedin.com/in/thefpandaguy/ Instagram - https://www.instagram.com/thefpandaguy/ TikTok - https://www.tiktok.com/@thefpandaguy Twitter - https://twitter.com/TheFPandAGuy YouTube - https://www.youtube.com/@thefpaguy8376 &nbsp; Quotes: “ Collegiate Challenge is not about being the best, its about challenging yourself, learning more and getting better at it. ” &nbsp; “ If you understand Python you can figure out Excel. ” “ Excel is the way to get people into data analytics. ” “ Challenge the assumptions, challenge the model and eventually figure out whats wrong. ” &nbsp; In today’s episode: (00:22) Intro; (00:45) Welcoming David Brown; (01:25) The worst financial model David has ever seen ; (03:17) David’s take away from the worst financial model ; (06:08) David ’s background; (10:05) How David decided to become a Finance Professor ; (12:39 - 13:25) Validate your Financial Modeling Skills with FMI’s Accreditation Program (ad); (13:27) What is the Microsoft Excel Collegiate Challenge; (17:20) Excel Tables; (19:17) Advice to students willing to participate in these competitions; (21:33) David’s experience with these competitions; (24:47) How to help students with a hands on experience to building models; (27:04) David’s suggestion to changes in college curriculum; (29:07) Financial Modeling for competitions vs. Building it for clients; (31:10) David’s learning from his research; (37:58) Rapid Fire; (42:19) Nugget on how to become a better modeler; (43:57) Connect with David; (44:50) Paul’s best picks – &nbsp;&nbsp;&nbsp;&nbsp;&nbsp; How David wishes to teach the college program for Finance (45:23) CPE Credit with this episode; (45:40) Outro. &nbsp;

Welcome to 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 Financial Modeling Institute (FMI)&nbsp; the most respected accreditations in Financial Modeling globally. In this episode, Paul Barnhurst is joined by Diarmuid Early, one of the best modelers in the world and, the&nbsp;Founder of Early Days Consulting. He is a&nbsp;regular competitor in the Financial Modeling World Cup (FMWC) and is often referred to as the Michael Jordan of financial modeling for his impressive results. He is the winner of the 2021 FMWC and a runner-up in the 2020 and 2022 editions. Listen to this episode as&nbsp;Diarmuid&nbsp;shares: His journey and background into ModelingHow Financial Modeling competitions help you grow and learnThe key differences between modeling for competition and modeling for workHis practical advice on how to build a 3-statement modelHow assumption ambiguity and structural ambiguity impact your model.His position on controversial modeling issues including circular references, dynamic arrays, modeling standards and more Financial Modeler’s Corner is sponsored by the Financial Modeling Institute Sign up for the Advanced Financial Modeler Accreditation or FMI Fundamentals Today and receive 15% of by using the special show code FMC15. Visit&nbsp; www.fminstitute.com/podcast &nbsp;and&nbsp;use code FMC15&nbsp;to save 15% when you register. Go to&nbsp; https://earmarkcpe.com , download the app, take the quiz and you can receive CPE credit for listening to the episode. Follow Diarmuid: &nbsp;&nbsp; YouTube -&nbsp; https://www.youtube.com/@DimEarly/ &nbsp;&nbsp; LinkedIn -&nbsp; https://www.linkedin.com/in/diarmuidearly Stream the events of FMWC live on YouTube by visiting -&nbsp; Financial Modeling World Cup&nbsp;&nbsp;Link to the next streaming session on July 27th at 9 AM MST of which Paul Barnhurst will be a part -&nbsp; Battle VII - Road to Las Vegas 2023 (Excel Esports)&nbsp; Follow Paul: Website -&nbsp; https://www.thefpandaguy.com/ LinkedIn -&nbsp; https://www.linkedin.com/in/thefpandaguy/ Instagram -&nbsp; https://www.instagram.com/thefpandaguy/ TikTok -&nbsp; https://www.tiktok.com/@thefpandaguy Twitter -&nbsp; https://twitter.com/TheFPandAGuy YouTube -&nbsp; https://www.youtube.com/@thefpaguy8376 Quotes: “You need to have certain discipline around what you want your model to do.” “Getting better at excel has been more valuable than getting better known by winning the FMWC.” &nbsp;&nbsp; “ Do terribly struggle for an hour and a half with what should have been a 30-minute question, but eventually get it out. You'll learn a ton from that. ” “ The big value in the competition is a learning opportunity and you don't need to train to start learning. ” “ The person who is most valuable as a financial modeler is the one who can tell you what are good assumptions to make. ”&nbsp;&nbsp; In today’s episode: (00:22) Intro; (00:45) Welcoming Diarmuid; (01:16)&nbsp; The worst financial model Diarmuid has ever seen ; (04:13)&nbsp; Diarmuid’s take away from the worst financial model ; (07:45)&nbsp; Diarmuid ’s background; (09:45) How&nbsp; Diarmuid became interested in Financial Modeling Competitions ; (11:48) How Diarmuid felt after winning the competition; (12:51) What Diarmuid enjoys about competing; (18:05) Financial Modeling for competitions vs. Building it for clients; (22:37 - 23:23) Validate your Financial Modeling Skills with FMI’s&nbsp; Accreditation Program&nbsp;(ad); (23:30) Diarmuid’s top advice for competitions; (25:10) Rapid Fire; (29:45) Nugget on how to become a better modeler; (34:40) Connect with Diarmuid; (35:40) About FMWC; (37:55) CPE Credit with this episode; (38:30) Outro;

Welcome to 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 Financial Modeling Institute (FMI),&nbsp; the most respected accreditations in Financial Modeling globally.In this episode, Paul Barnhurst is joined by David Brown, the Managing Partner of D Brown Consulting&nbsp;and one of the most respected financial modelers, consultants, and educators in the field of finance with offices on multiple continents. Listen to this episode as David shares: His journey and background into ModelingHow to find your passion and be willing to put yourself out thereHow he learned he had a passion for teaching at a young ageHow intuition is a good place to start, but the model helps validate hunches and numbersHow he explains the balance sheet without using numbers to non-finance peopleWays to embrace AI and use it to be more efficient in the work you do. His position on controversial modeling issues, including circular references, dynamic arrays, modeling standards, and moreFollow David:&nbsp;Website - https://www.dbrownconsulting.net/&nbsp;Twitter -&nbsp;https://twitter.com/dbrownanalyst&nbsp;Instagram -&nbsp;https://www.instagram.com/dbrownconsulting/&nbsp;YouTube - https://www.youtube.com/c/dbrownconsultingdbrownconsultingtv&nbsp;&nbsp;To learn more about David Brown and his offerings, see below:Learn more about dbrownconsulting and their practices and methodologies for working with data, by following this link:&nbsp; https://youtu.be/4qp8f3u3NvMTake your financial modeling skills to new heights with&nbsp;dbrownconsulting’s Advanced Financial Modeler Certificate Course!

Welcome to 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 Financial Modeling Institute (FMI)&nbsp; the most respected accreditations in Financial Modeling globally. In this first episode, Paul Barnhurst is joined by Ian Schnoor, the Executive Director of the Financial Modeling Institute and one of the foremost educators on financial modeling globally. Listen to this episode as Ian shares: ·&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; What it was like in the early days of financial modeling·&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Why FMI created a financial modeling accreditation in the first place ·&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; The importance of Financial Modeling as a profession·&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; How FMI created a community to help all modelers find the best resources and elevate the profession in the processFollow Ian:Website - https://fminstitute.com/ E-mail - [email protected]&nbsp; &nbsp;&nbsp; LinkedIn - <span style="font-size:14.0pt; mso-bidi-font-size:11.0pt;line-height:115%;mso-ascii-font-family:Arial; mso-fareast-font-family:Arial;mso-hansi-font-family:Arial;mso-bidi-font-family:...