I am getting an error for my formula for WACC. What am I doing wrong here? I also

I am getting an error for my formula for WACC. What am I doing wrong here? I also

I am getting an error for my formula for WACC. What am I doing wrong here?

I also

need a clarification from one of the tutors here. I am getting different TOTAL DEBT answer from adding the actual numbers depicting millions vs. shortcut millions (see below). I cannot ask the tutor anymore because my comments were turned off which i dont know why.

Value of Debt = 4696.40

Weight of Debt = 21.16%

Explanation:

Short Term Borrowings = 560

Current Portion of Long Term Debt = 83.5

Long Term Debt = 4052.9

Total Debt = 560 + 83.5 + 4052.9 = 4696.40 million (???)

Source : htttppss://ir.mccormick.comm/static-files/689b16f5-2507-4cbe-bddd-3190dbf2b6db

Market Value of Equity = 17500 million

Weight of Debt = 4696.40 / (17500 + 4696.4) = 21.16%

X V fx =141*C142(1-C143)+C144*C145BCEFGHKLMNCalculate the Weighted Average Cost of Capital (WACC) for Mccormick and Company using the formulaWACC = WD RD (1-T) + Ws IS and W, = Value of debt / Value of debt plus value of equity; Ws = Value of Stock Equity / Value of Debt Plus Value of Equity. For ease,the CFO says to use book value of Debt and the market Value of Equity. On February 26, 2019 the market Value of Equity (or Market Cap) in Yahoo was $17.5 billion.Use the 2018 10-K Financial Statements filed January 25, 2019 and look on the Balance sheet to see the total of Short term borrowings, Current portion of long termdebt and Long term debt. Use 4% for the cost of debt. Use 27.5% as the tax rate – a combination of federal and state income tax.05WACC = WD RD (1-T) + Ws rswhere :WD21.60%Wd = weight of debt/ Value of debt / Value of debt plus value of equityRD4%Ws = weight of common stocks27.50%Wp = weight of preferred stocksWS$17500 BillionWd + Ws + Wp = 1RS$400,200,000rD = cost of debtrs = cost of common stocksShort-term borrowings$560,000,000rP = cost of preferred stocksCurrent portion of long te$83,500,000T = tax rateLong term debt$4,052,900Total debt$647,552,900Outstanding shares132,148,261current price164,980,000Market value of equity17,500,000weight of debt97.37%AY#REF!iInvalid Cell Reference ErrorHelp on this ErrorTrace ErrorIgnore ErrorInstructionsnula Bar+


Are you overwhelmed by your class schedule and need help completing this assignment? You deserve the best professional and plagiarism-free writing services. Allow us to take the weight off your shoulders by clicking this button.

Get help

Who Will Write your Paper

Writer avatar
Tutor_Charles

Rating: 4.9/5    Reviews 377

Success rate 99%

Completed projects: 545

I am an experienced writer offering professional services across diverse fields. I provide quality work with strict adherence to the deadline.

Writer avatar
Tutor_Dr. Edith

Rating: 4.8/5    Reviews 381

Success rate 96%

Completed projects: 490

I am an experienced writer with great research and analytical skills. Original quality paper and on-time delivery are guaranteed. Let's do this!

Writer avatar
Tutor_Dr.Judy

Rating: 4.7/5    Reviews 316

Success rate 100%

Completed projects: 398

I am a professional writer with more than 8 years of experience. My mission is to provide you with high-quality paper in a timely fashion.

Writer avatar
Tutor_Ian

Rating: 4.8/5    Reviews 371

Success rate 96%

Completed projects: 432

Hi, I deliver quality papers on time following all the instructions provided. Client's satisfaction is my priority. Welcome for plagiarism-free papers.

Writer avatar
Tutor_Prof. Allan

Rating: 4.8/5    Reviews 400

Success rate 97%

Completed projects: 487

With over half a decade of academic experience, I'm committed both to efficiency and punctuality. If it's quality you're looking for, then I'm here to provide!

Writer avatar
Tutor_Prof. Gabie

Rating: 4.9/5    Reviews 447

Success rate 96%

Completed projects: 546

A quality-driven, skilled writer with over 5 years of experience in various disciplines. I deliver plagiarism-free papers and content of impeccable quality, always original and always before the deadline!

Writer avatar
Tutor_Sarah

Rating: 4.9/5    Reviews 427

Success rate 97%

Completed projects: 567

I have been a full-time freelance researcher and writer for a period of over 6 years. I have successfully completed over 1000 projects and assignments. I have had a good professional relationship with my clients. Try me today!

Writer avatar
Tutor_Stella

Rating: 4.9/5    Reviews 305

Success rate 99%

Completed projects: 404

I am a proficient writer with knowledge across a wide range of academic disciplines. I guarantee quality, timely and original content.

Writer avatar
Tutor_SylviaYoung

Rating: /5    Reviews 419

Success rate 98%

Completed projects: 506

Hi, count on me to deliver quality and exemplary papers. I will pay attention to all your instructions, and meet all your expectations.