Corporationâ€™s Weighted Average Cost of Capital
February WebWorks Instructions:
Using the data in the Excel files February Webworks Data.xlsx and SP500 earnings data.xls, calculate the weighted average cost of capital for 3M Corporation. Your estimate will be as of the day I gathered dataâ€”1/11/2013, and I believe all of the data you need is available in the two files. If you need some other data in addition to what Iâ€™ve provided, first try to get it as of 1/11/2013. If you canâ€™t get that, then use data as of the date of your analysis.
Your submission should be a single Excel file that has your detailed calculations split up into intuitive sections with an explanation of what you are doing and why. There are a number of judgment decisions youâ€™ll have to make in this project and you need to explain at each step what choices you had, what choice you made, and why.
For your final â€œnumerical answerâ€ you will need a single WACC, which will be your best guess at the companyâ€™s cost of capital given the assumptions youâ€™ve made. Also provide a discussion about the range the actual WACC is likely to fall in based on your analysis.