please screenshot and work problem using excel worksheet in the template's order that was given in the picture

C D G H 103 104 105 106 Q7. Hitech Company's capital structure is as follows: 107 Debt 25% 108 Preferred Stock 20% 109 Common equity 55% 110 The after-tax cost of debt is 7%; the cost of preferred stock is 12 percent; and the cost of common equity (in the form of retained earnings) is 14 percent. Calculate Hitech Company's 111 weighted average cost of capital in a manner similar to Q6 112 Cost (after Weighted tax) 113 Weights Cost 114 Debt (K.) 115 Preferred Stock 116 Common equity (Ke) 117 Weighted average cost of 118 capital (Ka) Unit 7 Problems Type here to search