Budget Planning

Topic outline

• L1. Make a Long-Term Spending Decision
  

  L1. Make a Long-Term Spending Decision

  • 1. Budget to Make Good Financial Decisions [1 min] URL
  • 2. Long-Term Spending Decisions [2 mins] URL
  • 3. Research and Collect Data [4 mins] URL
  • 4. Research Costs [4 mins] URL
  • 5. Add Rows and Duplicate Formulas [2 mins] URL
  • 6. Use Data to Inform a Decision [2 mins] URL
  • 7. Using Formulas to Inform Decisions [1 min] URL
• L2. Develop a Budget
  

  L2. Develop a Budget

  • 1. Develop a Budget [2 mins] URL
  • 2. Copy Data and Create a Summary Table [2 mins] URL
  • 3. Calculate Total Expenditures [3 mins] URL
  • 4. Categorize Expenditures [1 min] URL
  • 5. Label and Calculate Category Totals [5 mins] URL
  • 6. Use Data Validation to Make Your Spreadsheet More Reliable [2 mins] URL
  • 7. Visualize the Data and Make Decisions [2 mins] URL
  • 8. Develop a Budget Wrap Up [2 mins] URL
  • 8. Develop a Budget Wrap Up [2 mins] URL
• L3. Research Car Loans
  

  L3. Research Car Loans

  • 1. Introduction to Car Loans [3 mins] URL
  • 2. Loan Terms and APR [3 mins] URL
  • 3. Create a Loan Amounts Table [6 mins] URL
  • 4. Absolute Values and Currency Formatting [3 mins] URL
  • 5. Calculate Totals for Interest and Amount Paid [5 mins] URL
  • 6. Research Cars in Your Price Range [4 mins] URL
  • 7. Car Loans Wrap Up [1 min] URL
• L4. Plan a Vacation
  

  L4. Plan a Vacation

  • 1. Plan a Vacation [3 mins] URL
  • 2. Set Up Your Spreadsheet and Start Your Research [3 mins] URL
  • 3. Review of Formulas and Visuals [3 mins] URL
• L5. Create a Budget in Google Sheets Wrap Up
  

  L5. Create a Budget in Google Sheets Wrap Up

  • 1. Budgets: Life Has Many Financial Decisions [1 min] URL