Financial Decision Making for Managers Step 1: Make Cost of Capital Decisions

attached is an Excel Sheet with 2 Tabs which includes questions based on the math. Additional I need following below ( i also attached it on Word document)
Financial Decision Making for Managers
Step 1: Make Cost of Capital Decisions
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.
Step 2: 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 the time value of money and present value, you will also need to be knowledgeable about the ROE, ROA, and the DuPont Equations 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.
Step 3: Discuss Capital Budgeting
In 250 Words Elisa 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.
Step 4: Prepare Executive Summary
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.