Reference no: EM132258037

Question: 1. Create excel and estimate Johnson and Johnson's approximate cost of capital, (Use both market and book weights, for book versus market value weights see page 394 of your textbook-see attached).

[Hint: You need to estimate the cost of debt or Kd, you have done it in previous DB) and then estimate the cost of equity, Ks, again you have done it in previous DB].

If there is no preferred stock than Cost of capital = Wd * Kd (1-t)+Ws* Ks.

If PS then, Cost of capital = Wd * Kd (1-t)+ Ws* Ks + Wps *Kps

Wd = total long-term debt/TA, Ws = Total Equity/TA, Wps= Total PS/TA

Information related to above question is enclosed below:

Attachment:- HM.rar