Question: please construct on an excel spreadsheet 2. Duration, Convexity, and Price Approximation (25 points) A specially designed financial asset called XYZ generates a series of

please construct on an excel spreadsheet

2. Duration, Convexity, and Price Approximation (25 points) A specially designed financial asset called XYZ generates a series of cash flows (in dollar) as follows. Assume the yield to maturity is 4.25% and the interests are accumulated quarterly (i.e., quarterly compounding). (1) Calculate the price of Asset XYZ given yield of 4.25% (i.e., the present value). (2.5 points) (2) Calculate Macaulay duration and modified duration of Asset XYZ. (7 points) (3) Calculate the approximate duration of Asset XYZ by changing the yield up and down 25 basis points with the following formula: (5 points) Duration=2P0(y)PP+. (4) Calculate the approximate convexity of Asset XYZ by changing the yield up and down 25 basis points with the following formula: ( 5 points) Con=P0(y)2P++P2P0. (5) Using the duration you calculated in (2) and convexity you calculated in (4), estimate the relative price change of Asset XYZ with 250 basis points increase in yield. Then estimate the price of Asset XYZ with 250 basis points increase in yield. ( 3 points) (6) Comparing with the actual price of Asset XYZ with 250 basis points yield increase, is the estimation in (5) a good approximation? (2.5 points)

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!

Answer all in Excel. 2. Duration, Convexity, and Price Approximation (25 points) A specially designed financial asset called XYZ generates a series of cash flows (in dollar) as follows. Assume the...

All in Excel 2. Duration, Convexity, and Price Approximation (25 points) A specially designed financial asset called XYZ generates a series of cash flows (in dollar) as follows. Assume the yield to...

1. Duration, Convexity, and Price Approximation (25 points) A specially designed financial asset called XYZ generates a series of cash flows as follows (Table 1). Assume the yield to maturity is...

Questions 1. Duration, Convexity, and Price Approximation (25 points) A specially designed 4-year asset called XYZ generates a series of cash flows as follows (Table 1). Assume the yield to maturity...

3. Duration, Convexity, and Price Approximation (22.5 points) A specially designed financial asset called XYZ generates a series of cash flows as follows (Table 1). Assume the yield to maturity is...

Duration, Convexity, and Price Approximation (25 points) A specially designed 4-year asset called XYZ generates a series of cash flows as follows (Table 1). Assume the yield to maturity is 4.75% and...

2 . Duration, Convexity, and Price Approximation ( 2 5 points ) - - - - in excel A specially designed financial asset called XYZ generates a series of cash flows ( in dollar ) as follows. Assume the...

2. Duration, Convexity, and Price Approximation (25 points) ---- in excel A specially designed financial asset called XYZ generates a series of cash flows (in dollar) as follows. Assume the yield to...

A specially designed financial asset called XYZ generates a series of cash flows ( in dollar ) as follows. Assume the yield to maturity is 4 . 2 5 % and the interests are accumulated quarterly ( i ....

Year CE A specially designed financial asset called XYZ generates a series of cash flows (in dollar) as follows. Assume the yield to maturity is 4.25% and the interests are accumulated quarterly...

What are decision criteria and how are they used in decision making?

Let l be a line in the x-y plane. If l is a vertical line, its equation is x = a for some real number a . Suppose l is not a vertical line and its slope is m . Then the equation of l is y = mx + b ,...

On August 1 3 th , 2 0 2 2 , Bramble Service Co .

A company is preparing completing their Cash Budget. The following data has been prepared for cash receipts and payments. January February March Cash receipts $1,061,200 $1,182,400 $1,091,700 Cash...