Monthly Calculator

  • Resolved yoga21

    (@yogeekeye)


    4 years, 9 months ago

    I really need a help as trying to build a calculator from last 5 days unable to do so , i have able to made the calculator for Compound on yearly basis below is the formula and it works great,
    fieldname2*POW(1+fieldname3/fieldname6/12,fieldname6/12*fieldname4)

    but the problem is i want it tell users if someone has invested X amount on monthly basis for a certain period at particular interest rate what would be the Final amount(compounded)

    this is the formula i am trying to make my calculator
    FV = P * ( R * ( 1+i )n -1 ) * ( 1 + i )
    i
    FV = Future Value

    P = Monthly amount invested

    i = compounded rate of return

    As the returns are compounded for every investment instalment, monthly money will be compounded as: i/12.

    Similarly, daily daily will be compounded as i/365.

    For instance, your monthly investment amount is Rs 10,000 for a tenure of 24 months. You expect 10% annual rate of return. Then the future value would be calculated as below:

    Here, P= 10000

    i = 10% = (10/100)/12 = 1/120

    N= 12 months

    FV = 10000 * ( ( 1+1/120)12 -1 )* ( 1 + 1/120 )1/120

    Therefore, for the total investment of 1,20,000; amount at the end of the tenure will be Rs 13,20,000

    Please if you can help in this, Thanks in advance

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

    (@codepeople)

    Hello @yogeekeye

    The future value is an operation included into the “Financial Operations” module, distributed with the Developer and Platinum versions of the plugin:

    https://cff.dwbooster.com/documentation#financial-module

    You can play with this operation visiting the online demo:

    Public website:

    https://demos.dwbooster.com/calculated-fields-form/

    WordPress website:

    https://demos.dwbooster.com/calculated-fields-form/wp-login.php

    Best regards.

    Thread Starter yoga21

    (@yogeekeye)

    I tried a lot but there seems to be some problem, if you can see and guide, it would be much appreciated
    (fieldname2*(1-(1+(fieldname3/100)/12)POW(fieldname4*-12)))/((fieldname3/100)/12)

    Plugin Author codepeople

    (@codepeople)

    Hello @yogeekeye

    There are some errors in your equation:

    First, you have forgotten an operator before the POW operation and after the parenthesis in: )POW

    Second, the POW operation requires two parameters, and you are passing to it only one.

    Best regards.

    Thread Starter yoga21

    (@yogeekeye)

    I added the operation and the parameters its giving wrong calculation
    (fieldname2*(1-(1+(fieldname3/100)/12)/POW(fieldname4*-12,fieldname3)))/((fieldname3/100)/12)

    Plugin Author codepeople

    (@codepeople)

    Hello @yogeekeye

    If it is returning a wrong result, then, your equation does not represent the mathematical formula you wanted to implement. But it is not a problem in the plugin, because the plugin simply evaluates the mathematical operations you have included in the equation.

    Best regards.

    Thread Starter yoga21

    (@yogeekeye)

    The formula is this :
    P = (PMT [((1 + r)n – 1) / r])(1 + r)

    Where:

    P = The future value of the annuity stream to be paid in the future
    PMT = The amount of each annuity payment
    r = The interest rate
    n = The number of periods over which payments are to be made

    Thread Starter yoga21

    (@yogeekeye)

    Sorry this is wrong formula,

    Plugin Author codepeople

    (@codepeople)

    Hello @yogeekeye

    The formula you are referring does not have any relationship to the implemented equation.

    Best regards.

    Thread Starter yoga21

    (@yogeekeye)

    A = P * [{(1+i)^n – 1 }/i] * (1+i)
    Where :

    A = final amount
    P = installment each time
    n = total number of installments
    i = interest rate for that tenure (example if yearly return is 24%, but payments are made monthly then i = 24/12 = 2%)

    Plugin Author codepeople

    (@codepeople)

    Hello,

    If the fields are:

    P = fieldname1
    n = fieldname2
    i = fieldname3

    Note: if fieldname3 is a number field, and was selected the “Percent” option for the number type, you don’t need to transform the value to decimal.

    So, the equation would be:

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

    I’m sorry, the support service does not cover the implementation of the users’ projects (forms or formulas). However, if you need we implement your equations, do not hesitate in contact us through our private website: Customization

    Best regards.

    Thread Starter yoga21

    (@yogeekeye)

    This does not work, thanks for your help by d way and sorry for disturbing you again and again as i needed this and have tried to figure out from so many days.

    Plugin Author codepeople

    (@codepeople)

    Hello @yogeekeye

    With the information you have provided, I can check only the structure of the equation but not the values of the fields. Please, send me the link to the page where the form is inserted, and the values you are entering into the fields for testing your form in the same conditions.

    Best regards.

    Thread Starter yoga21

    (@yogeekeye)

    This is the type of calculator i am trying to make
    https://www.markcalculate.com/finance/sip-calculator
    https://groww.in/calculators/sip-calculator/
    https://rdcalculator.site/sip-calculator.html

    person invest amount 1000 every month for let say 2 years with an expected return of 3%, what will be the future value of this.

    Thread Starter yoga21

    (@yogeekeye)

    Here is the kind of calculation :
    Robert invests 10,000 each month in a fund for 10 years and the annual return was 18%, what will be his final corpus?

    Here as payments are monthly, total payment will be 10 * 12 = 120

    so n = 120 and i = 1.5 % (18/12)

    A = 10,000 * [{(1+ .015)^120 – 1}/.015 ] * (1+ .015) => 33.36lacs

    • This reply was modified 4 years, 9 months ago by yoga21.
    Plugin Author codepeople

    (@codepeople)

    Hello @yogeekeye

    None of the pages you sent me as a reference include your form. I am not implementing your project, I will simply check if the equation you have implemented is returning the values it should, based on the values indicated.

    If you want I implement your project, you should request a custom coding service through my private website: Customization

    Best regards.

Viewing 15 replies - 1 through 15 (of 21 total)
  • The topic ‘Monthly Calculator’ is closed to new replies.