Financial functions
The NPER function calculates the number of payment periods for a loan or an investment based on periodic constant payments […]
The PV function calculates the net present value for an investment or loan. PV stands for present value. What is […]
The XNPV function calculates the net present value for cash flows that may or may not be periodic. Net present […]
What is the RRI function? The RRI function calculates the growth of an investment in percent per period. What is […]
What is the VDB function? The VDB function calculates the depreciation of an asset for a given period using the […]
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 […]
What is the YIELD function? The YIELD function calculates the yield for a security that pays interest. The YIELD 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 […]
What is the IPMT function? The IPMT function calculates the interest payment for a specific period for an investment based […]
What is the PPMT function? The PPMT function calculates the principal payment for a specific period for an investment based […]
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 […]
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 […]
What is the ISPMT function? The ISPMT function calculates the interest paid during a specific period of an investment. What […]
What is the RATE function? The RATE function returns the interest rate per period of an annuity. What is an […]
What is the FV function? The FV function returns the future value of an investment based on a constant interest […]