Contents
An Introduction to Excel Functions
Financial Functions
Date and Time Functions
Math and Trigonometry Functions
Statistical Functions
Lookup and Reference Functions
Database Functions
Text Functions
Logical Functions
Information Functions
Engineering Functions
Cube Functions
Add-In and Automation Functions
|
 |
 |
 |
|
Financial Functions
Function |
Description |
Syntax |
||
ACCRINT |
Returns the accrued interest for a security that pays periodic interest |
(issue,first_interest,
settlement,rate,par,frequency,
basis,calc_method) |
||
ACCRINTM |
Returns the accrued interest
for a security that pays interest
at maturity |
(issue,settlement,rate,par,basis) |
||
AMORDEGRC |
Returns the depreciation for each accounting period by using a
depreciation coefficient |
(cost,date_purchased,
first_period,salvage,period,
rate,basis) |
||
AMORLINC |
Returns the depreciation for each accounting period |
(cost,date_purchased,
first_period,salvage,period,
rate,basis) |
||
COUPDAYBS |
Returns the number of days from the beginning of the coupon
period to the settlement date |
(settlement,maturity,
frequency,basis) |
||
COUPDAYS |
Returns the number of days in the coupon period that contains the settlement date |
(settlement,maturity,
frequency,basis) |
||
COUPDAYSNC |
Returns the number of days from the settlement date to the next coupon date |
(settlement,maturity,
frequency,basis) |
||
COUPNCD |
Returns the next coupon date
after the settlement date |
(settlement,maturity,
frequency,basis) |
||
COUPNUM |
Returns the number of coupons payable between the settlement date and maturity date |
(settlement,maturity,
frequency,basis) |
||
COUPPCD |
Returns the previous coupon date before the settlement date |
(settlement,maturity,
frequency,basis) |
||
CUMIPMT |
Returns the cumulative interest paid between two periods |
(rate,nper,pv,
start_period,end_period,
type) |
||
CUMPRINC |
Returns the cumulative principal paid on a loan between two periods |
(rate,nper,pv,start_period,
end_period,type) |
||
DB |
Returns an asset’s depreciation for a specified period by using the fixed-declining-balance method |
(cost,salvage,life,period,
month) |
||
DDB |
Returns an asset’s depreciation for a specified period by using the double-declining-balance method or another method that you specify |
(cost,salvage,life,period,
factor) |
||
DISC |
Returns the discount rate for
a security |
(settlement,maturity,pr,
redemption,basis) |
||
DOLLARDE |
Converts a dollar price expressed as a fraction into a dollar price
expressed as a decimal number |
(fractional_dollar,fraction) |
||
DOLLARFR |
Converts a dollar price expressed as a decimal number into a dollar price expressed as a fraction |
(decimal_dollar,fraction) |
||
DURATION |
Returns the annual duration
of a security with periodic
interest payments |
(settlement,maturity,coupon,yld,frequency,basis) |
||
EFFECT |
Returns the effective annual
interest rate |
(nominal_rate,npery) |
||
FV |
Returns the future value of
an investment |
(rate,nper,pmt,pv,type) |
||
FVSCHEDULE |
Returns the future value of an
initial principal after applying a
series of compound interest rates |
(principal,schedule) |
||
INTRATE |
Returns the interest rate for a fully invested security |
(settlement,maturity,
investment,redemption,basis) |
||
IPMT |
Returns the interest payment for an investment for a given period |
(rate,per,nper,pv,fv,type) |
||
IRR |
Returns the internal rate of return for a series of cash flows |
(values,guess) |
||
ISPMT |
Calculates the interest paid during a specific period of an investment |
(rate,per,nper,pv) |
||
MDURATION |
Returns the Macauley modified duration for a security with an
assumed par value of $100 |
(settlement,maturity,coupon,yld,frequency,basis) |
||
MIRR |
Returns the internal rate of return when positive and negative cash flows are financed at different rates |
(values,finance_rate,
reinvest_rate) |
||
NOMINAL |
Returns the annual nominal
interest rate |
(effect_rate,npery) |
||
NPER |
Returns the number of periods for an investment |
(rate, pmt, pv, fv, type) |
||
NPV |
Returns the net present value of an investment based on a series of periodic cash flows and a
discount rate |
(rate,value1,value2,...) |
||
ODDFPRICE |
Returns the price per $100 face value of a security with an odd first period |
(settlement,maturity,issue,
first_coupon,rate,yld,
redemption,frequency,basis) |
||
ODDFYIELD |
Returns the yield of a security with an odd first period |
(settlement,maturity,issue,
first_coupon,rate,pr,
redemption,frequency,basis) |
||
ODDLPRICE |
Returns the price per $100 face value of a security with an odd last period |
(settlement,maturity,
last_interest,rate,yld,
redemption,frequency,basis) |
||
ODDLYIELD |
Returns the yield of a security with an odd last period |
(settlement,maturity,
last_interest,rate,pr,
redemption,frequency,basis) |
||
PMT |
Returns the periodic payment for an annuity |
(rate,nper,pv,fv,type) |
||
PPMT |
Returns the payment on the
principal for an investment for a given period |
(rate,per,nper,pv,fv,type) |
||
PRICE |
Returns the price per $100 face value of a security that pays
periodic interest |
(settlement,maturity,rate,yld,
redemption,frequency,basis) |
||
PRICEDISC |
Returns the price per $100 face value of a discounted security |
(settlement,maturity,
discount,redemption,basis) |
||
PRICEMAT |
Returns the price per $100 face value of a security that pays
interest at maturity |
(settlement,maturity,issue,
rate,yld,basis) |
||
PV |
Returns the present value of
an investment |
(rate,nper,pmt,fv,type) |
||
RATE |
Returns the interest rate per
period of an annuity |
(nper,pmt,pv,fv,type,guess) |
||
RECEIVED |
Returns the amount received at maturity for a fully invested security |
(settlement,maturity,
investment,discount,basis) |
||
SLN |
Returns the straight-line depreciation of an asset for one period |
(cost,salvage,life) |
||
SYD |
Returns the sum-of-years’-digits depreciation of an asset for a specified period |
(cost,salvage,life,per) |
||
TBILLEQ |
Returns the bond-equivalent yield for a Treasury bill |
(settlement,maturity,
discount) |
||
TBILLPRICE |
Returns the price per $100 face value for a Treasury bill |
(settlement,maturity,
discount) |
||
TBILLYIELD |
Returns the yield for a Treasury bill |
(settlement,maturity,pr) |
||
VDB |
Returns the depreciation of an
asset for a specified period by
using a declining-balance method |
(cost,salvage,life,
start_period,end_period,factor,no_switch) |
||
XIRR |
Returns the internal rate of return for a schedule of cash flows that is not necessarily periodic |
(values,dates,guess) |
||
XNPV |
Returns the net present value for a schedule of cash flows that is not necessarily periodic |
(rate,values,dates) |
||
YIELD |
Returns the yield on a security that pays periodic interest |
(settlement,maturity,rate,pr,
redemption,frequency,basis) |
||
YIELDDISC |
Returns the annual yield for a discounted security, such as a Treasury bill |
(settlement,maturity,pr,
redemption,basis) |
||
YIELDMAT |
Returns the annual yield of
a security that pays interest
at maturity |
(settlement,maturity,issue,
rate,pr,basis) |
| Acknowledgments & Disclaimer |
Tags
No one has tagged this page yet... Be the first.. Log in using the link below and return to add your tag
