Amazon.com, Inc. is offering $1,000,000,000 of their 0.400% notes due 2023 (the 2023 notes), $1,250,000,000 of...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Amazon.com, Inc. is offering $1,000,000,000 of their 0.400% notes due 2023 (the "2023 notes"), $1,250,000,000 of their 0.800% notes due 2025 (the "2025 notes"), $1,250,000,000 of their 1.200% notes due 2027 (the "2027 notes"), $2,000,000,000 of their 1.500% notes due 2030 (the "2030 notes"), $2,500,000,000 of their 2.500% notes due 2050 (the "2050 notes"), and $2,000,000,000 of their 2.700% notes due 2060 (the "2060 notes," and, together with the 2023 notes, the 2025 notes, the 2027 notes, the 2030 notes, and the 2050 notes, the "notes"). The 2023 notes will bear interest at a rate of 0.400% per annum. The 2025 notes will bear interest at a rate of 0.800% per annum. The 2027 notes will bear interest at a rate of 1.200% per annum. The 2030 notes will bear interest at a rate of 1.500% per annum. The 2050 notes will bear interest at a rate of 2.500% per annum. The 2060 notes will bear interest at a rate of 2.700% per annum. Amazon.com will pay interest semi-annually on the notes beginning December 3, 2020. The 2023 notes will mature on June 3, 2023. The 2025 notes will mature on June 3, 2025. The 2027 notes will mature on June 3, 2027. The 2030 notes will mature on June 3, 2030. The 2050 notes will mature on June 3, 2050. The 2060 notes will mature on June 3, 2060. Suppose today is June 3, 2020, the issue day of these bonds. Please answer the following questions: 1) For each note, determine the amount of each coupon payment per $1,000 of face value and the total number of coupon payments. 2) For each note, calculate the yield to maturity. You can use the RATE function in Excel. 3) For each note, calculate the new price per $1,000 of face value if the yield to maturity increased by one percentage point (e.g., from 1.5% to 2.5% ) immediately after issuance. Also calculate the percentage price change. 4) For the entire bond issue package of $10 billion face value, calculate a. The total market value at the issue date. b. The total market value if the yield to maturity of each note increased by one percentage point. c. The percentage change in the total market value of the entire bond package in response to the immediate one percentage point increase in yield to maturity. Total face value Price Bond Maturity date First coupon payment Interest (per annum) ($ in thousands) (per $1,000 face value) 0.4000% 1,000,000 $998.60 0.8000% 1,250,000 $999.61 1.2000% 1,250,000 $999.67 1.5000% 2,000,000 $998.89 2.5000% 2,500,000 $989.77 2.7000% 2,000,000 $988.16 10,000,000 2023 notes June 3, 2023 2025 notes June 3, 2025 2027 notes June 3, 2027 2030 notes June 3, 2030 2050 notes June 3, 2050 2060 notes June 3, 2060 Total December 3, 2020 December 3, 2020 December 3, 2020 December 3, 2020 December 3, 2020 December 3, 2020 Amazon.com, Inc. is offering $1,000,000,000 of their 0.400% notes due 2023 (the "2023 notes"), $1,250,000,000 of their 0.800% notes due 2025 (the "2025 notes"), $1,250,000,000 of their 1.200% notes due 2027 (the "2027 notes"), $2,000,000,000 of their 1.500% notes due 2030 (the "2030 notes"), $2,500,000,000 of their 2.500% notes due 2050 (the "2050 notes"), and $2,000,000,000 of their 2.700% notes due 2060 (the "2060 notes," and, together with the 2023 notes, the 2025 notes, the 2027 notes, the 2030 notes, and the 2050 notes, the "notes"). The 2023 notes will bear interest at a rate of 0.400% per annum. The 2025 notes will bear interest at a rate of 0.800% per annum. The 2027 notes will bear interest at a rate of 1.200% per annum. The 2030 notes will bear interest at a rate of 1.500% per annum. The 2050 notes will bear interest at a rate of 2.500% per annum. The 2060 notes will bear interest at a rate of 2.700% per annum. Amazon.com will pay interest semi-annually on the notes beginning December 3, 2020. The 2023 notes will mature on June 3, 2023. The 2025 notes will mature on June 3, 2025. The 2027 notes will mature on June 3, 2027. The 2030 notes will mature on June 3, 2030. The 2050 notes will mature on June 3, 2050. The 2060 notes will mature on June 3, 2060. Suppose today is June 3, 2020, the issue day of these bonds. Please answer the following questions: 1) For each note, determine the amount of each coupon payment per $1,000 of face value and the total number of coupon payments. 2) For each note, calculate the yield to maturity. You can use the RATE function in Excel. 3) For each note, calculate the new price per $1,000 of face value if the yield to maturity increased by one percentage point (e.g., from 1.5% to 2.5% ) immediately after issuance. Also calculate the percentage price change. 4) For the entire bond issue package of $10 billion face value, calculate a. The total market value at the issue date. b. The total market value if the yield to maturity of each note increased by one percentage point. c. The percentage change in the total market value of the entire bond package in response to the immediate one percentage point increase in yield to maturity. Total face value Price Bond Maturity date First coupon payment Interest (per annum) ($ in thousands) (per $1,000 face value) 0.4000% 1,000,000 $998.60 0.8000% 1,250,000 $999.61 1.2000% 1,250,000 $999.67 1.5000% 2,000,000 $998.89 2.5000% 2,500,000 $989.77 2.7000% 2,000,000 $988.16 10,000,000 2023 notes June 3, 2023 2025 notes June 3, 2025 2027 notes June 3, 2027 2030 notes June 3, 2030 2050 notes June 3, 2050 2060 notes June 3, 2060 Total December 3, 2020 December 3, 2020 December 3, 2020 December 3, 2020 December 3, 2020 December 3, 2020
Expert Answer:
Answer rating: 100% (QA)
1 For each note determine the amount of each coupon payment per 1000 of face value and the total number of coupon payments 2023 notes Coupon payment p... View the full answer
Related Book For
Introduction to Operations Research
ISBN: 978-1259162985
10th edition
Authors: Frederick S. Hillier, Gerald J. Lieberman
Posted Date:
Students also viewed these finance questions
-
Open Text Corporation provides a suite of business information software products. Exhibit 10.10 contains Note 10 from the companys 2016 annual report detailing long-term debt. Amounts are in...
-
The Offering of the Notes by the Issuer in an aggregate principal amount of 600 million. Cullinan Holdco SCSp, a special limited partnership established under the laws of the Grand Duchy of...
-
Data Set 32 "Airport Data Speeds" in Appendix B includes Sprint data speeds (mbps). The accompanying TI-83 / 84 Plus display results from using those data to test the claim that they are from a...
-
Gene, age 34, and Beth, age 32, have been married for nine years. Gene, who is a college student, works part-time and earns $1,500. Beth is a high school teacher and earns a salary of $34,000. Their...
-
Name and discuss the two marketing strategies global companies can use to adapt to foreign markets. What are the benefits of each strategy?
-
Is there a single standard command-line processor to parse and process argv?
-
A mixture containing 65.0 mole% acetone (Ac) and the balance acetic acid (AA) is separated in a continuous distillation column at 1 atm. A flowchart for the operation is as follows: The overhead...
-
The table below shows the output per labourer per day for Guyana and Jamaica for Coffee and Rice. Coffee Rice Table 1 Output per labourer per day Guyana Jamaica 8 6 10 4 What is the autarky cost of...
-
Figure a shows a Houdaille damper, which is a device attached to an engine crankshaft to reduce vibrations. The damper has an inertia Id that is free to rotate within an enclosure filled with viscous...
-
Smart Securities Limited is a banking and investment firm that has been operating in the banking industry for over 20 years. The company has over twenty years of experience and managed to increase...
-
1. Explain and illustrate how might a nation's production possibilities be affected by the following? Each case independently. a. Wide-spread epidemic, like COVID pandemic. b. An increase in...
-
What strategies can be implemented to mitigate systemic barriers and promote inclusivity in empowerment initiatives within diverse communities ?
-
what ways do systemic barriers impede the realization of empowerment, and how can they be effectively dismantled?
-
At what point in the market systems has the entrepreneur emerged? Would like to know more, please explain your point of view.
-
How do emerging concepts like frugal innovation and reverse innovation redefine traditional notions of resource allocation and market penetration strategies in both developed and developing economies?
-
On January 1 of 2021, Matrix Co. signed a license agreement with Private Jet Co. Under the agreement Matrix would, for the next 5 years, have complete possession and use of a Gulfstream G4 Jet. On...
-
Cable Corporation is 60% owned by Anna and 40% owned by Jim, who are unrelated. It has noncash assets, which it sells to an unrelated purchaser for $100,000 in cash and $900,000 in installment...
-
The Omega Manufacturing Company has discontinued the production of a certain unprofitable product line. This act created considerable excess production capacity. Management is considering devoting...
-
Reconsider Prob. 9.1-3b. Starting with the northwest corner rule, interactively apply the transportation simplex method to obtain an optimal solution for this problem. In problem
-
The Tinker Construction Company is ready to begin a project that must be completed in 12 months. This project has four activities (A, B, C, D) with the project network shown next. The project...
-
Bethany, who weighs 560 N, lies in a hammock suspended by ropes tied to two trees. One rope makes an angle of 45 with the ground; the other makes an angle of 30. Find the tension in each of the ropes.
-
In the Skycoaster amusement park ride, riders are suspended from a tower by a long cable. A second cable then lifts them until they reach the starting position indicated in Figure P5.3. The lifting...
-
In the winter sport of curling, two teams alternate sliding 20 kg stones on an icy surface in an attempt to end up with the stone closest to the center of a target painted on the ice. During one...
Study smarter with the SolutionInn App