MCS provides consulting services for clients to help them identify areas of improvement in their financial structure and apply industry best practices in future business decisions. McCormick needs the...

1 answer below »

MCS provides consulting services for clients to help them identify areas of improvement in their financial structure and apply industry best practices in future business decisions. McCormick needs the expertise of MCS consultants to better understand the financial implications of developing acapital structurefor a recent acquisition of new product lines. To provide these services, a junior partner must first understand the cost of capital by exploringweighted average cost of capital(WACC),capital asset pricing model (CAPM), andmarket value ratios.


Working in thisProject 5 McCormick Workbookthat Elisa has provided, complete the Cost of Capital worksheet. The Cost of Capital worksheet contains information about weight of equity and debt, cost of equity and debt, and the weighted average cost of capital, as well as questions that will help the client in selecting the best financing decision.


When you have completed the Cost of Capital worksheet, submit it to the submission folder located in the final step of this project. You should aim to complete this step during Week 9.


Now that you have completed Step 1, proceed to Step 2, where you will make capital budgeting decisions.


McCormick & Company will also need assistance in understanding how their anticipated growth, debt, market return, and marginal tax rate will affect their bottom line if they choose to pursue this new project.


Recalling what you have learned in the previous project about thetime value of moneyandpresent value, you will also need to be knowledgeable about theROE, ROA, and the DuPont Equationas well asvaluation of multiple cash flowsto help McCormick make the decision on the project.


Working with the sameProject 5 Excel Workbookyou will use in Step 1, complete the Capital Budgeting worksheet. This worksheet contains additional information on the data that will drive McCormick’s investment decision—whether or not to build a new plant and purchase equipment.


When you have completed the Capital Budgeting worksheet, submit the Project 5 Excel Workbook to the folder located in the final step of this project. As you enter Week 10, proceed to Step 3, in which you will discuss capital budgeting with the finance team.






Now that you’re concluding your project for McCormick & Company, please prepare an executive summary based on your analysis and recommendations from the previous steps. Thisexecutive summary, along with citations for any sources you use, should be about one page in length.


Within your executive summary, I'd like you to highlight your analysis and recommendations to help McCormick & Company identify areas of improvement in their operations and explore options to make capital budgeting decisonsbased on the cost of capital.


I would need a detailed executive summary.










Answered 12 days AfterJun 09, 2021

Answer To: MCS provides consulting services for clients to help them identify areas of improvement in their...

Tanmoy answered on Jun 13 2021
132 Votes
Project 5 Workbook
Instructions
Instructions
To complete this workbook, answer the questions on each worksheet in the space provided.
Cost of Capital
        Answer Questions Below:
        #1
        Risk Free Rate    Market Premium    Beta    Beta x Market Premium
        3%    6%    0.9    5.40%
                    3.00%    Risk Free rate
                    8.40%    CAPM cost of Equity
        #2
        D1    $2.38
        P0    $139
        D1 / P0    1.72%
        g    7%
        DCF Cost of Equity    8.72%
        #3
        Bond Rate    Premium    Cost of Equity
        4%    7%    10.30%
        
4%    8%    11.20%
        4%    9%    12.10%
        #4
        Calculate weights
        Short-term borrowings    $ 600.70
        Current portion of long-term debt    $ 97.70
        Long-term debt    $ 3,625.80        Market Cap Equity    Total Capital
        Total Debt    $6,905.40        $3,456.70    $10,362.10
        Weights    66.6%        33.4%
        Debt Interest rate    4%
        Tax Rate    27.50%
        After tax cost of debt    2.90%        8.40%    Cost of equity
            Debt term        Equity term     WACC
            1.9326%        2.802%    4.73%
        #5 (open question)
Information from McCormick
Your task is to make an estimate of McCormick & Company's Weighted Average Cost of Capital (WACC) to use as the discount rate for evaluating capital projects, such as the one in the next tab.
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 6.5% 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...
SOLUTION.PDF

Answer To This Question Is Available To Download

Related Questions & Answers

More Questions »

Submit New Assignment

Copy and Paste Your Assignment Here