Using this case study:

https://www.sec.gov/Archives/edgar/data/354950/000035495015000008/hd-212015x10xk.htm

Prepare a financial analysis report for Home Depot Inc.. Note that while these elements may seem separate and unrelated, together they will present a well-rounded view of the companys finances with regard to the topics.

II. Stock Valuation

A. Based on the figures provided, calculate each of the following:

1. The new dividend yield if the company increased its dividend per share by 1.75

2. The dividend yield if the firm doubled its outstanding shares

3. The rate of return on equity (i.e., the cost of stock) based on the new dividend yield you calculated above

III. Bond Issuance

A. Assuming this company already has bonds outstanding, calculate the following:

1. The new value of the bond if overall rates in the market increased by 5%

2. The new value of the bond if overall rates in the market decreased by 5%

3. The value of the bond if overall rates in the market stayed exactly the same