Teachers.Net
JoinLog in
Teachers.Net

My New House

By Robert Culp

  • Computer
  • Middle
Activity Time
3 hours of class time
Materials
Computer, Excel, Real Estate Brochures
Concepts / Topics
Choose a house and understand it's costs

Students choose a home from real estate brochures, use a spreadsheet to calculate housing costs and required hourly pay, and chart their expenses.

Anticipated Skill Set

  • Students will learn to open and save an Excel file and understand that Excel can add, subtract, multiply, divide, and chart numbers for them.
  • Students will learn that housing is expensive and identify some of its associated costs.
  • Students will establish monthly and yearly budgets and calculate the hourly rate of pay they must earn to maintain this standard of living.
  • Students will gain a greater understanding of the need for good earning potential and the education required.

Procedure

  1. Bring in a pile of free real estate brochures from different real estate agencies. Have friends and family in other locations collect brochures from across the United States, especially places like New York and California.
  2. Let students browse the brochures and choose their preferred home.
  3. Have students go to their computers and open MS Excel, VisiCalc, or Lotus.
  4. Have students enter the value of the home, then calculate the monthly housing costs.
  5. Show students how to use the PMT function or the simpler calculation below:

    Average payment = ((Loan * Interest / 12 / 2) + (Loan / 360 months))
  6. Calculate school tax as 2.2% × Loan.
  7. Calculate insurance as 0.4% × Loan.
  8. Calculate electricity as 0.1% × Loan.
  9. Calculate heat as 0.3% of Loan.
  10. Calculate upkeep as 0.3% of Loan. Once students have listed these numbers in the spreadsheet file, have them use the SUM function to total the monthly cost of housing.
  11. Label the column “Monthly Costs.”
  12. Label the next column “Yearly Costs.”
  13. Enter the formula (CELLx * 12) in the adjacent cell.
  14. Copy the formula down the column.
  15. Sum the yearly column.
  16. Divide the yearly total by 2,080 hours to arrive at an hourly cost for housing.
  17. Have students create a bar chart showing expenses and a pie chart showing the percentage of expenses.

Additional Spreadsheet Modules

The teacher can bring in automotive sales magazines and classified ads and have students add a vehicle, gas, repairs, and insurance to their budgets.

Additional line items, such as food, clothes, and CDs, can be added for a complete picture of how much life costs. The more realistic the example, the greater the hourly wage required.

An additional module can suggest a vocational model for earning the money required to support the student's standard of living.

Teachers.Net · https://teachers.net/lessons/2663.html