Question: 1. What is the bond Yield (using data from markets insider, what is the bond yield). 2. Using the YTM, coupon rate and Maturity (from

1. What is the bond Yield (using data from markets insider, what is the bond yield). 2. Using the YTM, coupon rate and

1. What is the bond Yield (using data from markets insider, what is the bond yield).

2. Using the YTM, coupon rate and Maturity (from Markets Insider), calculate the bond price (using excel). Include your excel screenshot.

Home Depot Inc., TheDL-Notes 2016(16/21) Latest Price 0.00 0.00 Trade Time Trade Date Open Prev. Close 12:02PM Daily High 07/26/2016 Daily Low 0.00 52-week High 102.35 52-week Low Exchange 0.00 0.00 NYA Key Data Coupon in % Duration Accrued Interest 2.0000% Yield in % . Modified Duration - Currency USD Bond Data ISIN US437076BL56 HOME DEPOT 16/21 Name Country USA ISSUEANCE Issuer The Home Depot Inc. 1,350,000,000 Issue Volume USD Currency Issue Price 99.64 Issue Date 2/12/2016 COUPON 2.000% 1000 regular interest Coupon Denomination Quotation Type Payment Type Special Coupon Type Maturity Date Coupon Payment Date Payment Frequency 4/1/2021 10/1/2020 2.0 10/1/2016 No. of Payments per Year Coupon Start Date Final Coupon Date Floater? 3/31/2021 No Moody's Rating For The Home Depot Inc. Bond A2 3323522 ; Baa3 Baa2 Ba1 Ba2 Ba3 81 B2 AFFIRM Rating Rating Update Date of Rating Watchlist Indicator Watchlist Description 5/24/2017 Investment Grade righ Grade Investment Grade (Medium Grade Speculative Grade Watchlist Date Home Depot Inc., TheDL-Notes 2016(16/21) Latest Price 0.00 0.00 Trade Time Trade Date Open Prev. Close 12:02PM Daily High 07/26/2016 Daily Low 0.00 52-week High 102.35 52-week Low Exchange 0.00 0.00 NYA Key Data Coupon in % Duration Accrued Interest 2.0000% Yield in % . Modified Duration - Currency USD Bond Data ISIN US437076BL56 HOME DEPOT 16/21 Name Country USA ISSUEANCE Issuer The Home Depot Inc. 1,350,000,000 Issue Volume USD Currency Issue Price 99.64 Issue Date 2/12/2016 COUPON 2.000% 1000 regular interest Coupon Denomination Quotation Type Payment Type Special Coupon Type Maturity Date Coupon Payment Date Payment Frequency 4/1/2021 10/1/2020 2.0 10/1/2016 No. of Payments per Year Coupon Start Date Final Coupon Date Floater? 3/31/2021 No Moody's Rating For The Home Depot Inc. Bond A2 3323522 ; Baa3 Baa2 Ba1 Ba2 Ba3 81 B2 AFFIRM Rating Rating Update Date of Rating Watchlist Indicator Watchlist Description 5/24/2017 Investment Grade righ Grade Investment Grade (Medium Grade Speculative Grade Watchlist Date

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 USING 1000000000 AND NOT 1000 3. Ch 7: If your selected company has more than one bond, select one bond and complete the requirement below). If your company does not have a bond, go to...

Generic Bond Information. ^ 101.78 uso 0.24 (0.24%) KEY DATA Coupon in % 2.3750% Yield in % 2.07% 11.5985 Modified Duration 11.3638 Duration Accrued Interest 0.6133 Currency USD BOND DATA Country USA...

using the information given in the pictures, answer the questions below Question: 3. Find the following information: a) Maturity date b) coupon rate Calculate: c) What is the bond Yield (using data...

312 CONSOLIDATED INCOME STATEMENT 2018 47.369 36.037 11.132 (5716 3.307 (1496) 33 34 603 (784 (183 65 190 (261 13 2 (246) anom Notes 2019 Revenue 31 45.415 Cost of sales 31 135018 Gross margin 11.397...

QUESTION 7 (20 points) Calculate the Market Price of the Coupon Bond-mentioned in Question 6 by assuming (semi- annual Coupon payments) instead of Annual Coupon payments. Question 6 (20 points)...

Thank you! Problem 6-30 A BBB-rated corporate bond has a yield to maturity of 8.2%. A U.S. Treasury security has a yield to maturity of 6.5%. These yields are quoted as APRs with semiannual...

Problem 6-30 A BBB-rated corporate bond has a yield to maturity of 8.2%. A U.S. Treasury security has a yield to maturity of 6.5%. These yields are quoted as APRs with semiannual compounding. Both...

You can create your own cell reference! Problem 6-30 A BBB-rated corporate bond has a yield to maturity of 8.2%. A U.S. Treasury security has a yield to maturity of 6.5%. These yields are quoted as...

Problem 6-30 A BBB-rated corporate bond has a yield to maturity of 8.2%. A U.S. Treasury security has a yield to maturity of 6.5%. These yields are quoted as APRs with semiannual compounding. Both...

Working on a WACC project for a Financial Management class and need some help. Attached are the guidelines. The company I chose is Royal Dutch Shell plc WACC Project In this project, you will find...

What is an NGO?

Philip, Punter and Steadman, are partners in an office supply business, they made up their accounts to 30 June. The following is their balance sheet as at the 30 June 2014 Non Current Assets...

P9.7 (LO 2) Groupwork (Capitalization of Borrowing Costs) Laserwords A.. is a book distributor that had been operating in its original facility since 1988. The increase in certification programs and...

SIMAD UNIVERSITY Class: BACC25 Subject: Islamic Accounting Instructions: a) Follow The Instructions. Midterm Exam Instructor: All Ibrahim Date: 6-4-2022 b) You Have 1.5 Hrs. To Complete This Test. c)...

How can multimedia from the Internet be incorporated in a slide presentation? Give an example. (Objective 7)

Teamwork. Work with three or four of your classmates to develop a job description for the role of business communication student. Then, prepare a performance appraisal that discusses whether you meet...

You have a large amount of numeric data to include in your report. What type of visual aid would be most appropriate? Why? (Objective 3)