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

User Feedback

If needed, you can close this dialog to copy and paste text that you see on screen or to grab screenshots. As long as you don't load a new page anything that you've entered into this form will stay here.

Name(Required)
Please leave as much detail as possible and if you're facing an issue include any error messages that you may see.
What device type are you using?(Required)
What web browser are you using?(Required)

Drop files here or
Max. file size: 256 MB, Max. files: 3.
    `