So I found this example in the net
Compound interest formula (including principal):
A = P(1+r/n)(nt)
If an amount of $5,000 is deposited into a savings account at an annual interest rate of 5%, compounded monthly, the value of the investment after 10 years can be calculated as follows...
P = 5000. r = 5/100 = 0.05 (decimal). n = 12. t = 10.
If we plug those figures into the formula, we get:
A = 5000 (1 + 0.05 / 12) ^ (12(10)) = 8235.05.
So, the investment balance after 10 years is $8,235.05.
Okay, I'm using the PMT calculator in excel and I plug in these values
I get 53.03\$ per month, okay if I multiply it by 12*10 years I should get the same amount as the site, but now I get 6 363,93$
Why not the same? I use the pmt function in excel