You've collected the following information about a corporate bond: The yleld 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 G. Attempt 1/10 for 9.4pts What is the amount of each coupon payment? Part 2 E. Attempt 1/10 for 9.4 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 bend at each time. What is the cash flow in the last period? Copy the table above to Excel and add two rows, one showing the number of perlods from now and the second one the cash flow from the bond at each time. What is the cash flow in the last period? Part 3 B Attempt 1/10 for 9.4 pts. Using the appropriate discount rate, what is the present value of the cash flow in the last perlod? Add another row to your spreadsheet. Part 4 Attempt 1/10 for 9.4pts. What is the sum of present values? This is the fair value of the bond