Financial functions

How to use the NPER function

The NPER function calculates the number of payment periods for a loan or an investment based on periodic constant payments […]

How to use the PV function

The PV function calculates the net present value for an investment or loan. PV stands for present value. What is […]

How to use the XNPV function

The XNPV function calculates the net present value for cash flows that may or may not be periodic. Net present […]

How to use the RRI function

What is the RRI function? The RRI function calculates the growth of an investment in percent per period. What is […]

How to use the VDB function

What is the VDB function? The VDB function calculates the depreciation of an asset for a given period using the […]

How to use the DDB function

What is the DDB function? The DDB function calculates the depreciation of an asset for a given period using the […]

How to use the AMORLINC function

What is the AMORLINC function? The AMORLINC function calculates the depreciation for each accounting period. This function is designed for […]

How to use the AMORDEGRC function

What is the AMORDEGRC function? The AMORDEGRC function calculates the depreciation for each accounting period. This function is designed for […]

How to use the YIELD function

What is the YIELD function? The YIELD function calculates the yield for a security that pays interest. The YIELD function […]

How to use the SYD function

What is the SYD function? The SYD function calculates the yearly asset depreciation of a given year. What is SYD […]

How to use the TBILLEQ function

What is the TBILLEQ function? The TBILLEQ function calculates the equivalent bond yield for a Treasury bill. It converts the […]

How to use the TBILLPRICE function

What is the TBILLPRICE function? The TBILLPRICE function calculates the par amount (face value) for a Treasury bill. What is […]

How to use the TBILLYIELD function

What is the TBILLYIELD function? The TBILLYIELD function calculates the yield for a Treasury bill. What is the yield of […]

How to use the DOLLARFR function

What is the DOLLARFR function? The DOLLARFR function converts a decimal number to its equivalent in fractional numbers, used in […]

How to use the CUMIPMT function

What is the CUMIPMT function? The CUMIPMT function calculates the accumulated interest based on a start and end period on a […]

How to use the CUMPRINC function

What is the CUMPRINC function? The CUMPRINC function calculates the accumulated principal based on a start and end period on a […]

How to use the IPMT function

What is the IPMT function? The IPMT function calculates the interest payment for a specific period for an investment based […]

How to use the PPMT function

What is the PPMT function? The PPMT function calculates the principal payment for a specific period for an investment based […]

How to use the DB function

What is the DB function? The DB function calculates the depreciation of an asset for a given period using the […]

How to use the PRICEMAT function

What is the PRICEMAT function? The PRICEMAT function calculates the price per $100 nominal value of a bond that pays […]

How to use the PMT function

What is the PMT function? The PMT function returns the payment amount needed for borrowing a fixed sum of money […]

How to use the PDURATION function

What is the PDURATION function? The PDURATION function calculates how many periods required by an investment to reach a given […]

How to use the NOMINAL function

What is the NOMINAL function? The NOMINAL function calculates the nominal annual interest rate based on the effective rate and […]

How to use the ACCRINTM function

What is the ACCRINTM function? The ACCRINTM function calculates the accrued interest for a security that pays interest at maturity. […]

How to use the ACCRINT function

What is the ACCRINT function? The ACCRINT function calculates the accrued interest for a security that pays periodic interest. What […]

How to use the EFFECT function

What is the effect function? The EFFECT function calculates the effective annual interest rate, given the nominal annual interest rate […]

How to use the ISPMT function

What is the ISPMT function? The ISPMT function calculates the interest paid during a specific period of an investment. What […]

How to use the RATE function

What is the RATE function? The RATE function returns the interest rate per period of an annuity. What is an […]

How to use the FV function

What is the FV function? The FV function returns the future value of an investment based on a constant interest […]