# 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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.