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 | ||||||||
