Calculate the cost of each capital component, after-tax cost of debt, cost of preferred, and cost

. Calculate the cost of each capital component, after-tax cost of debt, cost of preferred, and cost of equity with the DCF method and CAPM method.

2. What do you estimate the company’s WACC?

Please use data from the provided worksheet. Let me know if you find anything wrong with the data if it interferes with solving the above problems. Please add a new worksheet to the workbook attached. Thank you!!1812795_1_johnson-johnson-interim-report-1-test