Please solve on EXCEL and Show steps with formulas. Thank you!

Electronics Galore has 950,000 shares of common stock outstanding at a book value of $10 per share. The market price of the common stock is $38 per share. The company also has 40,000 bonds outstanding that are quoted at 106% of $1,000 face value. What funding weight should be given to debt when the firm calculates its weighted average cost of capital? 0.54 0.82 0.41 0.46