September 17, 2021

## How to use YIELD Function in Excel

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 …

## How to use YIELDDISC Function in Excel

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 …

## How to use XIRR Function in Excel

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 …

## How to use XNPV Function in Excel

The Excel XNPV function is a financial function that calculates the net present value (NPV) of an investment using a discount rate and a series …

## How to use VDB Function in Excel

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 …

## How to use TBILLYIELD Function in Excel

The Excel TBILLYIELD function returns the yield for a Treasury bill. Syntax:= TBILLYIELD (settlement, maturity, price) The TBILLYIELD function syntax has the following arguments: Settlement    Required. …

## How to use the Excel TBILLEQ function

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: …

## How to use TBILLPRICE Function in Excel

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 …

## How to use RRI Function in Excel

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 …

## How to use RECEIVED Function in Excel

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 …