Reconcile clean price, accrued interest and settlement cash
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.
The answer cells begin blank. Enter a reusable formula and check it against the published practice datasets. Hints and the solution are available when you choose them.
Practice stays on this device. No worksheet data is uploaded.
A checkpoint records a fresh check of every dataset. This attempt tracks built-in hints, solutions, steps and worked examples; it does not establish independent authorship.
Help recorded: none of these built-in aids opened.
Make the formula your own.
View 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.
No account. No upload. Just try it.