you should create a simple Excel spreadsheet based on the info below. Put your imagination caps on and pretend that you are a paralegal working in a family law firm. You are currently working on a divorce case. You are trying to gather together information so you can complete the statement of net worth required to be filed with the court.

So far, you have gathered the following financial information from your client for the month of September: Paycheck on September 6th $1152.64 Paycheck on September 20th $1152.64 Electric bill $67.89 Verizon bill $76.14 Rent $625.00 Cable/Internet $112.65 Grocery bill September 7th $112.87 Grocery bill September 14th $87.95 Grocery bill September 21st $131.26 Grocery bill September 28th $125.45 Medical expenses for kids $15 Medical expenses for client $42.16 Car payment $130 Daycare $600 Credit card payments $156

You should create an Excel chart showing the total expenses, the total income, and the difference between the two for the month of September.

You should include headings where appropriate.

You should use formulas to add or subtract or find averages where appropriate.

You should include months October through December with formulas so you could easily add expenses and income for these months when you get them. You should also create an average column where you use an average formula to display average cost of each of the expenses list above. You should include an additional expense of Other - leave it blank for all months, but be sure to include it in any formulas you use.

So, for example, you would list Electric bill as an expense category with the amount $67.89 for the month of September; the cells for this expense in October, November and December will be blank. Then you should have another column or row where you show the average monthly expense for the electric bill. You should include a formula in this cell to figure out the average monthly expense of the electric bill for the months September through December (even though October through December are currently blank).

Numbers should be in the form of U.S. dollars.

You should include main heading on top e.g. Clients monthly expenses/income.