Financial Functions

 

Financial functions are useful for computing complex financial information such as interest rates, payment and equity data.

 

DB

Returns the depreciation of an investment using the fixed-declining balance method for the specified period. The 'life' and 'period' arguments must use the same units of measure.

 

DDB

Returns the depreciation of an investment using the variable declining balance method for the specified period. The 'life' and 'period' arguments must use the same units of measure.

 

FV

Returns the future value of an investment based on constant periodic payments and a constant interest rate.

 

NPER

Returns the number of periods for an investment with a constant cash flow and interest rate given a present and future value.

 

PMT

Returns the payment amount needed to finance an investment.

 

PV

Returns the present value of an investment based on constant periodic payments and a constant interest rate.