Type the Excel formula, filled down beside a column of annual yields in B, that prices the 5.2 %, $1,000-par, 10-year semi-annual bond at each yield.
Type the Excel formula, filled down beside a column of annual yields in B, that prices the 5.2 %, $1,000-par, 10-year semi-annual bond at each yield.
Answer
=-PV(B1/2,20,26,1000)
B1 = 0.04 → 1,098.11; 0.05 → 1,015.59; 0.06 → 940.49; 0.07 → 872.09; 0.08 → 809.74. The rate is the only input that changes.
Bigel, Introduction to Financial Analysis (CC BY 4.0) §10.14–10.15, §12.7, §13.5 — curvature-table and two-row-table shapes only; OpenStax Principles of Finance §10.4 — reference only (duration named); original bond and figures