MBA 620 University of Maryland Marketing Decisions of McCormick & Company Worksheet
Project 5: Financial Decision Making for ManagersStart HereOver the past eight weeks working at Maryland Creative Solutions, LLC (MCS), you have continued to prove your expertise through your ethical organizational analysis and ability to build effective virtual teams, while working hard in the areas of economics, finance, and accounting. Frank Marinara and Elisa Izuki are happy with your progress, and have decided to offer you a junior partner position with MCS. Congratulations! You’re excited to continue working for the company and believe you are on the right path to someday making senior partner.INBOX (2 NEW EMAILS)From: Frank Marinara, MCS Director of FinanceTo: YouCongrats on the promotion, we couldn’t have asked for a better junior partner. Keep it up!FrankFrom: Elisa, MCS Managing Senior Director PartnershipsTo: YouWe’re glad to have you as the newest junior partner at MCS. You will now be responsible for a greater depth of analysis as you make recommendations for our clients.McCormick & Company is very satisfied with the work finance analysts did on the previous project, and they would like us to continue working with them. In our ongoing work with this client, we are expecting you to be able to determine the cost of capital and make capital budgeting decisions.McCormick has expanded their current product line through an acquisition and is now considering a new project that requires an initial investment to build a new plant and purchase equipment. Given the information on capital structure and valuation that I’ll pass along to you, you’ll need to determine if McCormick should accept this project. You’ll be digging into the company’s market capitalization figures and value of debt to make cost of capital decisions and you’ll be analyzing the valuation of multiple cash flows to provide guidance on key budgeting choices.I also want you to join a meeting next week on the topic of capital budgeting with the other financial analysts. This discussion will help the client decide how they should organize their capital budget for making financial decisions.Ultimately, we’d like you to summarize your guidance and file a report that highlights your recommendations through an executive summary. Now that you are junior partner, I am expecting you to give the executive summary to the client. I’ll need all of these tasks complete within the next two weeks. I know it’s a lot, but I have no doubts about your abilities.Reach out if you need anything,Elisa As usual, you can get started in Step 1, but first, take two minutes to view the video below.TranscriptCourse TouchpointProject 5: Financial Decision Making for ManagersStep 1: Make Cost of Capital DecisionsMCS 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 a capital structure for a recent acquisition of new product lines. To provide these services, a junior partner must first understand the cost of capital by exploring weighted average cost of capital (WACC), capital asset pricing model (CAPM), and market value ratios.Working in this Project 5 McCormick Workbook that 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.Now that you have completed Step 1, proceed to Step 2, where you will make capital budgeting decisions.Project 5: Financial Decision Making for ManagersStep 2: Make Capital Budgeting DecisionsMcCormick & 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 the time value of money and present value, you will also need to be knowledgeable about the ROE, ROA, and the DuPont Equationas well as valuation of multiple cash flows to help McCormick make the decision on the project.Working with the same Project 5 Excel Workbook you 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. Proceed to Step 3, in which you will discuss capital budgeting with the finance team.Project 5: Financial Decision Making for ManagersStep 3: Discuss Capital BudgetingCalendar InviteEvent: Capital Budgeting DiscussionLocation: Compass RoomMeeting Organizer: Elisa Izuki, MCS Managing Senior Director PartnershipsElisa has asked the finance team to meet and discuss how capital budgeting will influence McCormick’s investment decision. Complete the following tasks within your group:Discuss the best estimates of McCormick & Company’s capital structure used for the acquisition of new product lines. Give credit to any sources you use to support your statements.Discuss how understanding capital budgeting will impact the decision of McCormick and Company’s potential investment in a new factory. Give credit to any sources you use to support your statements.Later in the week, after you are back in your office, you have a follow-up discussion with your MCS colleagues in an effort to summarize the key lessons from your discussion on capital budgeting at the meeting. Respond to your colleagues' original discussion posts and give credit to any sources you use to support your statements. Submit one original posting of at least 250 words in the Capital Budgeting Discussion . See MBA discussion guidelines.When you have completed Step 3, proceed to Step 4, where you will prepare an executive summary about the work you have completedProject 5: Financial Decision Making for ManagersStep 4: Prepare Executive SummaryINBOX (1 NEW EMAIL)From: Frank Marinara, Director of FinanceTo: YouHope all is going well.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. This executive 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 cost of capital decisions based on capital budgeting.Can’t wait to see the executive summary.Best,FrankPost your executive summary in the submission folder located in the final step of this project.The executive summary should demonstrate your ability to think critically. This is your chance to be recognized for your knowledge in the accounting and finance field.When you have completed Step 4, proceed to Step 5, where you will complete and submit your skills gap analysis to MCS’ Human Resources office.Project 5: Financial Decision Making for ManagersStep 5: Complete Skills Gap AnalysisINBOX (1 NEW EMAIL)From: Jennifer Craylin, Human Resources GeneralistTo: YouGood morning,At MCS, LLC our Human Resources department conducts a 10 week post-project self-evaluation of your skills. Using the same skills gap analysis file that was sent to you when you began with us, self-evaluate your project-related knowledge and skills accounting for your growth as you have worked on the other projects within MCS.The skills gap analysis will help you identify the skill areas you have enhanced by completing the previous five projects. This self-evaluation measures the gains in competencies you have developed.Complete your preliminary skills gap analysis by the end of Week 10. Carefully follow the instructions below:Use the same skills gap analysis file you used at the beginning of the course to self-evaluate the knowledge and skills you gained from working with MCS. Use the Project 5 worksheet within the file to complete this step.Identify the skill gaps you worked to reduce over the past 10 weeks and ascertain whether and how much you improved those skills. Take a moment to reflect on the activities you pursed to help you hone those skills. Include your reflection of no more than 200 words in the space provided in the skills gap analysis file.Submit your updated skills gap analysis to the submission folder located in the final step of this project.Please complete as soon as possible and submit. I’m sure you’ll be pleased with your progress.Best,JenniferWhen you have completed Step 4, move onto Step 5 where you will submit all work for Project 5.