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.
De funksje COMPOUND () jout de wearde werom fan in ynvestearring, neffens it startkaptaal, de nominale rinte, de stoartingsfrekwinsje en tiid. Foarbyld: & euro; 5. 000 tsjin 12% rinte, oer 5 jier opsparre mei in stoartingsfrekwinsje fan elk fearnsjier levert in einbedrach op fan COMPOUND( 5000; 0, 12; 4; 5) oftewol & euro; 9. 030, 56.