Bond valuation Nungesser Corporation's outstanding bonds have a $1,000 par value, a 9% semiannual coupon, 14 years to maturity, and an 7.5% YTM. What is the bond's price? Round your answer to the nearest cent. show how you would derive the solution using excel.