Reference no: EM131013772
Detailed Question: In addition to the Excel calculations, there is a written section due based on the calculations for details.
?Please make sure in addition to the Excel spreadsheet, the written part is included as well.
Prompt: Calculate stock and bond valuations for Home Depot Inc. and use the results to support your explanations of shareholder value and increasing capital. Assess the company's dividend policies and bond issuance policies in your explanations. Complete your calculations on the designated tab of the attached spreadsheet.
Specifically, the following critical elements must be addressed:
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
B. What effect would you expect each of the calculations you performed to have in terms of shareholder value? In other words, suppose the company's goal is to maximize shareholder value. How will each of the situations support or inhibit that goal? Be sure to justify your reasoning.
C. To what extent do you feel the company's dividend policies support or hinder their strategies? For example, if the company is attempting to grow, are they retaining and reinvesting their earnings rather than distributing them to investors through dividends? Be sure to substantiate your claims.
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
B. What effect would you expect each of the calculations you performed to have in terms of the company's decision to raise capital in this manner? In other words, for each situation, would you consider bond valuation to be a viable option for increasing capital? Be sure to justify your reasoning.
C. To what extent do you feel the company's bond issuance policies support or hinder their strategies? For example, if the company is attempting to fund operating expenses, refinance old debt, or change its capital structure, are they issuing sufficient bonds to achieve these goals? Be sure to substantiate your claims.
Attachment:- Assignment.rar
|
Calculate the equity ratio
: 1. Calculate the equity ratio based on the following information: cash = $14,870; accounts receivable =$22,108: prepaid $3,010; supplies = $927; equipment = $62,150
|
|
The supplies account had a beginning balance
: Journalize the adjusting entry required at the end of the year (December 31), assuming the amount of supplies on hand is $2,980.
|
|
What is meant by the plane of incidence
: What is meant by the plane of incidence? Distinguish between the two different linear polarizations pertinent to the derivation of the reflection and transmission coefficients for oblique incidence on a dielectric interface.
|
|
Which dividends are expected to grow at a rate
: The last dividend paid by Coppard Inc. was $1.25. The dividend growth rate is expected to be constant at 15% for 3 years, after which dividends are expected to grow at a rate of 6% forever. If the firm’s required return (rs) is 12%, what is its curre..
|
|
Calculate stock and bond valuations for home depot
: Calculate stock and bond valuations for Home Depot Inc. and use the results to support your explanations of shareholder value and increasing capital. Assess the company's dividend policies and bond issuance policies in your explanations.
|
|
What must the coupon rate be on the bonds
: Essary Enterprises has bonds on the market making annual payments, with twelve years to maturity, a par value of $1,000, and selling for $984. At this price, the bonds yield 7.7 percent. What must the coupon rate be on the bonds?
|
|
Zero rate with continuous compounding
: The annual continuously compounded 6-month and 1-year zero rates are 3% and 4%, respectively. A 1.5-year bond that pays coupons of $2 every six months currently sells for $98.52. What is the 1.5-year zero rate with continuous compounding? Show detail..
|
|
What is meant by the dominant mode
: Discuss the nomenclature associated with the modes of propagation in a rectangular waveguide. Explain the relationship between the cutoff wavelength and the dimensions of a rectangular waveguide based on the phenomenon at cutoff.
|
|
What is the equivalent uniform annual worth
: Trixie is buying a new car at a cost of $22099. She estimates the car will sell for $3118 at the end of year 6. Insurance, fees, maintenance, and gas will be $1108 in year 1 and will increase every year by 9%. If she keeps the car for 6 years, what i..
|