i would like a breakdown on how to solve this in excel

Suppose your firm has decided to use a divisional WACC approach to analyze projects. The firm currently has four divisions, A through D, with average betas for each division of 0.8, 1.1, 1.5, and 1.7, respectively. Assume all current and future projects will be financed with 35 percent debt and 65 percent equity, the current cost of equity (based on an average firm beta of 1.3 and a current risk-free rate of 6 percent) is 15 percent and the after-tax yield on the company's bonds is 11 percent. What will the WACCs be for each division? (Do not round intermediate calculations and round your final answers to 2 decimal places.) WACCS 11.35 12.70 % % Division A Division B Division C Division D 14.50 % 15.40