## Function |
## Name |
## Description |

`ACCRINT(issue, firstInterest, settlement, rate, par, frequency, basis, calcMethod)` |
ACCRINT | Returns the accrued interest for a security that pays periodic interest. |

`ACCRINTM(issue, settlement, rate, par, basis)` |
ACCRINTM | Returns the accrued interest for a security that pays interest at maturity. |

`AMORDEGRC(cost, datePurchased, firstPeriod, salvage, period, rate, basis)` |
AMORDEGRC | Returns the depreciation for each accounting period by using a depreciation coefficient. |

`AMORLINC(cost, datePurchased, firstPeriod, salvage, period, rate, basis)` |
AMORLINC | Returns the depreciation for each accounting period. |

`COUPDAYBS(settlement, maturity, frequency, basis)` |
COUPDAYBS | Returns the number of days from the beginning of the coupon period to the settlement date. |

`COUPDAYS(settlement, maturity, frequency, basis)` |
COUPDAYS | Returns the number of days in the coupon period that contains the settlement date. |

`COUPDAYSNC(settlement, maturity, frequency, basis)` |
COUPDAYSNC | Returns the number of days from the settlement date to the next coupon date. |

`COUPNCD(settlement, maturity, frequency, basis)` |
COUPNCD | Returns the next coupon date after the settlement date. |

`COUPNUM(settlement, maturity, frequency, basis)` |
COUPNUM | Returns the number of coupons payable between the settlement date and maturity date. |

`COUPPCD(settlement, maturity, frequency, basis)` |
COUPPCD | Returns the previous coupon date before the settlement date. |

`CUMIPMT(rate, nper, pv, startPeriod, endPeriod, typ)` |
CUMIPMT | Returns the cumulative interest paid between two periods. |

`CUMPRINC(rate, nper, pv, startPeriod, endPeriod, typ)` |
CUMPRINC | Returns the cumulative principal paid on a loan between two periods. |

`DB(cost, salvage, life, period, month)` |
DB | Returns the depreciation of an asset for a specified period by using the fixed-declining balance method. |

`DDB(cost, salvage, life, period, factor)` |
DDB | Returns the depreciation of an asset for a specified period by using the double-declining balance method or some other method that you specify. |

`DISC(settlement, maturity, pr, redemption, basis)` |
DISC | Returns the discount rate for a security. |

`DOLLARDE(fractionalDollar, fraction)` |
DOLLARDE | Converts a dollar price, expressed as a fraction, into a dollar price, expressed as a decimal number. |

`DOLLARFR(decimalDollar, fraction)` |
DOLLARFR | Converts a dollar price, expressed as a decimal number, into a dollar price, expressed as a fraction. |

`DURATION(settlement, maturity, coupon, yld, frequency, basis)` |
DURATION | Returns the annual duration of a security with periodic interest payments. |

`EFFECT(nominalRate, npery)` |
EFFECT | Returns the effective annual interest rate. |

`FV(rate, nper, pmt, pv, typ)` |
FV | Returns the future value of an investment. |

`FVSCHEDULE(principal, schedule)` |
FVSCHEDULE | Returns the future value of an initial principal after applying a series of compound interest rates. |

`INTRATE(settlement, maturity, investment, redemption, basis)` |
INTRATE | Returns the interest rate for a fully invested security. |

`IPMT(rate, per, nper, pv, fv, typ)` |
IPMT | Returns the interest payment for an investment for a given period. |

`IRR(values, guess)` |
IRR | Returns the internal rate of return for a series of cash flows. |

`ISPMT(rate, per, nper, pv)` |
ISPMT | Calculates the interest paid during a specific period of an investment. |

`MDURATION(settlement, maturity, coupon, yld, frequency, basis)` |
MDURATION | Returns the Macauley modified duration for a security with an assumed par value of $100. |

`MIRR(values, financeRate, reinvestRate)` |
MIRR | Returns the internal rate of return where positive and negative cash flows are financed at different rates. |

`NOMINAL(effectRate, npery)` |
NOMINAL | Returns the annual nominal interest rate. |

`NPER(rate, pmt, pv, fv, typ)` |
NPER | Returns the number of periods for an investment. |

`NPV(rate, values)` |
NPV | Returns the net present value of an investment based on a series of periodic cash flows and a discount rate. |

`PMT(rate, nper, pv, fv, typ)` |
PMT | Returns the periodic payment for an annuity. |

`PPMT(rate, per, nper, pv, fv, typ)` |
PPMT | Returns the payment on the principal for an investment for a given period. |

`PRICE(settlement, maturity, rate, yld, redemption, frequency, basis)` |
PRICE | Returns the price per $100 face value of a security that pays periodic interest. |

`PRICEDISC(settlement, maturity, discount, redemption, basis)` |
PRICEDISC | Returns the price per $100 face value of a discounted security. |

`PRICEMAT(settlement, maturity, issue, rate, yld, basis)` |
PRICEMAT | Returns the price per $100 face value of a security that pays interest at maturity. |

`PV(rate, nper, pmt, fv, typ)` |
PV | Returns the present value of an investment. |

`RATE(nper, pmt, pv, fv, typ, guess)` |
RATE | Returns the interest rate per period of an annuity. |

`RECEIVED(settlement, maturity, investment, discount, basis)` |
RATE | Returns the amount received at maturity for a fully invested security. |

`SLN(cost, salvage, life)` |
SLN | Returns the straight-line depreciation of an asset for one period. |

`SYD(cost, salvage, life, per)` |
SYD | Returns the sum-of-years’ digits depreciation of an asset for a specified period. |

`TBILLEQ(settlement, maturity, discount)` |
TBILLEQ | Returns the bond-equivalent yield for a Treasury bill. |

`TBILLPRICE(settlement, maturity, discount)` |
TBILLPRICE | Returns the price per $100 face value for a Treasury bill. |

`TBILLYIELD(settlement, maturity, pr)` |
TBILLYIELD | Returns the yield for a Treasury bill. |

`VDB(cost, salvage, life, startPeriod, endPeriod, factor)` |
VDB | Returns the depreciation of an asset for a specified or partial period by using a declining balance method. |

`XIRR(values, dates, guess)` |
XIRR | Returns the internal rate of return for a schedule of cash flows that is not necessarily periodic. |

`XNPV(rate, values, dates)` |
XIRR | Returns the net present value for a schedule of cash flows that is not necessarily periodic. |

`YIELD(settlement, maturity, rate, pr, redemption, frequency, basis)` |
YIELD | Returns the yield on a security that pays periodic interest. |

`YIELDDISC(settlement, maturity, pr, redemption, basis)` |
YIELDDISC | Returns the annual yield for a discounted security; for example, a Treasury bill. |

`YIELDMAT(settlement, maturity, issue, rate, pr, basis)` |
YIELDMAT | Returns the annual yield of a security that pays interest at maturity. |

# Excel Financial Functions

Create a Formula. Choices Functions. userfirstname(). Logic. format-date(). sin(). globalval(). Repeats. Functions. pi(). Date/Time Functions. date(). string(). atan(). logarithm(). imgurl(). userexternalid(). tan(). counter(). ‘.’ (dot).