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

Latham, NY

#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

Fullerton, CA

#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

Fullerton, CA

#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

Add your comments below

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
News This 13-year old owns his own house -- all 89-s... (Sep '17) Sep '17 C Hoxton 1
News 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
News Dubuque's first mosque opens (Dec '16) Dec '16 Old Pom 11
Would anyone like to see me? (Sep '13) Dec '16 veiny 8
News Parents complain about book used in Dubuque sch... (Nov '16) Nov '16 BAH 1

Dubuque Jobs

Personal Finance

Dubuque Mortgages