The FP&A Guy Network

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 project; (30:58) Rapid Fire; (35:31) When did Hedieh realize Financial Modeling as a career (37:31) Connect with Hedieh; (38:32) Paul’s best picks: (40:50) CPE Credit with this episode; (41:20) Outro...

Welcome to Financial Modeler's Corner (FMC) where we discuss the art and science of financial modeling with your host Paul Barnhurst. Financial Modeler's Corner is sponsored by Financial Modeling Institute (FMI), the most respected accreditations in Financial Modeling globally. In this episode, Paul Barnhurst is joined by Chris Reilly, who is the founder of Financial Modeling Education. Chris spent many years working in private equity, and today, he runs his own business focused on providing financial modeling education and financial modeling consulting services.   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.

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 - [email protected]   ·        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.  

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;

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!

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