FINA4920-BondsSummary - Bond Value=C*1- 11+rtr+ F1+rt...

Info iconThis preview shows pages 1–2. Sign up to view the full content.

View Full Document Right Arrow Icon
= * - + + + Bond Value C 1 11 rtr F1 rt = - ! YTM no closed form solution = - ! YTC no closed form solution = " " = , Clean Price Quoted or flat price Price that is quoted in the newspaper - or the price you find when you use the bond pricing formula above = + Dirty Price Clean Price Accrued Interest =# # * Accrued Interest ofdays since last coupon of days in coupon period coupon = Current Yield Annual Coupon PmtPrice Paid for Bond = = + ( ) Macauley's Duration t 1NCoupont1 YTMt t Bond Price = ( + ) Modified Duration DurationMacauley's 1 YTMm = ( + ) = ( + ) *( + ) Convexity 1 1 YMT 2t 1NCoupont 1 YTM t t2 t Bond Price = + - EAR 1 APRmm 1 = + - APR m1 EAR1m 1 = - EARcontinuous compounding eAPR 1 = FVcontinuous compounding PVert = - PVcontinuous compounding FVe rt = tcontinuous compounding lnFVPVr = rcontinuous compounding lnFVPVt PURPOSE FUNCTION CALL NAME, SYNTAX, ARGUMENTS DATE =DATE(YEAR, MONTH, DAY) =DATE(ENTRY) TODAY =TODAY() (NO ARGUMENTS NEEDED) TEXT DATE TO EXCEL DATE  =DATEVALUE(TEXT_ENTRY)
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Image of page 2
This is the end of the preview. Sign up to access the rest of the document.

Page1 / 2

FINA4920-BondsSummary - Bond Value=C*1- 11+rtr+ F1+rt...

This preview shows document pages 1 - 2. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online