xcel Simulation / Bond Pricing i Saved FILE HOME INSERT PAGE LAYOUT FORMULAS DATA REVIEW VIEW Sign In Calibri 11 A A % M Paste B I U- A Alignment Number Conditional Format as Cell Formatting Table Styles- Cells Editing Clipboard Font Styles G16 X fx =C6 C8 A B C D E F H 1 The Chestnut Street Company plans to issue $825,000, 10-year bonds that pay 7 percent 2 semiannually on March 31st and September 30th. 4 Information relating to this bond is found below: 5 Face Value: Number of Years: $ 825,000 6 10 7 Stated Interest Rate: 7% 8 Number of Payments per Year: 2 9 10 Required: 11 Calculate or provide the information requested using a formula or cell reference unless 12 you are instructed to use a specific function: 8% How many total payments or periods will this bond pay interest? 13 14 1) Assume the Market Interest Rate is: 15 16 a. 17 18 b. 19 20 21 22 23 When calculating the bond selling price, show the factor from the appropriate future or present value table (found in worksheets included in this workbook) that would be used to calculate the bond interest payments. Rannat.aunction h hut nouuea than Present Value of Annuity of $1 in function Bond Pricing *** READY Attempt(s) 0/5 20 100% Hint