I've seen two different ways of doing this can someone show me how to solve this and how to enter it on the excel. Thank you undefined

a. Find the price for the bond in the following table: (Round to the nearest cent.) Par Value Coupon Rate 6% Years to Maturity 20 Yield to Maturity 12% Price $ 545.90 $ $1,000.00 i X Data Table (Click on the following icon in order to copy its contents into a spreadsheet.) Years to Maturity 20 Price ? Par Value $1,000.00 $1,000.00 $5,000.00 $1,000.00 Coupon Rate 6% 12% 5% 7% Yield to Maturity 12% 6% 5% 9% 5 ? 25 25 ? ? Enter your answer in Print Done ? 3 parts remaining Clear All Final Check