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 | ||||||||||
YTM | ||||||||||
Price | For help with Excel’s PRICE function | |||||||||