Table of mortgage payments

New Contributor

Would like to create a table showing payments on Interest's and capital payment for a loan or mortgage

3 Replies


In your Excel click File->New, type mortgage, Enter. You will see few templates, perhaps one of them meet your needs.


I was not clear. I want to be able to find an amortization table with bi-weekly payment @tonyB1352 


Thank you for help

any template worth its salt would have provision for different schedules. Did you check the templates that are available?