ALL DONE IN EXCEL

Fiscal year ending: 12/31/2018

Assets: 16,173,000,000

Debt: 7,532,000,000

Shares: 322,884.000

Revenues: 9,061,000,000

EBIT: 475,000,000

Interest: 338,000,000

NetInc: 263,000,000

Stock Price: $39,98

Tax Paid: -126,000,000

Tax Rate: -91.97%

Task 1: Based on the above data, compute the following values:

Debt/Assets Ratio:

Debt/Equity ratio:

Earnings per share:

Interest rate on debt:

Value of interest Tax shield:

Task 2: Consider the following scenario:

the management team Is considering the possibility of increasing the firm's use of debt capital.

They propose to implement a leveraged repurchase, under which the firm would buy 10% of the outstanding shares, issuing long-term debt as needed to finance transaction.

Repurchase ratio: 10.00%

how many shares would be repurchased?

How much would the firm need to borrow to fund this purchase (ignore transaction costs and market price effects)

Based on the interest rate estimated in Task #1, how much (in dollars) would this add to the annual interest expense?

Under the proposal, calculate the following (assuming the proposed transaction has been completed):

Shares outstanding:

Debt:

Interest Expense:

Net income:

Earnings per share:

Debt/Assets ratio:

Debt' Equity ratio:

Value of interest Tax shield:

Breakeven EBIT:

How much would the proposed restructuring add to the value of the firm?

Do you think the proposed restructuring should proceed? Why or why not?

"Get 15% discount on your first 3 orders with us"
Use the following coupon
"FIRST15"

Order Now