xcel Simulation FILE Paste HOME INSERT PAGE LAYOUT FORMULAS DATA REVIEW VIEW K Calibri 11 A A % Clipboard 2 G16 A BIU A-Alignment Number Font x X fx =C6 C8 B C D M Conditional Format as Cell Cells Editing Table Formatting Styles Styles E F 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. 3 4 Information relating to this bond is found below: 155 Face Value: Number of Years: 6 7 Stated Interest Rate: 8 9 $ 825,000 10 7% 10 Required: Number of Payments per Year: 11 Calculate or provide the information requested using a formula or cell reference unless 12 you are instructed to use a specific function: 13 14 1) Assume the Market Interest Rate is: 8% 15 16 a.. 17 18 b. 19 20 21 22 23 How many total payments or periods will this bond pay interest? 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. Donnat.auertion h hut nouuce the nating Present Value of Annuity of $1 Bond Pricing READY Attempt(s) 0/5 T Sign In 20 H 100%