Table of mortgage payments

Copper Contributor

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

4 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?

Creating a table for mortgage payments is a great idea. It can help you understand how much you'll be paying over time and how much of it will go towards interest versus the principal amount. If you're not sure how to get started, it might be helpful to talk to a financial advisor or mortgage specialist. They can provide guidance and help you make sense of the numbers. In fact, you might want to check out Mortgage Advice Essex. They offer expert advice on mortgages and can help you find the best deal for your situation. Good luck with creating your table.