**Just part b) please without a spreadsheet**

(15 marks) A bond that pays semi-annual coupons at j2 = 4% has coupon payments of $500. The bond is redeemable at 105 on Sept 18, 2030. a) (3 marks) The bond was purchased by Sam Jones on September 18th, 2015 at a price P, to yield j2 = 5%. Calculate P. b) (8 marks) (i) (5 marks) Generate the first 3 lines (time 0 to 3 inclusive) of the bond amortization schedule. Include your completed partial schedule in your submission, rounding calculated values to the nearest penny. (If you wish to use a spreadsheet for this question, that is fine, but you will need to email a copy of your spreadsheet including calculations.) (ii) (1 mark) What is the book value adjustment portion of the 7th coupon payment? (No spreadsheets for this question. Please provide a written answer.) (iii) (2 marks) What is the book value of this bond on March 18, 2020? (No spreadsheets for this question. Please provide a written answer.) c) (4 marks) Sam sells the bond to another investor on March 18, 2020 (just after the coupon is paid that day) for a quoted price of q = 102.7. Using the method of averages, what yield rate, j2 did Sam earn over the time he owned the bond? (15 marks) A bond that pays semi-annual coupons at j2 = 4% has coupon payments of $500. The bond is redeemable at 105 on Sept 18, 2030. a) (3 marks) The bond was purchased by Sam Jones on September 18th, 2015 at a price P, to yield j2 = 5%. Calculate P. b) (8 marks) (i) (5 marks) Generate the first 3 lines (time 0 to 3 inclusive) of the bond amortization schedule. Include your completed partial schedule in your submission, rounding calculated values to the nearest penny. (If you wish to use a spreadsheet for this question, that is fine, but you will need to email a copy of your spreadsheet including calculations.) (ii) (1 mark) What is the book value adjustment portion of the 7th coupon payment? (No spreadsheets for this question. Please provide a written answer.) (iii) (2 marks) What is the book value of this bond on March 18, 2020? (No spreadsheets for this question. Please provide a written answer.) c) (4 marks) Sam sells the bond to another investor on March 18, 2020 (just after the coupon is paid that day) for a quoted price of q = 102.7. Using the method of averages, what yield rate, j2 did Sam earn over the time he owned the bond