Are the WACC, DCF, and cost correct in this? I am confident that the first part of the spreadsheet is correct.

Bonds weight 3096 10% 60% 10096 Capital Structure $ 3,000,000.00 $ 1,000,000.00 $ 6,000,000.00 $ 10,000,000.00 cost WACC 5% 1.50% 10% 19 18% 10.80% B3% 1.80% Preferred Stock Common Stock Total 11-1 After-tax cost of bonds: Semi-Annual YTM= Amua YTM= Cost of Bonds= 3.18% 6.3736 3.82% 11-2 Cost of retained earnings: DCF approach CAPM approach Average 11.10% 14.90% 13.296 12 10% 13.3096 11-3 11-4 Cost of prefered stock Cost of New Common Stock II-SA Bonds Preferred Stock Retained Earnings Total Amount 3,000,000 1,000,000 6.000.000 10,000,000 Weight 3096 1096 6096 10096 Cost 3.8296 11.1096 13.3096 28.2 296 WACC 0.6996 1.1196 7.9896 9.7896 11-5B Bonds Preferred Stock New Common Stock Total Amount 3,000,000 1,000,000 6.000.000 10,000,000 Weight 3096 1096 6096 10096 Cost 3.8296 11.1096 14.9096 29.8296 WACC 0.6996 1.1196 8.9496 10.7496 Bonds weight 3096 10% 60% 10096 Capital Structure $ 3,000,000.00 $ 1,000,000.00 $ 6,000,000.00 $ 10,000,000.00 cost WACC 5% 1.50% 10% 19 18% 10.80% B3% 1.80% Preferred Stock Common Stock Total 11-1 After-tax cost of bonds: Semi-Annual YTM= Amua YTM= Cost of Bonds= 3.18% 6.3736 3.82% 11-2 Cost of retained earnings: DCF approach CAPM approach Average 11.10% 14.90% 13.296 12 10% 13.3096 11-3 11-4 Cost of prefered stock Cost of New Common Stock II-SA Bonds Preferred Stock Retained Earnings Total Amount 3,000,000 1,000,000 6.000.000 10,000,000 Weight 3096 1096 6096 10096 Cost 3.8296 11.1096 13.3096 28.2 296 WACC 0.6996 1.1196 7.9896 9.7896 11-5B Bonds Preferred Stock New Common Stock Total Amount 3,000,000 1,000,000 6.000.000 10,000,000 Weight 3096 1096 6096 10096 Cost 3.8296 11.1096 14.9096 29.8296 WACC 0.6996 1.1196 8.9496 10.7496