Question: The following table shows information about an Amazon.com bond as of July 19, 2017: Amazon.com Bond Information Settlement Maturity Coupon Face Value 7/21/2017 12/5/2044

The following table shows information about an Amazon.com bond as of July

The following table shows information about an Amazon.com bond as of July 19, 2017: Amazon.com Bond Information Settlement Maturity Coupon Face Value 7/21/2017 12/5/2044 4.950% 100 Given Price Given Yield 118.691 3.840% 2 Frequency a) Determine the value of the bond and its current yield. Also find whether the bond is undervalued overvalued, or fairly valued compared to the given price. b) Calculate the yield to maturity using the YIELD function and find the duration, modified duration, and convexity of the bond. c) Determine the percentage change in price if market rates decline by 1%. Determine the actual relative change in bond prices using the intrinsic values for each rate. Compare this result with those obtained using the formulas with the modified duration only and with the modified duration and convexity together. d) Create a chart that shows the relationship of this bond's convexity to the coupon rate. Use a rate of 1% to 15% in calculating the convexity.

Step by Step Solution

★★★★★

3.41 Rating (160 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock

Solution a To determine the value of the bond we can use the formula for bond valuation V C rm 1 1 rmn FV 1 rmn where V is the bonds value C is the co... View full answer

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 Mathematics Questions!

Using the CMOS long-channel process (1 m), calculate the currents and voltages in the circuit seen below. What is the maximum value allowed for R2 so that M2 remains operating in the saturation...

The following table shows key operating statistics for the four largest public accounting firms: a. Determine the revenue per partner and revenue per professional staff for each firm. Round to the...

The following table shows the hypothetical labor requirements per ton of wool and per hand-knotted rug, for New Zealand and for India. a. Which country has an absolute advantage in each product? b....

The following table shows the National League home run leaders and their total home runs for the years 1980 to 2011. a. Determine Q1, Q2 and Q3 for the home run data. b. In which quartile is Howard...

Noah Kramer, a fixed-income portfolio manager based in the country of Sevista, is considering the purchase of Sevista government bonds. Sevista currently has government bonds evenly distributed among...

The following table shows real GDP per hour of work in four imaginary countries in the years 1997 and 2007. By what percentage did labor productivity grow in each country? Is it true that...

The Crevier Corporation began business on January 1, 2011. The following table shows information about inventories, as of December 31, for three consecutive years under different valuation methods....

The famous Y. S. Chang Restaurant is open 24 hours a day. Waiters and busboys report for duty at 3 A.M., 7 A.M., 11 A.M., 3 P.M., 7 P.M., or 11 P.M., and each works an 8-hour shift. The following...

A health club has sent promotional material to a mailing list consisting of local college students, area doctors, and lawyers. The following table shows the record of individuals taking up the clubs...

The following table summarizes information about the market for principles of economics textbooks: a. What is the market equilibrium price and quantity of textbooks? b. To quell outrage over tuition...

The following table shows the quantities of car alarms demanded and supplied per year in a town: Without drawing a graph, determine the efficient quantity in this market under each of the following...

What tips would you offer someone about to enter into negotiations to buy a business?

What impact will an unanticipated increase in the money supply have on the real interest rate, real output, and employment in the short run? How will expansionary monetary policy affect these factors...

A population is modeled by the differential equation For what values of P is the population increasing? ( Enter your answer in interval notation. Type the word infinity if needed. ) Blank 1 For what...

A student proposes the following strategy to synthesize the ether by an SN2 reaction. Explain why the synthetic route shown below would be unsuccessful? Also, show what happens instead DMF Br KBr K...

Evans Company has estimated the following amounts for its next fiscal year: If the company spends an additional $30,000 on advertising, sales volume would increase by 2,500 units. What effect will...

This is a course in professional sales training that highlights sales tips/guidelines for new aspiring sales professionals. Many leading universities provide advanced training programs leading to...

Hilltop Golf Course is planning for the coming season. Investors would like to earn a 15% return on the company's $60,000,000 of assets. The company primarily incurs fixed costs to groom the greens...

ABC Golf Company is planning for the coming season. Investors would like to earn a 15% return on the company's $60,000,000 of assets. The company primarily incurs fixed costs to groom the greens and...

In South Carolina, the minimum auto insurance coverages that you are required by law to carry are: Question 23 options: 25/50/25 liability and uninsured motorist coverage 25/50/25 liability,...

I need this done in 3 hours. QUESTION 1 Suppose you want to buy a house that costs $700,000. You are required to put 10% down, which means the amount to be borrowed is 90% of the price of the house....

Please answer the attached document. Thank you in advance 1. Frank's Dogs has beginning net fixed assets of $480 and ending net fixed assets of $530. Assets valued at $300 were sold during the year....

The last exam will cover these 3 tests plus a few small quizzes. The attached should give you a good idea of the material. Let me know if you have any questions. You can see which I got correct with...

Before grading your Unit 1 Textbook Problem assignment, you need to show your work in each cell using Excel correctly to earn credit. You also need to use the "Unit Activities Textbook Problems-...

1 What are the main components of personal financial planning? Solve What is the purpose of a financial plan? Solve Identify some common actions taken to achieve financial goals. How does a job...

Midterm Exam Practice Problems Examples of True or False statements 1. A 20-year 10% corporate bond was issued 10 years ago. You purchased this bond today, when it was trading to yield 12%. Next day,...