Financial Modeler's Corner cover image

Financial Modeler's Corner

Latest episodes

undefined
Aug 17, 2023 • 40min

Becoming a Better Financial Modeler with Chris Reilly

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.
undefined
8 snips
Aug 3, 2023 • 46min

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

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.  
undefined
Jul 20, 2023 • 39min

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

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;
undefined
Jul 6, 2023 • 45min

David Brown: The Future of Financial Modeling

David Brown, a respected financial modeler and consultant, shares his journey into modeling, passion for teaching, and thoughts on controversial modeling issues. He discusses the importance of problem-solving, storytelling with ratios, and embracing AI in financial modeling. Brown highlights the significance of financial modeling skills and accreditation, as well as the need for human understanding in aligning models with client needs. Overall, the podcast explores the future of financial modeling and the balance between AI and human expertise.
undefined
Jun 22, 2023 • 39min

Ian Schnoor: Why validate your Financial Modeling Skills?

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 
undefined
Jun 21, 2023 • 23sec

Financial Modeler's Corner Trailer

Remember Everything You Learn from Podcasts

Save insights instantly, chat with episodes, and build lasting knowledge - all powered by AI.
App store bannerPlay store banner