In Excel, how do I calculate how much interest will be paid after 10, 20, 30 years on a loan?

Posted by admin on June 24, 2010 Leave a comment (1) Go to comments

I know how to create an amortization schedule to figure out the interest over the life of the loan, so that is NOT what I am looking for.

I am looking for a formula where I can specify the loan amount, payment amount, interest rate, and number of periods, and then have it tell me how much interest I will pay after a certain number of periods have gone by.
Thanks woody, that formula was exactly what I was looking for. Wish I could just pick the best answer now instead of waiting… I always forget to come back.

Try the function CUMIPMT

loan amortization schedule
Leave a comment

1 Comments.

  1. woody June 25, 2010 at 3:30 am

    Try the function CUMIPMT
    References :

Leave a Reply

Your email address will not be published. Required fields are marked *

*


You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>