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

No video

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

Рет қаралды 1,461

Күн бұрын

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 9 ай бұрын

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

@variablex6928 9 ай бұрын

Extremely clear explanations.

@yongyanli9091 9 ай бұрын

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

@professorikram 9 ай бұрын

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 9 ай бұрын

I get it now :) Thank you for the explanation

@crispylemon 7 ай бұрын

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

@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: kzfaq.info/get/bejne/a5ahn7t6yuCmfJ8.htmlsi=pE7K1WlhJP1jSYPF