Pro-Forma Capital Structure Analysis & Modeling
Model out a full integrated 3 statement operating model incorporating various capital structure changes
Overview
This Excel-based course will look at the impact of various capital structure options on a company’s projected financials and credit statistics. The course will begin with participants building a 3 statement standalone operating model. From here, participants will examine various financing alternatives (equity and debt) and incorporate these new scenarios into a pro form operating model. Participants will calculate pro forma EPS, accretion-dilution, synergies to breakeven and credit metrics to understand the impact of each alternative on the pro forma financials of the company. Pros and cons of each financing alternative and tax consequences will also be discussed. Topics covered include:
- 3 statement standalone and pro forma financial modeling
- Sources and uses
- Debt and equity financing alternatives
- Pro forma EPS analysis
- Accretion-dilution analysis
- Credit ratio analysis
- Potential credit rating impact
- Scenarios analysis and self-referencing if statements