Reconcile clean price, accrued interest and settlement cash
Your goal: Build G2:G9 from the actual terms in B2:B9.
Full task requirements
Build G2:G9 from the actual terms in B2:B9. Find the previous/next coupon dates and remaining payment count, the coupon per 100 face, clean price, accrued coupon interest, dirty price and the cash amount for the stated face amount. Rates are annual decimals and prices are per 100 face. Keep full internal precision.
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 4
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.