Financial Modeler's Corner

Welcome to the Financial Modeler's Corner (FMC), where we discuss the art and science of financial modeling with your host Paul Barnhurst. Financial Modeler's Corner is sponsored by the Financial Modeling Institute (FMI), the most respected accreditation in Financial Modeling globally.

In this episode, Paul is joined by Ian Bennett, Partner, Deals Modelling team at PwC, Australia.

With over 20 years of experience as a professional financial modeler, Ian has constructed and assessed models critical for major transactions, infrastructure projects, and routine forecasting and reporting. Today Ian leads the deal modeling practice for Pwc Australia.

In addition to being a world-class Modeller Ian is incredibly dedicated to diversity, inclusion, and wellbeing (DI&W). This has propelled him through various positions within PwC and beyond. As a proud LGBTIQ+ ally, he serves on the Steering Committee of Shine@PwC, the firm's LGBTIQ+ employee network, and currently holds the role of wellbeing lead for the Financial Advisory business.

In this episode, expect to learn:

• Why understanding the stakeholders involved in a project is vital
• Why it's essential to listen actively to clients, understand their needs, and ask the right questions
• How to analyze the success and effectiveness of the financial modeling process
• What are the tools and technologies available in the market
• What are the new technologies and methodologies for financial modelers to stay effective and successful in their roles

Quotes: 

• “You need a desire to understand the power of the things you have in front of you and not be scared.”

• “Every model tells a story, and that story is known at the start of the project, and the questions that the model will be able to answer.”

• “Models are built for a single primary purpose at the time that they are conceived’

Sign up for the Advanced Financial Modeler Accreditation or FMI Fundamentals Today and receive 15% off by using the special show code ‘Podcast’.

Visit www.fminstitute.com/podcast and use code Podcast to save 15% when you register.

Go to https://earmarkcpe.com, download the app, take the quiz and you can receive CPE credit.

Follow Ian Bennett: 

Linkedin: https://www.linkedin.com/in/ianrbennett

Website: https://www.pwc.com.au/deals/modelling.html

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/

Newsletter - Subscribe on LinkedIn- https://www.linkedin.com/build-relation/newsletter-follow?entityUrn=7079020077076905984

In today’s episode:

00:20: Introduction

01:10: Problem that bettered Ian

03:00: Ian’s insights on financial models

05:18: Ian’s story

07:13: What is MFM and why did Ian pursue it?

08:35: Ian’s experience in the Global Excel Summit

10:49 Why Ian is passionate about financial modeling

11:52: Ian’s favorite industry that he likes to model

13:13: What makes a good financial modeler?

16:49: Things beyond the model that help in a project?

22:05: Approach and methodology 

27:00: Tools beyond Excel

34:40: Technical nugget when building new models

36:50:  Rapid fire 

39:08: Ian’s favorite function

45:00: Ian’s advice to become a better financial modeler

45:36: Wrap up

In this episode, Paul Barnhurst is joined by Derek Baker, who is drawn to really hard problems. Derek discovered early in his career that he loves startups and building companies.

He began his career working for SaaS startups, building out their core FP&A processes. For many of the companies he worked with, he was building their very first financial model to help them operate the business and make capital allocation decisions. He found that every business - regardless of stage - can improve performance with excellent FP&A.

Today, he works at Neighbor.com, a Series B startup, building the “Airbnb” of personal storage. Building the FP&A function for a marketplace has been the biggest challenge of his career, and he is loving every minute of it.

Listen to this episode as Derek shares:

• How he got into financial modeling for SaaS companies

• His advice for building robust SaaS Models.

• The importance of understanding a business to build better Models.

• Everything about SaaS and SaaS Companies.

• His position on controversial modeling issues, including circular references, dynamic arrays, modeling standards, AI in modeling, and more.

Quotes:

“ The only way you're really going to learn how to build a model is by building it. You can do all the study you want, but at the end of the day, it's like anything, without practice, it's just theory. ”

“ The better you know an industry, the better you know the operations of the business, the easier it is to build a model.”

“ [ What separates good FP &A from great FP & A] I think it's 1- business acumen and 2- business partnering. Anyone can build a model in Excel and can learn those technical skills. But using those technical skills to help the business and partner with the business to help them understand the business better and grow the business is exactly what FP&A should be doing....”

Sign up for the Advanced Financial Modeler Accreditation or FMI Fundamentals Today and receive 15% off by using the special show code ‘Podcast’.

Visit https://fminstitute.com/podcast/and use code Podcast to save 15% when you register.

Go to https://earmarkcpe.com , download the app, take the quiz and you can receive CPE credit.

Follow Derek:

• LinkedIn - https://www.linkedin.com/in/derek-d-baker/
• Website - https://community.plan-buddies.com/home

Follow Paul:

• Website - https://www.thefpandaguy.com/
• LinkedIn - https://www.linkedin.com/in/thefpandaguy/
• TikTok - https://www.tiktok.com/@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;

(32:58) Rapid Fire;

(36:09) Nugget;

(36:55) Connect with Derek;

(37:21) Outro;

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;

(01:44) Interview with Oz Du Soleil and Jo n A campora ;

(19:51) Everything about MECC with David Brown;

(25:43 - 26:30) Validate your Financial Modeling Skills with FMI’s Accreditation Program (ad);

(27:30) Interview with Benjamin Weber ;

(36:34) Interview with Patrick Chat ain ;

(41:28) Interview with Missy and Teresa ;

(48:38) Interview with Craig Hatmaker;

(54:00) Outro. 

Welcome to Financial Modeler's Corner (FMC) where we discuss the art and science of financial modeling with your host Paul Barnhurst. Financial Modeler's Corner is sponsored by Financial Modeling Institute (FMI) the most respected accreditation in Financial Modeling globally.

In this episode, Paul Barnhurst is joined by Sam Sivarajan , who is a Speaker, Wealth Management Consultant, Behavioral Scientist, Stoicism Padawan, Fintech Advisor, Podcast Host, Bestselling Author and an Adventurer. He has a law degree, an MBA, a PhD in behavioral science, and has also earned a CFP.

Sam’s work is focused on how we can make  better decisions  so that we can get to  better results  – in investing, in leadership, and in our personal lives.

Listen to this episode as Sam shares:

• His journey working in Telecom during the tech boom.
• Advice on balancing the art and science of Modeling.
• His advice on making smart assumptions.
• The importance of Decision Making.
• How to think critically when building a model and making assumptions.
• Everything about his books ‘Making your money work’, ‘Uphill’ and ‘Am I Ok?’
• His position on controversial modeling issues, including circular references, dynamic arrays, modeling standards, AI in modeling, and more .

Quotes:  

“ Never forget and lose sight of why you're creating the model, and who will use it....... ”

“ In my view, the model is simply a numerical representation of some prior deep-rooted strategic thinking , a nd you're bringing that to bear in that model as a representation . ”

“ A model is a simplification of reality. It isn't reality. And to remember that the model is but one tool in making key decisions. It shouldn't be the be all and end all...... ”
 

Sign up for the Advanced Financial Modeler Accreditation or FMI Fundamentals Today and receive 15% off by using the special show code ‘Podcast’.

Visit www.fminstitute.com/podcast and use code Podcast to save 15% when you register.  

Go to https://earmarkcpe.com , download the app, take the quiz and you can receive CPE credit. 

Am I Ok? - https://www.amazon.co.uk/Am-Essential-Questions-Investors-Financial-ebook/dp/B0CKY6XB4K?ref_=ast_author_mpb

Uphill - https://www.amazon.co.uk/Uphill-Ancient-Science-Choices-Challenges-ebook/dp/B0BGMJX9VN?ref_=ast_author_dp&dib=eyJ2IjoiMSJ9.fVxD2IJYvz1m0ZgBXJmkb595Ei0TtF8Wjx2TMOwZWzVdTmpjGxlD9-zbKVPzvrFn.gUxmNYfh-t6jXwKbr2EqugQZ4LBWXPOLoX6DrlNEsU0&dib_tag=AUTHOR

Follow Sam:    

Website - https://www.samsivarajan.com/

LinkedIn - https://ca.linkedin.com/in/samsivarajan

Podcast - https://www.samsivarajan.com/podcast

Twitter - https://twitter.com/SamSivarajan

Sam’s books:

Making your Money Work - https://www.amazon.co.uk/Making-Your-Money-Work-Financial-ebook/dp/B0B36PDQLX?ref_=ast_author_dp&dib=eyJ2IjoiMSJ9.fVxD2IJYvz1m0ZgBXJmkb595Ei0TtF8Wjx2TMOwZWzVdTmpjGxlD9-zbKVPzvrFn.gUxmNYfh-t6jXwKbr2EqugQZ4LBWXPOLoX6DrlNEsU0&dib_tag=AUTHOR

Follow Financial Modeler's Corner 

LinkedIn Page- https://www.linkedin.com/company/financial-modeler-s-corner/?viewAsMember=true  

Newsletter - Subscribe on LinkedIn- https://www.linkedin.com/build-relation/newsletter-follow?entityUrn=7079020077076905984  

In today’s episode:  

(00:22) Intro;

(00:45) Welcoming Sam;

(01:01) The worst financial model Sam has ever seen ;

(02:57) Sam’ s background;

(04:22) Sam’s experience at Telecom;

(10:27) How to balance the art of Art and Science of Modeling ;

(12:27) Why is the process often more important than the actual Model? ;

(17:07) Advice on Assumptions;

(21:51) Sam’s technique to get better at Modeling;

(22:30 - 23:15) Validate your Financial Modeling Skills with FMI’s Accreditation Program (ad);

(23:21) How people think about making decisions;

(24:35) How to make better decisions;

(27:40) Frameworks that help with Decision Making;

(31:57) Sam’s experience while writing his books - Making your Money Work, Uphill and Am I Ok?;

(34:20) Rapid Fire;

(37:38) Connect with Sam;

(38:17) Sam’s advice on being a successful Modeler;

(39:34) Paul’s Top Picks

- The importance of the Thinking Process

- Validating Assumptions

(41:00) Outro 

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 CFM?;

(41:03) FMI as a part of regular Graduation;

(46:08) Advice on being a better Financial Modeler;

(49:26) Connect with Dave, Giles and Rapha ë l ;

(50:40) Outro

Welcome to Financial Modeler's Corner (FMC) where we discuss the art and science of financial modeling with your host Paul Barnhurst. Financial Modeler's Corner is sponsored by Financial Modeling Institute (FMI) the most respected accreditations in Financial Modeling globally.

In this episode, Paul Barnhurst is joined by Dr. Andy Temte .

Dr. Andrew Temte, CFA, is the former CEO of Kaplan Professional and author of “Balancing Act: Teach, Coach, Mentor, Inspire,” and "The Balanced Business: Building Organizational Trust and Accountability through Smooth Workflows." He is also a board member and senior advisor at the FMI.

A thought leader on financial education and issues related to organizational health, continuous improvement, and workforce re-skilling, his articles have appeared in a number of media outlets, including Chief Executive and Chief Learning Officer.

This blend of higher education and professional education experience gives Dr. Temte a unique perspective when it comes to financial education and financial modeling

Listen to this episode as Andy shares: 

• His learning from the worst models he has come across.
• His experience reviewing financial models for acquisitions.
• His experience as a Member of the Board of FMI.
• The value of Financial Modeling Accreditation.
• Why he wrote his book ‘The Balancing Act’.
• His position on controversial modeling issues.

Quotes:  

“FMI is one of the only institutes that’s delivering a truly experiential credentialing process.”

“At the end of the day, modeling is about communication because you're helping communicate insights, derived from data and assumptions to drive behavior or changes or decisions. And so it's all about communicating.”

Sign up for the Advanced Financial Modeler Accreditation or FMI Fundamentals Today and receive 15% off by using the special show code ‘Podcast’.

Visit www.fminstitute.com/podcast and use code Podcast to save 15% when you register.  

Go to https://earmarkcpe.com , download the app, take the quiz and you can receive CPE credit. 

Follow Andy Temte:    

LinkedIn - https://www.linkedin.com/in/atemte/

Podcast - Balancing Act

Website - https://www.andrewtemte.com/

Andy’s books:

Balancing Act - https://www.amazon.com/Audible-Balancing-Act/dp/B0CFCZT4HN/ref=sr_1_2?crid=17K8UI3208G9Q&keywords=Andy+Temte&qid=1701342458&sprefix=andy+temte%2Caps%2C150&sr=8-2

The Balanced Business: Building Organizational Trust and Accountability through Smooth Workflows - https://www.amazon.com/Balanced-Business-Organizational-Accountability-.

Follow Paul:

Website - https://www.thefpandaguy.com/   

LinkedIn - https://www.linkedin.com/in/thefpandaguy/ 

Instagram - https://www.instagram.com/thefpandaguy/  

TikTok - https://www.tiktok.com/@thefpandaguy 

Twitter - https://twitter.com/TheFPandAGuy 

YouTube - https://www.youtube.com/@thefpaguy8376  

Follow Financial Modeler's Corner 

LinkedIn Page- https://www.linkedin.com/company/financial-modeler-s-corner/?viewAsMember=true  

Newsletter - Subscribe on LinkedIn- https://www.linkedin.com/build-relation/newsletter-follow?entityUrn=7079020077076905984  

In today’s episode:  

(00:22) Intro;

(00:46) Welcoming Andy;

(01:05) The worst financial model Andy has ever seen ;

(01:52) Andy’s key learning experience from the worst financial model ;

(02:45) Andy ’s background;

(05:07) Andy’s journey as a professor;

(07:16) Andy’s motivation to teach Finance ;

(11:02) Time at Kaplan;

(13:55) Andy’s views on the CFA program;

(17:27 - 18:13) Validate your Financial Modeling Skills with FMI’s Accreditation Program (ad);

(18:18) Andy’s experience as a Member of the Board of FMI;

(20:03) Value of Financial Modeling Accreditation;

(25:23) Andy’s motivation behind writing the book “The Balancing Act”;

(33:17) What motivated Andy to start a Podcast?;

(34:54) Rapid Fire;

(37:27) Advice on being a successful Modeler;

(39:32) Connect with Andy;

(40:10) Outro.

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? ;

(08:08) Signs that a Model is too detailed;

(10:57) Signs that a Model is too simple to make decisions;

(13:43 - 14:30) Validate your Financial Modeling Skills with FMI’s Accreditation Program (ad);

(14:39) About Bloomberg’s Interactive Calculator;

(15:58) Brian’s key learning from that Project;

(20:25) Guidelines on Balance;

(23:52) Brian’s thoughts on FMI;

(27:44) Trends of the Industry over the years;

(29:58) Rapid Fire;

(34:31) Advice on being a successful Modeler;

(35:23) Connect with Brian;

(35:50) Paul’s Top Picks - Finding the balance between complexity and simplicity

(39:32) Outro.