**Pricing of a
bond**

This Excel-Sheet calculates the fair price of a bond over
time. As input parameters it uses the cashflows at different
timesteps and a yield curve. Actually the sheet calculates the
price of one bond according to two different yieldcurves. You can
specify a spread (curve) between the two yieldcurves.

If we name the value of the yieldcurve at time t with y(t), the
cashflow at time t with c(t), t=0..20, then the price of a bond
with cashflows c(t) is given by:

**[Startpage]** --- **[guestbook]** --- **[sitemap]** --- last change: 31-07-2003