PLEASE SHOW EXCEL FUNCTION! You can ignore the extra numbers to the side in regards to the Total Market value and second % total, that was my attempt to work out the problem. NEED HELP WITH THE BLOCKS IN RED. Thank you!!

Stark Industries has the following capital structure: Debt is represented by bonds issued 5 years ago with an original maturity of 15 years, a coupon rate of 6.5%, a par value of $1,000, and a quoted price of 102.16. The bonds pay interest semiannually. The pays a $8.00 dividend preferred stock annually and is currently priced at $78.40 per share. The common stock is priced at $108.70 and just paid a dividend of $2.50. The dividend is expected to grow at 5.9% per year from here on out. Stark Industries has a marginal tax rate of 20%. Calculate the book-value weights for each source of capital. (10 points total) Calculate the market-value weights for each source of capital. (10 points total) Calculate the market-value weights for each source of capital. (10 points total) Calculate the after-tax costs of capital for each source of capital. (10 points total) Calculate the weighted average cost of capital using both the book value and market value weights. (10 points total)