First, you have to do problem 4-9 using a financial calculator

6. Using Excel can you calculate this note’s price, accrued interest, and yield to maturity (YTM)? Calculations using Excel (Excel insert: Please double click on this page to see the Excel sheet and use the function wizard to see the cell formulas.) 7. What is this note’s nominal rate and its effective annual rate… ................
................