Need mathematical equivalent of this excel formula PMT() [duplicate]
This question already has an answer here:
What would be the the mathematical equivalent of this excel formula? =PMT()
1 answer
I need help with the math equivalent for excel formula PMT(). There is an answer @ below thread... BUT nothing is mentioned with regards to the option parameters of PMT() i.e. FV and Type. Can anyone please guide with math equivalent with FV?
What would be the the mathematical equivalent of this excel formula? =PMT()
microsoft-excel worksheet-function
asked Dec 20 '18 at 6:37
Usman Saleem
42
marked as duplicate by Rajesh S, PeterH, n8te, Dave M, music2myear Dec 25 '18 at 0:18
This question has been asked before and already has an answer. If those answers do not fully address your question, please ask a new question.
add a comment |
This question already has an answer here:
What would be the the mathematical equivalent of this excel formula? =PMT()
1 answer
I need help with the math equivalent for excel formula PMT(). There is an answer @ below thread... BUT nothing is mentioned with regards to the option parameters of PMT() i.e. FV and Type. Can anyone please guide with math equivalent with FV?
What would be the the mathematical equivalent of this excel formula? =PMT()
microsoft-excel worksheet-function
asked Dec 20 '18 at 6:37
Usman Saleem
42
marked as duplicate by Rajesh S, PeterH, n8te, Dave M, music2myear Dec 25 '18 at 0:18
This question has been asked before and already has an answer. If those answers do not fully address your question, please ask a new question.
It is not a duplication. Its an extension question which is not answered in that post. Please read question FULLY before commenting.I am a new member and webpage is not allowing me to post comment on that existing question.
– Usman Saleem
Dec 20 '18 at 7:15
This kind of question seem to better suited for financially literate community rather than computer enthusiasts.. || Just in case it had been answered the OP should share the answer here or optionally close it. Good luck. ( :
– p._phidot_
Dec 20 '18 at 11:22
This is actually for an IT project; need to develop a solution equivalent to Excel's PMT ()
– Usman Saleem
Dec 20 '18 at 11:55
I have figured it out... posting here to help others: PMT = r / ((1 + r)^N - 1) * (pv * (1 + r)^N - fv) r = Annual Interest rate/100/ Total Number of payments in whole term N = Total number of payments in whole term PV = Loan Amount FV = future Value/Residual Value
– Usman Saleem
Dec 20 '18 at 12:51
add a comment |
This question already has an answer here:
What would be the the mathematical equivalent of this excel formula? =PMT()
1 answer
I need help with the math equivalent for excel formula PMT(). There is an answer @ below thread... BUT nothing is mentioned with regards to the option parameters of PMT() i.e. FV and Type. Can anyone please guide with math equivalent with FV?
What would be the the mathematical equivalent of this excel formula? =PMT()
microsoft-excel worksheet-function
asked Dec 20 '18 at 6:37
Usman Saleem
42
This question already has an answer here:
What would be the the mathematical equivalent of this excel formula? =PMT()
1 answer
I need help with the math equivalent for excel formula PMT(). There is an answer @ below thread... BUT nothing is mentioned with regards to the option parameters of PMT() i.e. FV and Type. Can anyone please guide with math equivalent with FV?
What would be the the mathematical equivalent of this excel formula? =PMT()
This question already has an answer here:
What would be the the mathematical equivalent of this excel formula? =PMT()
1 answer
microsoft-excel worksheet-function
microsoft-excel worksheet-function
asked Dec 20 '18 at 6:37
Usman Saleem
42
asked Dec 20 '18 at 6:37
Usman Saleem
42
edited Dec 20 '18 at 12:55
asked Dec 20 '18 at 6:37
Usman Saleem
42
asked Dec 20 '18 at 6:37
Usman Saleem
42
asked Dec 20 '18 at 6:37
Usman Saleem
42
42
marked as duplicate by Rajesh S, PeterH, n8te, Dave M, music2myear Dec 25 '18 at 0:18
This question has been asked before and already has an answer. If those answers do not fully address your question, please ask a new question.
marked as duplicate by Rajesh S, PeterH, n8te, Dave M, music2myear Dec 25 '18 at 0:18
This question has been asked before and already has an answer. If those answers do not fully address your question, please ask a new question.
It is not a duplication. Its an extension question which is not answered in that post. Please read question FULLY before commenting.I am a new member and webpage is not allowing me to post comment on that existing question.
– Usman Saleem
Dec 20 '18 at 7:15
This kind of question seem to better suited for financially literate community rather than computer enthusiasts.. || Just in case it had been answered the OP should share the answer here or optionally close it. Good luck. ( :
– p._phidot_
Dec 20 '18 at 11:22
This is actually for an IT project; need to develop a solution equivalent to Excel's PMT ()
– Usman Saleem
Dec 20 '18 at 11:55
I have figured it out... posting here to help others: PMT = r / ((1 + r)^N - 1) * (pv * (1 + r)^N - fv) r = Annual Interest rate/100/ Total Number of payments in whole term N = Total number of payments in whole term PV = Loan Amount FV = future Value/Residual Value
– Usman Saleem
Dec 20 '18 at 12:51
add a comment |
It is not a duplication. Its an extension question which is not answered in that post. Please read question FULLY before commenting.I am a new member and webpage is not allowing me to post comment on that existing question.
– Usman Saleem
Dec 20 '18 at 7:15
This kind of question seem to better suited for financially literate community rather than computer enthusiasts.. || Just in case it had been answered the OP should share the answer here or optionally close it. Good luck. ( :
– p._phidot_
Dec 20 '18 at 11:22
This is actually for an IT project; need to develop a solution equivalent to Excel's PMT ()
– Usman Saleem
Dec 20 '18 at 11:55
I have figured it out... posting here to help others: PMT = r / ((1 + r)^N - 1) * (pv * (1 + r)^N - fv) r = Annual Interest rate/100/ Total Number of payments in whole term N = Total number of payments in whole term PV = Loan Amount FV = future Value/Residual Value
– Usman Saleem
Dec 20 '18 at 12:51
It is not a duplication. Its an extension question which is not answered in that post. Please read question FULLY before commenting.I am a new member and webpage is not allowing me to post comment on that existing question.
– Usman Saleem
Dec 20 '18 at 7:15
It is not a duplication. Its an extension question which is not answered in that post. Please read question FULLY before commenting.I am a new member and webpage is not allowing me to post comment on that existing question.
– Usman Saleem
Dec 20 '18 at 7:15
This kind of question seem to better suited for financially literate community rather than computer enthusiasts.. || Just in case it had been answered the OP should share the answer here or optionally close it. Good luck. ( :
– p._phidot_
Dec 20 '18 at 11:22
This kind of question seem to better suited for financially literate community rather than computer enthusiasts.. || Just in case it had been answered the OP should share the answer here or optionally close it. Good luck. ( :
– p._phidot_
Dec 20 '18 at 11:22
This is actually for an IT project; need to develop a solution equivalent to Excel's PMT ()
– Usman Saleem
Dec 20 '18 at 11:55
This is actually for an IT project; need to develop a solution equivalent to Excel's PMT ()
– Usman Saleem
Dec 20 '18 at 11:55
I have figured it out... posting here to help others: PMT = r / ((1 + r)^N - 1) * (pv * (1 + r)^N - fv) r = Annual Interest rate/100/ Total Number of payments in whole term N = Total number of payments in whole term PV = Loan Amount FV = future Value/Residual Value
– Usman Saleem
Dec 20 '18 at 12:51
I have figured it out... posting here to help others: PMT = r / ((1 + r)^N - 1) * (pv * (1 + r)^N - fv) r = Annual Interest rate/100/ Total Number of payments in whole term N = Total number of payments in whole term PV = Loan Amount FV = future Value/Residual Value
– Usman Saleem
Dec 20 '18 at 12:51
add a comment |
1 Answer
1
active
oldest
votes
I have figured it out... here is how FV or Residual Value (RV) will be added to the mix...
P = r / ((1 + r)^N - 1) * (pv * (1 + r)^N - fv)
- P = Monthly Payment
- PV = Present Value (starting value of the loan)
- APR = Annual Percentage Rate
- r = Periodic Interest Rate = APR/number of interest periods per year
- N = Total number of interest periods (interest periods per year * number of years)
edited Dec 23 '18 at 21:49
MarianD
1,4231518
answered Dec 20 '18 at 12:56
Usman Saleem
42
add a comment |
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
I have figured it out... here is how FV or Residual Value (RV) will be added to the mix...
P = r / ((1 + r)^N - 1) * (pv * (1 + r)^N - fv)
- P = Monthly Payment
- PV = Present Value (starting value of the loan)
- APR = Annual Percentage Rate
- r = Periodic Interest Rate = APR/number of interest periods per year
- N = Total number of interest periods (interest periods per year * number of years)
edited Dec 23 '18 at 21:49
MarianD
1,4231518
answered Dec 20 '18 at 12:56
Usman Saleem
42
add a comment |
I have figured it out... here is how FV or Residual Value (RV) will be added to the mix...
P = r / ((1 + r)^N - 1) * (pv * (1 + r)^N - fv)
- P = Monthly Payment
- PV = Present Value (starting value of the loan)
- APR = Annual Percentage Rate
- r = Periodic Interest Rate = APR/number of interest periods per year
- N = Total number of interest periods (interest periods per year * number of years)
edited Dec 23 '18 at 21:49
MarianD
1,4231518
answered Dec 20 '18 at 12:56
Usman Saleem
42
add a comment |
I have figured it out... here is how FV or Residual Value (RV) will be added to the mix...
P = r / ((1 + r)^N - 1) * (pv * (1 + r)^N - fv)
- P = Monthly Payment
- PV = Present Value (starting value of the loan)
- APR = Annual Percentage Rate
- r = Periodic Interest Rate = APR/number of interest periods per year
- N = Total number of interest periods (interest periods per year * number of years)
edited Dec 23 '18 at 21:49
MarianD
1,4231518
answered Dec 20 '18 at 12:56
Usman Saleem
42
I have figured it out... here is how FV or Residual Value (RV) will be added to the mix...
P = r / ((1 + r)^N - 1) * (pv * (1 + r)^N - fv)
- P = Monthly Payment
- PV = Present Value (starting value of the loan)
- APR = Annual Percentage Rate
- r = Periodic Interest Rate = APR/number of interest periods per year
- N = Total number of interest periods (interest periods per year * number of years)
edited Dec 23 '18 at 21:49
MarianD
1,4231518
answered Dec 20 '18 at 12:56
Usman Saleem
42
edited Dec 23 '18 at 21:49
MarianD
1,4231518
edited Dec 23 '18 at 21:49
MarianD
1,4231518
edited Dec 23 '18 at 21:49
MarianD
1,4231518
1,4231518
answered Dec 20 '18 at 12:56
Usman Saleem
42
answered Dec 20 '18 at 12:56
Usman Saleem
42
answered Dec 20 '18 at 12:56
Usman Saleem
42
42
add a comment |
add a comment |
It is not a duplication. Its an extension question which is not answered in that post. Please read question FULLY before commenting.I am a new member and webpage is not allowing me to post comment on that existing question.
– Usman Saleem
Dec 20 '18 at 7:15
This kind of question seem to better suited for financially literate community rather than computer enthusiasts.. || Just in case it had been answered the OP should share the answer here or optionally close it. Good luck. ( :
– p._phidot_
Dec 20 '18 at 11:22
This is actually for an IT project; need to develop a solution equivalent to Excel's PMT ()
– Usman Saleem
Dec 20 '18 at 11:55
I have figured it out... posting here to help others: PMT = r / ((1 + r)^N - 1) * (pv * (1 + r)^N - fv) r = Annual Interest rate/100/ Total Number of payments in whole term N = Total number of payments in whole term PV = Loan Amount FV = future Value/Residual Value
– Usman Saleem
Dec 20 '18 at 12:51