Calculating the actual price of the security in the Wall ...

Using Excel can you calculate this note’s price, accrued interest, and yield to maturity (YTM)? What is this note’s nominal rate and its effective annual rate. Calculate this note’s modified duration using the approximation method. Calculate this note’s Macaulay duration and modified duration using the precise method. ................
................