Excel efficiency and customer data analysis
Learn to efficiently and rigorously analyze customer and financial data. Topics include customer segmentation, cohorts, ARR bridges and retention, price-volume trends, and P&L analysis.
We teach analysts and associates to analyze businesses, build financial models, and understand the reasoning behind each step. They learn to do the work themselves and to use AI to accelerate their work. They develop the understanding to question the output and recognize when something doesn’t make sense.
Training for analysts and associates at private equity, growth equity, and private credit firms, both as they start in the role and as they take on more complex work. We tailor the topics, depth, and pace to their experience and your firm’s investment focus.
Learn to efficiently and rigorously analyze customer and financial data. Topics include customer segmentation, cohorts, ARR bridges and retention, price-volume trends, and P&L analysis.
Understand how business transactions flow through the financial statements and how earnings differ from cash flow. Topics include revenue and expense recognition, cash conversion, and NWC dynamics and peg negotiation. For teams investing in software, we also focus on deferred revenue, capitalized software, and deferred commissions.
Build operating models and LBOs from scratch, including sources and uses, financial statements, debt schedules, and investment returns. Use back-of-the-envelope calculations to sanity-check the model and understand what drives returns. Additional topics include add-on acquisitions, tax considerations, and value creation bridges.
Understand how deal terms affect ownership and returns for investors and management. Build cap tables and equity waterfalls covering primary and secondary investments, convertible and participating preferred equity, and management options.
Learn to work effectively with AI across the investment process and your day-to-day responsibilities, from analyzing data and reviewing data rooms to preparing investment memos, tracking workstreams, and building dashboards. Learn to provide context and build reusable workflows while checking work and challenging conclusions.
We explain the reasoning behind each concept. Through hands-on modeling and analysis, participants learn to do the work and sanity-check it.
Our training is highly interactive. We ask questions throughout class to help participants build a strong grasp of the concepts.
Katie and Suzanne bring experience in private equity, leveraged finance, and operational leadership. Their teaching connects technical concepts to real examples from those roles.
We offer comprehensive analyst and associate programs as well as focused training on specific topics. We adapt the examples to your investment approach and can incorporate your firm’s models.
We recommend the depth, pace, and grouping based on participants’ backgrounds, with pre-work assigned where helpful.
New analyst programs typically include 20–25 hours of live instruction; new associate programs, around 15 hours. We offer virtual and in-person training, with timing and pacing planned around your team’s schedule.
Questions about what to expect?
Visit our FAQsTell us about your team. We’ll recommend the right training.