• Sections
What is the formula to calculate a PM...

# What is the formula to calculate a PMT when all youhave is PV, i and n (Present

Posted in the Dubuque Forum

rannanxy526
#1 Sep 26, 2013
What is the formula to calculate a PMT when all youhave is PV, i and n (Present Value, Interest Rate, Paymnt #?
-
I need to calculate by hand a PMT, with excel i only use the PMT function and it works, but now i need the formula to calculate it when i only have PV, i(interest), n(number of payments). As it is right now i cant even calculate the FV, but in reality what I need is PMT, not FV per se.

Thanks.
xapa
#2 Oct 22, 2013
What is the formula to calculate a PMT when all youhave is PV, i and n (Present Value, Interest Rate, Paymnt #?I need to calculate by hand a PMT, with excel i only use the PMT function and it works, but now i need the formula to calculate it when i only have PV, i(interest), n(number of payments). As it is right now i cant even calculate the FV, but in reality what I need is PMT, not FV per se.

Thanks.
ajed
#3 Oct 22, 2013
xapa wrote:
What is the formula to calculate a PMT when all youhave is PV, i and n (Present Value, Interest Rate, Paymnt #?I need to calculate by hand a PMT, with excel i only use the PMT function and it works, but now i need the formula to calculate it when i only have PV, i(interest), n(number of payments). As it is right now i cant even calculate the FV, but in reality what I need is PMT, not FV per se.

Thanks..
You can find the best solutions for you at:-hxxp://WWW.ANNUITY-HELP.US

#### Tell me when this thread is updated:

Subscribe Now Add to my Tracker

Characters left: 4000

Please note by submitting this form you acknowledge that you have read the Terms of Service and the comment you are posting is in compliance with such terms. Be polite. Inappropriate posts may be removed by the moderator. Send us your feedback.

### Dubuque Discussions

Title Updated Last By Comments
This 13-year old owns his own house -- all 89-s... (Sep '17) Sep '17 C Hoxton 1
Iowa woman found guilty of stealing from elderl... (Apr '17) Apr '17 Randy 1
Dubuque Women's March (Jan '17) Mar '17 Mike Smith 3
Katrina Althaus? (Jan '17) Jan '17 Curious 1
Dubuque's first mosque opens (Dec '16) Dec '16 Old Pom 11
Would anyone like to see me? (Sep '13) Dec '16 veiny 8
Parents complain about book used in Dubuque sch... (Nov '16) Nov '16 BAH 1