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

Create a pro forma cap table (with formulas) and sources and uses

Create a pro forma cap table (with formulas) and sources and uses for the following: Current Cap and Assumptions: a. $25m minimum cash b. $25m EBITDA Year 2021 c. $250m term loan with a 10% coupon a. $75m prepayable at par b. $175m prepayable at 1.5% d. $125m equity Inv a. $250m new equity b. Pay down $125m debt c. Refinance rest of debt at 8% Investor 2: a. $125m new equity b. $125m convertible note at 8% (20% conversion premium) c. Pay down $75m debt d. Refinance rest of debt at 10% Include EBITDA multiples, interest coverage ratio, and interest expense savings

Step by Step Solution

★★★★★

3.52 Rating (159 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock

Answer Current Cap Table Equity 125m Debt 250m EBITDA 25m EBITDA Multiple 5x I... View full answer

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 Accounting Questions!

Sources and Uses for the year just ended, you have gathered the following information about the Holly Corporation. a. A $200 dividend was paid. b. Accounts payable increased by $500. c. Fixed asset...

Using Table 6-13, create a pro forma balance sheet using the percentage of sales method. If net income next year is $50,000, answer the following: a. How much did the owners take out of the business?...

Create a pro forma Income Statement and Balance Sheet for the company's current fiscal year. Incorporate (a) the information provided in their current financial statements, (b) additional information...

Finally, one can determine the layout of chunks to disks with the following code. The basic idea is to select N random patterns, and to exhaustively read together all pairwise combinations of the...

a. Use the Executive Paper model (Tables 29.6???29.8) to produce pro forma income statements, balance sheets, and sources and uses of funds statements for 2000 and 2001. Assume business as usual...

Complete the requirements for each of the following independent cases: Case A. Dr Pepper Snapple Group, Inc., is a leading integrated brand owner, bottler, and distributor of nonalcoholic beverages...

The statements of financial position, cash flows, income and movements of non-current assets of Dragon plc for the year ended 30 September 20X6 are set out below: (i) Statement of financial position...

(Multiple Choice Questions) 1. CPA QUESTION: Decal Corp. incurred substantial operating losses for the past three years. Unable to meet its current obligations, Decal filed a petition of...

Compute the amount of interest during 2014, 2015, and 2016 for the following note receivable: On May 31, 2014, Main Street Bank lent $220,000 to Ron Rowlette on a two-year, 5% note. 2. Which party...

Using the data from E8-20, indicate the effects on net assets and EPS for the following dates: 1. June 1 (date of declaration) 2. July 15 (date of record) 3. August 14 (date of payment) Data from...

Via Gelato is a popular neighborhood gelato shop. The company has provided the following cost formulas and actual results for the month of June: Fixed Element per MonthVariable Element per...

Gary was driving back to the office from his off-site construction job on Friday. He had put in a long week and just wanted to go home. But a text from William back in the office reminded him to...

The next exercise is designed to use an interactive visualization tool. The file LaptopSales.csv is a comma-separated file with nearly 300,000 rows. It has been provided by ENBIS (the European...

Dr. Guest discussed the concept of "resource recovery" as a potential solution to sanitation challenges faced by developing communities. Using the information provided in the video and your own...

Problem 2-20 (Algo) Plantwide versus Multiple Predetermined Overhead Rates: Service Industry (LO2-1, LO2-2, LO2-3, LO2-4] McCullough Hospital uses a job-order costing system to assign costs to its...

Year end is 31 December. XYZ decided to change the method of valuation of raw materials from the weighted average cost method to FIFO. Change In accounting policy has been accounted for during the...

5 6 9 . Tesla metre per ampere ( T . m / A ) is the unit for the measurement of Magnetic susceptibility Magnetic moment Permeability of free space Flux density

Uniform electric field in Figure a uniform electric field is directed out of the page within a circular region of radius R = 3.00 cm. The magnitude of the electric field is given by E = (4.50 x 10-3...

Woody's Widget Shop has the following information: The average widget has a sales price of $18; raw materials for the widget are $4, and it takes 30 minutes to assemble one widget. Production labor...

N. Ebriate, a college student at a party university, decides to forego beer drinking and invest the $100 he saves at the end of each month in a mutual fund that is currently earning 11 percent...

a. Construct a personal income statement for the Humperdinck family using the following information: salaries, $42,000; mortgage payment, $7,980; food, $2,400; interest income, $150; transportation,...

A sociologist assigned to a correctional institution was interested in studying the relationship between intelligence and delinquency. A delinquency index (ranging from 0 to 50) was formulated to...

Following a recent congressional election, a political scientist attempted to investigate the relationship between campaign expenditures on television advertisements and subsequent voter turnout. The...

Sales revenue (Y) and advertising expenditure (X) data for a large retailer for the period 1988-1993 are given in the following table. a. Does the plot of Y versus X suggest that a linear...