Workbook Functions: Financial

 

DB(cost, salvage, life, period [, months])

Real depreciation of an asset for a specific period using the fixed-declining balance method. Cost is the initial cost of the asset, salvage is the salvage value of the asset and life is the number of periods in its useful life. Months is the number of months in the first year of the item's life (default is 12). The time units for life and period must match.

See also: DDB, SLN, SYD, VDB

 

DDB(cost, salvage, life, period [,factor])

Depreciation of an asset for a specific period of time using the double-declining balance method or a declining balance factor supplied. Factor is the rate at which the balance declines (default value is 2). All entries must be >0.

See also: DB, SLN, SYD, VDB

 

DOLLAR(number [,precision])

Returns the number as text, using currency format. The number of decimal places to the right of the decimal point is indicated by precision.

See also: FIXED, TEXT, VALUE

 

FV(interest, number of payments per annuity, payment [,present value of annuity] [,type])

Future value of an annuity based on regular payments and a fixed interest rate. Type indicates when the payments are due: 0 for the end of period, 1 for the beginning of the period.

See also: IPMT, NPER, PMT, PPMT, PV, RATE

 

IPMT(interest rate, period, number of payments, present value [,future value] [,type])

Interest payment of an annuity for a given period based on regular payments and a fixed periodic interest rate. Present value and future value (default is 0) refer to the values which the annuity is worth currently and after all the payments have been made. Type=0 if the payments are due at the end of each period and Type=1 if they are due at the beginning.

See also: FV, PMT, PPMT, RATE

 

IRR(cash flow [,guess])

Internal rate of return for a series of periodic cash flows given as a reference to a range (e.g. RR(B1:B6)). Guess (default is 10%) is the estimate of the internal rate of return.

See also: MIRR, NPV, RATE

 

MIRR(cash flows, finance rate, reinvest rate)

Modified internal rate of return for a series (given as a reference to a range)of periodic cash flows. Cash received and cash paid have positive and negative values, respectively. The order of calculation is the order in which the values appear. Finance rate is the interest rate paid on money used in the cash flow and reinvest rate is the interest rate received on money reinvested from the cash flow.

See also: IRR, NPV, RATE

 

NPER(interest rate, pmt, pf, [,fv] [,type])

Number of periods of an investment based on regular periodic payments and a fixed interest rate. Pmt is the fixed payment made each period, pf is the present value that a series of future payments is currently worth, fv is the balance to attain after the final payment (default is 0) and type indicates when the payments are due: 0 refers to payments due at the end of the period and 1 at the beginning.

See also: FV, IPMT, PMT, PPMT, PV, RATE

 

NPV(discount rate, value list)

Net present value of an investment based on a series of periodic payments and a discount rate. Value list contains values that represent payments and income.

See also: FV, IRR, PV

 

PMT(interest rate, number of periods per annuity, pv [,fv] [,type])

Returns the periodic payment of an annuity, based on regular payments and a fixed periodic interest rate. Pv is the amount the annuity is currently worth and fv is the amount the annuity will be worth (default is 0). Type indicates when the payments are due: 0 refers to payments due at the end of the period and 1 at the beginning.

See also: FV, IPMT, NPER, PPMT, PV, RATE

 

PPMT(interest rate, period, number of periods, pv [,fv] [,type])

Returns the principle paid on an annuity for a given period. Pv is the amount the annuity is currently worth and fv is the amount the annuity will be worth (default is 0). Type indicates when the payments are due: 0 refers to payments due at the end of the period and 1 at the beginning.

See also: FV, IPMT, NPER, PMT, PV, RATE

 

PV(interest rate, number of periods in the investment, pmt [,fv] [,type])

Returns the present value of an annuity, considering a series of constant payments made over a regular payment period. Pmt is the fixed payment made each period and fv is the amount the annuity will be worth (default is 0). Type indicates when the payments are due: 0 refers to payments due at the end of the period and 1 at the beginning.

See also: FV, IPMT, NPER, PMT, PPMT, RATE

 

RATE(number of periods, pmt, pv [,fv] [,type] [,guess])

Returns the interest rate per period of an annuity, given a series of constant cash payments made over a regular payment period. Pmt is the fixed payment made each period, fv is the amount the annuity will be worth (default is 0) and guess is the estimate of the interest rate (default is 10%). Type indicates when the payments are due: 0 refers to payments due at the end of the period and 1 at the beginning.

See also: FV, IPMT, NPER, PMT, PPMT, PV

 

SYD(initial cost, salvage value, number of periods in useful life, period)

Depreciation of an asset for a specified period using the sum-of-years method. Period refers to the period for which to calculate the depreciation.

See also: DDB, SLN, VDB

 

VDB(initial cost, salvage value, number of periods in useful life, start period, end period [, factor] [,method])

Depreciation of an asset for a specified period using a variable method of depreciation. Start period and end period are the beginning and end periods for which to calculate the depreciation. Factor is the rate at which the balance declines (default is 2) and method is a logical value that determines if the method to be used should be switched to straight-line method when the depreciation is greater than the declining balance calculation.

See also: DDB, SLN, SYD