Calculate Payments and Interest with Excel

About this tutorial:

Video duration: 3:57
This useful tutorial from shows you how to calculate payments and interest rates when making a large purchase such as a home or car. Know how much you can afford before you shop.

| Online Employee Training Platform. KnowledgeCity offers 10,000+ online video tutorials in Business, Computer, Safety, and Banking.

Subscribe to our YouTube Channel:
Check our Blog:

Follow KnowledgeCity on Social Media Channels!

Post Author:

Apple lover, ICT and LEAN consultant, MS Office lecturer My other website with video tutorials - Tutorials, guides and news for iPhones and iPads

13 thoughts on “Calculate Payments and Interest with Excel

    The Casual Gamer

    (January 13, 2019 - 5:47 am)

    volume is quite low


    (January 13, 2019 - 5:47 am)

    This video is so helpfull that is has 200,000 views but somehow not enough because it has only 150 likes and 13 comments on it. Here's a 14th. Have a good day and a like.

    Agha Muzahir Hussain, CICP

    (January 13, 2019 - 5:47 am)

    is it on reducing balance or on fixed interest rate


    (January 13, 2019 - 5:47 am)

    Thank you, very useful!

    Kuldeep Garg

    (January 13, 2019 - 5:47 am)

    I want business ledger intrest formula mandi type

    Pathetic CodeVideos

    (January 13, 2019 - 5:47 am)

    Thanks a lot. Not many videos explained about monthly interest payments and thats what I was looking for.

    abdulwaduud ahmed

    (January 13, 2019 - 5:47 am)

    u amiable person. you help me alot from new house. I wasn't born USA but how things when buying a house.

    Atche Dai

    (January 13, 2019 - 5:47 am)

    I can't hear a shit!

    Aaron Elzy

    (January 13, 2019 - 5:47 am)

    Voice volume is a little quiet but this helped me immensely, thanks.


    (January 13, 2019 - 5:47 am)

    Thanks bud, really cleared it up for me. I have a test on this next week and this was the only thing I had doubts on. 

    Bilal Baasit

    (January 13, 2019 - 5:47 am)

    it's B3 🙂


    (January 13, 2019 - 5:47 am)

    for the first 2 seconds i thought you were jerry seinfeld

    pey chin hwee

    (January 13, 2019 - 5:47 am)

    how to calculate this?
    Let say I save/input $400 every month for 3 years in a bank, the annual interest rate is 33%.
    Then how much will I get back by the end of 3rd year??

    Total principal input = 400 x 12 = 14400

Leave a Reply

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