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 internal rate of return for a series of cash flows (Double).
MIRRReturns the internal rate of return for a series of cash flows (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 aid 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).

© 2017 Better Solutions Limited. All Rights Reserved. © 2017 Better Solutions Limited

Top