Question: please provide answer through Microsoft excel with the formulas used for each row The CEO of ABC Inc. is in the process of designing a

please provide answer through Microsoft excel with the formulas used for each row

please provide answer through Microsoft excel
The CEO of ABC Inc. is in the process of designing a recapitalization proposal. Pre-recapitalization, the company has two tranches of debt in its capital structure: 1) senior debt with a value of $800 and 2) junior debt with a value of $600. Unfortunately, an analysis of the operations of ABC Inc. indicates that this is not sustainable. As a result, the following exchange is proposed: Senior creditors receive new senior debt worth $650 (with an interest rate of 8%) and 20% of the firm's equity, while junior creditors receive new junior debt worth $400 (with an interest rate of 12%) and 30% of the firm's equity. The remaining 50% of the firm's equity will be given to the existing shareholders of ABC Inc. According to the recapitalization plan, the CEO agrees to use all available cash for amortization of senior debt. In addition, investment in working capital will be self-financed (ANWC = 0) and CAPEX will be just enough to cover depreciation. Table 1 provides the revised projections for ABC Inc. for the next 5 years. Please complete the following table 1. Fill in the blanks ( Table 1 Year 1 2 3 4 5 EBIT 250.00 263.00 276.00 289.00 304.00 Interest Senior 8% 52.00 Junior 12% 48.00 EBT 150.00 Tax 35% 52.50 Net Income 97.50 Debt Amortization Senior Junior 0 0 0 0 0 Cash Balance Debt Balance Senior 650.00 Jumor 400.00 400 400 400 400 400

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!