Question: For this exercise it is expected that you will use Excel for all of your calculations. Term Structure of Interest Rates and Forward Rates (

For this exercise it is expected that you will use Excel for all of your calculations.
Term Structure of Interest Rates and Forward Rates
(a) Recall from lecture that bt is the price today of a zero-coupon bond that pays $1 at time t, for a given value of rt, the t-period spot rate. Using the values for bt in Table 1 on Page 2, together with Equation (1), find the values for rt, for t=1,2,3.
bt=1(1+rt)t
Rearranged:
(1+rt)t=1bt
rt=1btt-1
rt=(1bt)1t-1
(b) Define fjk to be the (hedgeable) forward rate from time j to time k. Use the calculated spot rates, rt, from Part (1a), together with Equation (2), to calculate the three forward rates: f12,f23, and f13.
(1+rj)j(1+fjk)k-j=(1+rk)k
where:
rt-= the t-period spot rate
fjk-= the forward rate from Period jto Period k, where k>j
1
Table 1: Zero-Coupon Bond Prices per $1 Face
\table[[t,bt
 For this exercise it is expected that you will use Excel

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!