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