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

[@joseantoniosotovaldez7073]

Man, you have saved me, thank you. Clear as crystal !

[@4116mari]

Wow thank you so much!! I’m more of a visual learner and this helps so much!!!

[@ExplorewithBindra]

great videos

[@Delightful-diary]

love it. easy to understand.

[@PriyaSingh-zw4oe]

You nailed it bro!

[@walidamin1035]

Thank you very much sir❤️

[@tycrooms5905]

Do you have a downloadable spreadsheet?

[@professorikram]

Hi Ty! No, unfortunately not. But good idea, I'll start keeping those from now on.

[@d-will5159]

@@professorikram did you upload the downloadable version?

[@VividImageryPro]

What if they make large payments in between?

[@professorikram]

I recommend that you make an additional column, "Additional Principal paid", right next to "Principal Paid". In this column you can enter the additional payments being made towards the principal in between. In this case, the "Loan Balance" at the benginning of every month will get reduced by the SUM of "Principal Paid" and "Additional Principal Paid".

[@VividImageryPro]

@@professorikram will that affect the other formulas at all?

[@professorikram]

@@VividImageryPro You are right, it will. Specifically, the amount going towards principal and interest each month will change. Give me some time, I'll share a Google Sheet with you that can help you with that.

[@VividImageryPro]

@@professorikram that would be amazing!!!

[@shellychampagne8055]

Thank you for the detailed presentation that was very easy to understand !!I have a question regarding paying down the principal early as it relates to a true balloon payment. Can I message you? It's a 3 year Balloon I'm thinking that if I pay additional payments to the principal ahead of time it reduces the balloon payment at the end. Am I thinking about that correctly?