Compare duration with exact bond repricing
Your goal: Build G2:G9 using the fixed 100 redemption and terms in B2:B8 plus decimal yield change B10.
Full task requirements
Build G2:G9 using the fixed 100 redemption and terms in B2:B8 plus decimal yield change B10. Report clean, accrued and dirty prices, Macaulay duration in years, modified duration, the approximate change -modified duration × yield change × dirty price, exact clean-price repricing change, and exact minus approximate. Settlement stays fixed so accrued interest cancels from the price change.
Regular semiannual termsRead the regular coupon calendar
B2 is settlement; B3 is maturity. Read annual rates, frequency, basis and face amount beside their original A labels. Calculated results appear after your formulas pass.
| # | ||
|---|---|---|
| 1 | ||
| 2 | ||
| 3 | ||
| 4 | ||
| 5 | ||
| 6 | ||
| 7 | ||
| 8 | ||
| 9 | ||
| 10 |
Step 1 of 5
Read the regular coupon calendar
Rules for this step
Select settlement, maturity, frequency and day-count basis. Coupon dates follow the maturity-anchored schedule; annual rates remain annual decimals in the financial function arguments.