Embracing Skepticism To Enhance Financial Modeling Techniques
Ankita Ghosh Ankita Ghosh

Embracing Skepticism To Enhance Financial Modeling Techniques

In this episode, expect to learn:

  • An unconventional entry into investment banking at 43, highlighting how the background in education enriches the approach to financial analysis and modeling, emphasizing the crossover skills between teaching and financial analysis.

  • This highlights how teaching skills are transferable and beneficial in the financial analysis and modeling sectors.

  • An anecdote about a significant error in a financial model, which failed to detect a $29 billion discrepancy, underscoring the critical importance of rigorous validation and diagnostic checks in financial modeling.

  • The role of behavioral factors in financial modeling, adopting a stance of professional skepticism and the need for understanding and questioning the assumptions underlying a model before trusting its output.

  • The importance of simplicity and planning in financial modeling, the most effective models are those that are straightforward, well-planned, and can communicate complex financial insights in an accessible manner.

  • Strategies for mitigating bias, such as incorporating different perspectives and rigorous testing of hypotheses

Read More
How Simplicity in Financial Modeling Enhances Decision Making
Ankita Ghosh Ankita Ghosh

How Simplicity in Financial Modeling Enhances Decision Making

In this episode, expect to learn:

  • The significance of technical skills, such as financial modeling, accounting, and Excel proficiency, in the finance industry

  • How specialized training programs can help individuals enhance their financial knowledge and technical abilities

  • The evolving role of AI in finance and how it complements human expertise rather than replacing it

  • The balance between technical proficiency and interpersonal skills to excel in their careers

  • How individuals can build trust with clients, colleagues, and stakeholders, ultimately contributing to the integrity and credibility of the finance profession.

Read More
Unraveling the Mystery: Roderick Mckinley's Guide to Navigating Tokenomics
Ankita Ghosh Ankita Ghosh

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

In this episode, expect to learn:

  • Understand the integration of finance, blockchain, Tokenomics, and strategic guidance for blockchain projects.

  • Gain insights into challenges and opportunities in transitioning from traditional finance to the crypto space.

  • Learn how to navigate complexities like token volatility and incentive alignment in blockchain projects.

  • Obtain practical tips on developing tokenized business models, designing token utilities, and structuring token allocations for successful fundraising.

  • Acquire valuable knowledge for navigating the evolving landscape of blockchain and cryptocurrency.

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

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

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

Read More
Mastering SaaS Models: Derek Baker's insights on building robust SaaS models  
Guest User Guest User

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

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.

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

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

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.

Read More
Beyond the Classroom: Why Learning Excel is an Investment for Your Career 
Guest User Guest User

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

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.

Read More
Episode 18 - From Campus to Spreadsheet: The Microsoft Excel Collegiate Challenge Journey 
Paul Barnhurst Paul Barnhurst

Episode 18 - From Campus to Spreadsheet: The Microsoft Excel Collegiate Challenge Journey 

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 e 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 5G Lambdas and more.

Read More
Episode 17: Precision in Modeling: Sam Sivarajan’s Wisdom on Balancing Art, Science, and Decision-Making
Paul Barnhurst Paul Barnhurst

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

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.

Read More
Episode 16: Dave Hallwood, Giles Male, and Rafaël Le Saux Explore Being a Better Financial Modeler and Financial Modeling Certifications
Paul Barnhurst Paul Barnhurst

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

In this LinkedIn Live, Paul Barnhurst is joined by three amazing Modelers, Dave Hallwood, Giles Male and Rafa ë l Le Saux.

David Hallwood FCCA 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 Modeller - 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, CFA, CAIA, CFM, ABV, FMVA 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.

Read More
Episode 15: From Classroom to Certification: Andy Temte's Unique Perspective on Financial Modeling 
Paul Barnhurst Paul Barnhurst

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

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 acquisition targets

• His experience as a Member of the Board of FMI.

• The value of Financial Modeling Accreditation.

• Everything about his book ‘The Balancing Act’.

• His motivation to start a Podcast.

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

Read More
Special Episode: Run the Numbers by CJ Gustafson
Paul Barnhurst Paul Barnhurst

Special Episode: Run the Numbers by CJ Gustafson

This week, we are bringing you a unique 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.

Read More
Episode 13: How Financial Modelers build a goldilocks “Just-right” Financial Model with Brian Egger
Paul Barnhurst Paul Barnhurst

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

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.

Read More
Episode 12 - From Rocks to Riches: The Power of Financial Models in the Mining Industry with Emilie Williams
Paul Barnhurst Paul Barnhurst

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

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, and 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 modeler

· 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

Read More
Special Episode: Breaking into Finance Podcast with Craig Thompson
Paul Barnhurst Paul Barnhurst

Special Episode: Breaking into Finance Podcast with Craig Thompson

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.

Read More
Episode 10 - Mastering Finance: Navigating CFA Institute and CFA Program Changes with Rob Langrick
Paul Barnhurst Paul Barnhurst

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

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 as one of if not the most important corporate decision making tool

Read More
Episode 9 - Financial Modeling Through the Years: Stories & Insights from Colin Human, David Thompson, and Prem Beejan 
Paul Barnhurst Paul Barnhurst

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

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

Read More
Episode 8 - Charting a Start-up’s Journey: Financial Models for start-up’s with Zainab Nwachuku
Paul Barnhurst Paul Barnhurst

Episode 8 - Charting a Start-up’s Journey: Financial Models for start-up’s with Zainab Nwachuku

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

  • In this episode, Paul shares some great modeling people and companies to follow to stay up to date on modeling.

Read More
Episode 7 - Are LAMBDAs & Dynamic Arrays the future of Financial Modeling? A lively discussion with 4 modeling experts.
Paul Barnhurst Paul Barnhurst

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

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 Stein 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 Schnoor 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

Read More
Episode 6 -Become a better Modeler by developing a decision-making mindset: Hedieh Kianyfard
Paul Barnhurst Paul Barnhurst

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

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

Read More