Information System P

Date Due: Monday 05/05/2014

Go online and find a “Balance Sheet” from a company. Criteria for the balance sheet:

· Must have at least 2 periods of data (or 2 locations of data). Example: 2010, 2011; or January 1, January 15; or Eastern Region, Central Region, Western Region, etc.

· Must have at least 7 items under assets

Create a worksheet for the Assets portion only of this balance sheet to look like the one online altering it slightly so that you will only have one period or location on a sheet and a sub-title indicating that. You must put in formulas where appropriate.

Create a workbook placing the data from the periods or locations on separate sheets. Have one additional sheet as your summary sheet, so that it has the same layout as each of the separate period sheets, with an appropriate sub-title to that effect. You will calculate the gain/loss from the first period to second period using 3-D cell referencing.

Create another sheet showing the period data side-by-side with appropriate headers noting the period of each column of data. Rename the tab to Comparison. Use 3-D cell referencing in this worksheet, so that any changes to the individual sheets of data would be reflected on this sheet as well. Create a cylinder chart using the data from assets, placed side-by-side. Change the color of the cylinders and back wall. Place an appropriate title on the Chart as well.

You will write up a short report (1 page) including some background of the company, what data has been included in the balance sheet, finally what we can gather about the company based on the data in the balance sheet.

Order of printouts:

1. Cover page

2. Report

3. Original Balance Sheet from online

4. Worksheets

5. Chart

6. Formula View of Summary sheet and the Comparison sheet.