4 (EXCEL TEMPLATE) a) Use the Present Value (PV) function to find the duration of a $1000 face value, 25 year, annual coupon bond with an 4 25 percent coupon rate and a 5 75 percent yield to maturity b) Use the Duration Function to find the duration of the bond listed above After clicking on Duration, go to Help on this Function to determine the proper entries 1 DURATION Weight Time x Weight 12 13 10 15 16 12 13 14 16 17 18 19 20 21 19 21 23 23 24 25 25 27 28 29 30 Use the Duration Function to find the duration of the bond listed above After clicking on Duration, go to 31 Help on this Function to determine the proper entries 32 Duration

The Answer is in the image, click to view ...

Question: 4. (EXCEL TEMPLATE) a) Use the Present Value (PV) function to find the duration of a $1000 face value, 25-year, annual coupon bond with an

4. (EXCEL TEMPLATE) a) Use the Present Value (PV) function to

4. (EXCEL TEMPLATE)

a) Use the Present Value (PV) function to find the duration of a $1000 face value, 25-year, annual coupon bond with an 4.25 percent coupon rate and a 5.75 percent yield to maturity.

b) Use the Duration Function to find the duration of the bond listed above. After clicking on Duration, go to "Help on this Function" to determine the proper entries.

1 DURATION Weight Time x Weight 12 13 10 15 16 12 13 14 16 17 18 19 20 21 19 21 23 23 24 25 25 27 28 29 30 Use the Duration Function to find the duration of the bond listed above. After clicking on Duration, go to 31 "Help on this Function" to determine the proper entries. 32 Duration

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!

5. ( EXCEL ) Use the information for a Starbucks bond shown on the next page to answer the following questions. NOTE: You should assume that todays date is 10/1/2017. Do not use continuous interest...

please answer these questions for " financial management" course 2:02 Assignment4.docx FINANCIAL MANAGEMENT Answer the following 10 questions, and explain your answer, each correct answer is 10...

Hello, Please help me solve this using excel. Thank you. 1. Calculate the value of a fixed rate bond with fifteen years left to maturity, annual coupon payments at a coupon rate of 5.0%, face value...

,Help me answer. The spot exchange rate for Canadian dollars is $C1.33/$US. Dollarssix-month interest rateone-year interest rate Canada2%2.5% U.S.2.5%2.75% a. What is the six-month fair forward...

Show work on excel spreedsheet and what formula is being used. 2 BOND VALUATIONN Calculate the value of a bond that will mature in 14 years and has a $1,000 face value. The annual coupon interest...

PROBLEM 7-4 BOND VALUATION Calculate the value of a bond that wil mature in 14 years and has a $1,000 face value. The annual coupon interest rate is 5 percent, and the investor's required rate of...

Beach Wear has current liabilities of $450,000, a quick ratio of 1.5, inventory turnover of 1.25, and a current ratio of 3. What is the cost of goods sold? 843,750 735,450 655,750 133,500 964,500 2....

3,4,5. please include formulas. much love will thumbs up QUESTION 3 A S1000 bond with a coupon rate of 4%, interest paid semiannually, matures in 14 years, and sells for $980. What is the yield to...

I need both answers if you can, thank you for your help! QUESTION 4 1 points Save Answer Calculate the total return on a $1,000 face value, 5 percent coupon bond (annual) purchased for $1,030, and...

give answer with brief work ASAP Required: Answer each of the following questions, documenting your work. (5 points each) 1. A $10,000 face value bond with ten years to maturity and a six percent...

Let i0, i1, . . . , in be a rearrangement of the integers 0, 1, . . . , n. Show that f [xi0 , xi1 , . . ., xin] = f [x0, x1, . . ., xn]. [Consider the leading coefficient of the nth Lagrange...

Mary Smith sells gourmet chocolate chip cookies. The results of her last month of operations are as follows: Required a. Prepare a contribution format income statement for Mary. b. If Mary sells her...

Bond - rating firms such as Moody's and Standard and Poor classify bonds based on: Only interest rate risk. I iquidity, market, and interest rate risk Lipuldity, interest rate, and default risk. Only...

Lastest was a days ago - 11 - BIVA 60 .- FETE 15 .- PO TO they . errywood There are Ceding BONFERIND X + me ndeng trolder Dimporto the browser import favorites AW Web - Oh M y unt Agreement dados...

4. Why do companies develop formal mentoring programs? What are the potential benefits for the mentor and for the protg? What is the best way to match mentors and protgs?

2. Interactive Learning Modules and Simulations: These interactive simulations emphasize people and task management. Employees learn by viewing videos; interacting with models and problem employees;...

1. Development roles: Managers, mentors, development staff, and other roles in the development process.