Fixed Payment Mortgage Amortization Schedule - Video Tutorial - Beginning Excel

This is an Excel tutorial for my Acct 232B course that teaches students how to use Excel to build a Fixed Payment Amortization schedule. Students are required to watch this video and practice developing it. They are then required to take an exam in which they are challenged to recreate this schedule in Excel, in 30 minutes or less, without referring to any notes. Therefore, this tutorial has three objectives 1) teach beginning students how to use various built-in Excel functions 2) teach students how to work efficiently with Excel 3) teach students how to build a fixed payment amortization schedule.

Category:

Education

Tags:

• Excel
• 2007
• Mortgage
• Calculator
• Fixed
• Payment
• Amortization
• Schedule
• =pmt()
• function
• home
• purchase

[BYUHawaii]

@fadioq

Your are welcome. I hope it helped you understand loans and Excel better.

[fadioq]

THNX