Filetype Excel XLSX | Posted on 09 Aug 2022 | 3 years ago
Authentication
digital resources
187x Filetype XLSX File size 0.37 MB Source: www.mortgagecalculator.org
Sheet 1: Budget Overview
| Projected Balance | $1,585 | Projected minus expenses | |||||
| Actual Balance | $1,740 | Actual minus expenses | |||||
| Difference | $155 | Actual minus projected | |||||
| Income | Expenses | ||||||
| Projected | Actual | Projected | Actual | ||||
| Income 1 | $6,000 | $5,800 | $7,915 | $7,860 | |||
| Income 2 | $1,000 | $2,300 | |||||
| Extra income | $2,500 | $1,500 | |||||
| Total Income | $9,500 | $9,600 | |||||
| Actual Expenses Breakdown | |||||||
| Budget Summary | ||||||
| Data | ||||||
| Category | Description | Sum - Projected Cost | Sum - Actual Cost | Sum - Difference | ||
| Children | $140 | $140 | $0 | |||
| Extracurricular Activities | $40 | $40 | $0 | |||
| Medical | ||||||
| School Supplies | ||||||
| School Tuition | $100 | $100 | $0 | |||
| Entertainment | $400 | $358 | $42 | |||
| Concerts | $50 | $40 | $10 | |||
| Live Theater | $200 | $150 | $50 | |||
| Movies | $50 | $28 | $22 | |||
| Music (CDs, Downloads, etc.) | $50 | $30 | $20 | |||
| Sporting Events | $0 | $40 | ($40) | |||
| Video/Dvd (Purchase) | $20 | $50 | ($30) | |||
| Video/Dvd (Rental) | $30 | $20 | $10 | |||
| Food | $1,100 | $1,320 | ($220) | |||
| Gifts and Charity | $100 | $125 | ($25) | |||
| Housing | $2,830 | $2,702 | ($72) | |||
| Insurance | $900 | $900 | $0 | |||
| Loans | $200 | $200 | $0 | |||
| Personal Care | $150 | $140 | $10 | |||
| Pets | $170 | $100 | $70 | |||
| Taxes | $300 | $300 | $0 | |||
| Transportation | $1,425 | $1,375 | $50 | |||
| Savings | $200 | $200 | $0 | |||
| Investment Account | $200 | $200 | $0 | |||
| Retirement Account | ||||||
| Total Result | $7,915 | $7,860 | ($145) | |||
| Description | Category | Projected Cost | Actual Cost | Difference | Actual Cost Overview | ||
| Extracurricular Activities | Children | $40 | $40 | $0 | 40 | ||
| Medical | Children | 0 | |||||
| School Supplies | Children | 0 | |||||
| School Tuition | Children | $100 | $100 | $0 | 100 | ||
| Concerts | Entertainment | $50 | $40 | $10 | 40 | ||
| Live Theater | Entertainment | $200 | $150 | $50 | 150 | ||
| Movies | Entertainment | $50 | $28 | $22 | 28 | ||
| Music (CDs, Downloads, etc.) | Entertainment | $50 | $30 | $20 | 30 | ||
| Sporting Events | Entertainment | $0 | $40 | ($40) | 40 | ||
| Video/Dvd (Purchase) | Entertainment | $20 | $50 | ($30) | 50 | ||
| Video/Dvd (Rental) | Entertainment | $30 | $20 | $10 | 20 | ||
| Dining Out | Food | $1,000 | $1,200 | ($200) | 1200 | ||
| Groceries | Food | $100 | $120 | ($20) | 120 | ||
| Charity 1 | Gifts and Charity | $75 | $100 | ($25) | 100 | ||
| Charity 2 | Gifts and Charity | $25 | $25 | $0 | 25 | ||
| Gift 1 | Gifts and Charity | 0 | |||||
| Gift 2 | Gifts and Charity | 0 | |||||
| Cable/Satellite | Housing | $100 | $100 | $0 | 100 | ||
| Electric | Housing | $45 | $50 | ($5) | 50 | ||
| Gas | Housing | $300 | $400 | ($100) | 400 | ||
| House Cleaning Service | Housing | $200 | 0 | ||||
| Maintenance | Housing | $200 | $150 | $50 | 150 | ||
| Mortgage Or Rent | Housing | $1,700 | $1,700 | $0 | 1700 | ||
| Natural Gas/Oil | Housing | 0 | |||||
| Online/Internet Service | Housing | $100 | $100 | $0 | 100 | ||
| Phone (Cellular) | Housing | $60 | $60 | $0 | 60 | ||
| Phone (Home) | Housing | $35 | $39 | ($4) | 39 | ||
| Supplies | Housing | $40 | $55 | ($15) | 55 | ||
| Waste Removal and Recycle | Housing | $25 | $22 | $3 | 22 | ||
| Water and Sewer | Housing | $25 | $26 | ($1) | 26 | ||
| Health | Insurance | $400 | $400 | $0 | 400 | ||
| Home | Insurance | $400 | $400 | $0 | 400 | ||
| Life | Insurance | $100 | $100 | $0 | 100 | ||
| Credit Card 1 | Loans | $200 | $200 | $0 | 200 | ||
| Credit Card 2 | Loans | 0 | |||||
| Credit Card 3 | Loans | 0 | |||||
| Personal | Loans | 0 | |||||
| Student | Loans | 0 | |||||
| Clothing | Personal Care | $150 | $140 | $10 | 140 | ||
| Dry Cleaning | Personal Care | 0 | |||||
| Hair/Nails | Personal Care | 0 | |||||
| Health Club | Personal Care | 0 | |||||
| Medical | Personal Care | 0 | |||||
| Food | Pets | $150 | $75 | $75 | 75 | ||
| Grooming | Pets | $20 | $25 | ($5) | 25 | ||
| Medical | Pets | 0 | |||||
| Toys | Pets | 0 | |||||
| Investment Account | Savings | $200 | $200 | $0 | 200 | ||
| Retirement Account | Savings | 0 | |||||
| Federal | Taxes | $300 | $300 | $0 | 300 | ||
| Local | Taxes | 0 | |||||
| State | Taxes | 0 | |||||
| Bus/Taxi Fare | Transportation | $100 | $150 | ($50) | 150 | ||
| Fuel | Transportation | $450 | $400 | $50 | 400 | ||
| Insurance | Transportation | $300 | $300 | $0 | 300 | ||
| Licensing | Transportation | $25 | $25 | $0 | 25 | ||
| Maintenance | Transportation | $100 | $50 | $50 | 50 | ||
| Parking Fees | Transportation | 0 | |||||
| Vehicle Payment | Transportation | $450 | $450 | $0 | 450 | ||
no reviews yet
Please Login to review.
