Mastering SaaS Models: Derek Baker's insights on building robust SaaS models
Feb 29, 2024
auto_awesome
Derek Baker shares insights on building robust SaaS models, the challenges faced in financial modeling, importance of business understanding, controversial modeling issues, and the evolution of Excel functionalities. He emphasizes the significance of continuous practice to improve modeling skills and the importance of business acumen for financial modelers.
Modeling cash flows enhances business insights by detecting inefficiencies and enhancing accuracy.
Leveraging dynamic arrays in financial models increases efficiency and versatility, streamlining calculations and automating processes.
Deep dives
Understanding the Importance of Business Operations in Financial Modeling
Modeling the flows of different aspects within a business, such as cash flows on the balance sheet, provides valuable insights into the business's operations. By comprehensively modeling these flows, like understanding how collections and payments correlate, financial modelers can detect inefficiencies or leakage points, enhancing the accuracy and effectiveness of the financial model.
Incorporating Dynamic Arrays in Financial Modeling
Leveraging dynamic arrays in financial models contributes to increased efficiency and accuracy. While still exploring their full potential, dynamic arrays offer the ability to streamline calculations and automate processes, enhancing the overall functionality and versatility of the model.
Strategic Use of Circular References for Scenario Comparison
While avoiding circular references in general financial modeling, utilizing them for scenario comparison can be beneficial. Self-referencing if statements allow for a side-by-side evaluation of different scenarios, aiding in decision-making processes and facilitating a deeper understanding of potential outcomes.
Enhancing Financial Modeling Through Strong Business Acumen
The key to becoming a proficient financial modeler lies in developing a strong understanding of the business. By aligning technical skills with business acumen and partnering closely with business leaders, financial modelers can create models that not only reflect financial data accurately but also effectively support strategic decision-making and organizational growth.
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’.