Link Search Menu Expand Document

cterm

Explanation Find the period during which the principal reaches the target maturity amount.
Call format var c = cterm (interest, target maturity, principal )
Return value Returns the period (year) until the target maturity is reached when the principal is invested at the interest rate.
Arguments Number interest For 5% , specify 0.05
Number Target maturity amount Target amount
Number Principal
Exception None
Example of use
var a = cterm (0.05, 1000000, 800000);
/ * a is the number of years to operate 800,000 principal at an annual rate of 5 % to 1 million * /
Related item