Hello,

I need help with this one question that involves excel (screenshot included). I need to find the answers using excel formulas. The issue is that for the maturity date and settlement date the formula is a date but it is not showing in the cells as a date it is showing as a number. I tried to format it as a date but it won't change in the cell regardless. The formula I am trying to use is PRICE(settlement, maturity, rate, yld, redemption, frequency, [basis]). I am also not sure what number to uses for "redemption" in the formula

Input Area: Bonds outstanding 195000 Settlement date 40179 Maturity date 49675 Annual coupon rate 0 Coupons per year 2 Yield to maturity 0.049 Market value of equity 73000000 Output Area: Bond price - use Excel PRICE function Market value of debt Value of firm Weight of debtLO3 18. Calculating Capital Structure Weights Ace Industrial Machines issued 195,000 zero coupon bonds four years ago. The bonds originally had 30 years to maturity with a yield to maturity of 5.2 percent. Interest rates have recently decreased, and the bonds now have a yield to maturity of 4.9 percent. If the company has a $73 million market value of equity, what weight should it use for debt when calculating the cost of capital