Infer yield from a coupon bond quote
Your goal: Build G2:G7 from B2:B9.
Full task requirements
Build G2:G7 from B2:B9. Solve the annual yield from the clean quote, reprice at that solved yield, report price minus quote, compare annual coupon/clean quote (current yield), then report accrued interest and settlement cash for the stated face amount. Keep full internal precision; YIELD and current yield answer different questions.
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.