Analyzing Data in a Personal Budget Workbook
rhariff74
ssalinas_08042018.xlsx
Sheet1
| Sharlene's Budget |
| | January | February | March | April | May | June | July | August | September | October | November | December | Year Total |
| Income One | $ 2,458.00 | $ 2,458.00 | $ 2,458.00 | $ 2,458.00 | $ 2,458.00 | $ 2,458.00 | $ 2,458.00 | $ 2,458.00 | $ 2,458.00 | $ 2,458.00 | $ 2,458.00 | $ 2,458.00 | $29,496.00 |
| Income Two | $ 700.00 | $ 700.00 | $ 700.00 | $ 700.00 | $ 700.00 | $ 700.00 | $ 700.00 | $ 700.00 | $ 700.00 | $ 700.00 | $ 700.00 | $ 700.00 | $ 8,400.00 |
| Total Income | $ 3,158.00 | $ 3,158.00 | $ 3,158.00 | $ 3,158.00 | $ 3,158.00 | $ 3,158.00 | $ 3,158.00 | $ 3,158.00 | $ 3,158.00 | $ 3,158.00 | $ 3,158.00 | $ 3,158.00 | $37,896.00 |
| Rent | $750.00 | $750.00 | $750.00 | $750.00 | $750.00 | $750.00 | $750.00 | $750.00 | $750.00 | $750.00 | $750.00 | $750.00 | $ 9,000.00 |
| Utilities | $195.00 | $190.00 | $120.00 | $125.00 | $120.00 | $200.00 | $220.00 | $225.00 | $110.00 | $185.00 | $175.50 | $225.00 | $ 2,090.50 |
| Car Payment | $250.00 | $250.00 | $250.00 | $250.00 | $250.00 | $250.00 | $250.00 | $250.00 | $250.00 | $250.00 | $250.00 | $250.00 | $ 3,000.00 |
| Credit Card | $50.00 | $50.00 | $50.00 | $50.00 | $50.00 | $50.00 | $50.00 | $50.00 | $50.00 | $50.00 | $50.00 | $50.00 | $ 600.00 |
| Loan | $85.00 | $85.00 | $85.00 | $85.00 | $85.00 | $85.00 | $85.00 | $85.00 | $85.00 | $85.00 | $85.00 | $85.00 | $ 1,020.00 |
| Groceries | $150.00 | $125.00 | $285.00 | $315.00 | $295.50 | $250.00 | $302.75 | $255.65 | $297.65 | $343.25 | $322.95 | $386.33 | $ 3,329.08 |
| Gas | $95.00 | $100.00 | $200.00 | $85.75 | $79.85 | $105.50 | $115.25 | $120.55 | $100.00 | $95.00 | $89.99 | $110.00 | $ 1,296.89 |
| Savings | $500.00 | $550.00 | $500.00 | $500.00 | $525.00 | $500.00 | $500.00 | $515.00 | $550.00 | $500.00 | $450.00 | $425.00 | $ 6,015.00 |
| Entertainment | $50.00 | $65.00 | $55.00 | $40.00 | $70.00 | $50.00 | $45.00 | $35.00 | $45.00 | $50.00 | $60.00 | $60.00 | $ 625.00 |
| Checking | $100.00 | $100.00 | $100.00 | $100.00 | $100.00 | $100.00 | $100.00 | $100.00 | $100.00 | $100.00 | $100.00 | $100.00 | $ 1,200.00 |
| Insurance | $125.00 | $125.00 | $125.00 | $125.00 | $125.00 | $125.00 | $125.00 | $125.00 | $125.00 | $125.00 | $125.00 | $125.00 | $ 1,500.00 |
| Supplements | $65.00 | $90.00 | $85.00 | $75.00 | $85.00 | $90.00 | $65.00 | $68.00 | $75.00 | $75.50 | $85.99 | $99.99 | $ 959.48 |
| Total Expenses | $ 2,415.00 | $ 8,796.00 | $ 8,921.00 | $ 8,816.75 | $ 8,851.35 | $ 8,871.50 | $ 8,924.00 | $ 8,895.20 | $ 8,853.65 | $ 8,924.75 | $ 8,860.43 | $ 8,982.32 | $11,397.32 |
| Net Income | $ 743.00 | $ (5,638.00) | $ (5,763.00) | $ (5,658.75) | $ (5,693.35) | $ (5,713.50) | $ (5,766.00) | $ (5,737.20) | $ (5,695.65) | $ (5,766.75) | $ (5,702.43) | $ (5,824.32) | $26,498.68 |
| Average Expense |
| Minimum Expense |
| Maximum Expense |
