Armed with your debit card and a simulated bank account balance, you are to come up with realistic expenses (including tithes and donations) that you might have over the course of three months. How good are you with God’s money?
Your job is to keep personal records of expenses for a period of three months. On the last day of each month, an allowance of $500 is deposited into your bank account. For this exercise, you have no other income.
Your bank balance on January 1 is $2509.58. You will use your debit card for every transaction. You are not allowed to spend more money than you have in your account at any time. At the end of the third month (March), you must have entered a minimum of 30 transactions. (Try to enter at least 10 transactions for every month.)
Step 1: Open the Personal Expenses spreadsheet. Save your copy as Personal Expenses - Firstname Lastname in your Final Project folder.
/1 Step 2: Replace “Your Name” with your actual name.
/1 Step 3: Format the dates to the current year.
/1 Step 4: Examine the column headings. Change the headings to suit you, delete columns you don't anticipate using, and insert more columns for additional expenses.
/1 Step 5: Center and format titles.
/1 Step 6: Format the cells accordingly (date, currency, etc.).
/2 Step 7: Use one formula in the column Bank Balance that will subtract the total expenses from the previous balance and add the income. DO NOT manually enter different formulas for different rows. Copy the formula down at least 30 cells.
/4 Step 8: Create at least 30 realistic transactions. Be sure to include:
your monthly allowance,
a monthly tithe of 10% of your monthly allowance,
at least one donation to a cause that furthers God’s Kingdom purposes
/1 Step 9: On March 31, enter “Total” in the Description cell.
/2 Step 10: Total each Expense column and the Income column. Use formulas to calculate the totals.
/1 Step 13: Format the table appropriately so that it looks nice and is easy to read and identify important information.
/3 Step 14: Create a pie chart that depicts your total expenses. Until Google Sheets improves this feature, you will need to create two columns or rows side-by-side, one containing labels and one containing your totals. Select both columns or rows to create your chart. Place the chart below your data. Format and size your chart appropriately, giving it a title and legend.
Step 15: Compare your sheet to the exemplar. Does it look close?
Total: /18
Step 16: Submit to the Final Project Assignment on Classroom your:
Most Wanted workbook
Personal Expenses workbook