Question

You will be paying $8,600 a year in tuition expenses at the end of the next two years. Bonds currently yield 7%.

a. What is the present value and duration of your obligation? (Do not round intermediate calculations. Round "Present value" to 2 decimal places and "Duration" to 4 decimal places.)

1. Present Value =

2. Duration (in years) =

b. What maturity zero-coupon bond would immunize your obligation? (Do not round intermediate calculations. Round "Duration" to 4 decimal places and "Face value" to 2 decimal places.)

1. Duration (in years) =

2. Face Value =

c. Suppose you buy a zero-coupon bond with value and duration equal to your obligation. Now suppose that rates immediately increase to 9%. What happens to your net position, that is, to the difference between the value of the bond and that of your tuition obligation? (Do not round intermediate calculations. Input the amount as a positive value. Round your answer to 2 decimal places.)

1. Net position ____ in value by ____

d. What if rates fall immediately to 5%? (Do not round intermediate calculations. Input the amount as a positive value. Round your answer to 2 decimal places.)

1. Net position ____ in value by ____

I need to see this worked out by hand (pen and paper) NOT in excel. I understand how to format excel but need to be able to work this out myself without the use of excel. Please show all work in arriving at an answer. Thanks!

Answer 1

IT IS JUST WRITTEN IN EXCEL, NO WHERE EXCEL FUNCTION IS USED. THANK YOU