Calculating simple loan amount.

Hello,

I’m sorry, but the formula you’ve entered does not represent the result you are waiting. As demonstration I’ll replace the values in your formula with the corresponding numbers to evaluate it manually:

150000*5/100/30*12 = 
750000/100/30*12 = 
7500/30*12 = 
250*12 = 
3000

Please, check your formula’s structure.
Best regards.

Thank you. the numbers you sent equal 3000 and you don’t explain why the formula is done this way and how its entered into your plugin.

Again, If I calculate $150K * 5.0% for 30 years my answer is $805.23.

Hello,

I’ve simply replaced the values in the equation you sent me, and evaluated it manually.

Note: The equations are entered through the “Set Equation” attribute in the properties of the calculated field.

The operation you need is:

CALCULATEPAYMENT(x,y,z)

It calculates the Financed Payment Amount, and its parameters are:
amount, months, interest rate (percent)

So, replacing your values:

CALCULATEPAYMENT(150000,30*12,5) = 805.23

The CALCULATEPAYMENT operation is included in the “Financial Module” distributed with the “Developer” and “Platinum” versions of the plugin. More information in the following link:

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

Best regards.

So I tried your formula and it doesn’t produce a value. I’m not going to purchase your product because it falls short of anything I need. I’d rather pay someone to write a jquery sript while I write the HTML and CSS.

Here’s to deleting your plugin.

• This reply was modified 7 years, 8 months ago by tarzan61.

Hello @tarzan61,

If you don’t want to upgrade to the “Developer” version of the plugin, and you know the operations to impement, you can write your own formula directly in the “Set Equation” attribute of the calculated field. The plugin allows you to use all javascript and jQuery operations.

Best regards.