|
CUMIPMT
|
Returns the total interest paid on a loan in specified periodic
payments.
|
|
CUMPRINC
|
Returns the total capital repaid on a loan in specified periodic
payments.
|
|
DB
|
Returns the depreciation of an asset for a given year using the fixed
rate declining-balance method.
|
|
DDB
|
Returns the depreciation of an asset for a given year using the double
declining-balance method (or any other factor).
|
|
DOLLARDE
|
Converts a fractional number representation of a number into a decimal
number.
|
|
DOLLARFR
|
Converts a decimal number into a fractional representation of that
number.
|
|
EFFECT
|
Returns the effective compounded interest rate given a nominal interest
rate.
|
|
FV
|
Returns the future value of an initial sum with a subsequent stream of
payments.
|
|
FVSCHEDULE
|
Returns the future value of a lump sum, with changing future interest
rates.
|
|
IPMT
|
Returns the portion of the periodic payment which is interest for a
fixed rate loan or annuity.
|
|
IRR
|
Calculates the internal rate of return of a series of cash flows.
|
|
ISPMT
|
Returns the interest paid in a period for a fixed-rate loan.
|
|
MIRR
|
Returns the modified internal rate of return of a series of cash flows.
|
|
NOMINAL
|
Returns a nominal interest rate given the effective compounded interest
rate.
|
|
NPER
|
Returns the number of payment periods for an annuity.
|
|
NPV
|
Returns the net present value of an investment with regular cash
payments.
|
|
PDURATION
|
Returns the number of periods required by an investment to realize a
desired value.
|
|
PMT
|
Returns the payment per period for a fixed-rate loan.
|
|
PPMT
|
Returns the portion of the periodic payment which is repaid capital for
a fixed-rate loan or annuity.
|
|
PV
|
Returns the present value of a stream of future payments with a final
lump sum.
|
|
RATE
|
Returns the interest rate of an annuity.
|
|
RRI
|
Returns an equivalent interest rate when an investment increases in
value.
|
|
SLN
|
Returns the depreciation of an asset in a single period using the
straight-line depreciation method.
|
|
SYD
|
Returns the depreciation of an asset for a given year using the sum of
the years' digits method.
|
|
TBILLEQ
|
Returns the bond-equivalent-yield (BEY) for a US Treasury bill.
|
|
TBILLPRICE
|
Returns the issue price for a US Treasury bill, per $100 face value,
given a discount rate.
|
|
TBILLYIELD
|
Returns the yield for a US Treasury bill.
|
|
XIRR
|
Calculates the internal rate of return of a series of irregular cash
flows.
|
|
XNPV
|
Returns the net present value of an investment with irregular cash
payments.
|