Loan Amortization | Calculating Monthly Mortgage Payments Using PV of Annuity Formula

Поделиться
HTML-код
  • Опубликовано: 28 авг 2024
  • In this video, I walk students through a loan amortization problem which is somewhat more representative of real-world mortgage loans. Specifically, I give an example of a loan which calls for MONTHLY payments and when the APR is compounded monthly. I also show how answers change depending on whether the first payment is due at the END or BEGINNING of the loan.
    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.ed....
    Follow me on LinkedIn:
    / professorikram
    Follow me on Facebook:
    / ikramteaches
    Follow me on Instagram:
    / professorikram

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

  • @variablex6928
    @variablex6928 9 месяцев назад +1

    Extremely clear explanations.

  • @variablex6928
    @variablex6928 9 месяцев назад +1

    Your channel is under-watched. More students need to watch these videos for simple and clear explanations on what seems like a 'tough' topic.

    • @professorikram
      @professorikram  9 месяцев назад

      That's very kind of you to say. Thank you! Feel free to reach out to me if there are specific finance topics you'd like to see videos on.

  • @yongyanli9091
    @yongyanli9091 9 месяцев назад +2

    In the question, it said the mortgage rate is compounded monthly, so I think you miss the step of converting APR into EAR.

    • @professorikram
      @professorikram  9 месяцев назад +1

      Hi Yongyan. Be careful. You would Only convert the APR into an EAR if the payments were to be made annually. In this case, both the compounding and the payments are being done monthly, so there is no need to convert APR into EAR.

    • @yongyanli9091
      @yongyanli9091 9 месяцев назад

      I get it now :) Thank you for the explanation

  • @crispylemon
    @crispylemon 7 месяцев назад +1

    If I want to know how much I still owe at maybe Year 19, am I finding the present value?

    • @professorikram
      @professorikram  7 месяцев назад

      Yes that’s correct. You can figure out how many more months of the same payment are remaining, and calculate their present value. I have a separate video on “Balloon Payments” that explains that very idea and also shows how you can do that using Excel: ruclips.net/video/50qlXIezBLk/видео.htmlsi=pE7K1WlhJP1jSYPF