Help to do some excel function assignment to Calculate the Coupon Payment and Price of the Bond and fill in the Green cells, all calculations should result in positive numbers, do not round any calculations

* Assume the first coupon payment is exactly 6 months from today unless the bond is 0-Coupon

** Use the Date(year,month,day) function. Add years of a term to a year of issue date. Month and Day should be the same.If the term is less than 5 years, assume it's a 0-Coupon Bond, otherwise there are 2 interest payments per year***

= Date(Year()+term,Month(),Day())

*** Use the IF() function

Set Term to 15, Bond rating to A... Value should be: 953.63

Set Term to 3, Bond rating to B... Value should be: 947.66 LEAVE cells E11 & E12 set to 3 and B respectively before turning in

Par Value:		1,000.00				Term	Bond rating
Coupon Rate:		3.10%
Bond Term (choose):		3	see rows 31 & 32 below				A	B	C
Bond Rating (choose):		B				1	1.10%	1.50%	2.30%
						2	1.20%	1.60%	2.40%
Issue Date		8/1/15				3	1.40%	1.80%	2.60%
Maturity date:			calculate maturity date for chosen term**			4	1.60%	2.00%	2.80%
						5	1.80%	2.20%	3.00%
Table row			use MATCH() function			10	3.10%	3.50%	4.30%
Yield to Maturity:			use HLOOKUP() function			15	3.50%	3.90%	4.70%
						20	4.90%	5.30%	6.10%
Coupon pmts p/year:		2				30	5.60%	6.00%	6.80%
How many interest payments remain to be paid?
What is the amount of each semiannual coupon payment?
What is the PV of the Par Value of the bond?
What is the PV of the semiannual coupon payments?*
What is the Price of the Bond today?				Calculate all of these as if the bond pays two interest payments per year