Hello, can you please assist with solving this in excel?

P9-14 WACC: Book weights and market weights Webster Company has compiled the information shown in the following table. Source of capital Book value Market value After-tax cost Long-term debt $4,000,000 $3,840,000 6.0% Preferred stock 40,000 60,000 13.0 Common stock equity 1,060,000 3,000,000 17.0 Totals $5,100,000 $6,900,000 G/ Finance, Fifteenth Edition, by Chad J. Zutter and Scott B. Smart. Published by Pearson. Copyright @ 2019 by Pearson Education, CHAPTER 9 The Cost of Capital 423 a. Calculate the WACC using book value weights. b. Calculate the WACC using market value weights. c. Compare the answers obtained in parts a and b. Explain the differences