The COMPOUND() function returns the value of an investment, given the principal, nominal interest rate, compounding frequency and time. For example: $5000 at 12% interest compounded quarterly for 5 years will become COMPOUND(5000; 0.12; 4; 5) or $9030.56.
A función COMPOUND () devolve o valor dun investimento, dado o valor, a taxa de xuro nominal, a frecuencia de composición e o tempo. Por exemplo: 5000€ a unha taxa composta do 12% trimestral en 5 anos tornaranse en COMPOUND( 5000; 0, 12; 4; 5) ou 9030. 56€.