Pick any publicly traded company that you would like. You will be accumulating three years of balance sheets in Excel,


Using Excel to analyze financial information.

1. Pick any publicly traded company that you would like. You will be accumulating three years of balance sheets in Excel, and creating common-size statements for each of those years. (If you would like to have more information about common-size statements, look at http://www.netmba.com/finance/statements/common-size/.) You should also create a number of graphs illustrating the balance sheet information. You may obtain company information either from the SEC (Edgar) or from the company’s website.

2. Use the same company as the previous exercise. Note that you will be accumulating three years of income statements as well as preparing common-size statements, calculating the following financial statement ratios and preparing a number of graphs illustrating those ratios and any other information you feel is important.

The ratios to be prepared are:

Current ratio

Debt to equity ratio

Gross profit ratio

Return on assets

Return on equity

Inventory ratios, if appropriate



This essay is written by:

Prof. SirMojo Verified writer

Finished papers: 435

Proficient in:

English, History, Business and Entrepreneurship, Nursing, Psychology, Management

You can get writing help to write an essay on these topics
100% plagiarism-free

Hire This Writer
© 2017 theacademicessays. All Rights Reserved. Design & Developed by theacademicessays.
How to Avoid Plagiarism
  • Use multiple resourses when assembling your essay
  • Use Plagiarism Checker to double check your essay
  • Get help from professional writers when not sure you can do it yourself
  • Do not copy and paste free to download essays
Get plagiarism free essay
Loading...