Software Industry Analysis & Financial Modeling
Learn the financial essentials of software industry analysis, including customer retention metrics, software-specific accounting issues, and software company modeling. You’ll build a sample software company model to show how customer analysis and retention metrics integrate into a three-statement financial model.
Instructor-led courses, learn in-person or virtually
Learn Key Software Industry Financial Modeling Techniques
Utilizing the same case study based approach delivered for our corporate clients, this course provides hands on training focused on the software industry.
Participants will explore the fundamentals of software analysis, including customer retention metrics, software-specific accounting issues, and other considerations important to building and understanding software models. This course is highly focused on developing key Excel skills while still introducing key industry fundamentals and financial metrics that are unique to the software industry.
Led by our experienced instruction team of former practitioners, you get a unique blend of industry insight combined with a passion for teaching. The average TTS instructor has been part of the team for 8.5 years.
What you will learn:
Excel Best Practices and Efficiencies
Build a software industry financial model
Software industry accounting
Customer retention metrics
Agendas
Software Industry Analysis
Key Fundamental Software Industry Topics:
- Overview of software income statement analysis and the importance of understanding unit economics beyond consolidated group performance
- Discuss and evaluate ACV and MRR and discuss key software KPIs including logo, gross dollar and net dollar retention
- Build customer-level cohort analysis including cleaning, filtering, and analyzing data using text functions, Pivot tables and Logic+math functions (SUMIF, COUNTIF, ROUNDUP and complex Nested IFs) in Excel
- Review Lookup functions including VLOOKUP, HLOOKUP, LOOKUP, INDEX, and MATCH
- Build complex nested statements to calculate churn, retention, upsell analysis
Software Industry Financial Modeling
Key Software Industry Financial Modeling Topics:
- Introduce LTV and CAC analysis and calculate metrics using both pen-and-paper and Excel exercises
- Differentiate between bookings, billings and revenue and discuss the importance of deferred revenue and deferred compensation expenses in accrual accounting
- Discuss capitalization of certain costs including internal- and external-use software and certain customer acquisition costs (CAC)
- Build the “World’s Easiest Software Company” model to show how customer analysis and retention metrics integrate into three-statement financial model
Unlock your career potential
Training The Street has been teaching the biggest finance firms for over 20 years. To help unlock your career potential, we offer certificates to provide the recognition you deserve.
After you finish your course, you will receive a certificate which can be easily added to your LinkedIn profile.
How Do You Like To Learn?
Flexible Learning Options
Our courses are available in both in-person or virtual classroom formats. If you learn better in your own space or traveling isn’t convenient, virtual is great solution. Either way, you get the skills and support you need to succeed.
What Does A Day Look Like?
Whether you join us in-person or virtually, the classroom is a combination of micro-lectures and hands-on exercises that ensure retention levels are high and students stay engaged. You’ll use some of the most innovative Excel based learning tools available, providing instant performance feedback as well as the opportunity for as many “reps” as you need to be “desk ready”.
What’s Included
Instructor-led classroom training
Ongoing instructor support
One-year online access to course materials, Excel files, and related self-study courses for additional reference and review
Excel model template
Excel model solution
Schedule
9:00 am to 5:00 pm each day with an hour lunch around noon and shorter breaks throughout the day.
Prerequisites
Fundamental knowledge of financial accounting: TTS recommends our self-study book, Fundamentals of Financial Accounting and Analysis. For additional information please visit TTSAcademy.com
Who Is This Course For?
- Firms that need to get small groups or individuals up to speed on the software industry (new, lateral, or off-cycle hires)
- Financial services professionals looking to learn the intricacies of the software industry
- Those looking to transition into the software industry and seeking a better understanding of how to model and understand the software industry
Course Pricing
$2,300 (2 days)*
* register at least 30 days in advance
– Group rates available
– Discounts offered to existing clients
Standard registration inside 30 days:
$2,500 per day
Cancellation Policy
Cancellations up to 14 days before the workshop will receive a full refund. Cancellations within 14 days of a course will not be refunded. TTS reserves the right, at its sole discretion, to cancel a course. If TTS cancels a course, payments are refunded in full.
Questions? Please contact info@trainingthestreet.com for more information.
Can't Attend A Live Course?
Learn Online
- Proven curriculum used by our top finance, consulting, and corporate clients
- Same experienced instructors
- Learn at your own pace