Spot- discount forward

David Harper CFA FRM

David Harper CFA FRM
Subscriber
Hi Frank,

I added that cell, at the risk of another item, to show that the yield (YTM) is different from, but totally compatible with, spot rate and forward rate curve.

The yield to maturity is the I/Y (IRR) that you get when pricing yield with the calculator: it's the rate that, if all FV cash flows are discounted at, will produce a (model) value equal to the (market) bond price.

So, i hope this XLS is instructive b/c several of the rate concepts are illustrated at once:
1. you can start with a spot rate curve
2. each spot can be translated into discount factors (set of discount factors = discount function)
3. the spot rate curve can be used to infer the forward rate curve
4. Given either the spot/forward curve, the bond price can be calculated
5. Given the bond price, the yield (YTM) can be calculated

Finally, the spot and forward curve are sets of rates; e.g., they may slope upward
but the yield/YTM is a single rate for all maturities: it is a flat horiztonal line
But it's the flat rate line that corresponds to (give the same price as) the reality-based spot/forward curves.

David
 

Fatena

New Member
David,

I am not finding the key rate spreadsheet. Do you mind letting me which spreadsheet is.

Thanks
 
Top