worksheet function - What would be the the mathematical equivalent of this excel formula? =PMT()

Thursday 1 March 2018

worksheet function - What would be the the mathematical equivalent of this excel formula? =PMT()

I need to create a JavaScript form that does the same calculation as this =PMT() function.

mortgage = 220000
rate= 4.75%
term = 30

The example formula I have is =PMT(4.75%/12,30*12,220000*-1)

What would be the equation for this function? I tried to look up this function but it doesn't explain it very well.

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)