use this method to solve it

Ace Industrial Machines issued 165,000 zero coupon bonds 6 years ago. The bonds originally had 30 years to maturity with a yield to maturity of 6.4 percent. Interest rates have recently decreased, and the bonds now have a yield to maturity of 5.5 percent. The bonds have a par value of $2,000. If the company has a $84.2 million market value of equity, what weight should it use for debt when calculating the cost of capital? (Do not round intermediate calculations and round your answer to 4 decimal places, e.g.. .1616.) Answer is complete but not entirely correct. Weight of debt 0.4987 =140000*PV(5.3%/2,2*24,0,-2000)/(140000*PV(5.3%/2,2*24,0,-2000)+80.2*10^6) =0.49871 Comment >