Loan Amortization Unit using Microsoft Excel


1 Rating
212 Downloads 827 Views Updated: Friday, July 15, 2016 - 1:33pm
Share with a friend

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


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