Calculate Compound Interest.

[johngouws]

Hi All,

I have a working example of calculating interest in excel and would like to get to the same answer in QlikView.

EXCEL EXAMPLE:

Compound Interest Calculator

Initial investment                    = 2000

Annual Interest Rate               = 8%

No. of compound periods        = 365

Years                                    = 5

Balance                               = 2 983.52

"Balance" is derived from : "=2000 * (1 + 0.08 /365) ^ (5 * 365)".

In QlikView I am trying   "pow(2000 * (0.1 + (0.08 / 365)), (5 / 365))"    but not getting the correct answer. I am obviously doing something wrong. The attached qvw shows example.

Thank you very much.

[Chanty4u]

exp is seem ok.  1.07531...

the value it is givng? wrng/

[tresesco · Accepted solution]

=2000*pow(1+0.08/365, 5*365)

With formatting:

=Num(2000*pow(1+0.08/365, 5*365),'##.00')

[johngouws]

Thank you.

I see the places I went wrong. Appreciate it.

John