Finance Excel Spreadsheet Question help

Jul 25th, 2015
SoccerBoss
Category:
Business & Finance
Price: $20 USD

Question description

Separate sheet for each problem.

18. 

The company of Arifin, Chigurapati, Hilliard, O’Brien and Oaks (ACHOO) is presently enjoying abnormally high growth because of a surge in the demand for their services.  The company expects earnings and dividends to grow at a rate of 20% for the next 4 years, after which there will be no growth (g = 0) in earnings and dividends.  The company’s last dividend, D0, was $1.50.  ACHOO’s beta is 50% higher than that of the average stock, the market risk premium is 6%, and the risk-free rate is 4%.  Determine the current price of the common stock.

19. 

(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?

(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: (8pts) 

  • 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
20. 

There is a bond with 19 years remaining until maturity.  The bond pays a coupon of $45 every six months and has a yield to maturity of 6.77%.

There is a second bond also with 19 years remaining until maturity.  This bond pays a $10 coupon every six months and has a yield to maturity of 6.77%.

If the yield to maturity for these bonds increases by 1% over the next year, what will the percentage change in bond price be for both of them over the course of the year?

Tutor Answer

(Top Tutor) Daniel C.
(997)
School: New York University
PREMIUM TUTOR

Studypool has helped 1,244,100 students

8 Reviews


Summary
Quality
Communication
On Time
Value
tinytim47
Dec 1st, 2016
" Wow this is really good.... didn't expect it. Sweet!!!! "
Five Star Tutor
Nov 21st, 2016
" Outstanding Job!!!! "
mixedballz
Nov 18th, 2016
" excellent work as always thanks for the help "
lilmoe415
Nov 9th, 2016
" Thank you, Thank you, for top quality work, this is your guy!! "
darnay
Oct 26th, 2016
" The best tutor out there!!!! "
dontuwannaknow
Oct 17th, 2016
" Excellent work as always thanks so much "
SjSurvivor143
Oct 4th, 2016
" Thanks for the help. "
Joemoe
Sep 20th, 2016
" <3 it, thanks for saving me time. "
Ask your homework questions. Receive quality answers!

Type your question here (or upload an image)

1824 tutors are online

Brown University





1271 Tutors

California Institute of Technology




2131 Tutors

Carnegie Mellon University




982 Tutors

Columbia University





1256 Tutors

Dartmouth University





2113 Tutors

Emory University





2279 Tutors

Harvard University





599 Tutors

Massachusetts Institute of Technology



2319 Tutors

New York University





1645 Tutors

Notre Dam University





1911 Tutors

Oklahoma University





2122 Tutors

Pennsylvania State University





932 Tutors

Princeton University





1211 Tutors

Stanford University





983 Tutors

University of California





1282 Tutors

Oxford University





123 Tutors

Yale University





2325 Tutors