The second screenshot is the ch5-04 file for reference (needs to be in excel).

2 Create a new What SUP Bond Amortization Schedule a. Using the ch5-04 file to start your work, create a worksheet (similar to the one created in this chapter) that calculates the bond proceeds for a $2,500,000, 10-year, 4 percent stated interest bond issued when the market interest rate is 5 percent. Include a bond amortization schedule and use names in the work- sheet, as illustrated in the chapter (You will also need to format the cells.) Save your file as ch5-04_student_name (replacing student_name with your name) Print the newly completed worksheet in Value view, with your name and date printed in the lower left footer and the file name in the lower right footer. b. Use the Scenario Manager to create a scenario using stated rates of 3, 3.5, 4.5, and 6 percent to calculate alternative annual interest pay- ments and bond proceeds. Print the resulting summary worksheet. Use Excel's goal seek feature to calculate the stated interest rate it C. would have to pay under the original bond analysis (in part a) to achieve bond proceeds of $2,600,000. Print the resulting worksheet in Value view, with your name and date printed in the lower left footer and the file name in the lower right footer. Window Help Sun Feb 28 9:33 PM Excel File Edit View Insert Format Tools Data o. AutoSave OFF ABESU ch5-04 Home Insert Draw Page Layout Formulas Data Review View Tell me Share V Comments Book Antiqua 12 A A 9 Insert & Wrap Text General 29. O 3 Delete Paste BT U v Av = Ideas Merge & Center $ % ) Conditional Format Cell Formatting as Table Styles Sort & Filter Format v Find & Select Sensitivity B15 X R T F F H 1 J K 1. W 0 O R S T 11 V X Y 7 AA AR What SLIP, Inc. 2 Bond Amortivation Schedule 4 Market Rate s stated Rate 6 Term 7 Interest Payment 2 Amount 9 Proceeds 10 (Discount / Premium 11 Interest Payment Interest Discount) Premium Payment Caming Valer Amortization 1 12 13 14 15 16 17 18 19 20 3 4 5 5 2 7 4 10 Sheet1 Sheet2 Sheets + + 86% 28 W etv Aue I o