In this episode of Financial Modeler's Corner, host Paul Barnhurst chats with Nick Boberg, a financial modeler and consultant based in Hamilton, New Zealand. Paul and Nick explore the essentials of building well-structured, effective financial models. They discuss Nick’s approach to simplicity and consistency, the importance of clarity in model design, and the role of competition in refining one’s Excel and modeling skills.

Nick is a financial modeler and the co-founder of Boberg Advisory, a consultancy that specializes in providing financial modeling services to SMEs. With extensive experience as Finance Director at Anglesea Hospital and Associate Director at PwC, Nick has built and reviewed hundreds of models, many focused on cash flow forecasting, budgeting, and management reporting. He is also an accomplished competitor in the Financial Modeling World Cup and the Microsoft Excel World Championships, where he has achieved finalist and semifinalist placements.

Expect to Learn

Why structure and consistency are key in financial modeling
The role of simplicity in building models
Insights from Nick’s competitive modeling career
How to balance technical expertise with user-friendly design

Here are a few quotes from the episode:

"The beauty of financial modeling lies in its simplicity. If you can make a model both functional and easy to follow, you've mastered it." - Nick Boberg
"Consistency in formatting is key. A model that looks clean and well-structured builds trust with the user, especially when it's used for important decision-making." - Nick Boberg

Nick shares that the core of building great financial models lies in structure and simplicity. He emphasizes the importance of creating models that are not only accurate but also easy to follow and understand. Whether in competition or in client work, Nick highlights that clear, well-structured models make a real difference in their effectiveness and usability.

Follow Nick:

LinkedIn: https://www.linkedin.com/in/nickboberg/

Company: https://www.linkedin.com/company/boberg-advisory/

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

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

Visit https://bit.ly/497oAqW and use the code “Podcast” to save 15% when you register.

In today’s episode:

[03:30] – Worst Modeling Experience

[08:08] – Running Boberg Advisory

[12:11] – Competing in Excel Championships

[17:42] – Importance of Structure

[20:00] – Risks of Complex Formulas

[23:20] – Avoiding Hard Codes

[27:13] – Building "Pretty" Models

[30:10] – Dynamic Arrays in modeling

[36:05] – Rapid fire Section

[40:54] – Last Question & Wrap up

Why Structure and Design are Critical Elements of Trust and Credibility in Financial Modeling with Nick Boberg

The FP&A Guy Network

Why Structure and Design are Critical Elements of Trust and Credibility in Financial Modeling with Nick Boberg