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 auto-loan.
Google Sheet: 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 (wpcarey.asu.edu/people/profil....
Follow me on LinkedIn:
/ professorikram
Follow me on Facebook:
/ ikramteaches
Follow me on Instagram:
/ professorikram
Негізгі бет Loan Amortization: Calculating Mortgage Payments and Balloon Payments (Using Excel)
Пікірлер: 15