Скачать с ютуб Loan Amortization: Calculating Mortgage Payments and Balloon Payments (Using Excel) в хорошем качестве

Loan Amortization: Calculating Mortgage Payments and Balloon Payments (Using Excel)

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: 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