Financial

Built-in functions › Spreadsheet formulas › Financial

50 functions in this category.

Financial

Function	What it does
accrint	Accrued interest for a security paying periodic interest.
accrintm	Accrued interest for a security paying interest at maturity.
coupdaybs	Days from beginning of coupon period to settlement.
coupdays	Days in the coupon period containing the settlement date.
coupdaysnc	Days from settlement to next coupon date.
coupncd	Next coupon date after settlement.
coupnum	Number of coupon payments between settlement and maturity.
couppcd	Previous coupon date before settlement.
cumipmt	Cumulative interest paid between two periods.
ddb	Double-declining-balance depreciation.
disc	Discount rate of a security.
dollarde	Convert dollar from fractional to decimal notation.
dollarfr	Convert dollar from decimal to fractional notation.
duration	Macaulay duration of a bond.
effect	Effective annual interest rate from a nominal rate.
fv	Future value of an investment.
fvschedule	Future value with variable interest rates.
intrate	Interest rate on a fully invested security.
ipmt	Interest portion of a periodic loan payment.
irr	Internal rate of return for a series of cash flows.
ispmt	Interest paid in a specific period (straight-line schedule).
mduration	Modified duration of a bond.
mirr	Modified internal rate of return.
nominal	Nominal annual rate from an effective rate.
nper	Number of payment periods for a loan or investment.
npv	Net present value of a stream of cash flows.
oddfprice	Price per $100 face value of a security with an odd first period.
oddlprice	Price per $100 face value of a security with an odd last period.
pduration	Periods needed for a lump-sum to grow to a target value.
pmt	Periodic payment for a loan or annuity.
ppmt	Principal portion of a periodic loan payment.
price	Price per $100 face value of a coupon-paying bond.
pricedisc	Price per $100 face value of a discounted security.
pricemat	Price per $100 of a security paying interest at maturity.
pv	Present value of an investment.
rate	Periodic interest rate for an annuity.
received	Amount received at maturity for a discounted security.
rri	Equivalent interest rate for a lump-sum growth.
sln	Straight-line depreciation.
syd	Sum-of-years’ digits depreciation.
tbilleq	Bond-equivalent yield for a Treasury bill.
tbillprice	Price per $100 face value of a Treasury bill.
tbillyield	Yield of a Treasury bill given its price.
vdb	Variable-declining-balance depreciation between two periods.
xdb	Fixed-declining-balance depreciation.
xirr	Internal rate of return with irregular cash-flow dates.
xnpv	Net present value with irregular cash-flow dates.
yield	Yield of a coupon-paying bond given its price.
yielddisc	Annual yield of a discounted security.
yieldmat	Annual yield of a security paying interest at maturity.