Key Takeaways: Use Excel to get a handle on your mortgage or loan by determining your monthly payment, your interest rate, and your loan schedule.

Microsoft Excel allows you to either create a spreadsheet from scratch with your own formulas or use a premade template provided by Microsoft. Microsoft has provided a template for loan amortization ...