Capital calculation with exponentials

  • Resolved kronos1337

    (@kronos1337)


    7 years, 2 months ago

    Hi, I want to calculate the capital after x years.
    I have following parameters, that the user have to type in:

    1. Start capital (e.g. 1000€)
    2. Investment period in years (e.g. 10 years)
    3. Interest (e.g. 5%).

    The formular would be: End capital = Start capital*(1+interest/100)^Investment period in years or fieldname1*(1+fieldname2/100)^fieldname3

    The exponent doesn´t seem to work this way. How can I use it correctly?

Viewing 2 replies - 1 through 2 (of 2 total)
  • Plugin Author codepeople

    (@codepeople)

    7 years, 2 months ago

    Hello @kronos1337,

    The exponent corresponds to the “POW” operation. For example, the operation: 3^2 would be representes as: POW(3,2)

    So the equation would be:

    
fieldname1*POW((1+fieldname2/100),fieldname3)

    Best regards.

    Thread Starter kronos1337

    (@kronos1337)

    7 years, 2 months ago

    wow, that was fast, thank you!

Viewing 2 replies - 1 through 2 (of 2 total)

The topic ‘Capital calculation with exponentials’ is closed to new replies.