Question: Create a pro forma cap table (with formulas) and sources and uses for the following: Current Cap and Assumptions: $25m minimum cash $25m EBITDA Year

Create a pro forma cap table (with formulas) and sources and uses for the following:

Current Cap and Assumptions:

  1. $25m minimum cash
  2. $25m EBITDA Year 2021
  3. $250m term loan with a 10% coupon
    1. $75m prepayable at par
    2. $175m prepayable at 1.5%
  4. $125m equity

Investor 1:

  1. $250m new equity
  2. Pay down $125m debt
  3. Refinance rest of debt at 8%

Include EBITDA multiples, interest coverage ratio, and interest expense savings

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!

Q:

Create a pro forma cap table (with formulas) and sources and uses for the following: Current Cap and Assumptions: $25m minimum cash $25m EBITDA Year 2021 $250m term loan with a 10% coupon $75m...

Q:

Create a pro forma cap table (with formulas) and sources and uses for the following: Current Cap and Assumptions: $25m minimum cash $25m EBITDA Year 2021 $250m term loan with a 10% coupon $75m...

Q:

Create a pro forma cap table (with formulas) and sources and uses for the following: Current Cap and Assumptions: $25m minimum cash $25m EBITDA Year 2021 $250m term loan with a 10% coupon $75m...

Q:

Create a pro forma cap table (with formulas) and sources and uses for the following: Current Cap and Assumptions: $25m minimum cash $25m EBITDA Year 2021 $250m term loan with a 10% coupon $75m...

Q:

Create a pro forma cap table (with formulas) and sources and uses for the following: Current Cap and Assumptions: $25m minimum cash $25m EBITDA Year 2021 $250m term loan with a 10% coupon $75m...

Q:

Create a pro forma cap table (with formulas) and sources and uses for the following: Current Cap and Assumptions: $25m minimum cash $25m EBITDA Year 2021 $250m term loan with a 10% coupon $75m...

Q:

Create a pro forma cap table (with formulas) and sources and uses for the following: Current Cap and Assumptions: $25m minimum cash $25m EBITDA Year 2021 $250m term loan with a 10% coupon $75m...

Q:

Create a pro forma cap table (with formulas) and sources and uses for the following: Current Cap and Assumptions: $25m minimum cash $25m EBITDA Year 2021 $250m term loan with a 10% coupon $75m...

Q:

excel finance formulas-how to create a pro forma for income statement and balance sheet from the following information provided. Open the data worksheet and delete all other student data but your...

Q:

end of year 10. The principal on the high-yield notes is all due in ten years (i.e., year 16). All debt repayments occur at the end of the year. K. Any excess cash proceeds (after working capital and...

Q:

Anthony promises to pay McCarthy $10,000 if McCarthy reveals to the public that Washington is a Communist. Washington is not a Communist and never has been. McCarthy successfully persuades the media...

Q:

The Esquer mechanic shop incurred these costs below while manufacturing car products: Direct materials used: $117,200 Factory supplies used: $14,500 Direct labor: $232,800 Advertising expense:...

Q:

Pesto Corporation acquired 6 5 percent of Sauce Corporation s common stock on January 1 , 2 0 X 7 , for $ 2 7 4 , 3 0 0 in cash. At the acquisition date, the book values and fair values of Sauce s...

Q:

Draw a class diagram and its relationship based on the following statements. You can use any UML tool/software to represent your class diagram. Do NOT copy and paste your diagram, use the attachment...