The Excel SLN function returns the depreciation of an asset for one period, calculated with a straight-line method. The calculated depreciation …
Category: Financial functions
The Excel RATE function is a financial function that returns the interest rate per period of an annuity. You can …
The Excel PV function is a financial function that returns the present value of an investment. You can use the …
The Excel PRICEMAT function returns the price per $100 face value of a security that pays interest at maturity. Syntax:= …
The Excel PRICEDISC function returns the price per $100 face value of a discounted security. Syntax:= PRICEDISC(settlement, maturity, discount, redemption, …
Price function in excel is a financial function in excel which is used to calculate the original value or the …
The Excel PPMT function can be used to calculate the principal portion of a given loan payment. For example, you …
The Excel PMT function is a financial function that returns the periodic payment for a loan. You can use the …
The Excel PDURATION function returns the number of periods required for an investment to reach a desired value. Syntax:= PDURATION …
The Excel ODDLYIELD function calculates the yield of a security with an odd (short or long) last period. Syntax:= ODDLYIELD …