DPL 9 Help

Financial Spreadsheet Functions

Financial Spreadsheet Functions

All of the arguments of these functions (x, y, z, s, and w) are expressions. Series and array subranges are allowed in any argument requiring a series or array (without subscripts). Normally none of the arguments of the financial spreadsheet functions should be a negative number.

DPLExcelAction
@cterm(x,y,z)NPER(x,,-z,y) The number of compounding periods for an investment with present value z to grow to future value y, earning a fixed periodic interest rate x. No argument should be 0.
@ddb(x,y,z,w)DDB(x,y,z,w) The double-declining depreciation allowance of an asset in period w, given the original cost x, predicted salvage value y, and the number of periods z in the life of the asset. The third and fourth arguments should not be 0.
@fv(x,y,z)FV(y,z,-x) The future value of a series of equal payments, each equal to x, earning a periodic interest rate y over z periods. Second argument should not be 0.
@irr(x,s)IRR(s,x) The internal interest rate of the series of cash flows in s, computed from a starting guess of x. It is possible for a set of cash flows to have more than one internal rate of return. When this occurs, @irr( ) may not find the same solution in DPL and Excel. This situation will never occur if the initial cash flow has one sign, and all the rest have another.
@npv(x,s)NPV(x,a) The present value of the series of cash flows in s, discounted at a periodic interest rate of x.
@pmt(x,y,z)PMT(y,z,-x) The amount of a periodic payment needed to pay off a principal x at a periodic interest rate of y over z periods. Second and third arguments should not equal 0.
@pv(x,y,z)PV(y,z,-x) The present value of a series of equal payments, each equal to x, discounted at a periodic interest rate of y over z periods. The second argument should not equal 0.
@rate(x,y,z)RATE(z,,-y,x) The periodic interest rate necessary for a present value of y to grow to a future value of x in z periods. Second and third arguments should not equal 0.
@sln(x,y,z)SLN(x,y,z) The straight-line depreciation allowance of an asset, given the original cost x, predicted salvage value y, and the number of periods z in the life of the asset. Third argument should not equal 0.
@syd(x,y,z,w)SYD(x,y,z,w) The sum-of-the-years'-digits depreciation allowance of an asset in period w, given the original cost x, predicted salvage value y, and the number of periods z in the life of the asset. The third argument should not equal 0.
@term(x,y,z)NPER(y,-x,,z) The number of payment periods of an investment, given the amount of each payment x, the periodic interest rate y, and the future value of the investment z. First and second arguments should not equal 0.

Notes: This information is subject to change. New functions are added from time to time. Contact technical support for the latest compatibility information.

Versions: DPL Professional, DPL Enterprise, DPL Portfolio

See Also

Spreadsheet Functions