Analyzing Data in a Personal Budget Workbook
rhariff74
Module34.xlsxPersonal Budget 2018
| Sharlene Personal Budget | |||||||||||||||
| BUDGET ITEMS | PROJECTED COSTS | JAN | FEB | MAR | APR | MAY | JUN | JUL | AUG | SEP | OCT | NOV | DEC | Total | Item Average Expense |
| 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 | $750.00 | $9,000.00 | $750.00 |
| Utilities | $125.00 | $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 | $174.21 |
| 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 | $250.00 | $3,000.00 | $250.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 | $50.00 | $600.00 | $50.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 | $85.00 | $1,020.00 | $85.00 |
| Groceries | $300.00 | $300.00 | $305.00 | $285.00 | $315.00 | $295.50 | $250.00 | $302.75 | $255.65 | $297.65 | $343.25 | $322.95 | $386.33 | $3,659.08 | $304.92 |
| Gas | $100.00 | $95.00 | $100.00 | $90.00 | $85.75 | $79.85 | $105.50 | $115.25 | $120.55 | $100.00 | $95.00 | $89.99 | $110.00 | $1,186.89 | $98.91 |
| Savings | $500.00 | $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 | $501.25 |
| Entertainment | $50.00 | $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 | $52.08 |
| 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 | $100.00 | $1,200.00 | $100.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 | $125.00 | $1,500.00 | $125.00 |
| Supplements | $80.00 | $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 | $79.96 |
| Projected Budget Total: | $2,515.00 | ||||||||||||||
| Total Monthly Expenses: | $2,565.00 | $2,660.00 | $2,495.00 | $2,500.75 | $2,535.35 | $2,555.50 | $2,608.00 | $2,579.20 | $2,537.65 | $2,608.75 | $2,544.43 | $2,666.32 | |||
| Projected versus Actuals. | -$50.00 | -$145.00 | $20.00 | $14.25 | -$20.35 | -$40.50 | -$93.00 | -$64.20 | -$22.65 | -$93.75 | -$29.43 | -$151.32 |
Ssalinas
Nov-Dec 2018
| Rent | NOV | DEC |
| Utilities | $750.00 | $750.00 |
| Car Payment | $175.50 | $225.00 |
| Credit Card | $250.00 | $250.00 |
| Loan | $50.00 | $50.00 |
| Groceries | $85.00 | $85.00 |
| Gas | $322.95 | $386.33 |
| Savings | $89.99 | $110.00 |
| Entertainment | $450.00 | $425.00 |
| Checking | $60.00 | $60.00 |
| Insurance | $100.00 | $100.00 |
| Supplements | $125.00 | $125.00 |
| Projected Budget Total: | $85.99 | $99.99 |
| Total Monthly Expenses: | ||
| Projected versus Actuals. | $2,544.43 | $2,666.32 |
| -$29.43 | -$29.43 | -$151.32 |
