WACC should be calculated for all the following scenarios:

Using Excel, create a single-page spread sheet to calculate the WACC for Johnson and Johnson (NYSE: JNJ).

1.Using adjusted and an ERP of 12%

2.Using 12% as your required equity return.

3.Using adjusted a forward looking ERP calculated by NYU Professor Damodaran.

Show all your inputs and source of inputs. Format the spreadsheet as professionally as your skills permit. All three scenarios should be on the spread.

Adjusted Beta= 0.841

Adjusted a=0.761

ERP NYU Professor Damodaran= 5.20%