Last updated
Was this helpful?
Last updated
Was this helpful?
Financial functions evaluate and calculate data related to money, investments, interest rates, and other aspects of finance.
Returns the compound annual growth rate of an investment.
Returns the effective annual interest rate.
Returns the future value of an investment.
Returns the interest portion of a periodic payment for a loan based on the amount, number of periods, and constant interest rate. The portion of the payment allocated to interest decreases over time.
Returns the nominal annual interest rate.
Returns the number of periods for a loan or investment based on known amount, interest rate, and periodic payment amount.
Returns the periodic payment for a loan based on the amount, number of periods, and constant interest rate.
Returns the principal portion of a periodic payment for a loan based on the amount, number of periods, and constant interest rate. The portion of the payment allocated to principal increases over time.
Returns the present value of a loan or an investment, when using constant and regular periodic payments.
Returns the net present value of an investment for payments or incomes at irregular intervals.