Question: Using the spreadsheet eaxmple below. Calculate the duration for a Bond with a face value of $1000, coupon rate of 7.5% paid annually, yield of

Using the spreadsheet eaxmple below. Calculate the duration for a Bond with a face value of $1000, coupon rate of 7.5% paid annually, yield of 9% and maturity of 6 years.

3.- Using the bond in (2) , calculate how many bonds you need to pay a liability at the end of year 5 of $16878.

4.- Explain why you are "immune" to changes in rates for that payment. Includes different rates and results (using pics from the spreadsheet).

5.- Compare the results found in (4) using a (any) Bond with different duration. Using the spreadsheet eaxmple below. Calculate the duration for a Bond

1.528965 FV Coupon Yield Maturity 1000 7.50% 3% In Year 4 we need to pay 3585 CF DF CF DF CF DF t FV PV 1 75 0.9174 75 0.8417 75 0.7722 75 0.7084 75 0.6499 10750.5963 68.8073 68.8073 97.1272 63.1260 126.252089.1075 57.9138 173.7413 81.7500 53.1319212.5276 75.0000 48.7449 243.7243 342.9847 973.6133 1316.5980 4 68.8073 904.8060 6 640.9874 3845.9243 932.7112 4670.9767 2.722926801 Duration5.007956 1.528965 FV Coupon Yield Maturity 1000 7.50% 3% In Year 4 we need to pay 3585 CF DF CF DF CF DF t FV PV 1 75 0.9174 75 0.8417 75 0.7722 75 0.7084 75 0.6499 10750.5963 68.8073 68.8073 97.1272 63.1260 126.252089.1075 57.9138 173.7413 81.7500 53.1319212.5276 75.0000 48.7449 243.7243 342.9847 973.6133 1316.5980 4 68.8073 904.8060 6 640.9874 3845.9243 932.7112 4670.9767 2.722926801 Duration5.007956

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!

Bond A Face value: $1000 coupon rate: 8% paid annually yield to maturity: 10% Term to maturity: 3 Bond B Face value: $1000 coupon rate: 8% paid semi-annually yield to maturity: 10% Term to maturity:...

Describe following for Bonds : coupon rate current yield Yield to maturity Which ones of the above rates/yield can change over the life of the bond and if yes, why? ( 10 points) Research and find a...

As Chief Economic Adviser at BigOil Company, you are also the companys Chief Financial Officer. Your company has launched an ambitious capital investment program, and the Board of Directors has...

NEED ONLY ANSWERS ASAP Q1 - What is the expected price of the following bond? Par value: $1,000 Years to maturity: 30 years Coupon rate: 8% paid semiannually Beta: 0.5 Assume: Risk-free rate: 4%...

Show the step by step calculations 1.Given the following information on a bond, if the interest rate decreases by 1% (that is, from 4% to 3%), what is the change in the price of the bond based on...

Please show me how to solve this question and it's sub questions in excel. Especially the graph he shows, I dont know how you create that graph with the info given. 2) If the interest rate increases...

Question 1 : Define risk as it relates to an investment? Briefly discuss how risk can be measured. (10 points) Question 2 : Briefly discuss the difference between a share of common stock versus a...

Question 2 : Briefly discuss the difference between a share of common stock versus a share of preferred stock . What are the characteristics of each? What is meant by a call provision and what is a...

SHOW STEP BY STEP SOLUTION: 1.The expected annual inflation rates for the coming 5 years are listed in the following table: Year Expected annual inflation rate 1 4% 2 2 3 2 4 1 5 1 The real risk-free...

Consider future enhancements that could be completed at another time. Provide at least three future enhancement ideas.

Graph your solution and the ambient temperature when is small, say = 0.1. Describe the result. There are many important differential equations for which separation of variables fails, but which can...

Under what conditions would a second mortgage on property be considered superior to the first? Multiple Choice when the frst mortgage has been at least hialf repaid by the mortgagor when the second...

Within a continuously competitive global business environment, publicly held companies face constant pressure to generate and report positive financial results. Unfortunately, some leaders may be...

1. The fi lm Erin Brockovich dramatically illustrates the power of listening. Watch the fi lm, and pay attention to how Julia Roberts, in the role of Erin Brockovich, shows she is listening carefully...

5. How we can improve our listening skills?

1. As a class, identify ethical principles that guide different listening purposes. What different moral goals and responsibilities accompany informational and critical listening and relationship...