what percentage of the captial structure?

need excel formula in excel sheet

Market value of preferred is 100K Investors expect a return of 12% on this investment PART 1- Calculating a WACC- (30pts). Make sure you answer all questions. Forcefully Delicious Cookies funds itself with Debt, Preferred Stock, and with Equity. Its tax rate is 25%. Please see the info below on FDC's capital structure. Compute the market value of debt, preferred, and equity, the capital structure weights, and the WACC. Please note- you do not need to know anything about preferred stock to answer this question. You just 4 need to read carefully and follow the directions Market value of preferred is 100K Investors expect a return of 12% on this investment 4 . Question- what is the cost of the preferred stock that you will use in calculating the WACC Market value of preferred is 100K Investors expect a return of 12% on this investment PART 1- Calculating a WACC- (30pts). Make sure you answer all questions. Forcefully Delicious Cookies funds itself with Debt, Preferred Stock, and with Equity. Its tax rate is 25%. Please see the info below on FDC's capital structure. Compute the market value of debt, preferred, and equity, the capital structure weights, and the WACC. Please note- you do not need to know anything about preferred stock to answer this question. You just 4 need to read carefully and follow the directions Market value of preferred is 100K Investors expect a return of 12% on this investment 4 . Question- what is the cost of the preferred stock that you will use in calculating the WACC