How to Calculate Monthly Payments in Excel with PMT Function

[@danteencinas7020]

Thank you for the excellent & concise explanation!

[@rickbolner8909]

Good job: quick, informative, even covered some theory--"shows up negative because it's shown as a cash outflow. . , something like that. thanks,

[@PrintSales]

Excellent explanation, Thank You.

[@ExcelU]

Glad you liked it

[@josealvesferreira1683]

Very good, congratulations.

[@ExcelU]

Thanks!

[@draincel]

EXCELLENT

[@MutualFundsFunda]

nice

[@mohdrahmatmohdnoordin1736]

i hv a questions... if loan amount is 10k, annual int is 4%, tenure 5 yrs... montly should be 200... why pmt value is 184.xx is the formula wrong...

[@arshadhkabeer]

The PMT is calculating the period with 30 days per month, which is 360 days per year, I think this is the problem, there should be a solution for this, let me know if you have any.

[@shayalsharma677]

wow, you have really helped me in one of my assignments, thank you sir

[@robertross3188]

What about if your starting off with a loan that already has accumulated unpaid interest? How do you calculate the monthly payment without the added interest affecting the rate that is only charged based on the principal and not the principal + interest?

[@TheShayre]

Awesome!!