Case Study – Nike
north
WACC.Example13.xlsxExport Summary
| This document was exported from Numbers. Each table was converted to an Excel worksheet. All other objects on each Numbers sheet were placed on separate worksheets. Please be aware that formula calculations may differ in Excel. | |||
| Numbers Sheet Name | Numbers Table Name | Excel Worksheet Name | |
| Capital Structure | |||
| Table 1 | Capital Structure | ||
| WACC | |||
| Table 1 | WACC |
Capital Structure
| $ Value | |||
| Market Value of Equity | $ 90.00 | ||
| Market Value of Debt | $ 50.00 | ||
| Total | $ 140.00 | ||
| Market Values of Capital | % Weight | ||
| Market Value of Equity | 64% | ||
| Market Value of Debt | 36% | ||
&"Helvetica Neue,Regular"&12&K000000&P
Enter Market Values
Capital Structure
Market Value of Equity Market Value of Debt 0.642857 0.357143
WACC
| Market Values of Capital | % Weight | Cost of Components | Contribution | |||
| Market Value of Equity | 64% | 12% | 7.71% | |||
| Market Value of Debt | 36% | 6% | 2.14% | |||
| 9.86% | WACC |
&"Helvetica Neue,Regular"&12&K000000&P
Enter Cost of Equity and Cost of Debt.
