Vanguard Software
Forecasting & Planning Solutions
Home Products Solutions Services Customers Partners Company
 
Applying science to business management

contents.gifindex.gifprev1.gifnext1.gif

term

Format: term( pmt, rate, fv )

Arguments: (real) pmt Periodic payment

(real) rate Periodic interest rate (1=100%)

(real) fv Future value

Returns: (real) The number of periods required for a periodic investment of pmt at an interest rate of rate to grow to fv

Description: The term is calculated using the following equation:

  dph00493.gif

Examples: term(1000,8%,20000) = 12.416  (years required for an annual investment of $1000 at 8% to grow to $20000)

See Also: rate, pv, fv, pmt, npv, irr, cf

  Demand Planning  |  Financial Forecasting
Forecasting Software  |  Strategic Planning Software  |  Decision Tree Software
Decision Support Software  |  Expert System Software  |  Online Surveys

Contact Us  |  Terms of Use  |  Privacy Policy  |  Site Map
Vanguard Software
© 2011 Vanguard Software Corporation
Print this page   Email this page to a friend