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. $125m new equity
  2. $125m convertible note at 8% (20% conversion premium)
  3. Pay down $75m debt
  4. Refinance rest of debt at 10%

Include interest expense savings and please make your own assumptions

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:

The topic of pensions and other postretirement benefits was considered at length in an accounting theory class. The discussion centered on the following terms: (a) Representational faithfulness (b)...

Q:

In comparing the variability of the tensile strength of two kinds of structural steel, an experiment yielded the following results: n = 13, s 19.2, n2 = 16, and s2 = 3.5, where the units of...

Q:

Using the link below, compose a one-page summary of the video. https://youtu.be/j5PYredaIHo?si=S5RHOo9AWzpbr1hh WHY 90% OF TRADERS LOSE MONEY

Q:

A company is preparing completing their Cash Budget. The following data has been prepared for cash receipts and payments. January February March Cash receipts $1,061,200 $1,182,400 $1,091,700 Cash...