Category: Financial functions

Excel Yield Function is used to calculate on a security or a bond which pays the interest periodically, the yield is a type of financial function …

The Excel YIELDDISC function returns the annual yield for a discounted security, such as a Treasury bill, that is issued at a discount but that …

The Excel XIRR function is a financial function that returns the internal rate of return (IRR) for a series of cash flows that occur at …

The Excel VDB function returns the depreciation of an asset for given period, using the double-declining balance method or another method specified by changing the factor argument. By …

The Excel TBILLEQ function returns the bond-equivalent yield for a Treasury bill. Syntax: TBILLEQ (settlement, maturity, discount) The TBILLEQ function syntax has the following arguments: …

The Excel TBILLPRICE function returns the price per $100 face value for a Treasury bill Syntax:= TBILLPRICE (settlement, maturity, discount) The TBILLPRICE function syntax has …

The Excel RRI function returns an equivalent interest rate for the growth of an investment. You can use RRI to calculate Compound Annual Growth Rate …

The Excel RECEIVED function returns the amount received at maturity for a fully invested security. Syntax:=RECEIVED (settlement, maturity, investment, discount, [basis]) The RECEIVED function syntax …