Financial Functions

DDBReturns the depreciation of an asset over a period of time (Double).
FVReturns the future value of a series of equal cash flows at regular intervals (Double).
IPMTReturns the interest paid in a given period in a series of equal cash flows at regular intervals (Double).
IRRReturns the interest rate for a series of unequal cash flows at regular intervals (implicit reinvestment rate) (Double).
MIRRReturns the interest rate for a series of unequal cash flows at regular intervals (explicit reinvestment rate) (Double).
NPERReturns the number of periods for an investment (Double).
NPVReturns the present value of a series of unequal cash flows at regular intervals (Double).
PMTReturns the amount of principal and interest paid in a given period in a series of equal cash flows at regular intervals (Double).
PPMTReturns the amount of principal paid in a given period in a series of equal cash flows at regular intervals (Double).
PVReturns the present value of an annuity (Double).
RATEReturns the interest rate for a series of equal cash flows at regular intervals (Double).
SLNReturns the straight-line depreciation of an asset over a single period of time (Double).
SYDReturns the sum-of-years' digits depreciation of an asset (Double).
DDB
Returns the depreciation of an asset over a period of time (Double).
FV
Returns the future value of a series of equal cash flows at regular intervals (Double).
IPMT
Returns the interest paid in a given period in a series of equal cash flows at regular intervals (Double).
IRR
Returns the interest rate for a series of unequal cash flows at regular intervals (implicit reinvestment rate) (Double).
MIRR
Returns the interest rate for a series of unequal cash flows at regular intervals (explicit reinvestment rate) (Double).
NPER
Returns the number of periods for an investment (Double).
NPV
Returns the present value of a series of unequal cash flows at regular intervals (Double).
PMT
Returns the amount of principal and interest paid in a given period in a series of equal cash flows at regular intervals (Double).
PPMT
Returns the amount of principal paid in a given period in a series of equal cash flows at regular intervals (Double).
PV
Returns the present value of an annuity (Double).
RATE
Returns the interest rate for a series of equal cash flows at regular intervals (Double).
SLN
Returns the straight-line depreciation of an asset over a single period of time (Double).
SYD
Returns the sum-of-years' digits depreciation of an asset (Double).

© 2019 Better Solutions Limited. All Rights Reserved. © 2019 Better Solutions Limited Top