YIELDDISC
A
C
- CALCULATE
- CALCULATETABLE
- CALENDAR
- CALENDARAUTO
- CEILING
- CHISQ.DIST
- CHISQ.DIST.RT
- CHISQ.INV
- CHISQ.INV.RT
- CLOSINGBALANCEMONTH
- CLOSINGBALANCEQUARTER
- CLOSINGBALANCEYEAR
- COALESCE
- COLUMNSTATISTICS
- COMBIN
- COMBINA
- COMBINEVALUES
- CONCATENATE
- CONCATENATEX
- CONFIDENCE.NORM
- CONFIDENCE.T
- CONTAINS
- CONTAINSROW
- CONTAINSSTRING
- CONTAINSSTRINGEXACT
- CONVERT
- COS
- COSH
- COT
- COTH
- COUNT
- COUNTA
- COUNTAX
- COUNTBLANK
- COUNTROWS
- COUNTX
- COUPDAYBS
- COUPDAYS
- COUPDAYSNC
- COUPNCD
- COUPNUM
- COUPPCD
- CROSSFILTER
- CROSSJOIN
- CUMIPMT
- CUMPRINC
- CURRENCY
- CURRENTGROUP
- CUSTOMDATA
D
E
I
N
O
P
R
S
- SAMEPERIODLASTYEAR
- SAMPLE
- SEARCH
- SECOND
- SELECTCOLUMNS
- SELECTEDMEASURE
- SELECTEDMEASUREFORMATSTRING
- SELECTEDMEASURENAME
- SELECTEDVALUE
- SIGN
- SIN
- SINH
- SLN
- SQRT
- SQRTPI
- STARTOFMONTH
- STARTOFQUARTER
- STARTOFYEAR
- STDEVX.P
- STDEVX.S
- STDEV.P
- STDEV.S
- SUBSTITUTE
- SUBSTITUTEWITHINDEX
- SUM
- SUMMARIZE
- SUMMARIZECOLUMNS
- SUMX
- SWITCH
- SYD
T
U
Understanding the YIELDDISC Function
The YIELDDISC function calculates the yield of a security that has a discount at maturity. It takes four arguments: settlement, maturity, pr, and redemption. The settlement argument is the date on which the security is purchased. The maturity argument is the date on which the security matures. The pr argument is the price per $100 face value of the security. The redemption argument is the redemption value per $100 face value of the security at maturity.
The function returns the yield of the security as a decimal number. The yield is the annual interest rate that the security would have if it were sold at the current market price.
Using the YIELDDISC Function in Power BI
To use the YIELDDISC function in Power BI, you must first create a table or import a table that contains the settlement, maturity, pr, and redemption values for the securities you want to analyze.
Once you have the table, you can create a measure that uses the YIELDDISC function to calculate the yield for each security. To create the measure, follow these steps:
1. Open Power BI and go to the “Data” tab.
2. Select the table that contains the settlement, maturity, pr, and redemption values for the securities you want to analyze.
3. Click on the “New Measure” button in the “Modeling” tab.
4. In the formula bar, enter the following formula:
YieldDISC = YIELDDISC(Table[Settlement], Table[Maturity], Table[Pr], Table[Redemption])
5. Replace "Table" with the name of your table.
6. Click "Enter" to create the measure.
Once you have created the measure, you can use it in visualizations and reports to analyze the yield of your securities.
Examples of Using the YIELDDISC Function
To better understand how to use the YIELDDISC function in Power BI, let's look at a few examples:
Example 1: Calculating Yield for a Single Security
Suppose you have a security with the following details:
- Settlement date: 1/1/2020
- Maturity date: 12/31/2020
- Price per $100 face value: $98
- Redemption value per $100 face value: $100
To calculate the yield of this security using the YIELDDISC function, you would enter the following formula in the formula bar:
YieldDISC = YIELDDISC(1/1/2020, 12/31/2020, 98, 100)
The function would return the yield of the security as a decimal number.
Example 2: Calculating Yield for Multiple Securities
Suppose you have a table that contains the settlement, maturity, pr, and redemption values for multiple securities. To calculate the yield for each security using the YIELDDISC function, you would create a measure using the formula we discussed earlier. You could then use the measure in a table visualization to display the yield for each security.
The YIELDDISC function is a powerful tool for calculating the yield of securities that have a discount at maturity. By following the steps we discussed in this article, you can easily use the function in Power BI to analyze your securities and make informed investment decisions.
