ITSW 1304 – Introduction to Spreadsheets

Independent Project

 

Go on-line and find / select a corporation that has published financial statements.  From the data prepare:

 

1. A comparative Balance Sheet (current year vs. prior year) including % of change.
2. A comparative Income statement (current year vs. prior year) including % of change.
3. A column chart for revenue (income) items for current year.
4. A pie chart for all current assets.
5. An appropriate Pivot Table  (i.e., expenses that had a positive % of change).
6. A sub report of expenses sorted in decending order
7. Include a cover sheet, appropriate clip art, pictures, word art, shading, borders, etc. (presentation is a major part of the report grade).