Description
Complete the Budget Worksheet. NOTE: Make sure to choose an entry level job/career that you have the current qualifications necessary to be hired. Do not choose a job that requires additional education or experience that you currently do not have.
Unformatted Attachment Preview
Purchase answer to see full attachment
Explanation & Answer
Hello, so here is what I have so far for the question? Do you need me to complete the pet section? I am a little confused as to who's budget this is. For loans and credit cards do you want me to fill something in? Please let me know.
Personal Budget Worksheet NAME: ______________________________________
To complete this exercise, you will need to select a city or town and research the typical starting salary there for
your chosen occupation. NOTE: Make sure your occupation is a job that requires an undergraduate degree and is not a job
that requires more education or experience than you have at the time you graduate. You will also need to research the
cost living there, specifically expenses like rent or mortgage, utilities, gas, etc. Websites that may help with your
research:
www.salary.com, www.homefair.com, www.fueleconomy.gov, http://www.eia.gov, and
www.costoflivingbystate.org
______________________________________________________________________________
Based on the research you did earlier in the course, identify an occupation you may pursue.
Occupation: Administrative Assistant ________________________
Town/City: Riverside ________________________
State: California _________________
Average entry level salary for this occupation in your chosen city or town: $14.31 per hour_____
Total Annual Gross Pay $ 36,513.00 (Select amount based on research)
Monthly Gross Pay: $ 3,042.75 (Divide total by 12 for this amount)
Subtract: 1/3 of total income for taxes $ 1,014
Monthly Projected Income (THIS SHOULD BE MONTHLY - NOT ANNUAL SALARY) $ 2,028.75
HOUSING
Mortgage or rent
Phone
Projected Cost
$1.537
Actual Cost
$1.400
Difference
$137
$100
$100
$0
Electricity
$90
$60
$30
Gas
$40
$180
-$140
Water and sewer
$78
Cable
$40
ENTERTAINMENT/PERSONAL
Movies
$20
Concerts
$50
$78
Sporting events
$50
$40
Live theater
$25
$25
Other
$100
Other
Supplies
$0
$0
Other
Other
$0
$0
Total
Maintenance or repairs
Total
$1.970
$1.740
Projected Cost
Actual Cost
Difference
$0
Student
$0
Credit card
Insurance
$100
$100
Credit card
Licensing
$150
$150
Credit card
Fuel
$200
$200
Other
$0
$0
$250
Bus/taxi fare
Maintenance
$250
Total
$0
$0
Other
Total
Projected Cost
Personal
$0
Vehicle payment
$120
$230
LOANS
TRANSPORTATION
$0
CDs
$100
Waste removal
Projected Cost
Video/DVD
$700
$250
$450
TAXES
Projected Cost
Federal
INSURANCE
Projected Cost
Actual Cost
Difference
State
Home
$0
$0
Local
Health
$196
$196
Other
Life
$0
$0
Renter's Insurance
...