Only need part 4 answered ASAP!
Part 4 IB Attempt 1/10 for 10 pts. What is the sum of present values? This is the fair value of the bond. + decimals Submit Part 2 IB Attempt 1/10 for 10 pts. Copy the table above to Excel and add two rows, one showing the number of periods from now and the second one the cash flow from the bond at each time. What is the cash flow in the last period? 1015.5 Correct B D AJ AK AL 1,000 18 Periods 36 =B22 0.031 Coupon 15.5 =B1-B3/2 1 Face value Years to 2 maturity 3 Coupon rate Yield to maturity 5 Periods from 6 now 7 Cash flow 4 0.049 1 N 3 B. 35 36 Formula 15.5 15.5 15.5 15.5 1,015.5 =B1+$D3 At maturity (in the last period), the bond makes the last coupon payment and pays back the principal, or face value of the bond. Part 3 IB Attempt 1/10 for 10 pts. Using the appropriate discount rate, what is the present value of the cash flow in the last period? Add another row to your spreadsheet. 424.8633 Correct The appropriate discount rate is 1/2 * YTM, since yield to maturity is by convention quoted as an APR. Intro You've collected the following information about a corporate bond: A B 1 Face value 1,000 2 Years to maturity 18 3 Coupon rate 0.031 4 Yield to maturity 0.049 The yield to maturity is the market interest rate for bonds of similar risk and maturity. It is Jan. 2, 2014, and interest payments occur on Jan. 1 and July 1 of each year. Part 1 IB Attempt 1/10 for 10 pts. What is the amount of each coupon payment? 15.5 Correct Coupon payments are interest payments. By convention, corporate bonds pay interest twice a year in the U.S.A. Annual coupon = Coupon rate * Face value = 0.031 * 1,000 = 31 Each coupon = 1/2 * Annual coupon = 15.5 Part 2 IB Attempt 1/10 for 10 pts. Copy the table above to Excel and add two rows, one showing the number of periods from now and the second one the cash flow from the bond at each time. What is the cash flow in the last period? 1015.5 Correct B D AJ AK AL 1,000 18 Periods 36 =B22 0.031 Coupon 15.5 =B1-B3/2 1 Face value Years to 2 maturity 3 Coupon rate Yield to maturity 5 Periods from 6 now 7 Cash flow 4 0.049 1 N 3 B. 35 36 Formula 15.5 15.5 15.5 15.5 1,015.5 =B1+$D3 At maturity (in the last period), the bond makes the last coupon payment and pays back the principal, or face value of the bond. Part 3 IB Attempt 1/10 for 10 pts. Using the appropriate discount rate, what is the present value of the cash flow in the last period? Add another row to your spreadsheet. 424.8633 Correct The appropriate discount rate is 1/2 * YTM, since yield to maturity is by convention quoted as an APR
