Reference no: EM131532886
You need to complete this problem in a spreadsheet and show all your work. Create an excel file that shows your calculations. Clearly indicate your final answer(s). Name the file with the following convention: Lastname-Problem#.xlsx. For instance, Roark-Problem2.xlsx.
(a) Several years ago the Haverford Company sold a $1,000 par value bond that now has 25 years to maturity and an 8.00% annual coupon that is paid quarterly. The bond currently sells for $900.90, and the company’s tax rate is 40%. What is the component cost of debt for use in the WACC calculation? (3pts)
(b) Haverford uses debt, common equity and preferred stock in their capital structure. Using the following information AND the cost of debt calculated in part (a) above, determine the WACC for the company: (7pts)
Preferred Dividend is $2.50 per share
Price of Preferred is $22.72
Weight of Debt is 40% and Weight of Equity is 45%
Haverford estimates the cost of equity based on their debt yield plus a risk premium of 5.5%
Discourage reporting of workplace injuries
: Did the program discourage reporting of workplace injuries and accidents? Discuss and provide examples to support your answer.
|
When working on production planning
: When working on production planning, What's a good way to increase profit, and maximize plant utilization?
|
Maximize plant utilization
: When working on production planning, What's a good way to increase profit, and maximize plant utilization?
|
Record and post the necessary closing entries for business
: The December 31, 2011, adjusted trial balance of Business Solutions (reflecting its transactions from October through December of 2011) follows.
|
Common equity and preferred stock in their capital structure
: Haverford uses debt, common equity and preferred stock in their capital structure.
|
Complete the six-column table by entering adjustments
: As of December 31, 2011, employees had earned $420 of unpaid and unrecorded wages. The next payday is January 4, at which time $1,250 in wages will be paid.
|
What is the role of the teacher
: What is the role of the teacher? How should they relate to each other and why? What does the Bible have to say about learners and teachers?
|
Enter adjusting and closing information in the work sheet
: Prepare a 10-column work sheet for fiscal year 2011, starting with the unadjusted trial balance and including adjustments based on these additional facts.
|
Demand means that quantity demanded falls
: A decrease in demand means that quantity demanded falls
|