.
Loan Amortization Unit using Microsoft Excel
lesson
267 Downloads
1.0 (1 Review)
beta
EdBrAIn It
EdBrAIn uses AI to customize lesson resources for your students’ needs.

Loan Amortization Unit using Microsoft Excel

Share

Share On Facebook
Share On Twitter
Share On Pinterest
Share On LinkedIn
Share On Microsoft Teams
Email
    • math student
    • Preview of Loans_and_Percentage_Rates_–_Practice_Sheet.docx - page 1
    • Preview of Loan_Table_Fill-In.xlsx - page 1
    • Preview of Loan_Payments_in_Excel_–_Review.docx - page 1
    • Preview of Loan_Payments_in_Excel_–_Quiz_A_2013-14.docx - page 1
    • Preview of Monthly_Loan_Payments_for_Buying_a_Car.docx - page 1
    • Preview of The_Devil_and_Daniel_Webster.docx - page 1
    • Preview of Creating_a_Loan_Amortization_Calculator_in_Microsoft_Excel.docx - page 1
    • Preview of Monthly_Loan_Payments_–_Sample.docx - page 1
    • Preview of loan_calculator_v2.xlsx - page 1
      Subject Math — Algebra, Mathematical Functions
      Grade Level Grades 9-12
      Resource Type Activity, Assessment, Handout, Worksheet
      License

      About This Lesson

      I use this unit as part of an Alg2 course. The objective is for students to construct formulas and to get an intuitive sense of how loans work.
      Day 1 - Discuss loans and credit cards (do Loans and Percentage Rates - Practice Sheet)
      Day 2 - Review practice sheet, do Loan Table Fill-In for a couple sample problems
      Day 3 - In lab, using tutorial on how to create the loan amortization calculator.
      Day 4 - Continuing day 3, answer questions at the end
      Day 5 - Loan Payments in Excel Review (prep for quiz)
      Day 6 - Quiz
      Additional Activities: Buying a Car, Daniel Webster

      Resources

      Files

      beta
      EdBrAIn uses AI to customize lesson resources for your students’ needs.

      Loans_and_Percentage_Rates_–_Practice_Sheet.docx

      Activity
      February 13, 2020
      96.58 KB
      Log in to Download
      beta
      EdBrAIn uses AI to customize lesson resources for your students’ needs.

      Loan_Table_Fill-In.xlsx

      Handout, Worksheet
      February 13, 2020
      35.66 KB
      Log in to Download
      beta
      EdBrAIn uses AI to customize lesson resources for your students’ needs.

      Loan_Payments_in_Excel_–_Review.docx

      Activity
      February 13, 2020
      133.82 KB
      Log in to Download
      beta
      EdBrAIn uses AI to customize lesson resources for your students’ needs.

      Loan_Payments_in_Excel_–_Quiz_A_2013-14.docx

      Assessment
      February 13, 2020
      125.23 KB
      Log in to Download
      beta
      EdBrAIn uses AI to customize lesson resources for your students’ needs.

      Monthly_Loan_Payments_for_Buying_a_Car.docx

      Activity
      February 13, 2020
      73.58 KB
      Log in to Download
      beta
      EdBrAIn uses AI to customize lesson resources for your students’ needs.

      The_Devil_and_Daniel_Webster.docx

      Activity
      February 13, 2020
      76.73 KB
      Log in to Download
      beta
      EdBrAIn uses AI to customize lesson resources for your students’ needs.

      Creating_a_Loan_Amortization_Calculator_in_Microsoft_Excel.docx

      February 13, 2020
      156.64 KB
      Log in to Download
      beta
      EdBrAIn uses AI to customize lesson resources for your students’ needs.

      Monthly_Loan_Payments_–_Sample.docx

      February 13, 2020
      649.21 KB
      Log in to Download
      beta
      EdBrAIn uses AI to customize lesson resources for your students’ needs.

      loan_calculator_v2.xlsx

      February 13, 2020
      92.78 KB
      Log in to Download

      Reviews

      1.0
      1 Reviews
      gwamer1
      gwamer1 December 07, 2013

      Not useful only because it is not Common Core. Good for Business math class.

      Advertisement