Bond valuation
Callaghan Motors' bonds have 19 years remaining to maturity. Interest is paid annually, they have a $1,000 par value, the coupon interest rate is 6%, and the yield to maturity is 8%. What is the bond's current market price? Round your answer to the nearest cent. please show the numbers you would compute in excel.