Help with Monthly Payment Amount formula

  • Resolved coobye

    (@coobye)


    8 years, 2 months ago

    Hello,

    I’m confused with a common formula to calculate the Monthly Payment Amount.

    Here is my formula who works in Excel :

    – Loan Amount : 174200 € 
    – Annual Interest Rate(%) : 4%
    – Term: 300 months

    (174200*((4/100)/12))/(1-(1+((4/100)/12))^(-300))

    Good result is 919.4918

    With CFF i got -1.935555555555556 I don’t understand …

    Can someone help me please. Thanks

    https://wordpress.org/plugins/calculated-fields-form/

Viewing 2 replies - 1 through 2 (of 2 total)
Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘Help with Monthly Payment Amount formula’ is closed to new replies.