Amortization Schedule: Loan Repayment | Basic Intro | PV, PMT, BAL, PRN, INT

[@TheKarver21]

You make everything so easy. Thank you 😊

[@joshemman]

You’re welcome 😊

[@KeanneSMH]

Thank you so much! Cut the time by a significant portion compared to doing everything manually!😊

[@florencehungwe]

Well explained, thank you 🎉

[@SpoorthikaSpoo-uf5bx]

How To Calculate PMT In Using Normal Calculater Did U Explain It

[@JohnMark-ty8xq]

The 7.5 and 4 and 8000, did you multiply it?

[@joshemman]

No. They were not multiplied. The PMT function in Excel was used to obtain the periodic payment.

[@carlvincentlas-ay1617]

How did you compute the remaining numbers

[@joshemman]

@@carlvincentlas-ay1617 Excel automatically calculates them when you copy the formula to those cells.

[@bedanmacharia3344]

Why I'm i getting 2400 instead of 2388.54

[@joshemman]

Maybe your cell is formatted to round values. You can try typing the input on a different sheet.

[@lindahchisemphere9220]

Thank you

[@lightningkamagong8028]

thank you very much!