Using Excel formulas please

3. Consider the following information for Odarian, Inc.: - Odarian's target capital structure weights are 25% long-term debt, 14% preferred stock, and 61% equity. - The firm has one outstanding 7.03\% bond issue that matures on October 28, 2038, makes semiannual payments, and currently sells for $858 per bond. Assume that October 28, 2023, is the settlement date for the bond issue. - Odarian's preferred stock pays an annual dividend of \$2.67 and currently sells for \$32.76. - The company's common stock's returns have a covariance of 0.00461555255 with the market's returns. The variance of the market's returns is 0.001883899 . The market risk premium is 15.83 percent, and the risk free rate of return is 1.1 percent. - The company's marginal tax rate is 20%. a. (15 points) What is Odarian's weighted average cost of capital? b. (10 points) Odarian operates hardware stores nationwide and plans to open a shop in Nevada. The table below contains the cash flow analysis for this expansion. Use the = NPVO function in Excel to find the project's NPV. Should Odarian open the hardware store? Explain