Function

What It Does

Comments

DDB(cost, salvage, _

life,period[, factor])

Returns a Double value that s an asset s depreciation for a specified time using a given method of depreciation.

cost is the asset's initial cost, salvage is the asset's value at the end of its working lifetime, life is the asset's lifetime, and period is the period (in months) for which the depreciation is calculated. factor(optional) is the rate the balance declines if it's is omitted, then the double-declining depreciation method is used.

FV(rate, nper, pmt[,pv[,type]])

Returns a Double value that represents the future value of an annuity based on a number of periodic fixed payment amounts (pmt) and a fixed interest rate (rate)

The pv argument specifies a present value or lump sum of a series of future payments, and type specifies when payments are due. Defaults to 0 for end of payment. 1 represents the beginning of the payment period.

IPmt (rate, per,nper, pv[,fv[, type]])

Returns a Double value that indicates the interest payment for a fixed-period annuity based on a number (nper) of periodic fixed payments (per) and a fixed interest rate (rate).

pv specifies the present value of a series of payments.fv (optional) specifies the future value or cash balance left after the final payment.type (optional) specifies when payments are due (0 = end of the payment period, the default; 1 = beginning of the payment period).

IRR[values()[, guess]]

Returns a Double value indicating the internal rate of return for an array of values that represent cash flow.

The values() array must contain at least one negative value (payment) and one positive value (receipt). guess (optional) specifies an estimate to be returned by IRR (default estimate is .1).

MIRR(values(), finrate, reinvrate)

Returns a Double value that s the modified internal rate of return for an array of values representing cash flow.

The values() array must contain at least one negative value (payment) and one positive value (receipt). The finrate argument is the interest rate paid for financing, and reinvrate is the interest rate received on gains from cash reinvestment.

Nper (rate, pmt,pv[, fv[,type]])

Returns a Double value that indicates the number of periods for an annuity based on periodic fixed payments (pmt) and a fixed interest rate (rate).

pv specifies the present value of a series of payments or receipts.fv (optional) specifies the future value or cash balance left after the final payment.type(optional) specifies when payments are due (0 = end of the payment period, the default; 1 = beginning of the payment period).

NPV(rate, values ())

Returns a Doublevalue representing the present value of an investment based on a discount rate (rate) and an array of valuesthat represent cash flow.

The values() array must contain at least one negative value (payment) and one positive value (receipt).

Pmt(rate, nper, pv[,fv[, type]])

Returns a Double value that indicates the payment for an annuity based on a number (nper)of periodic fixed payments and a fixed interest rate (rate).

pv specifies the present value of a series of payments or receipts. fv (optional) specifies the future value or cash balance left after the final payment. type(optional) specifies when payments are due (0 = end of the payment period, the default; 1 = beginning of the payment period).

PPmt(rate, per,nper, pv[,fv[, type]])

Returns a Double value that indicates the principle payment for a given period (per) of an annuity based on a number (nper) of periodic fixed payments and a fixed interest rate (rate).

pv specifies the present value of a series of payments or receipts. fv (optional) specifies the future value or cash balance left after the final payment. type(optional) specifies when payments are due (0 = end of the payment period, the default; 1 = beginning of the payment period).

PV(rate, nper,pmt[, fv[, type]])

Returns a Double value that indicates the present value of an annuity based on a number (nper) of periodic fixed payments (pmt) and a fixed interest rate (rate).

fv (optional) specifies the future value or cash balance left after the final payment.type (optional) specifies when payments are due (0 = end of the payment period, the default; 1 = beginning of the payment period).

Rate(nper, pmt,pv[, fv[,type[, guess]]])

Returns a Double value that indicates the fixed interest rate per period for an annuity based on a number (nper) of periodic fixed payments (pmt).

fv (optional) specifies the future value or cash balance left after the final payment. type (optional) specifies when payments are due (0 = end of the payment period, the default; 1 = beginning of the payment period). guess (optional) specifies an estimate to be returned by Rate (default estimate is .1).

SLN(cost, salvage, life)

Returns a Double value representing an asset s straight-line depreciation, given its initial cost, salvage value at the end of its useful life, and life span.

SYD(cost, salvage, _ life, period)

Returns a Double value that s an asset s sum-of-years' digits depreciation given its initial cost, salvage value at the end of its useful life, life span, and period for which depreciation is calculated.