=

Instructions: You submit your Excel document on D2L. On D2L, under Course Elements, click on Assignments, then you will see Computer project from Ch1OLTL. Please open it, and scroll down, you will see Add a file button. Click on it and upload your Excel document. After uploading, you must click Submit to complete the submission. On January 1, 2018, the Blue Devil Corporation issued $100,000 of ten-year bonds. The bonds carried a stated annual interest rate of 6 percent, with interest payable semiannually on June 30 and December 31 REQUIRED: 1. Using the Excel PV function, determine the proceeds of the bond issuance assuming an 8 percent effective (market) annual interest rate. PV(rate,nper,-pmt,-fv,type) Use two present value tables to compute the price of the bonds. Show it on the Excel document Use the answer from the Excel PV function, and create an amortization table In Excel for the entire term of the bonds using the effective interest method of amortization. A formula or copying a formula is required for all cells that contain numbers 2. Using the Ex cel PV function, determine the proceeds of the bond issuance 3. assuming a 4 percent effective (market) annual interest rate. PV(rate,nper,-pmt,-f.type)- Use two present value tables to compute the price of the bonds. Show it on the document Excel 4. Using sheet 2 of the same file you created for step 2, repeat step 2 above assuming that the market annual interest rate is 4 percent