QD Bond Calculation
Inputs
Par Value of Bonds (FV) $ 1,000.00
Coupon 12.00%
Coupons per year 1
Years to Maturity 19
Yield r 7.00%
Outputs
Coupon Payment (PMT or C) $ 120.00
= coupon * par value of bonds/coupons per year
# periods (nper) or T 19 = coupons per year * years to maturity
Yield (r) 7.00% =yield r/coupons per year
PV of Annuity (Coupons) $1,240.27 =PV(r, nper,pmt)*-1
PV of Lump Sum (Maturity) $ 276.51
=face or maturity value/(1+r)^T where T is nper
Price of Bond $ 1,516.78
