MR. ROBINSON
  • Economics
    • Forms >
      • Syllabus
      • Remind
    • Assignments
    • Notes
    • Projects >
      • Personal Budget
    • Extra-Credit
    • Study Aids
  • World History
    • Forms >
      • Syllabus
      • Remind
    • Notes
    • Assignments
    • Projects
    • Extra-Credit
    • Study Aids

Personal Budget

Instructions
Excel Worksheet
Jobs Worksheet
Walk-Through

Reminder: You need to download the Excel Template, fill it in and then print it. It should be one of the last tasks you perform for this assignment. 

Bureau of Labor Statistic
  • Information too fill in the Jobs Worksheet.
  • ​Remember, there are qualification requirements for certain professions.  

Payscale Calculator
  • ​ Select Los Angeles for city (although any city in Southern California is acceptable)

Salary Paycheck Calculator
  • Select California for state
  • Allowances: 1
  • Pay Frequency: Semi-Monthly
  • The figure you will enter into the worksheet is the Net Pay

Find a House
Mortgage Calculator
  • DO NOT calculate the mortgage if you are RENTING, This is only if you are buying a house. 
  • ​Down payment -- 3.5%
  • Interest rate -- 5%
  • Property tax -- 1.25% (Price of house x 0.0125 = Property Tax)
  • PMI -- 0.52%
  • Loan length -- 30 years
  • Select "click here to show the calculations" - Only need the first page for documentation
  • Monthly mortgage or rent should not exceed 35% of your gross monthly income

Car - Edmunds.com
  • Down payment no greater than 10% of the price of the car;
  • 4% interest rate;
  • ​Loan length of 3, 4, 5, or 6 years;
  • No trade in
  • You can do a loan or a lease

Grocery Pricing
  • Use 90001 for the zip code  
  • "Shop by Aisle"
  • You can find item pricing but you cannot add it to a cart without registering. You do not need to register.
  • You can probably also get pricing by looking a receipts from your parents grocery shopping
  • Going to the store and getting the prices is also an option. 

Personal Budget Order

  • Spreadsheet
  • BLS Summary
  • Jobs Worksheet
  • Payscale Calculator (payscale.com)
  • Paycheck Calculator (paycheckcity.com)
  • House/Apartment
  • Mortgage (If applicable)
  • Car
  • Grocery
  • Entertainment
  • Reflection
Powered by Create your own unique website with customizable templates.
  • Economics
    • Forms >
      • Syllabus
      • Remind
    • Assignments
    • Notes
    • Projects >
      • Personal Budget
    • Extra-Credit
    • Study Aids
  • World History
    • Forms >
      • Syllabus
      • Remind
    • Notes
    • Assignments
    • Projects
    • Extra-Credit
    • Study Aids