![Learn techniques we teach around the world... Learn techniques we teach around the world...](https://trainingthestreet.com/wp-content/uploads/2023/03/Rahul-1024x682-1.jpg)
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.
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
What Does A Day Look Like?
Who Is This Course For?
![What Does A Day Look Like? What Does A Day Look Like?](https://trainingthestreet.com/wp-content/uploads/2023/03/Students2-1024x631-1.jpg)
![Course Details Course Details](https://trainingthestreet.com/wp-content/uploads/2023/03/lightbulb.png)
Course Details
What’s Included
Schedule
Prerequisites
How Do You Like To Learn?
![In-Person Training In-Person Training](https://trainingthestreet.com/wp-content/uploads/2023/03/Instruction3-175x175-1.png)
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.
![Virtual Training Virtual Training](https://trainingthestreet.com/wp-content/uploads/2023/03/VIRTUAL-SQUARE-175x175-1.jpg)
Course Pricing
Cancellation Policy
See what our students say
![Training The Street Certification Training The Street Certification](https://trainingthestreet.com/wp-content/uploads/2023/03/tts-certification.png)
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.
![MUFG MUFG](https://trainingthestreet.com/wp-content/uploads/2023/03/MUFG-1.jpg)
![Morgan Stanley Morgan Stanley](https://trainingthestreet.com/wp-content/uploads/2023/03/MORGAN-STANLEY.jpg)
![UBS UBS](https://trainingthestreet.com/wp-content/uploads/2023/03/UBS-1.jpg)
![TRUIST TRUIST](https://trainingthestreet.com/wp-content/uploads/2023/03/TRUIST.jpg)
![BLACKSTONE BLACKSTONE](https://trainingthestreet.com/wp-content/uploads/2023/03/BLACKSTONE.jpg)
![MIZUHO MIZUHO](https://trainingthestreet.com/wp-content/uploads/2023/03/MIZUHO-1.jpg)
![STIFEL STIFEL](https://trainingthestreet.com/wp-content/uploads/2023/03/STIFEL.jpg)
![Wells Fargo Wells Fargo](https://trainingthestreet.com/wp-content/uploads/2023/03/WELLSFARGO-1.jpg)
![Fifth Third Bank Fifth Third Bank](https://trainingthestreet.com/wp-content/uploads/2023/03/53RD.jpg)
![BARINGS BARINGS](https://trainingthestreet.com/wp-content/uploads/2023/03/BARINGS.jpg)
![MOELIS MOELIS](https://trainingthestreet.com/wp-content/uploads/2023/03/MOELIS-1.jpg)
![EVERCORE EVERCORE](https://trainingthestreet.com/wp-content/uploads/2023/03/EVERCORE.jpg)
![GREENHILL GREENHILL](https://trainingthestreet.com/wp-content/uploads/2023/03/GREENHILL.jpg)
![New York University New York University](https://trainingthestreet.com/wp-content/uploads/2023/06/NYU-Stern-Logo.png)
![MACQUARIE MACQUARIE](https://trainingthestreet.com/wp-content/uploads/2023/03/MACQUARRIE.jpg)
![LAZARD LAZARD](https://trainingthestreet.com/wp-content/uploads/2023/03/LAZARD.jpg)
![J. P. Morgan J. P. Morgan](https://trainingthestreet.com/wp-content/uploads/2023/06/JP-Morgan_SQUARE-LOGO_2020.png)
![Kellogg School of Management Kellogg School of Management](https://trainingthestreet.com/wp-content/uploads/2023/06/Kellogg-logo.jpg)
![The University of North Carolina The University of North Carolina](https://trainingthestreet.com/wp-content/uploads/2023/06/SecondaryLogo_Color3.png)
![Training The Street Academy Self Study Courses Training The Street Academy Self Study Courses](https://trainingthestreet.com/wp-content/uploads/2023/06/Self_Study_Graphic-bg.png)