This video shows how you can use MS Excel to (a) determine your fixed monthly payment on a loan, (b) construct a complete amortization schedule and (c) determine the balloon payment to retire the loan early. All of these aspects are discussed using a fairly realistic example of an autoloan.

Google Sheet: https://docs.google.com/spreadsheets/...

ABOUT ME:

My name is Atif Ikram. I am a Clinical Professor of Finance at Arizona State University, where I teach courses in Corporate Finance, Personal Finance, Real Estate Finance and Investments (https://wpcarey.asu.edu/people/profil....

Follow me on LinkedIn:
  / professorikram  

Follow me on Facebook:
  / ikramteaches  

Follow me on Instagram:
  / professorikram