Mortgage Calculator

Find out Excel 2010 – “Variable Charge Bank loan Payment”: Podcast #1438





“I was in Milwaukee this 7 days at the IIA Regional Convention when Heidi requested me about calculating a financial loan payment for a financial loan, with variable curiosity premiums.” Knowing that “PMT” can make this effortless for a set fee, in modern podcast, Episode #1438, Invoice reveals us how to use Aim Seek to back again into this answer.

4 comments

  1. Hi, great tutorial. Aren't the payments supposed to change as well when the rate changes? They will not stay consistent throughout the life of the loan. How would you show that in this particular scenario? Thank you

    Reply
  2. I am trying to figure out how to calculate student loan payments in excel. With payments being made on the monthly or biweekly bases. 

    Reply
  3. You helped me with my homework! You are the best!

    Reply
  4. thanks for teaching! this is just too amazing

    Reply

Leave a Reply