Please show the work on Excel

5) Determine the ATWACOC of firm ABC given the information below. Assume a corporate tax rate of 39%. Further assume that the expected common stock dividend next year is $2 per share and it is expected to grow at 8% per annum. (20 points) maturity coupon 6% Book Value $300,000,000 $700,000,000 $250,000,000 $1,000,000,000 # of units 300000 700000 5000000 6 years 12 years 7% price $1,025 $950 $45 $20 Bonds Debentures Preferred Stock Common Stock Retained Earnings 9% 40000000 $2,000,000,000