| Functions |
What it Does |
| FV |
Returns the future value of an
investment |
| NPER |
Returns the number of periods
for an investment |
| PMT |
Returns the periodic payment for
an annuity |
| RATE |
Returns the interest rate per
period of an annuity |
| ACCRINT |
Returns the accrued interest for
a security that pays periodic interest |
| ACCRINTM |
Returns the accrued interest for
a security that pays interest at maturity |
| AMORDEGRC |
Returns the depreciation for
each accounting period by using a depreciation coefficient |
| AMORLINC |
Returns the depreciation for
each accounting period |
| COUPDAYBS |
Returns the number of days from
the beginning of the coupon period to the settlement date |
| COUPDAYS |
Returns the number of days in
the coupon period that contains the settlement date |
| COUPDAYSNC |
Returns the number of days from
the settlement date to the next coupon date |
| COUPNCD |
Returns the next coupon date
after the settlement date |
| COUPNUM |
Returns the number of coupons
payable between the settlement date and maturity date |
| COUPPCD |
Returns the previous coupon date
before the settlement date |
| CUMIPMT |
Returns the cumulative interest
paid between two periods |
| CUMPRINC |
Returns the cumulative principal
paid on a loan between two periods |
| DB |
Returns the depreciation of an
asset for a specified period using the fixed-declining balance method |
| DDB |
Returns the depreciation of an
asset for a specified period using the double-declining balance method or
some other method you specify |
| DISC |
Returns the discount rate for a
security |
| DOLLARDE |
Converts a dollar price, expressed as a fraction, into a dollar price,
expressed as a decimal number |
| DOLLARFR |
Converts a dollar price, expressed as a decimal number, into a dollar
price, expressed as a fraction |
| DURATION |
Returns the annual duration of a
security with periodic interest payments |
| EFFECT |
Returns the effective annual
interest rate |
| FVSCHEDULE |
Returns the future value of an
initial principal after applying a series of compound interest rates |
| INTRATE |
Returns the interest rate for a
fully invested security |
| IPMT |
Returns the interest payment for
an investment for a given period |
| IRR |
Returns the internal rate of
return for a series of cash flows |
| ISPMT |
Returns the interest paid during
a specific period of an investment |
| MDURATION |
Returns the Macauley
modified duration for a security with an assumed par value of $100 |
| MIRR |
Returns the internal rate of
return where positive and negative cash flows are financed at different rates |
| NOMINAL |
Returns the annual nominal
interest rate |
| NPV |
Returns the net present value of
an investment based on a series of periodic cash flows and a discount rate |
| ODDFPRICE |
Returns the price per $100 face
value of a security with an odd first period |
| ODDFYIELD |
Returns the yield of a security
with an odd first period |
| ODDLPRICE |
Returns the price per $100 face
value of a security with an odd last period |
| ODDLYIELD |
Returns the yield of a security
with an odd last period |
| PPMT |
Returns the payment on the
principal for an investment for a given period |
| PRICE |
Returns the price per $100 face
value of a security that pays periodic interest |
| PRICEDISC |
Returns the price per $100 face
value of a discounted security |
| PRICEMAT |
Returns the price per $100 face
value of a security that pays interest at maturity |
| PV |
Returns the present value of an
investment |
| RECEIVED |
Returns the amount received at
maturity for a fully invested security |
| SLN |
Returns the straight-line
depreciation of an asset for one period |
| SYD |
Returns the sum-of-years' digits
depreciation of an asset for a specified period |
| TBILLEQ |
Returns
the bond-equivalent yield for a Treasury bill |
| TBILLPRICE |
Returns the price per $100 face
value for a Treasury bill |
| TBILLYIELD |
Returns the yield for a Treasury
bill |
| VDB |
Returns the depreciation of an
asset for a specified or partial period using a declining balance method |
| XIRR |
Returns the internal rate of
return for a schedule of cash flows that is not necessarily periodic |
| XNPV |
Returns the net present value
for a schedule of cash flows that is not necessarily periodic |
| YIELD |
Returns the yield on a security
that pays periodic interest |
| YIELDDISC |
Returns the annual yield for a
discounted security for example, a Treasury bill |
| YIELDMAT |
Returns the annual yield
of a security that pays interest at maturity |
Back home