Question: 3. Write the Excel function and arguments for DURATION of a par value 5 year, 10% coupon bond. Discount rate is also 10%. 1 2

3. Write the Excel function and arguments for DURATION of a

3. Write the Excel function and arguments for DURATION of a par value 5 year, 10% coupon bond. Discount rate is also 10%. 1 2 3 4 % PV of Total Value Weighted Maturity (1)*(4) Year Coupon 10% PV PV/$1000 Duration: a. Use the table above to estimate the actual duration. (Show your work) b. Interpret your results. What does duration tell you? i. Based on your estimated duration, what are the effect on the bond's price if interest rates go from 10% to 11%. Explain. %AP ~ -DUR (43) 1 + i ii. If Duration is 2 years, how does affect the price of the bond? (Re-estimate the change in price with a 2-year duration in the formula above). 1. Why are your results different

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!

TEST REVIEW 3. Write the Excel function and arguments for DURATION of a par value 5 year, 10% coupon bond. Discount rate is also 10% 1 2. 3 4 % PV of Total Value 5 Weighted Maturity (1) "(4) Year...

Write the Excel function and arguments for DURATION of a par value 5 year, 10% coupon bond. Discount rate is also 10%. 1 2 3 4 5 Year Coupon 10% PV % PV of Total Value Weighted Maturity 1 PV/$1000...

please help with number 3 Write the Excel function and arguments for DURATION of a par value 3 -year, 15\% coupon bond. Discount rate is 10%. a. Use the table above to estimate the actual duration....

TURN YOUR ANSWERS IN EXCEL. Estimate the DURATION of a par value 4 year, 6% coupon bond. Discount rate is also 6%. a. Use the table above. b. Interpret your results. What does duration tell you? i....

Hello, I can't figure how to calculate the cash flow and the PV(CF) which is preventing me to answer questions. Could you help me ? Ready $5ix Accessibility: Investigate FTN 4504-100 Project 2 Fall...

Consider the following par bond (ie coupon rate-yield): Maturity: 12345 VTM: 4.5%;4.0%;3.75%;3.5%;3.375% Q1a. Calculate discount factor for all 5 years ( 5 points) Q1b.Calculate spot rates for all 5...

The CFO of Star Asset Management observes the current prices and characteristics of zero-coupon treasury bonds as summarized in the following table. a. Compute the 4 year forward interest rate 3...

The following default-free government bonds are available in the market: Bond A is a 4-year zero-coupon bond, Bond B is an 8-year zero-coupon bond, and Bond Z is a 5- year 10% coupon bond making...

Question 11 Which bond will be the most sensitive (in terms of percentage changes in its price) to interest rate changes? 5 year 10% coupon bond 20 year 10 % coupon bond 20 year 2% coupon bond 5 year...

Which of the following functions lies in the subspace spanned by the functions 1, x, sinx and sin2 x? (a) 3 - 5x (b) x2 + sin2 x (c) sinx -2cosx (d) cos2x (e) xsinx (f) ex

Find the degeneracy of the states 2P, 3D, and 4F possessing the greatest possible values of the total angular momentum.

Most uninsured adults prior to the passage of the ACA were employed but were not covered by health insurance because: Ther could not afford to pur their portion of the prembum or pochase heath...

EXERCISE 8-3 Direct Materials Budget LOB-4 Three grams of musk oil are required for each bottle of Mink Caress, a very popular perfume made by a small company in western Siberia. The cost of the musk...