Public Company Summary Prompt

Please follow the instructions below carefully. Be sure to show your work! USE EXCEL

Choose a company that you can obtain lots of information on

This company will be publicly traded company

Resources: BusinessWeek, SEC Online (Edgars), NU Library (Reference USA, D&B Million Dollar Database), yahoo.com/finance, Morningstar.com, Darkside Article.

Please confirm the company before proceeding

Include a prepared common size income statement for 2014 and 2015 for your company

Provide a statement that analyzes your work and demonstrates your understanding of the common size techniques

Perform ratio analysis on your company for 2014 and 2015. At a minimum you should have 5 ratios for each year. Please provide calculations

Provide a statement that demonstrates your understanding of what the ratios mean in the context of your company.

Analyze your company's capital structure.

At a minimum you should:

Provide a statement about the company's capital structure and any changes you would recommend making. This should include: The company's equity position and items like: number of shares, market price, EPS, PE ratio, and book to market value. The company's debt with a particularly focus on bonds and items like: YTM, rating, ability to pay.

Calculate your company's WACC and Analyze if it is optimal.

Be sure to clearly breakout the components ("Darkside" article may help with this).

Provide a clear statement that demonstrates understanding of WACC and if it is optimal for your company.