Can you please provide the pre-tax WACC and After-tax WACC formulas that are used in excel.

TTC wants to gain a starting point as to where they are currently. As of today, the company has $3.2 billion in debt, total equity capitalization

of $51 billion, and an equity beta of 1.26. Included in TTC's assets are $14.6 billion in cash and risk free securities. The company is currently

is experiencing a risk free rate of interest at 4% and a market risk premium of 5%. Based on this information, address the questions below.

What is TTC's enterprise value?

68400000000

What is the beta of TTC's business assets?

1.6227

What is the WACC of TTC?

8.2542

TTC currently has common stock with a market value of $8 billion, along with their debt of $3.2 billion. Investors are anticipating a 15% return on stock, and a 5% return on debt. If TTC were to issue $3.2 billion of new stock in order to pay off the debt, what would be the anticipated return of the stock after this transaction? What would happen to the return on stock if the company were instead to take out $1 billion in debt to repurchase shares? Assume both transaction would occur in a perfect market.

Anticipated stock return after stock issuance to pay off debt:

0.121429

Anticipated return after increase of debt to repurchase shares:

0.138889

For the scenarios above, TTC wants to evaluate their WACC on a pretax and after tax basis. What will be the WACC for each situation outlined in the previous scenario?

After stock issuance to pay off debt

Pre-Tax WACC

After Tax WACC

After increase of debt to repurchase shares

Pre-Tax WACC

After Tax WACC