XLS Bond Valuation and Yield Calculation

Value of Bond in Dollars Redemption Value as % of Par =-PV(B4/B6,B5*B6,B3/B6*B2,B2) Fraction of Period Elapsed Bond Value Between Payment Dates Accrued Interest Clean Price Valuation Between Periods, the Hard Way This is the "Dirty Price" =B11/100*B2 =PRICE(B6,B7,B4,B5,B3,B8,B9) Bond Yield Example Bond Yield Calculations Bond Yield Example Data ... ................
................