Excel Yield Function is used to calculate on a security or a bond which pays the interest periodically, the yield is …
Category: Financial functions
The Excel YIELDDISC function returns the annual yield for a discounted security, such as a Treasury bill, that is issued …
The Excel XIRR function is a financial function that returns the internal rate of return (IRR) for a series of …
The Excel XNPV function is a financial function that calculates the net present value (NPV) of an investment using a …
The Excel VDB function returns the depreciation of an asset for given period, using the double-declining balance method or another method …
The Excel TBILLYIELD function returns the yield for a Treasury bill. Syntax:= TBILLYIELD (settlement, maturity, price) The TBILLYIELD function syntax …
The Excel TBILLEQ function returns the bond-equivalent yield for a Treasury bill. Syntax: TBILLEQ (settlement, maturity, discount) The TBILLEQ function …
The Excel TBILLPRICE function returns the price per $100 face value for a Treasury bill Syntax:= TBILLPRICE (settlement, maturity, discount) …
The Excel RRI function returns an equivalent interest rate for the growth of an investment. You can use RRI to …
The Excel RECEIVED function returns the amount received at maturity for a fully invested security. Syntax:=RECEIVED (settlement, maturity, investment, discount, …