Financial Modeler's Corner

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/@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: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;...

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

In this episode, we have another special treat for you which is part two of the Financial Modeling World Cup (FMWC) and the Microsoft Excel Collegiate Challenge (MECC). Paul attended modeling competitions in Arizona and Las Vegas watching competitors compete 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/@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) 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;

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 Query The 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;...

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

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

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

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

Welcome to Financial Modeler's Corner (FMC) where we discuss the art and science of financial modeling with your host Paul Barnhurst. Financial Modeler's Corner is sponsored by Financial Modeling Institute (FMI) the most respected accreditations in Financial Modeling globally. In this episode, Paul Barnhurst is joined by Brian Egger .   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 Modeler His learning from the worst models he has come across. His role as the Global Head of Financial Modeling at Bloomberg Everything 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? ;...

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 model Her learnings from the worst models she has come across The unique challenges of modeling in the mining industry Her experience with competing in ESPN’s most recent Excel Battle The importance of practicing to be a better modeler Her 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 This 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 Finance Last 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 here https://open.spotify.com/show/3KtwQ1mhwj7X0HKK7RyJHc?si=8e9eeeed0c18463f

Welcome to Financial Modeler's Corner (FMC) where we discuss the art and science of financial modeling with your host Paul Barnhurst. Financial Modeler's Corner is sponsored by Financial Modeling Institute (FMI)  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 Analyst The CFA Program and why they modified the program to include new content The value of FMI's financial modeling content to the new CFA Program The 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/@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:48) Welcoming Rob; (01:00) The worst financial model Rob has ever seen ; (02:33) Rob’s key learning experience from the worst financial model ; (04:20) Rob’s background; (06:28) Rob’s experience as an Equity Analyst; (08:53) What motivated Rob to move into Education; (10:27) What lead Rob to join the CFA Institute; (11:55) Roles Rob had at CFA; (14:33 - 15:19) Validate your Financial Modeling Skills with FMI’s Accreditation Program (ad); (15:20) Changes to the Practical Skills Modules; (16:43) People’s response to change; (19:20) Changes apart from Practical Skills; (22:22) The main benefit to Charter Holders; (24:55) Experience with FMI; (26:24) Why is it important for everyone in finance to learn the basics of financial modeling ; (28:33) Rapid Fire; (32:47) Advice to college students; (34:27) Connect with Rob;

Welcome to Financial Modeler's Corner (FMC) where we discuss the art and science of financial modeling with your host Paul Barnhurst. Financial Modeler's Corner is sponsored by Financial Modeling Institute (FMI) the most respected accreditations in Financial Modeling globally. In this episode, Paul Barnhurst is joined by three distinguished modeling experts: Colin Human, David Thompson, and Prem Beejan. Colin Human started out his financial career as a 22-year-old chartered accountant in South Africa. Today, he is the CEO of Goalfix and provides financial modeling consulting and training. David Thompson is an independent financial consultant who provides expert financial modeling, financial planning & 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 modeling Their 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 them The impact of Generative AI on Models The importance of Formal Accreditation Their 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 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)...

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 modeling Her 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 reality The horror story of linking workbooks in Excel Her unwavering passion for Modeling Her position on controversial modeling issues, including circular references, dynamic arrays, modeling standards, and more Sign up for the Advanced Financial Modeler Accreditation or FMI Fundamentals Today and receive 15% off by using the special show code ‘Podcast’. Visit www.fminstitute.com/podcast and use code Podcast to save 15% when you register. 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)...

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 modeling LAMBDAs what they are and how they could revolutionize financial modeling Dynamic Arrays, what they are, how they work, and what it is like to build a model using Dynamic Arrays How Dynamic Arrays will make auditing models easier The 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 Fairhurst Danielle is speaking at the global excel summit - Global Excel Summit 2024 | Microsoft Excel Event | Welcome Upcoming 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.” “...

Welcome to Financial Modeler's Corner (FMC) where we discuss the art and science of financial modeling with your host, Paul Barnhurst. Financial Modeler's Corner is sponsored by Financial Modeling Institute (FMI) the most respected accreditations in Financial Modeling globally. In this episode, Paul Barnhurst is joined by Hedieh Kianyfard, who is the founder of Finexmod. This is the website where Hedieh shares her views on financial modeling and shows that it’s possible to have fun with finance. Hedieh is passionate about economic development and aims to make financial modeling easy and fun for everyone. Listen to this episode as Hedieh shares: Her journey and background in financial modeling Her experience and learning from the worst models that she came across How Hedieh considers Modeling as a great career and more than a stepping stone. Responsibility as a modeler to reject bad projects and help ensure good projects are accepted. Everything about her book- Financial Modeling Detective 10 Financial Modeling Commandments Why people should avoid circular references – hint they are the devil 😊 The importance of having a decision-making mindset Her position on controversial modeling issues, including circular references, dynamic arrays, modeling standards, and more Sign up for the Advanced Financial Modeler Accreditation or FMI Fundamentals Today and receive 15% off by using the special show code ‘Podcast’. Visit www.fminstitute.com/podcast and use code Podcast to save 15% when you register. Quotes: “A Financial Modeler is like a Fortune Teller.” “Modeling is a great career and more than a stepping stone.” “ It’s important to put yourself, in the end, users' shoes to understand their needs better. ” “ As modelers we have a responsibility to reject bad projects and help ensure good projects are accepted. ” Follow Hedieh: Website - https://www.finexmod.com/ LinkedIn - http://linkedin.com/in/hediehkianyfard Instagram - https://instagram.com/finexmod Facebook - https://m.facebook.com/people/Finexmod/100063965894693/ Youtube - https://youtube.com/@FinancialModelDetective The Interpolate-Lookup function as explained by Professor Edward Bodmer- https://edbodmer.com/interpolate-lookup-function/ Financial Model Detective Book: Financial Model Detective: Hints and tricks for review of financial models: Kianyfard, Hedieh: 9781074174606: Amazon.com: Books  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:45) Welcoming Hedieh; (01:06) The worst financial model Hedieh has ever seen ; (03:26) Hedieh’s key learning experience from the worst financial model ; (06:23) Hedieh’s background; (09:35) About Hedieh’s website - Finexmod (10:23) About Hedieh’s book - Financial Modeling Detective (12:25) Why is it important to have someone audit Financial Models (16:12) Financial Model Ten Commandments (17:31) Rule 9 - Why people should avoid circular references (19:21) Rule 10 - The Modeler shouldn’t be selfish (21:15 - 22:02) Validate your Financial Modeling Skills with FMI’s Accreditation Program (ad); (22:03) The decision makers mindset; (26:31) How to develop that decision making mindset; (28:30) What is the process of infrastructure...

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 Modeling The importance of simple, uncomplicated model design How being a part of a financial modeling community like FMI can help modelers The revolver approach for managing cash and why it is important in modeling The benefits and challenges of using EBITDA to value a company 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.   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 Newsletter Linkedin 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 ,...

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

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 Modeling How Financial Modeling competitions help you grow and learn The key differences between modeling for competition and modeling for work His practical advice on how to build a 3-statement model How 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;

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 Modeling How to find your passion and be willing to put yourself out there How he learned he had a passion for teaching at a young age How intuition is a good place to start, but the model helps validate hunches and numbers How he explains the balance sheet without using numbers to non-finance people Ways 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 more Follow 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/4qp8f3u3NvM Take your financial modeling skills to new heights with dbrownconsulting’s Advanced Financial Modeler Certificate Course!

Welcome to Financial Modeler's Corner (FMC) where we discuss the art and science of financial modeling with your host Paul Barnhurst. Financial Modeler's Corner is sponsored by Financial Modeling Institute (FMI)  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 process Follow 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/TheFPandAGuy YouTube - 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)...