Review and study the following information related to stocks:
Identify the types of stock, such as common or preferred stock, currently issued, and outstanding.
Identify the presence of treasury stock and its impact on overall stockholders' equity.
Analyze debt vs. equity. Using the correct formulas and a separate tab for each analysis, calculate the following ratios using Excel: calculate the return on equity, debt to equity, capital structure leverage, and times interest earned ratios, and use them to identify the total make-up of stockholders' equity as compared to debt.
Using the results of your analysis, write a 500-word memo to the CEO recommending and explaining the pros and cons of issuing new stock, reissuing treasury stock (if applicable), and issuing convertible bonds. Justify your recommendation using the 10-K stock information and ratios along with citing two substantiating academic sources that support your analysis of the stockholders' equity.
Sample Solution