Is there a template in Excel for an amortization table? I would like to calculate my mortgage but I am hoping I don’t have to build a table myself – I am not that good with Excel:(
2 Comment(s)
Depending what Windows program you are currently running. I have Windows XP and there are quite a few different templates in amortization that may help you out with your problem.
You can check out my amortization schedule tutorial (see source list below). There is an Excel file that you can download. Just change the numbers.
Keep in mind that an amortization table only deals with the loan itself. Typically, your total payment will be higher because of the monthly insurance and property tax escrow payments.
Depending what Windows program you are currently running. I have Windows XP and there are quite a few different templates in amortization that may help you out with your problem.
Lady Chae` | Sep 21, 2009 | Reply
You can check out my amortization schedule tutorial (see source list below). There is an Excel file that you can download. Just change the numbers.
Keep in mind that an amortization table only deals with the loan itself. Typically, your total payment will be higher because of the monthly insurance and property tax escrow payments.
Tim
Tim | Sep 25, 2009 | Reply