Question: Please answer these questions using excel. Thanks. Duration 1. What is the duration of a 10-year, 6% bond if the market rate on bonds of

Please answer these questions using excel. Thanks.

Duration

1. What is the duration of a 10-year, 6% bond if the market rate on bonds of similar quality is 5.8%?

2. Now suppose that the yield to maturity has changed to 5.81%. Using Macaulay duration, what is the approximate percent change in the price of the bond? (You do not need to recalculate Macaulay duration using 5.81%. Use the duration value that you found in Problem 1.)

3. Using convexity, what is the approximate percent change in the price of the bond?

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!

please answer the question using excel. thanks Bond Valuation Exercises: Question 1. GTF Corporation has 5 percent coupon bonds on the market with a par of $1,000 and 10 years left to maturity. The...

please help me to solve this question 2&3 by using Microsoft Excel and show me the formula too. thankyou! Answer all questions in Microsoft Excel. Question 1 You are given the following 10% annual...

PLEASE ANSWER THESE QUESTIONS IN EXCEL FORMULAS!!!! (Give me answers for yellow and grey boxes in the sheet. I don't need numbers. I need formulas to type in!!) The sheet provided above was provided...

can help me to solve these by using M.Excel? shows the formula as well for reference. thank you in advanced! Answer all questions in Microsoft Excel. Question 1 You are given the following 10% annual...

I'm specifically having trouble with the After tax salvage value (terminal Value) line. Moon Bakery The Moon Bakery Corporation was originally founded in Dallas, TX in 1991 by Jay Kaplan, who...

Moon Bakery The Moon Bakery Corporation was originally founded in Dallas, TX In 1991 by Jay Kaplan, who currently serves as the company's Chief Executive Officer. About four years ago, Kaplan's...

Please answer Part II in detail. Thanks! Question 1 (36 Marks) Part I The capital structure of a company with relevant market information are shown as below: Common stock: There are 55 million shares...

Please Help. Thanks Moon Bakery The Moon Bakery Corporation was originally founded in Dallas, TX in 1991 by Jay Kaplan, who currently serves as the company's Chief Executive Officer. About four years...

Please answer attached questions 1-20 and submit ASAP. 1. (TCO 1) A comparative advantage of financial intermediaries can be classified as (Points : 4) the ability to achieve economies of scale. the...

help me to solve by using M.Excel and show the formula as well. thank you in advanced! Answer all questions in Microsoft Excel. Question 1 You are given the following 10% annual coupon bond prices....

Derive the expression for Reynolds number.

The Montreal Music Company Ltd. has a fiscal year that ends March 31. During the year ending March 31, 2012, the company had the following transactions involving these assets: Buildings. No...

Which one of the following is liable for the debts of a business beyond the capital originally subscribed? A limited partner A shareholder of a private company A general partner A shareholder of a...

The first scenario will be a Verbal Judo scenario in which your scenario follows the standard Verbal Judo interaction: You need to ask somebody to modify their behavior either to do something or to...

What factors may influence how a receiver will react to a message? (Objective 2)

You are Finance Officer for Commercial Credit, Inc. Juan Martinez is the owner of a Mexican restaurant. He needs a loan of $200,000 to replace coolers, mixing machines, fry cookers,and commercial...

Write a letter canceling an appointment that you had scheduled this Thursday at 2 p.m. to meet with your production manager to discuss product goals for the next six weeks. Reschedule the meeting for...