Type, on three lines, the Excel formulas for the coupon payment per period, the number of periods and the rate per period of a 5.2 %, $1,000-par, 10-year bond yielding 6 %.
Type, on three lines, the Excel formulas for the coupon payment per period, the number of periods and the rate per period of a 5.2 %, $1,000-par, 10-year bond yielding 6 %.
Answer
=0.052*1000/2 =10*2 =0.06/2
26, 20 and 0.03 — the pmt, nper and rate that =PV needs, each converted to a half-year. fv is par, 1,000.
Bigel, Introduction to Financial Analysis (CC BY 4.0) §12.4 — bond vocabulary shape only; OpenStax, Introduction to Business (CC BY 4.0) §16.4 — shape only; the semi-annual convention is the course’s standing rule (outline §7); original bond