Create a spreadsheet that contains the Bi-Yearly expenses for the company that you chose. This will be linked into your presentation, and you will be presenting this at the end of the semester. The spreadsheet must include the following.

I chose is Starbucks.

You can search on the balance sheet for different income sources and expenses (for the excel sheet)

http://www.nasdaq.com/symbol/sbux/financials?query=balance-sheet

Sheet 1: January

Enter 5 income sources for the company and record the following:

Date

Payment method (cash, check, deposit, etc.)

Amount

Description

Enter 6 expenses that were paid by credit card and record the following. Make sure that at least 4 of your expenses are recurring at least 3 times

Date

Amount

Description

Rename the sheet and change the sheet tab color

Calculate the total income and apply the total cell style

Calculate how much was spent on each expense using the SumIf function and apply the total cell style

Count how many times each expense is listed using the Countif function.

Insert a title and merge and center the title across the columns

Format the date using the March 14, 2012

Use the currency format for the Income

Use the accounting format for the expenses

Create a new sheet for February using ALL that is listed in Sheet 1 and make the following changes:

Rename the sheet and change the sheet tab color

Change the amounts for the income and expenses

Change the date format to 14-Mar-12

Wrap the text of the income total

Hide Row 6

Set column B width to 18

Create a new sheet for March using ALL that is listed in Sheet 1 and make the following changes:

Rename the sheet and change the sheet tab color

Change the amounts for the income and expenses

Calculate 10% ma’asrot for each income source using absolute reference. Calculate the total price owed to ma’asrot.

Sort the expenses alphabetically by description

Freeze the header row

Create a new sheet for April using ALL that is listed in Sheet 1 and make the following changes:

Rename the sheet and change the sheet tab color

Change the amounts for the income and expenses

Insert a header with your name, the page number and the company you chose.

Apply conditional formatting with a colorful pattern style

Create a new sheet for May using ALL that is listed in Sheet 1 and make the following changes:

Rename the sheet and change the sheet tab color

Change the amounts for the income and expenses

Apply an Orange border around the title

Change the title font color to Purple

Change the color of one of the cells to yellow

Create a new sheet for June using ALL that is listed in Sheet 1 and make the following changes:

Rename the sheet and change the sheet tab color

Change the amounts for the income and expenses

Enter the name of the month and rotate the text

Insert a 3D pie chart reflecting the sum of each of the recurring expenses and make the following changes:

Place the chart below the income total

Show the Category Name and Percentage of each section separated with a semicolon and place the labels in the center of each section

Remove the legend

Insert a picture into one of the pie slices

Explode the chart (separate the pie slices)

Enter a chart title

Create a Total sheet and calculate the following:

Rename the sheet and change the sheet tab color

Create columns for January-June

Enter the Income for each month using cell reference

Enter the expense for each item for each month using cell reference

Calculate the total month balance for each month

Calculate the average balance for each month

Calculate the highest expense for each month

Calculate the lowest expense for each month

Insert Sparklines chart showing the income and expense for each month, and show the highest and lowest points

Insert an IF statement for each month that reflects that if the income is less than the expenses enter the text “Need Loan” otherwise it should show the remaining balance (income-expenses).

Insert a 3D column chart that reflects the expenses for each month and make the following changes:

Insert a chart title

Insert a gradient background for the chart

Place the chart in a new sheet called “Column Chart” and change the tab color.

Place the legend on the right

Change one of the item colors to orange