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.