PLEASE PROVIDE THE EXCEL FORMULAS ONLY TO SOLVE THIS PROBLEM

IE10-2 Computing the Issue Price of a Bond and Computing the Carrying Value over the Life of the Bond using Effective Interest Amortization Yancy Capital needs help creating a bond amortization schedule. Yancy uses Effective Interest Amortization. Market Rate 9.4\% Required: 1. Calculate the Bond Proceeds. 2. Complete the Effective Interest Amortization table for the entire life of the bond. Hint: Be sure to place a "-" before using the TVM function to make the factors positive. 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. IE10-2 Computing the Issue Price of a Bond and Computing the Carrying Value over the Life of the Bond using Effective Interest Amortization Yancy Capital needs help creating a bond amortization schedule. Yancy uses Effective Interest Amortization. Market Rate 9.4\% Required: 1. Calculate the Bond Proceeds. 2. Complete the Effective Interest Amortization table for the entire life of the bond. Hint: Be sure to place a "-" before using the TVM function to make the factors positive. 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