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

contents.gifindex.gifprev1.gifnext1.gif

rate

Format: rate( fv, pv, term )

Arguments: (real) fv Future value

(real) pv Present value

(real) term Number of periods

Returns: (real) Periodic interest rate necessary for an investment of pv to grow to a future value of fv in term periods

Description: The interest rate is calculated using the following equation:

  dph00485.gif

Examples: rate(10000,1000,20) = 0.122  (Interest rate required for $1000 to grow to $10000 in 20 years)

See Also: term, 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