The firm is acquiring 1 0 0 % ?ownership in the target company. The firm plans to
Fantastic news! We've Found the answer you've been seeking!
Question:
The firm is acquiring ?ownership in the target company.
The firm plans to exit the investment at the end of Year
There are no interim cash inflows to the firm, in the form of special dividends or otherwise, during the hold period.
All Free Cash Flow in a given period should be used to pay down the Senior Debt balance.
What is the Total Equity Value at exit?
Transcribed Image Text:
EBITDA Purchase Multiple Project WeekFive LTM EBITDA Transaction Assumptions $10,0 Shares Outstanding 10,0x Options Outstanding 10,000 0,000 Implied Enterprise Value $100,0 Average Option Exercise $0,00 Existing Net Debt Implied Equity Value $30,0 FD Shares Outstanding 10,000 $70,0 Implied Price Per Share $7,00 Sources and Uses of Funds Sources Multiple Rate $ mm % Uses Sr. Debt 4,0x 8,00% $40,0 40,0% Equity Purchase Sub. Debt 0,0x 0,00% 0,0 0,0% Refinance Net Debt Mezz. 0,0x 0,00% 0,0 0.0% Fees & Expenses Equity 6,0x 60.0 60,0% Other 10,0x $100,0 100,0% Sr. Debt/EBITDA Net Debt/EBITDA EBITDA Sr. Interest EBITDA / Total Interest Sr. Debt Paydown Time & Date: Source of Projections: Comments Fees & Expenses $ mm Fee % $ mm $70,0 30,0 Sr. Debt 2,00% Sub. Debt 0,00% 0.0 Mezz. Debt 0,00% 0.0 Other Fees $100,0 Total Fees Credit Statistics PF LTM Year 1 Year 2 Year 3 Year 4 Year 5 Year 6 Year 7 Income Statement Assumptions LTM 0 Year 1 1 Year 2 2 Year 3 3 Year 4 4 Year 5 5 Year 6 6 Year 7 7 Sales $50,0 $55,0 $60,5 $66,6 $73,2 $80,5 $88,6 $97,4 Growth % 10,0% 10,0% 10,0% 10,0% 10,0% 10,0% 10,0% EBITDA . $10,0 $11,6 $13,3 $15,3 $16,8 $18,5 $20,4 $22,4 Margin % 20.0% 21,0% 22,0% 23,0% 23,0% 23,0% 23,0% 23,0% Depreciation $2.5 $2,8 $3,0 $3,3 $3,7 $4,0 $4,4 $4,9 Margin % 5,0% 5,0% 5,0% 5,0% 5,0% 5,0% 5,0% 5,0% L Amortization $0,0 $0,0 $0,0 $0.0 $0.0 $0.0 $0,0 $0,0 Margin % 0,0% 0,0% 0,0% 0,0% 0,0% 0,0% 0,0% 0,0% EBIT $7,5 $8,8 $10,3 $12,0 $13,2 $14,5 $15,9 $17,5 Interest Expense Sr. Debt Sub. Debt Mezz. Debt Amort. of Financing Fees Total Interest Expense EBT Taxes 40,0% Net Income 0,0 0,0 0,0 0,0 0,0 0,0 0,0 0,0 0,0 0,0 0,0 0,0 0,0 0.0 0,0 0.0 0,0 0,0 0,0 $0,0 $0,0 $0.0 $0.0 $0,0 $0,0 $0,0 $8,8 $10,3 $12,0 $13,2 $14,5 $15,9 $17,5 4.1 4,8 5.3 5,8 6,4 7,0 $5,3 $6,2 $7,2 $7,9 $8,7 $9,6 $10,5 Cash Flow and Debt Repayment Summary Year 1 Year 2 Year 3 Year 4 Year 5 Year 6 Year 7 Net Income $5,3 $6,2 $7,2 $7,9 $8,7 $9,6 $10,5 Depreciation & Amortization 2,8 3,0 3,3 3,7 4,0 4,4 4,9 Capital Expenditures 2,5% of Sales (1,4) (1,5) (1,7) (1,8) (2,0) (2,2) (2,4) Working Capital 10,0% of Change in Sales (0,5) (0,6) (0,6) (0,7) (0,7) (0,8) (0,9) Free Cash Flow $6,2 $7,1 $8,2 $9,1 $10.0 $11,0 $12,1 Sr. Debt at Beginning of Period $40,0 $40,0 $40,0 $40,0 $40,0 $40,0 $40,0 Repayment of Senior Debt Sr. Debt at End of Period $40,0 $40,0 $40,0 $40,0 $40,0 $40,0 $40,0 Cash at Beginning of Period Excess Cash from Operations after Debt Repayment Cash at End of Period $0,0 $6,2 $13,3 $21,5 $30,6 $40,6 $51,6 6,2 7.1 8,2 9.1 10,0 11,0 12,1 $6,2 $13,3 $21,5 $30,6 $40,6 $51,6 $63,6 Enterprise Value in Exit Year (Based on Purchase Price Multiple) Net Debt in Exit Year Equity Value IRR in Exit Year Equity Investment Year 1 Return Year 2 Return Year 3 Return Year 4 Return Year 5 Return Year 6 Return Year 7 Return IRR to Financial Sponsor Year 5 EBITDA Purchase Multiple Project WeekFive LTM EBITDA Transaction Assumptions $10,0 Shares Outstanding 10,0x Options Outstanding 10,000 0,000 Implied Enterprise Value $100,0 Average Option Exercise $0,00 Existing Net Debt Implied Equity Value $30,0 FD Shares Outstanding 10,000 $70,0 Implied Price Per Share $7,00 Sources and Uses of Funds Sources Multiple Rate $ mm % Uses Sr. Debt 4,0x 8,00% $40,0 40,0% Equity Purchase Sub. Debt 0,0x 0,00% 0,0 0,0% Refinance Net Debt Mezz. 0,0x 0,00% 0,0 0.0% Fees & Expenses Equity 6,0x 60.0 60,0% Other 10,0x $100,0 100,0% Sr. Debt/EBITDA Net Debt/EBITDA EBITDA Sr. Interest EBITDA / Total Interest Sr. Debt Paydown Time & Date: Source of Projections: Comments Fees & Expenses $ mm Fee % $ mm $70,0 30,0 Sr. Debt 2,00% Sub. Debt 0,00% 0.0 Mezz. Debt 0,00% 0.0 Other Fees $100,0 Total Fees Credit Statistics PF LTM Year 1 Year 2 Year 3 Year 4 Year 5 Year 6 Year 7 Income Statement Assumptions LTM 0 Year 1 1 Year 2 2 Year 3 3 Year 4 4 Year 5 5 Year 6 6 Year 7 7 Sales $50,0 $55,0 $60,5 $66,6 $73,2 $80,5 $88,6 $97,4 Growth % 10,0% 10,0% 10,0% 10,0% 10,0% 10,0% 10,0% EBITDA . $10,0 $11,6 $13,3 $15,3 $16,8 $18,5 $20,4 $22,4 Margin % 20.0% 21,0% 22,0% 23,0% 23,0% 23,0% 23,0% 23,0% Depreciation $2.5 $2,8 $3,0 $3,3 $3,7 $4,0 $4,4 $4,9 Margin % 5,0% 5,0% 5,0% 5,0% 5,0% 5,0% 5,0% 5,0% L Amortization $0,0 $0,0 $0,0 $0.0 $0.0 $0.0 $0,0 $0,0 Margin % 0,0% 0,0% 0,0% 0,0% 0,0% 0,0% 0,0% 0,0% EBIT $7,5 $8,8 $10,3 $12,0 $13,2 $14,5 $15,9 $17,5 Interest Expense Sr. Debt Sub. Debt Mezz. Debt Amort. of Financing Fees Total Interest Expense EBT Taxes 40,0% Net Income 0,0 0,0 0,0 0,0 0,0 0,0 0,0 0,0 0,0 0,0 0,0 0,0 0,0 0.0 0,0 0.0 0,0 0,0 0,0 $0,0 $0,0 $0.0 $0.0 $0,0 $0,0 $0,0 $8,8 $10,3 $12,0 $13,2 $14,5 $15,9 $17,5 4.1 4,8 5.3 5,8 6,4 7,0 $5,3 $6,2 $7,2 $7,9 $8,7 $9,6 $10,5 Cash Flow and Debt Repayment Summary Year 1 Year 2 Year 3 Year 4 Year 5 Year 6 Year 7 Net Income $5,3 $6,2 $7,2 $7,9 $8,7 $9,6 $10,5 Depreciation & Amortization 2,8 3,0 3,3 3,7 4,0 4,4 4,9 Capital Expenditures 2,5% of Sales (1,4) (1,5) (1,7) (1,8) (2,0) (2,2) (2,4) Working Capital 10,0% of Change in Sales (0,5) (0,6) (0,6) (0,7) (0,7) (0,8) (0,9) Free Cash Flow $6,2 $7,1 $8,2 $9,1 $10.0 $11,0 $12,1 Sr. Debt at Beginning of Period $40,0 $40,0 $40,0 $40,0 $40,0 $40,0 $40,0 Repayment of Senior Debt Sr. Debt at End of Period $40,0 $40,0 $40,0 $40,0 $40,0 $40,0 $40,0 Cash at Beginning of Period Excess Cash from Operations after Debt Repayment Cash at End of Period $0,0 $6,2 $13,3 $21,5 $30,6 $40,6 $51,6 6,2 7.1 8,2 9.1 10,0 11,0 12,1 $6,2 $13,3 $21,5 $30,6 $40,6 $51,6 $63,6 Enterprise Value in Exit Year (Based on Purchase Price Multiple) Net Debt in Exit Year Equity Value IRR in Exit Year Equity Investment Year 1 Return Year 2 Return Year 3 Return Year 4 Return Year 5 Return Year 6 Return Year 7 Return IRR to Financial Sponsor Year 5
Expert Answer:
Related Book For
Income Tax Fundamentals 2013
ISBN: 9781285586618
31st Edition
Authors: Gerald E. Whittenburg, Martha Altus Buller, Steven L Gill
Posted Date:
Students also viewed these finance questions
-
Read the case study "Southwest Airlines," found in Part 2 of your textbook. Review the "Guide to Case Analysis" found on pp. CA1 - CA11 of your textbook. (This guide follows the last case in the...
-
Managing Scope Changes Case Study Scope changes on a project can occur regardless of how well the project is planned or executed. Scope changes can be the result of something that was omitted during...
-
Strickland Co. currently charges manufacturing over-head costs to products using machine hours. However, company management believes that the use of ABC would provide more realistic cost estimates...
-
What are the benefits of using material requirements planning (MRP)?
-
Heating is a physical process. When mercuric oxide is heated, it becomes mercury and oxygen. Does this mean that mercuric oxide is a mixture rather than a compound?
-
On December 14, 2011, appellant Aaron Olson contracted to receive telephone service from respondent CenturyLink and also applied for reduced-rate service that CenturyLink provides through Minnesotas...
-
Ferraro, Inc. established a share-appreciation rights (SAR) program on January 1, 2010, which entitles executives to receive cash at the date of exercise for the difference between the market price...
-
3. (25 points) Consider two firms out of a competitive industry. They have the following technologies: C(y) = y + 2y; C2(y) = 1.5y + 3y. Show these firms' individual supply functions on a...
-
Steel is an alloy consisting of Fe with a small amount of C. Elemental Cr can be added to steel to make the steel less likely to rust; Cr atoms react with oxygen in the air to form a nonreactive...
-
You have to pay 11.9% retail tax where you live and you are buying a $17.60 case to protect your phone, what number should you multiply the price of the case by, in order to get the total amount of...
-
Preston Partners, a calendar-year partnership, has two unrelated general partners, Jack Preston and Diane Dunn. Jack has a 75 percent ownership interest in the partnership and Diane has a 25 percent...
-
Approximately a year and a half ago, you were hired as a Contracting Officer of NAVSYSCOM. You were previously employed by Company B, a DoD contractor. WHen you left, you maintained your 401K, but it...
-
5. There are three categories for movie tickets, with the following prices: General admission: $12.50 Senior citizen: Child under 10: $11.00 $9.00 Write a Python program that prompts the customer for...
-
Perform an online search using the words "old economy new economy marketing jobs" and read three (3) related sites. Once you have read the article or articles, use the websites below and any other...
-
The diagram shows the classification of the cosmological models with > 0 according to the values of the parameters 0 and M0 . A straight line could be added to this figure that would separate...
-
Interview managers at three companies in your area about their use of ERP. How have their experiences been similar? What accounts for the similarities and differences?
-
Sherry rents her vacation home for 6 months and lives in it for 6 months during the year. Her gross rental income during the year is $4,000. Total real estate taxes for the home are $950, and...
-
Carl and Jenny adopt a Russian orphan. The adoption takes 2 years and two trips to Russia and is final in 2012. They pay $6,000 in 2011 and $7,500 in 2012 of qualified adoption expenses, and have AGI...
-
Phil and Linda are 25-year-old newlyweds and file a joint tax return. Linda is covered by a retirement plan at work, but Phil is not. a. Assuming Phil's wages were $27,000 and Linda's wages were...
-
Is Fairmont in compliance with company policy that requires explicit approval of all hours of eighty hours or more.
-
d that Fairmont is not in complianThe forensic audit has determinece with Federal withholding requirements for FICA and Medicare because FICA and Medicare were not withheld from employee paychecks...
-
Which of the following is not a technique to conceal inventory shrinkage? 1. Counting and valuing the physical inventory at the end of each year 2. Writing off inventory after physical inventory...
Study smarter with the SolutionInn App