Forum Discussion

tonyB1352's avatar
tonyB1352
Copper Contributor
Feb 07, 2021

Table of mortgage payments

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

4 Replies

  • laurenttrevino's avatar
    laurenttrevino
    Copper Contributor

    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 https://Essexmoneyman.com. They offer expert advice on mortgages and can help you find the best deal for your situation. Good luck with creating your table.

  • tonyB1352's avatar
    tonyB1352
    Copper Contributor

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

     

    Thank you for help

    • mathetes's avatar
      mathetes
      Gold Contributor
      any template worth its salt would have provision for different schedules. Did you check the templates that are available?
  • SergeiBaklan's avatar
    SergeiBaklan
    Diamond Contributor

    tonyB1352 

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