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

Поделиться
HTML-код
  • Опубликовано: 11 окт 2024

Комментарии • 15

  • @ExplorewithBindra
    @ExplorewithBindra Год назад +1

    great videos

  • @joseantoniosotovaldez7073
    @joseantoniosotovaldez7073 2 года назад +1

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

  • @4116mari
    @4116mari 2 года назад +1

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

  • @PriyaSingh-zw4oe
    @PriyaSingh-zw4oe 3 года назад +1

    You nailed it bro!

  • @Delightful-diary
    @Delightful-diary 3 года назад +1

    love it. easy to understand.

  • @walidamin1035
    @walidamin1035 3 года назад +1

    Thank you very much sir❤️

  • @tycrooms5905
    @tycrooms5905 3 года назад

    Do you have a downloadable spreadsheet?

    • @professorikram
      @professorikram  3 года назад

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

    • @d-will5159
      @d-will5159 Год назад +1

      @@professorikram did you upload the downloadable version?

  • @VividImageryPro
    @VividImageryPro Год назад

    What if they make large payments in between?

    • @professorikram
      @professorikram  Год назад +1

      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
      @VividImageryPro Год назад

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

    • @professorikram
      @professorikram  Год назад +1

      @@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
      @VividImageryPro Год назад

      @@professorikram that would be amazing!!!

    • @shellychampagne8055
      @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?