### Financial functions

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

The RRI function calculates the growth of an investment in percent per period. Formula in cell C6: =RRI(C2, C3, C4) [โฆ]

How to use the VDB function

The VDB function calculates the depreciation of an asset for a given period using the double-declining balance method or based [โฆ]

How to use the DDB function

The DDB function calculates the depreciation of an asset for a given period using the double-declining balance method or based [โฆ]

How to use the AMORLINC function

The AMORLINC function calculates the depreciation for each accounting period. This function is designed for the French accounting system. Formula [โฆ]

How to use the AMORDEGRC function

The AMORDEGRC function calculates the depreciation for each accounting period. This function is designed for the French accounting system. Formula [โฆ]

How to use the YIELD function

The YIELD function calculates the yield for a security that pays interest. The YIELD function is designed to calculate the [โฆ]

How to use the SYD function

The SYD function calculates the yearly asset depreciation of a given year. Formula in cell C6: =SYD(C2,C3,C4,C5) Excel Function Syntax [โฆ]

How to use the TBILLPRICE function

The TBILLPRICE function calculates the par amount (face value) for a Treasury bill. Formula in cell C6: =TBILLPRICE(C2,C3,C4) Excel Function [โฆ]

How to use the TBILLYIELD function

The TBILLYIELD function calculates the yield for a Treasury bill. Formula in cell C6: =TBILLYIELD(C2,C3,C4) Excel Function Syntax TBILLYIELD(settlement, maturity, [โฆ]

How to use the DOLLARFR function

The DOLLARFR function converts a decimal number to its equivalent in fractional numbers, used in securities denominated in dollars. Excel [โฆ]

How to use the CUMIPMT function

The CUMIPMT function calculates the accumulated interest based on a start and end period on a loan. The image above shows [โฆ]

How to use the CUMPRINC function

The CUMPRINC function calculates the accumulated principal based on a start and end period on a loan. The image above shows [โฆ]

How to use the IPMT function

The IPMT function calculates the interest payment for a specific period for an investment based on repeated constant payments and a [โฆ]

How to use the PPMT function

The PPMT function calculates the principal payment for a specific period for an investment based on repeated constant payments and a [โฆ]

How to use the DB function

The DB function calculates the depreciation of an asset for a given period using the fixed-declining balance method. Formula in [โฆ]

How to use the PRICEMAT function

The PRICEMAT function calculates the price per \$100 nominal value of a bond that pays interest at maturity. Formula in [โฆ]

How to use the PMT function

The PMT function returns the payment amount needed for borrowing a fixed sum of money based on constant payments and [โฆ]

How to use the PDURATION function

The PDURATION function calculates how many periods required by an investment to reach a given amount based on a percentage [โฆ]

How to use the NOMINAL function

The NOMINAL function calculates the nominal annual interest rate based on the effective rate and the number of compounding periods [โฆ]

How to use the ACCRINTM function

The ACCRINTM function calculates the accrued interest for a security that pays interest at maturity. Formula in cell C7: =ACCRINTM(C2,C3,C4,C5,C6) [โฆ]

How to use the ACCRINT function

The ACCRINT function calculates the accrued interest for a security that pays periodic interest. Formula in cell C9: =ACCRINT(C2,C3,C4,C5,C6,C7,C8) Excel [โฆ]

How to use the EFFECT function

The EFFECT function calculates the effective annual interest rate, given the nominal annual interest rate and the number of compounding [โฆ]

How to use the ISPMT function

The ISPMT calculates the interest paid during a specific period of an investment. Formula in cell B3: =ISPMT(0.1/12,1,4*12,10000) Excel Function [โฆ]

How to use the RATE function

The RATE function returns the interest rate per period of an annuity. Formula in cell E3: =RATE(B3,C3,D3) Excel Function Syntax [โฆ]

How to use the FV function

The FV function returns the future value of an investment based on a constant interest rate. You can use FV [โฆ]