## YIELDMAT

Function Type: Financial Description: Returns the annual yield of a security that pays interest at maturity. Function Structure: =YIELDMAT(settlement, maturity, issue, pr, [basis]). Argument Breakdown: settlement – This is the settlement date of the security. The date should be after the issue date when the security is traded to the buyer. maturity – The maturityContinue reading “YIELDMAT”

## YIELDDISC

Function Type: Financial Description: Returns the annual yield for a discounted security; for example, a Treasury bill. Function Structure: =YIELDDISC(settlement, maturity, pr, redemption, [basis]). Argument Breakdown: settlement – This is the settlement date of the security. It is a date after the security is traded to the buyer – that is, after the issue date.Continue reading “YIELDDISC”

## YIELD

Function Type: Financial Description: Returns the yield on a security that pays periodic interest. Function Structure: =YIELD(settlement, maturity, rate, pr, redemption, frequency, [basis]). Argument Breakdown: settlement – This is the settlement date of the security. It is a date after the security is traded to the buyer that is after the issue date. maturity –Continue reading “YIELD”

## XIRR

Function Type: Financial Description: Returns the internal rate of return for a schedule of cash flows that is not necessarily periodic. Function Structure: =XIRR(values, date, [guess]). Argument Breakdown: values – This is the array of values that represent the series of cash flows. Instead of an array, it can be a reference to a rangeContinue reading “XIRR”

## VDB

Function Type: Financial Description: Returns the depreciation of an asset for a specified or partial period by using a declining balance method. Function Structure: =VDB(cost, salvage, life, start_period, end_period, [factor], [no_switch}). Argument Breakdown: cost – Initial cost of the asset. salvage – Asset value at the end of depreciation. life – Periods over which assetContinue reading “VDB”

## TBILLYIELD

Function Type: Financial Description: Returns the yield for a Treasury bill. Function Structure: =TBILLYIELD(settlement, maturity, pr). Argument Breakdown: settlement – Settlement date of the security. maturity – Maturity date of the security. pr – Price per \$100. Example: If you need instant expert help with Excel or Google Sheets, please visit my fiverr gig. Back toContinue reading “TBILLYIELD”

## TBILLPRICE

Function Type: Financial Description: Returns the price per \$100 face value for a Treasury bill. Function Structure: =TBILLPRICE(settlement, maturity, discount). settlement – Settlement date of the security. maturity – Maturity date of the security. discount – The discount rate for the security. Example: If you need instant expert help with Excel or Google Sheets, pleaseContinue reading “TBILLPRICE”

## TBILLEQ

Function Type: Financial Description: Returns the bond-equivalent yield for a Treasury bill. Function Structure: =TBILLEQ(settlement, maturity, discount). Argument Breakdown: settlement – Settlement date of the security. maturity – Maturity date of the security. discount – Discount rate of the security. Example: If you need instant expert help with Excel or Google Sheets, please visit my fiverrContinue reading “TBILLEQ”

## SYD

Function Type: Financial Description: Returns the sum-of-years’ digits depreciation of an asset for a specified period. Function Structure: =SYD(cost, salvage, life, per). Argument Breakdown: cost – Initial cost of the asset. salvage – Asset value at the end of the depreciation. life – Periods over which asset is depreciated. per – Period to calculation depreciationContinue reading “SYD”