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

@tonyB1352 

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

image.png

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?