Do the 3 calculation problems using the formula sheet (Excel or calculator).
Formula Sheet semiannual coupons
What to compute
Formula / Excel
Cash flows per period
PMT = (Coupon rate × Face value) / 2
# of periods
NPER = Years × 2
Yield to maturity (nominal APR)
YTM = RATE(NPER, PMT, -Price, 1000) × 2
Current yield
Current yield = Annual coupon / Price = (Coupon rate × Face value) / Price
Capital gain yield (1-year)
Capital gain yield = YTM − current yield
Relationship
YTM = Current yield + Capital gain yield
Concepts & Theory Checklist
Yield measures
Coupon rate vs. yield: coupon rate is based on face value; yields are based on market price.
Current yield = annual coupon ÷ price (ignores capital gain/loss).
YTM is the discount rate that sets price equal to PV of all promised cash flows (coupon income + price pull-to-par).
Capital gain yield (for a holding period) is the percentage price change over that period.
YTM ≈ total return = Current yield + Capital gain yield (intuitive decomposition).
If YTM is unchanged, discount bonds tend to have positive capital gain yield (price drifts up toward par), while premium bonds tend to have negative capital gain yield (price drifts down toward par).
Discount bond: Price < par → YTM > coupon rate. Premium bond: Price > par → YTM < coupon rate.
Price–yield relationship and interest-rate risk
Bond prices move inversely with yields. If market yields rise, existing fixed-rate bond prices fall.
Sensitivity to yield changes increases with longer maturity and lower coupon (higher duration).
Quick ranking (all else equal): long maturity & low coupon (or zero-coupon) = most sensitive; short maturity = least sensitive.
Price response is curved (convex): for large yield moves, duration alone is an approximation.
Duration (optional)
Macaulay duration is the weighted-average time to receive cash flows (in years).
Modified duration converts Macaulay duration into an interest-rate sensitivity measure.