Ian Schnoor: Going from Good to Great in Financial Modeling
FP&A Today Episode 37

Ian Schnoor: Going from Good to Great in Financial Modeling

This episode is all about financial modeling from one of the world’s experts. Ian Schnoor, CFA, CFM is Executive Director at the Financial Modeling Institute (FMI) & President and Founder at The Marquee Group. In this episode, he provides frank assessment of why most financial models fail and how you can take instant actions to instantly transform your financial modeling.

This is absolutely essential listening for anyone considering taking the Financial Modeling Institute’s world-respected accreditation program. The program is recognized by companies like Goldman Sachs, Moody’s KPM and Morgan Stanley as the most rigorous validation of financial modeling skills and ranges from foundational, to advanced, to Chartered Financial Modeler and Master Financial Modeler.

In this episode:

  • From investment banking to creating the world’s only accredited financial modeling training
  • The skills you will need to pass the robust accreditation by the Financial Modeling Institute
  • Why employers are increasingly requiring proof of financial modeling skills
  • The multi-disciplinary skills required to excel in modeling including design, data flow, communication and storytelling
  • How the integrated 3 statement model is the table stakes for being considered a good financial modeler
  • How you can get your financial model humming smoothly - you should not have to pop your car hood to show the engine
  • The power of a committee approach to modeling and design in a company
  • Nixing our favorite function question: There should be no favorites in Excel, but pick the tools that will help you to get the job done you have in front of you

Watch the full show on YouTube

Read the full transcript and blog

Follow Ian Schnoor, CFA, CFM

Learn about the The Marquee Group

Learn about The Financial Modeling Institute (FMI) and the FMI Certifications offered.

Follow Paul Barnhurst

Follow Datarails

If you would like to earn CPE Credit for listening to this episode visit Earmarkcpe.com. Download the app, take a short quiz, and get your CPE Certificate.

FP&A Today is brought to you by Datarails

Datarails is the financial planning and analysis platform that automates data consolidation, reporting and planning, while enabling finance teams to continue using their own Excel spreadsheets and financial models.

Get in touch at www.datarails.com

Roger Crawley

Vice President - Valuation, Modeling and Economics at EY

2 年

I often use car analogies when taking about models because of the engine concept. I'm going to add this one to my list. I often ask people if they would pick someone off a street corner to fly them in a plane, this is what many do with some of their most critical models.

Danielle Stein Fairhurst

Financial Modeller | Author | Microsoft MVP | Corporate Trainer

2 年

I'm only half-way through listening to this fantastic interview by Paul Barnhurst with Ian Schnoor, CFA, CFM and I'm finding myself nodding furiously - especially this bit: "People have this idea of a modeller who sits in a corner all day long working on spreadsheets but in fact a good modeller is spending half their time at most on Excel and the rest of it requires people skills; asking questions, collecting data, pushing back, challenging, presenting, collecting feedback, listening. It’s multidisciplinary." I couldn't agree more!

Irwin I.

Since 2011 Trainer/Auditor Financial Modeling using FAST Standard & Corporate Finance using Excel & since 2016 Trainer Business Intelligence using Microsoft Power BI

2 年

Adriyani Sahidi

Oana Labes, MBA, CPA

Helping Mid-Market CEOs Grow with CFO Intelligence, Real-Time Financial Dashboards & Board-Ready Forecasts and Insights | Speaker and CEO FinCoach | oanalabes.com | financiario.com | Join 450,000+ Followers and Readers

2 年

Love Ian and his teaching style, looking forward to this Paul!

John Woods, MBA

Senior Accountant @ Cheniere | CPA (2/4) & CFA Candidate | Valuation | FP&A | DCF Modeling | Financial Reporting

2 年

Great interview!

要查看或添加评论,请登录

Paul Barnhurst的更多文章

社区洞察

其他会员也浏览了