Issue with Incorrect Output in Retirement Calculator

  • Resolved fifthshield

    (@fifthshield)


    1 year, 1 month ago

    Hi Support Team,

    I’m using the Cost Calculator Builder plugin to create a Retirement Calculator on my WordPress website. I’ve added a custom formula to calculate the estimated retirement corpus based on inputs like current age, retirement age, current savings, monthly investment, and expected annual return.

    Here’s the formula I’m using:

    C * (((1 + (D / 1200)) ^ ((G - A) * 12) - 1) / (D / 1200)) + B * ((1 + (D / 1200)) ^ ((G - A) * 12))

    Where:
    A = Current Age
    G = Retirement Age
    B = Current Savings
    C = Monthly Investment
    D = Expected Annual Return (%)

    However, the plugin output is significantly higher than the expected result. For example:

    • Current Age: 30
    • Retirement Age: 50
    • Current Savings: ₹100,000
    • Monthly Investment: ₹5,000
    • Expected Return: 10%

    Plugin Output: ₹16.69 Crores

    It seems the formula or the field calculations are not functioning as expected. I’ve verified the formula with manual calculations, and the discrepancy persists.

    Could you please help me identify:

    1. If the formula format is correct for the plugin?
    2. Whether the plugin is treating percentage or decimal values incorrectly?
    3. Any setting that could cause this kind of inflated output?

    Looking forward to your quick assistance before purchasing the plugin.

    Thanks & regards,

    The page I need help with: [log in to see the link]

Viewing 5 replies - 1 through 5 (of 5 total)
  • James StylemixThemes

    (@jamesstylemixthemes)

    1 year, 1 month ago

    Hi @fifthshield,

    Thank you for reaching out to us!

    The issue might be related to how the percentage is applied in your formula. It looks like you’ve defined the percentage using a basic slider and are directly multiplying it with other values. By multiplying 10 (D) with other numbers, you’re actually multiplying by 10, not by 10%.

    If you want to calculate 10% of another value, your formula should look more like this:
    D / 100 * (((1 + (E / 1200)) ^ ((B - A) * 12) - 1) / (E / 1200)) + C * ((1 + (E / 1200)) ^ ((B - A) * 12))

    Let us know if you need any further assistance!

    Kind regards,
    James

    Thread Starter fifthshield

    (@fifthshield)

    1 year, 1 month ago

    Hi James,

    Thanks for your quick response!

    I tried using the formula you shared:

    D / 100 * (((1 + (E / 1200)) ^ ((B - A) * 12) - 1) / (E / 1200)) + C * ((1 + (E / 1200)) ^ ((B - A) * 12))

    However, the system shows an error saying “Nonexistent letters are used” (screenshot attached above). In my calculator setup, the available fields are:

    • A = Current Age
    • G = Retirement Age
    • B = Current Savings
    • C = Monthly Investment
    • D = Expected Annual Return

    There is no field labeled “E” — it seems that’s causing the issue.

    Could you please help me correct the formula using the actual field labels above?

    Looking forward to your guidance.

    Plugin Support juliastylemixthemes

    (@juliastylemixthemes)

    1 year, 1 month ago

    Hello @fifthshield ,

    Thank you for your request! You’re absolutely right—there was an error in the field ID used in the formula I shared. I apologize for the confusion with the “E” field, which doesn’t exist in your setup (A = Current Age, G = Retirement Age, B = Current Savings, C = Monthly Investment, D = Expected Annual Return).

    I recommend trying a slightly different format for the formula, adjusted to match your field labels, as shown below:

    C * ((POW(1 + D/1200, (G - A) * 12) - 1) / (D / 1200)) + B * (POW(1 + D/1200, (G - A) * 12))

    This formula uses the correct field IDs (C, D, G, A, B) and the POW function, which is often better supported in the Cost Calculator Builder plugin for exponentiation. Please try implementing this formula in your calculator and let me know if it works.

    If the calculation still doesn’t produce the expected result, could you please share an example of the correct calculation (e.g., with specific values and the expected outcome)? This will help me adapt the formula further to meet your needs. Thank you for your patience, and I’m here to assist!

    Best regards,
    Julia Ten
    Stylemix Support Team

    Thread Starter fifthshield

    (@fifthshield)

    1 year, 1 month ago

    Hi,

    Thanks for your help—the formula is working perfectly now.

    I just have one more query:
    Is it possible to display the result in the Indian numbering format (e.g., ₹1,00,000 instead of ₹100,000)? It would really improve clarity for Indian users.

    Looking forward to your guidance!

    Plugin Support mgordon7

    (@mgordon7)

    1 year, 1 month ago

    Thank you for highlighting the Indian number formatting issue. The Cost Calculator Builder supports currency customization, but specific Indian number formatting (e.g., 1,00,00,000) may require additional configuration. I can recommend you write this kind of suggestion in our features request section of the Cost Calculator plugin -> https://stylemixthemes.cnflx.io/boards/cost-calculator-builder. Our dev team will include additional features/options according to the popularity of the requests from our dear customers

    Cheers

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

The topic ‘Issue with Incorrect Output in Retirement Calculator’ is closed to new replies.