Please help me to solve this problem in manual or excel with step by step.

LG LGA LG5 LG ST9-1 Individual costs and WACC Humble Manufacturing is interested in measuring its overall cost of capital. The firm is in the 40% tax bracket. Current investigation has gathered the following data: Debt The firm can raise debt by selling $1,000-par-value, 10% coupon interest rate, 10-year bonds on which annual interest payments will be made. To sell the issue, an average discount of $30 per bond must be given. The firm must also pay flotation costs of $20 per bond. Preferred stock The firm can sell 11% annual dividend) preferred stock at its $100-per-share par value. The cost of issuing and selling the preferred stock is expected to be $4 per share. Common stock The firm's common stock is currently selling for $80 per share. The firm expects to pay cash dividends of $6 per share next year. The firm's divi- dends have been growing at an annual rate of 6%, and this rate is expected to continue in the future. The stock will have to be underpriced by $4 per share, and flotation costs are expected to amount to $4 per share. Retained earnings The firm expects to have $225,000 of retained earnings avail- able in the coming year. Once these retained earnings are exhausted, the firm will use new common stock as the form of common stock equity financing a. Calculate the individual cost of each source of financing. (Round to the nearest 0.1%. b. Calculate the firm's weighted average cost of capital using the weights shown in the following table, which are based on the firm's target capital structure propor- tions. (Round to the nearest 0.1%. Weight 40% Source of capital Long-term debt Preferred stock Common stock equity Total 15 45 100% c. In which, if any, of the investments shown in the following table do you recommend that the firm invest? Explain your answer. How much new financing is required? Investment opportunity Expected rate of retum 11.2% 9.7 12.9 Initial investment $100,000 500,000 150,000 200,000 450,000 600,000 300,000 16 5 11.8 10.1 10.5