Abstract
This paper presents an Excel-based learning exercise to build amortization tables with mortgage prepayments. Periodic and one-time prepayments are considered. Students analyze how the application of prepayments changes the cost and term of a mortgage. Essential financial literacy and spreadsheet skills that are highly valued by households and employers are demonstrated in this exercise.
Recommended Citation
(2024)
"Amortization Tables with Loan Prepayments,"
Journal of Economics and Finance Education: Vol. 23:
Iss.
2, Article 3.
Available at:
https://scholarship.rollins.edu/jefe/vol23/iss2/3
