Solved by Expert Tutors
Explanation: Question 1 Risk Free Market premium Beta Beta'Market premium 3.00% 6 00%% 0.054 3% Risk Free rate 8400% CAPM cost of Equity #2 D1 2.38...
Solved by Expert Tutors
Question

SOLUTION IS ALREADY ATTACHED FOR ALL PARTS , JUST NEED EXCEL FORMULAS FOR THAT SOLUTION .THANKS SCENARIO:

The CFO plans to borrow a portion of the required $350 million initial investment for this project using 20 year bonds. For most of the past 10 years, the company has used 7% as the discount rate. This was based on a study of the company's WACC in early 2010. Interest rates have risen since the last study when the McCormick & Co rate average interest rate was 3%. We will use 4% today. Also, there has been a change in the weights between debt and equity in the overall capital structure since 2010.

The most significant change was the acquisition of RB Foods. It is the main reason for this study. Here is what our MD&A reported about that acquisition.


On August 17, 2017, we completed the acquisition of Reckitt Benckiser's Food Division ("RB Foods") from Reckitt Benckiser Group plc. The purchase price was approximately $4.2 billion, net of acquired cash. The acquisition was funded through our issuance of approximately 6.35 million shares of common stock non-voting (see note 13 of the financial statements) and through new borrowings comprised of senior unsecured notes and pre-payable term loans (see note 6 of the financial statements). The acquired market-leading brands of RB Foods include French's®, Frank's Red Hot® and Cattlemen's®, which are a natural strategic fit with our robust global branded flavor portfolio. We believe that these additions move us to a leading position in the attractive U.S. condiments category and provide significant international growth opportunities for our consumer and industrial segments.

The RB Foods acquisition resulted in acquisitions contributing more than one-third of our sales growth in 2017 and is expected to result in acquisitions contributing more than one-third of our sales growth in 2018.

As part of your work, you will be asked for a recommendation for the cost of equity. There are three widely accepted methods used to calculate the cost of equity. They are the Capital Asset Pricing Model (CAPM), the Discounted Cash Flow approach (DCF) and the debt rate plus a risk premium of 3% to 5% recommended by one board member. This last is often used by very wealthy investors as a check on the other two methods. Your recommendation for the cost of equity will be necessary so you can undertake the calculation estimating the WACC.

Questions:

1. You have been asked to calculate the cost of equity using the Capital Asset Pricing Model (CAPM). The CFO estimates the Beta as 0.90. Management wants to use the 30 year bond rate as the risk free rate, arguing that Investors should make long term investments; that rate is 3% today. The expected return on the stock market as a whole has been estimated to be 7%, 10% and 12% by various studies. The CFO asks that you use an expected return of 9% for the average stock. The market risk Premium (RPM) will be 6%. 9% minus 3% = 6%.   

Calculate the cost of equity (Rs) using the CAPM. The formula is Rs  = rRF  + (RPM ) x β.  Rs is the required return on equity or the Cost of Equity, rRF is the risk free rate, RP M is the required stock market return in excess of the risk free rate, and β , (Beta) is the stocks relative risk. β is also described as the estimate of the amount of risk that an individual stock contributes to a well balance portfolio.   

2. The Discounted Cash Flow model is referred to as the Direct Dividend Model in the MBA 620 course materials. The formula reduces to Rs = (D1 / P0 ) + g where Rs is the required return on equity or the Cost of Equity, D1 is the expected future dividend, P0 is the price of the stock today and g is the expected growth in dividends. The CFO notes that the expected future dividend is $2.38 and the expected growth rate is 7%. For this calculation, please use the March 17, 2020 closing price of $138.70 per share.  Calculate the cost of equity (Rs) using the DCF approach.

3. Cristina Flores is an advisor to a board member who works at a private equity firm. She has told the CFO that sophisticated investors use a quick estimate of the cost of equity. She says that the cost of equity must logically be higher than the company's debt rate. The estimate is that 3% to 5% should be added to the company's long term interest rates. McCormick & Company estimates its current borrowing cost at 4%. Make your own estimate of the relative risk of McCormick & Company. Then, calculate the cost of equity (Rs) using this "own debt plus 3% to 5%" formula.

4. Calculate the Weighted Average Cost of Capital (WACC) for McCormick and Company using the formula WACC = (WD x RD x (1-T)) + (WS  x Rs)

Note that --

Rs = the cost of equity  

Rd = the cost of debt

T = the tax rate  

WD  = Value of debt / (Value of debt plus value of equity) 

WS  = Value of equity / (Value of debt plus value of equity)   **Note that the weight of debt plus the weight of equity must total to 100%, as there are only two components in the capital structure.**

In order to estimate the weights of debt and equity in the total capital structure, the CFO suggests using the book value of debt and the market value of equity. To determine the book value of debt, use data from the year end November 2019 McCormick 10-K. Look on the Balance sheet and add the following -- Short term borrowings, Current portion of long term debt, and Long term debt. To determine the market value of equity, use the following data: On March 17, 2020 the market value of equity (or "Market Cap") for McCormick (MKC ) - as found on Yahoo finance - was $18.42 billion. Use 4% for the cost of debt. Use 27.5% as the tax rate - an estimate of the combination of federal and state income tax rates. Make your own best estimate of the cost of equity based on your work in questions 1, 2, and 3.


SOLUTION :


WACC = Weight*Cost of Debt + Weight*Cost of Equity

=WD*KD + WE*KE

=0.1901*2.9% +0.8099*8.4%

= 7.35432%


Note; Use CAPM model since it gives the highest cost of equity



Screenshot (55).png

Screenshot (55).png
Explanation:
Question 1
Risk Free
Market premium
Beta
Beta'Market premium
3.00%
6 00%%
0.9
3.054
3% Risk Free rate
8400% CAPM cost of Equity
#2
D1
2.38
IPO
138.7
D1/PO
0.017159337
DCF Cost of Equity
7.017159337
Bond rate
premium
Cost of Equity
4%%
Calculate weights
Short term borrowings
600.7
Current portion of longterm debt
97.7
Long term Borrowing
3625.8
Market Capital equity
Total Capital
Total debt
1324.2
18420
22744.2
Weights
0.1901
0.8099
Debt Interest Rate
4%
Tax Rate
27.50%
After Tax Cost of debt
2.9
8.4% Cost of equity
Debt Term
Equity Term
WADC
0.5514
6.80297
7.35432

Step-by-step answer

The student who asked this found it Helpful

, dictum vitae odio. Donec al

ctum vitae odio. Donec aliqu

ac

ipiscing elit. Nam l

ur laoreet. Nam risu

ec aliquet. Lorem ip

gue vel laoreet ac, dictum vitae o

acinia pulvi

et, consectetur adipiscing elit. Nam lacinia pulvinar tortor nec facilisis. Pellentesque dapibus efficitur laoreet. Nam risus ante, dapibus a


pulvinar tortor nec facilisis. Pellentesque dapibus efficitur laoreet. Nam risus ante, dapibus a molestie


, dictum vitae odio. Donec aliquet. Lorem ipsum dolor sit amet, consectetur a


s a molestie consequat, ultrices ac magna. Fusce dui lectus, congue vel laoreet ac, dictum vitae odio. Donec aliquet. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Nam lacinia pulvinar tortor nec facilisis. Pellentesque dapibus efficitur laoreet. Nam risus ante, dapibus a molestie consequat, ultrices ac magna. Fusce dui lectus, congue vel laoreet ac, dictum vitae odio. Donec aliquet. Lorem ipsum dolor sit amet, consectetur

Subscribe to view the full answer

Subject: Business, Finance

Why Join Course Hero?

Course Hero has all the homework and study help you need to succeed! We’ve got course-specific notes, study guides, and practice tests along with expert tutors.

  • -

    Study Documents

    Find the best study resources around, tagged to your specific courses. Share your own to gain free Course Hero access.

    Browse Documents
  • -

    Question & Answers

    Get one-on-one homework help from our expert tutors—available online 24/7. Ask your own questions or browse existing Q&A threads. Satisfaction guaranteed!

    Ask a Question
Let our 24/7 Finance tutors help you get unstuck! Ask your first question.
A+ icon
Ask Expert Tutors You can ask You can ask You can ask (will expire )
Answers in as fast as 15 minutes