Principles of Corporate Finance Main Menu Tenth Edition Chapter 3 Question 3

In February 2009 Treasury 6s of 2026 offered a semiannually compounded yield of
3.5965%. Recognizing that coupons are paid semiannually, calculate the bond’s price.
Enter the values in blue colored cells
Chapter 3
Question 3
Student Name:  
Course Name:   
Student ID:   
Course Number:   
Use Excel’s PRICE function to find the value of the bond under the following assumptions:
Settlement Date 
Maturity Date 
Coupon Rate 
Price For help with Excel’s PRICE function