What is Odarian's weighted average cost of capital?

Use the NPV function in Excel to find the project's NPV? Should Odarian open the coffee s hop? Explain.

3. Consider the following information for Odarian, Inc. Odarian's target capital structure is 38% long-term debt, 15% preferred stock and 67% equity. The firm has one outstanding 8.03% bond issue that matures on November 7, 2039 makes semiannual payments, and currently sells for $851 per bond. Assume that November 7, 2019, is the settlement date for the bond issue. Odarian's preferred stock pays an annual dividend of $2.37 and currently sells for $1.29 o The company's common stock's returns have a covariance of 0.00359824709 with the market's returns. The variance of the market's returns is 0.001883899. The market risk premium is 11.48 percent, and the risk free rate of return is 1.87 percent . The company's marginal tax rate is 22%. a. What is Odarian's weighted average cost of capital? b. Odarian operates coffee shops nationwide and plans to open a shop in Oregon. The table below contains the cash flow analysis for this expansion. Year 0 1 2 3 4 Cash Flow -$3,500,000 $1,000,000 $2,000,000 $1,400,000 $1,000,000 Use the NPVO function in Excel to find the project's NPV? Should Odarian open the coffee shop? Explain