Hey guys, Any chance of being pointed in the right direction to find the PMT function in excel? This is the function that calculates payments for debt repayment. I want to write something that will show your payments needed in order to have your credit cards paid off in 1, 3, 5, 7 & 10 years. So I'm a bum because I really don't feel like cracking open the equation and writing this from scratch. Can you look past that and give me some resources, or hopefully some prebuilt functions, that can do this. Thanks in advance
yes, well, that's a video explaining how to set it up in excel. I'm looking for a pmt function in php so that I can make a web site do this ... not excel
Hey mate! Sounds like you're looking for the excel payment function to implement into a site? I found this, hope it helps. payment per period = P* i*(1+i)^n/((1+i)^n-1) where i is the interest per period (20%/12) n is the number of periods P is the original principal
Hey boss! Good seeing you around. I think I can reverse engineer what I need out of that. Thanks for finding that for me. Since it's for credit card debt I'm going to have a bitch of a time getting everything working because the interest rates may vary depending on whether it's interest on cash advance, balance transfer or regular transaction. ... you gave me exactly what I was looking for. +1 Sending PM to catch up