In your report, you must include following steps. 1) A one-page executive summary on the case2) All calculation steps for weights, cost of debts, costs of equities, and weighted average costs of capital with proper written explanations. (i.e., you can show your calculations in excel with explanations on your calculations in word). Please do not type in numbers in excel. Instead try to show your calculations.3) Data source (e.g., exhibit 2)4) Discussion on under- or over- estimation of WACC on Nike′s stock valuation (you don′t need to calculate, but just discuss)You are required to submit your report (in ms word) and supporting materials (in excel).All students are expected to communicate well in writing (i.e., typing). Each assignment should include 2-5 pages of analysts (typed and double-spaced) with references to an unlimited number of tables, figures, and notes attached to appendices. All written assignments will be subject to submission to anti-plagiarism software
