PROF SCRIPT – Risk and Return, Cost of Capital, and Dividend Policy

Part 1 of Assignment – 
Assignment Steps 
Resources: Tutorial help on Excel® and Word functions can be found on the Microsoft® Office website. There are also additional tutorials via the web that offer support for office products. 
Scenario: Wilson Corporation (not real) has a targeted capital structure of 40% long term debt and 60% common stock. The debt is yielding 6% and the corporate tax rate is 35%. The common stock is trading at $50 per share and next year’s dividend is $2.50 per share that is growing by 4% per year.
Prepare a minimum 700-word analysis including the following: