PLEASE PROVIDE THE EXCEL FORMULAS ONLY TO SOLVE THIS PROBLEM

IE10-1 Computing Issue Prices of Bonds Sold at Par, at a Discount, and at a Premium Yancy Capital needs help pricing the following bonds in potential market conditions: Required: Fill out the worksheet below to price the bonds with the following market rates: 1. Market Rate 6% 2. Market Rate 12% 3. Market Rate 8\% Navigation: 1. Use the Open Excel in New Tab button to launch this question. 2. When finished in Excel, use the Save and Return to Assignment button in the lower right to return to Connect