please use formula or excel to calculate. please explain me as much you can.

Zero-coupon bond. Wesley Company will issue a zero-coupon bond this coming month. The projected bond yield is 10%. If the par value is $5,000, what is the bond's price using a semiannual convention if a. the maturity, is 15 years? b. the maturity is 35 years? c. the maturity is 60 years? d. the maturity is 80 years? a. What is the price of the bond using a semiannual convention if the maturity is 15 years? $ (Round to the nearest cent.) b. What is the price of the bond using a semiannual convention if the maturity is 35 years? $ (Round to the nearest cent.) c. What is the price of the bond using a semiannual convention if the maturity is 60 years? $ (Round to the nearest cent.) d. What is the price of the bond using a semiannual convention if the maturity is 80 years? $ (Round to the nearest cent.)