Chapter Contents |
Previous |
Next |
COMPOUND |
Category: | Financial |
Syntax | |
Arguments | |
Details | |
Examples |
Syntax |
COMPOUND(a,f,r,n) |
Range: | a 0 |
Range: | f 0 |
Range: | r 0 |
Range: | n 0 |
Details |
The COMPOUND function returns the missing argument in the list of four arguments from a compound interest calculation. The arguments are related by
One missing argument must be provided. It is then calculated from the remaining three. No adjustment is made to convert the results to round numbers.
Examples |
The accumulated value of an investment of $2000 at a nominal annual interest rate of 9 percent, compounded monthly after 30 months, can be expressed as
future=compound(2000,.,0.09/12,30);
The value returned is 2502.54. The second argument has been set to missing, indicating that the future amount is to be calculated. The 9 percent nominal annual rate has been converted to a monthly rate of 0.09/12. The rate argument is the fractional (not the percentage) interest rate per compounding period.
Chapter Contents |
Previous |
Next |
Top of Page |
Copyright 1999 by SAS Institute Inc., Cary, NC, USA. All rights reserved.