Complete LBO Modeling in Excel
CPE for CPAs: analyze leveraged transactions with an integrated LBO model and detailed debt schedules.
Practical CPE for accounting professionals
Work through the financing, cash-flow and return mechanics of a leveraged buyout. Build a detailed Excel model to evaluate how operating assumptions, debt terms and exit outcomes affect the transaction.
What you will work on
- Structure sources and uses of funds.
- Integrate pro forma financial statements and detailed debt schedules.
- Model interest, mandatory repayments and cash sweeps.
- Calculate sponsor and management returns, including IRR and multiples of invested capital.
Who this course is for
CPAs working with transaction analysis, financial advisory, lending or corporate finance.
Fit CPE learning around your work
Learn on demand and apply the material through the course activities. Review the CPE program details and completion requirements before enrolling. Credit is earned through successful completion, not purchase alone; acceptance is determined by your state board.
Choose practical CPE you can apply in your next analysis, report or client conversation.
CPE program details
Field of study: Finance — Technical
Program level: Advanced
Delivery method: QAS Self Study
Prerequisites: Financial Statement Analysis, Excel Fundamentals, Introduction to 3-Statement Modeling, 3-Statement Modeling, Real Company Modeling, Valuation Fundamentals, Valuation Modeling, and Short-Form LBO Modeling, or equivalent experience.
Advance preparation: None. Excel desktop is required for hands-on modeling or charting practice.
Credit and completion: 2.6 CPE hours. Complete all required content and reinforcement activities and score at least 70% on the final assessment. A downloadable certificate is issued after successful completion.
Registration and access: Create or sign in to a Pillars account and complete enrollment or purchase. Individual self-study access expires 365 days after enrollment.
Refunds, cancellations, and complaints: Review the Terms & Conditions. Submit program or service complaints through Pillars Support.
Learning objectives
- Explain how a long-form LBO expands on a short-form model by incorporating detailed capital sources, ownership returns, and pro forma financial statements.
- Construct and interpret sources-and-uses information and an opening pro forma balance sheet for a long-form LBO transaction.
- Model multiple debt tranches, PIK interest and dividends, and mandatory or accelerated cash-sweep repayments.
- Project the integrated income statement, balance sheet, and cash flow statement in a long-form LBO model.
- Explain the roles of preferred equity, common equity, management rollover equity, and warrants in a dual-tier equity structure.
- Calculate and interpret returns to sponsor/common equity, mezzanine, and management, including IRR and MOIC outputs.
- Use credit statistics and sensitivity analysis to assess leverage, debt capacity, coverage, and transaction outcomes.
Pillars of Wall Street LLC is registered with the National Association of State Boards of Accountancy (NASBA) as a sponsor of continuing professional education on the National Registry of CPE Sponsors (Registry ID 122036). State boards of accountancy have final authority on the acceptance of individual courses for CPE credit. Complaints regarding registered sponsors may be submitted to the National Registry of CPE Sponsors through its website.
Course Overview
See the lessons, assessments, and required evaluation included in this CPE course.
Course content will appear here when available.