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.
- Information too fill in the Jobs Worksheet.
- Remember, there are qualification requirements for certain professions.
- Select Los Angeles for city (although any city in Southern California is acceptable)
- Select California for state
- Allowances: 1
- Pay Frequency: Semi-Monthly
- The figure you will enter into the worksheet is the Net Pay
- 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
- 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
- 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