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

[@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

[@PriyaSingh-zw4oe]

You nailed it bro!

[@Delightful-diary]

love it. easy to understand.

[@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?