Financial Modeler's Corner

Follow Financial Modeler's Corner
Share on
Copy link to clipboard

Financial Modeler's Corner is a podcast where we talk all about the art and science of financial modeling with distinguished Financial Modeler's from around the globe. Financial Modeler's Corner is hosted by Paul Barnhurst a global thought leader in the field of finance.  The Financial Modeler's Corner podcast is brought to you by Financial Modeling Institute. FMI offers the most respected accreditations in financial modeling. 

Paul Barnhurst


    • Jun 11, 2024 LATEST EPISODE
    • every other week NEW EPISODES
    • 44m AVG DURATION
    • 30 EPISODES


    Search for episodes from Financial Modeler's Corner with a specific topic:

    Latest episodes from Financial Modeler's Corner

    Secrets to Building Error-Free Financial Models with Cameron And Nicholas Hay

    Play Episode Listen Later Jun 11, 2024 47:05


    Welcome to the Financial Modeler's Corner (FMC), where we discuss the Art and Science of Financial Modeling with your host Paul Barnhurst.Financial Modeler's Corner is sponsored by the Financial Modeling Institute (FMI), the most respected accreditation in Financial Modeling globally.In today's episode, Paul engages in a conversation with Cameron and Nicholas Hay to discuss dynamic arrays in financial modeling. Cameron and Nicholas share their experiences and insights on using dynamic arrays to build fully dynamic models, avoiding common pitfalls, and the benefits of this approach.Cameron and Nicholas are seasoned financial modeling experts and co-founders of Finomatic Consulting. Their practical advice and innovative tips have helped countless professionals enhance their modeling skills.Key takeaways from this week's episode include:Use dynamic arrays to reduce the number of formulas and potential error points. Clearly separate inputs, calculations, and outputs into distinct sheets. This enhances clarity and ease of use.Ensure uniform column and row structures across sheets. This consistency minimizes errors and simplifies formula management, making models easier to audit and understand.Mixing traditional Excel formulas with dynamic arrays reduces the benefits. A complete commitment ensures better performance and error reduction.Using graphs and charts helps quickly identify trends and anomalies, making it easier to ensure realistic assumptions and accurate models.Establishes a solid foundation, ensuring you learn best practices early on, which prevents the development of bad habits and enhances overall modeling skills.Implementing dynamic arrays can drastically reduce the file size and complexity of models, making them more efficient and manageable.Issues like mixed calculations and unrealistic assumptions emphasize the importance of thorough checks and realistic inputs in financial modeling.Download a sample fully dynamic 3-statement model Excel Files — The FP&A Guy (thefpandaguy.com) courtesy of Cameron and Nicolas Hay. Quotes:Here are a few relevant quotes from the episode on financial analysis and modeling:"A blank Excel workbook doesn't have any errors in it until you add data and formulas. Minimizing the number of formulas should reduce the error potential of the file.”“With business, if you can understand how cash flows around a business, that's you can get in and really understand a business.”“If you're going to dip your toe into dynamic arrays, you've got to make sure you commit fully with 100% commitment.”Sign up for the Advanced Financial Modeler Accreditation Today and receive 15% off by using the special show code ‘Podcast'. Visit www.fminstitute.com/podcast and use code “Podcast” to save 15% when you register.  Go to https://earmarkcpe.com, download the app, take the quiz and you can receive CPE credit. View and download the Financial Modeling Code at financial-modelling-code.ashx...

    Golden Rules to Prevent Excel Disasters in Financial Modeling with Gary Knott

    Play Episode Listen Later Jun 4, 2024 44:02


    Welcome to the Financial Modeler's Corner (FMC), where we discuss the Art and Science of Financial Modeling with your host Paul Barnhurst.Financial Modeler's Corner is sponsored by the Financial Modeling Institute (FMI), the most respected accreditation in Financial Modeling globally.In today's episode, Paul engages in a conversation with Gary Knott, to discuss invaluable insights and tips on avoiding common Excel pitfalls, structuring workbooks for success, and the importance of consistency and clarity.Gary is a seasoned financial modeling expert and author of "Avoid Excel Horror Stories." He shares his golden ground rules for Excel modeling. With a background at Deloitte and his successful consultancy, Gary's practical advice and innovative tips have helped countless professionals enhance their modeling skills.Key takeaways from this week's episode include:Organize workbooks with clear, logical structures. Separate inputs, calculations, and outputs into distinct sheets. Use consistent naming conventions and separator sheets to enhance clarity and ease of use.Maintaining a consistent design throughout the workbook. Use uniform column and row structures across sheets. Consistency minimizes errors and simplifies formula management, making models easier to audit and understand.Formal training in financial modeling is crucial. It establishes a solid foundation, ensuring you learn best practices early on, which prevents the development of bad habits and enhances overall modeling skills.Real-life horror stories highlight common errors, such as improper data copying and pasting. Ensuring consistent data formats and understanding the intricacies of your calculations are essential to avoid costly mistakes.Use Macros for repetitive tasks like generating output sheets, not for complex calculations. They help automate processes and reduce manual errors but should be applied judiciously to maintain model integrity.Implement data validation to restrict inputs. This minimizes user errors by ensuring only valid data entries are made, such as positive numbers or specific date ranges, enhancing the reliability of your models.Regularly test models to ensure accuracy. Use master check sheets to consolidate checks and quickly identify errors. This proactive approach helps maintain the model's integrity and reliability over time.Quotes:Here are a few relevant quotes from the episode on financial analysis and modeling:"Consistency is key." I think of all the rules there are, that's the one. If you follow that one, that can bring you a long way in terms of getting a reliable model.“Certainly, getting trained early, not trying to learn it yourself, but taking some formal training course so you can learn the basics.”“I'm always a very keen fan of putting checks in models, collating them all on a master check sheet, and then adding them all up.”"If the difference is zero, then your balance sheet balances. You can send that through to a master check sheet. Then if you add them all up, all the checks up and they're totally zero, then you haven't identified any issues"Sign up for the Advanced Financial Modeler Accreditation Today and receive 15% off by using the special show code ‘Podcast'. Visit www.fminstitute.com/podcast and use code “Podcast” to save 15% when you register.  Go to

    Unlocking Financial Model Secrets and Advanced Techniques with Stephen Aldridge

    Play Episode Listen Later May 21, 2024 45:49


    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...

    Financial Modeling Techniques for Global FP&A Success with Carolina Lago

    Play Episode Listen Later May 7, 2024 42:01


    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....

    Embracing Skepticism To Enhance Financial Modeling Techniques With Geoff Robinson

    Play Episode Listen Later Apr 23, 2024 49:24


    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...

    How Simplicity In Financial Modeling Enhances Decision Making

    Play Episode Listen Later Apr 9, 2024 51:37


    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...

    Unraveling the Mystery: Roderick Mckinley's Guide to Navigating Tokenomics

    Play Episode Listen Later Mar 28, 2024 44:22


    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 -

    Shaping Business Strategy: Ian Bennett's Insights on What Makes for a Great Financial Modeler

    Play Episode Listen Later Mar 14, 2024 46:34


    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-

    Mastering SaaS Models: Derek Baker's insights on building robust SaaS models

    Play Episode Listen Later Feb 29, 2024 38:02


    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; (02:41) Derek' s background; (04:41) Experience and Challenges while building the first Financial Model; (07:20) What Derek thinks was missing from Finance Education in school?; (10:13) What is it that Derek likes about SaaS and SaaS companies?; (12:31) Key inputs in SaaS Revenue Models; (15:08) What is the first tool that SaaS Startups must invest in?; (16:40 - 17:25) Validate your Financial Modeling Skills with FMI's Accreditation Program (ad ) ; (17:26) Building a Three Statement Model - SaaS vs other Industries; (19:00) Building Deferred Revenue; (21:56) How to get started with building SaaS Models?; (24:05) How often does Derek use Dynamic Arrays?; (27:20) One thing that helped Derek in building Financial Models; (29:20) Technical advice that can help people become better Modelers; (32:26) Derek's favorite Excel Shortcut; (32:58) Rapid Fire; (36:09) Nugget; (36:55) Connect with Derek; (37:21) Outro;

    Beyond the Numbers: Lance Rubin's Insights on AI, Power BI, and the Future of Financial Modeling

    Play Episode Listen Later Feb 15, 2024 49:03


    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;

    Beyond the Classroom: Why Learning Excel is an Investment for your Career 

    Play Episode Listen Later Feb 1, 2024 60:18


    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 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; (01:34) A clip with Andrew Ngai ; (02:00) Interview with Andrew Grigolyunovich ; (11:46) Interview with Paul Wagner ; (17:12) Interview with Sarah ; (22:12 - 22:58) Validate your Financial Modeling Skills with FMI's Accreditation Program (ad ) ; (22:59) Introduction to Students Clips Section ; (24:30) Interview with Tess Patton and Spencer Angell ; (39:57) Interview with Kameron ; (43:56) Interview with Daniel; (46:37) Interview with Mikayla & Carson ; (52:20) Clip from the Team of Utah; (58:43) Outro;

    From Campus to Spreadsheet: The Microsoft Excel Collegiate Challenge Journey

    Play Episode Listen Later Jan 18, 2024 55:26


    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: 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: “[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 David Brown “ [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 Benjamin Weber 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 Oz du Soleil : YouTube - https://www.linkedin.com/in/ozdata/ LinkedIn - https://www.youtube.com/channel/UCZgOVykPoRbSZQfY9YysiRQ Follow Jon Acampora : Website - https://www.excelcampus.com/ LinkedIn - https://www.linkedin.com/in/jonacampora Follow David Brown: LinkedIn - https://www.linkedin.com/in/dr-david-c-brown/?trk=public_post_feed-actor-name 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&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 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: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.

    Precision in Modeling: Sam Sivarajan's Wisdom on Balancing Art, Science, and Decision-Making

    Play Episode Listen Later Jan 4, 2024 41:36


    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. Sam's work is focused on how we can make better decisions so that we can get to better results – in investing, in leadership, and in our personal lives. 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: “ 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 . ” “ 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...... ” 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. Am I Ok? - https://www.amazon.co.uk/Am-Essential-Questions-Investors-Financial-ebook/dp/B0CKY6XB4K?ref_=ast_author_mpb Uphill - https://www.amazon.co.uk/Uphill-Ancient-Science-Choices-Challenges-ebook/dp/B0BGMJX9VN?ref_=ast_author_dp&dib=eyJ2IjoiMSJ9.fVxD2IJYvz1m0ZgBXJmkb595Ei0TtF8Wjx2TMOwZWzVdTmpjGxlD9-zbKVPzvrFn.gUxmNYfh-t6jXwKbr2EqugQZ4LBWXPOLoX6DrlNEsU0&dib_tag=AUTHOR Follow Sam: Website - https://www.samsivarajan.com/ LinkedIn - https://ca.linkedin.com/in/samsivarajan Podcast - https://www.samsivarajan.com/podcast Twitter - https://twitter.com/SamSivarajan Sam's books: Making your Money Work - https://www.amazon.co.uk/Making-Your-Money-Work-Financial-ebook/dp/B0B36PDQLX?ref_=ast_author_dp&dib=eyJ2IjoiMSJ9.fVxD2IJYvz1m0ZgBXJmkb595Ei0TtF8Wjx2TMOwZWzVdTmpjGxlD9-zbKVPzvrFn.gUxmNYfh-t6jXwKbr2EqugQZ4LBWXPOLoX6DrlNEsU0&dib_tag=AUTHOR 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: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

    Exclusive Talk: Dave Hallwood, Giles Male, and Rafaël Le Saux Explore Being a Better Financial Modeler and Financial Modeling Certifications

    Play Episode Listen Later Dec 21, 2023 51:51


    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 LinkedIn Live, Paul Barnhurst is joined by three amazing Modelers, Dave Hallwood, Giles Male and Rafa ë l Le Saux. 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 & 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. Listen to this episode as the guests talk about: Their experiences in Modeling. 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: “this job is about people, it's about talking to people, it's about giving them information instead of data” “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.” "Simple is hard, complex is easy" 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 Dave: LinkedIn - https://www.linkedin.com/in/david-hallwood-fcca-87270449/ Follow Giles: 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/ Follow Paul: Website - https://www.thefpandaguy.com/ LinkedIn - https://www.linkedin.com/in/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 In today's episode: (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

    From Classroom to Certification: Andy Temte's Unique Perspective on Financial Modeling

    Play Episode Listen Later Dec 7, 2023 40:48


    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 . 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. 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. This blend of higher education and professional education experience gives Dr. Temte a unique perspective when it comes to financial education and financial modeling Listen to this episode as Andy shares: 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: “FMI is one of the only institutes that's delivering a truly experiential credentialing process.” “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. Go to https://earmarkcpe.com , download the app, take the quiz and you can receive CPE credit. Follow Andy Temte: LinkedIn - https://www.linkedin.com/in/atemte/ Podcast - Balancing Act Website - https://www.andrewtemte.com/ Andy's books: Balancing Act - https://www.amazon.com/Audible-Balancing-Act/dp/B0CFCZT4HN/ref=sr_1_2?crid=17K8UI3208G9Q&keywords=Andy+Temte&qid=1701342458&sprefix=andy+temte%2Caps%2C150&sr=8-2 The Balanced Business: Building Organizational Trust and Accountability through Smooth Workflows - https://www.amazon.com/Balanced-Business-Organizational-Accountability-. 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 In today's episode: (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.

    Special Bonus Episode: Run the Numbers by CJ Gustafson

    Play Episode Listen Later Nov 30, 2023 51:23


    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

    How Financial Modelers build a goldilocks “Just-right” Financial Model with Brian Egger

    Play Episode Listen Later Nov 22, 2023 40:06


    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 . Brian is the Global Head of Financial Modeling, Senior Gaming/Lodging Analyst at Bloomberg Intelligence. 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. 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. Listen to this episode as Brian shares: 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: “ Models should be dynamic and not static, they should be integrated and not sort of siloed pieces not speaking to each other. ” " 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. ” “ The CFA exam prepares you in many ways to be a capable securities analyst. ” 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. 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&AGUY10' . Go to https://earmarkcpe.com, download the app, take the quiz and you can receive CPE credit. Follow Brian Egger: LinkedIn - https://www.linkedin.com/in/brianegger/ 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 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 In today's episode: (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.

    From Rocks to Riches: The Power of Financial Models in the Mining Industry with Emilie Williams

    Play Episode Listen Later Nov 9, 2023 40:49


    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. 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. 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. Listen to this episode as Emilie shares: 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: “ 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 …” 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. 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&AGUY10'.Click on the link to register: Financial Modeling World Cup Go to https://earmarkcpe.com , download the app, take the quiz and you can receive CPE credit. Follow Emilie Williams: LinkedIn - https://www.linkedin.com/in/emilie-williams-06582761/ Website - https://cvmconsultants.ca/ 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

    Special Episode: Breaking into Finance Podcast with Craig Thompson

    Play Episode Listen Later Nov 2, 2023 44:48


    Special EpisodeThis week we are bringing you a unique episode. This episode is a Breaking Into Finance podcast episode hosted by Craig Thompson featuring Paul Barnhurst. 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&A Guy, host of FP&A Today and Financial Modeler's Corner. Financial Planning & Analysis ("FP&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&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

    Mastering Finance: Navigating CFA Institute and CFA Program Changes with Rob Langrick

    Play Episode Listen Later Oct 26, 2023 35:28


    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 Rob Langrick. 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. 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 & Company in New York. List to this episode as Rob Shares:His learnings from the worst models he has seen in his career 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. Go to https://earmarkcpe.com , download the app, take the quiz and you can receive CPE credit. Quotes: “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: LinkedIn - https://www.linkedin.com/in/rob-langrick-cfa-cipm-b16736/ 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/@thefpandaguyTwitter - 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=trueNewsletter - Subscribe on LinkedIn- https://www.linkedin.com/build-relation/newsletter-follow?entityUrn=7079020077076905984 In today's episode: (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;

    Financial Modeling Through the Years: Stories & Insights from Colin Human, David Thompson, and Prem Beejan

    Play Episode Listen Later Oct 12, 2023 59:59


    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 & analysis, independent valuations, strategy, and corporate development services to both the public and private sectors. 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: How they got started in financial modelingTheir experience and learning from the worst models that they came across 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. Follow Colin Human: Website - https://goalfixglobal.com/staff/colin-human/ LinkedIn - https://www.linkedin.com/in/colin-human-b8072812/ Follow Prem Beejan: Website - https://www.fmcmauritius.com/ LinkedIn - https://www.linkedin.com/in/prem-beejan-msc-mfm-5a921025/ Follow David Thompson: Website - https://tghcorp.com.au/ LinkedIn - https://www.linkedin.com/in/strategy-finance-valuations-modelling/ Follow Paul Barnhurst: 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 Quotes: “ 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 “ 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 In today's episode: (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 ; (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 Financial Modeler; (46:51) The importance of Strategic Thinking; (49:41) Rapid Fire; (56:42) Nugget on Financial Modeling from the renowned Guests; (58:51) Connect with David, Prem and Colin;

    Charting a Start-up's Journey: Financial Models for start-up's with Zainab Nwachuku

    Play Episode Listen Later Sep 28, 2023 38:18


    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. Zainab is extremely passionate about financial modeling and hopes more women who are fond of numbers choose to join the profession. Listen to this episode as Zainab shares: 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. Quotes: “ 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. ” “ 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: Website - https://theintellectualplug.com/ LinkedIn - https://www.linkedin.com/in/mszainababu/ 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 Must follow LinkedIn Profiles: Financial Modeling World Cup https://www.linkedin.com/company/financial-modeling-world-cup/ Financial Modeling Institute https://www.linkedin.com/company/fminstitute/ Chris Reilly https://www.linkedin.com/in/chris-reilly-mission-capital/ Danielle Stein Fairhurst https://www.linkedin.com/in/daniellesteinfairhurst/ Hedieh Kianyfard https://www.linkedin.com/in/hediehkianyfard/ Lance Rubin https://www.linkedin.com/in/financial-modelling/ Giles Male https://www.linkedin.com/in/giles-male-30643b15/ In today's episode: (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; (09:50) Women in Modeling; (11:17) About The Intellectual Plug; (12:38) Common Company challenges; (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 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. (32:00) Rapid Fire: The Pattern So Far; (35:18) Must Follow LinkedIn Profiles (37:22) CPE Credit (37:40) Outro

    Are LAMBDAs & Dynamic Arrays the future of Financial Modeling? A lively discussion with 4 modeling experts.

    Play Episode Listen Later Sep 14, 2023 53:38


    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 & 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. Jeff is a Financial Modeler, Business Analyst, International Trainer & 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 Executive Director at the Financial Modeling Institute (FMI), which is also the sponsor of this Podcast. 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&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/ 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 Subscribe to our Newsletter- https://www.linkedin.com/build-relation/newsletter-follow?entityUrn=7079020077076905984 Quotes: “Python brings a suite of libraries that can do some amazing things.” “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.” In today's episode: (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; (18:20) FMI exams and Dynamic Arrays; (21:57) LAMBDAs for 5G modeling ; (24:13) How to use 5G modeling; (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 & Ian (52:57) Outro

    Become a better Modeler by developing a decision-making mindset: Hedieh Kianyfard

    Play Episode Listen Later Aug 31, 2023 41:59


    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

    Becoming a Better Financial Modeler with Chris Reilly

    Play Episode Listen Later Aug 17, 2023 40:09


    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. Chris is very passionate about Financial Modeling and helping others learn to build robust financial models focused on the 3-financial statements. 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 Podcast. Visit www.fminstitute.com/podcast and use code Podcast to save 15% when you register. Follow Chris: Website - https://www.financialmodelingeducation.com/ LinkedIn - https://www.linkedin.com/in/chris-reilly-mission-capital/ Newsletter - https://financialmodelingeducator.com/Follow Financial Modeler's Corner LinkedIn Page & Subscribe to NewsletterLinkedin Page - 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. ” “ 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. Go to https://earmarkcpe.com , download the app, take the quiz and you can receive CPE credit.

    Financial Modeling education, Excel competitions, exciting academic research and more with Professor David C. Brown

    Play Episode Listen Later Aug 3, 2023 46:26


    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. 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 to save 15% when you register. Go to https://earmarkcpe.com , download the app, take the quiz and you can receive CPE credit. Follow David: YouTube - https://www.youtube.com/@docbrownexcels Website - https://www.davidclaytonbrown.com/ E-mail - dcbrown@email.arizona.edu · To learn more about Microsoft Excel Collegiate Challenge, visit this website- https://mecc.college/ 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: “ Collegiate Challenge is not about being the best, its about challenging yourself, learning more and getting better at it. ” “ 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. ” 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 – How David wishes to teach the college program for Finance (45:23) CPE Credit with this episode; (45:40) Outro.

    Benefits of competing in the Financial Modeling World Cup - Insights from World Champion Diarmuid Early

    Play Episode Listen Later Jul 20, 2023 39:14


    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 Diarmuid Early, one of the best modelers in the world and, the Founder of Early Days Consulting. He is a 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 Diarmuid 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 www.fminstitute.com/podcast and use code FMC15 to save 15% when you register. Go to https://earmarkcpe.com , download the app, take the quiz and you can receive CPE credit for listening to the episode. Follow Diarmuid: YouTube - https://www.youtube.com/@DimEarly/ LinkedIn - https://www.linkedin.com/in/diarmuidearly Stream the events of FMWC live on YouTube by visiting - Financial Modeling World Cup Link to the next streaming session on July 27th at 9 AM MST of which Paul Barnhurst will be a part - Battle VII - Road to Las Vegas 2023 (Excel Esports) 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: “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.” “ 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. ” In today's episode: (00:22) Intro; (00:45) Welcoming Diarmuid; (01:16) The worst financial model Diarmuid has ever seen ; (04:13) Diarmuid's take away from the worst financial model ; (07:45) Diarmuid 's background; (09:45) How 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 Accreditation Program (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;

    David Brown: The Future of Financial Modeling

    Play Episode Listen Later Jul 6, 2023 44:38


    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 Brown, the Managing Partner of D Brown Consulting 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: Website - https://www.dbrownconsulting.net/ Twitter - https://twitter.com/dbrownanalyst Instagram - https://www.instagram.com/dbrownconsulting/ YouTube - https://www.youtube.com/c/dbrownconsultingdbrownconsultingtv 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: https://youtu.be/4qp8f3u3NvMTake your financial modeling skills to new heights with dbrownconsulting's Advanced Financial Modeler Certificate Course!

    Ian Schnoor: Why validate your Financial Modeling Skills?

    Play Episode Listen Later Jun 22, 2023 38:59


    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 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: · What it was like in the early days of financial modeling· Why FMI created a financial modeling accreditation in the first place · The importance of Financial Modeling as a profession · 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 - info@fminstitute.com LinkedIn - https://www.linkedin.com/in/ianschnoor/ 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/TheFPandAGuyYouTube - https://www.youtube.com/@thefpaguy8376 Sign up for the Advanced Financial Modeler Accreditation or FMI Fundamentals Today and receive 15% off by using the special show code FMC15.Visit www.fminstitute.com/podcast and use code FMC15 to save 15% when you register.If you want to earn CPE credit fort this episode go to https://earmarkcpe.com, download the app, take the quiz and you can receive CPE credit. On each episode we will have a section called “Ask the Host/ Guests” in which you can ask your own questions. You can submit your questions about financial modeling at pbarnhurst@TheFPandAGUy.com or DM on LinkedIn.These episodes will also talk about interesting news regarding financial modeling. So if you find something which is worth a share, send it across so that it can be discussed on our future episodes. Quotes: “There was no opportunity for people to really learn formally how to build models.”“If someone gets FMI's accreditation they know you are the best in your practice, they know how to model and they know design is important.”“Without design the whole thing falls apart.”“Training firms can teach you and give you the knowledge you need but to really become excellent and prove it, that requires independent validation and that's where FMI comes in.”“We want FMI to encourage people to interact and teach each other, learn from each other and enhance this profession.” In today's episode: (00:22) Intro; (00:50) Welcoming Ian; (02:42) How FMI started; (05:45) Paul's experience; (06:37) The importance of Design; (07:37) Multi-disciplinary approach for a dynamic model; (08:53) What makes FMI unique; (11:23) Why Paul chose FMI; (12:53) The importance of Validation of Training; (14:26 - 15:13) Validate your Financial Modeling Skills with FMI's Accreditation Program (ad); (15:14) Resources/ Programs included in the FMI; (18:26) Why Ian chose to be the premier sponsor for FMC podcast; (21:15) What Ian hopes people gain from the podcast; (24:22) Ian's answers to standard questions; (24:30) Which is the worst financial model ever seen; (26:17) Ian's take away from the worst financial models; (27:53) Rapid Fire; (32:00) Ian's advice for modelers; (33:17) Connect with Ian; (35:12) Paul's Top Quote from the episode; (36:25) Have Financial Models become the most important decision making tool in finance? - LinkedIn Poll Results; (38:13) CPE Credit with this episode; (38:54) Outro.

    Financial Modeler's Corner Trailer

    Play Episode Listen Later Jun 21, 2023 0:23


    Claim Financial Modeler's Corner

    In order to claim this podcast we'll send an email to with a verification link. Simply click the link and you will be able to edit tags, request a refresh, and other features to take control of your podcast page!

    Claim Cancel