The Excel TBILLYIELD function returns the yield for a Treasury bill, based on a settlement date, a maturity date, and a price per $100. In the example shown, the settlement date is 5-Feb-2019, the maturity date is 1-Feb-2020, and the price per $100 is 97.54. The formula in F5 is:
...Read more
The TBILLPRICE function returns the price per $100 face value for a Treasury bill, based on a settlement date, a maturity date, and a discount. In the example shown, the settlement date is 5-Feb-2019, the maturity date is 1-Feb-2020, and the discount is 2.45%. The formula in F5 is:
...Read more
Some bonds have an irregular first or last period, so interest payments don't fit a normal schedule. To calculate the price of a bond with an irregular last period, you can use the ODDLPRICE function. The ODDLPRICE Function returns the price per $100 face value of a security having a short or...Read more
Some bonds have an irregular first or last period, so interest payments don't fit a normal schedule. To calculate the price of a bond with an irregular first period, you can use the ODDFPRICE function. The ODDFPRICE Function returns the price per $100 face value of a security having an irregular...Read more
The Excel PRICEDISC function returns the price per $100 face value of a discounted security. In the example shown, the formula in F5 is:
=PRICEDISC(C6,C7,C8,C9,C10)
with these inputs, PRICEDISC returns a price for the bond of $82.50....Read more
The Excel PRICEMAT function returns the price per $100 face value of a security that pays interest at maturity. In the example shown, the formula in F5 is:
=PRICEMAT(C5,C6,C7,C8,C9,C10)
with these inputs, PRICEMAT returns a price...Read more
This formula concatenates the original value in column B to a string of asterisks (*) assembled with the REPT function so that the final result is always 12 characters:
REPT("*",12-LEN(B5))
Inside the REPT function, the text to repeat is...Read more
This formula uses boolean logic to output a conditional message. If the value in column C is less than 100, the formula returns "low". If not, the formula returns an empty string ("").
Boolean logic is a technique of handling TRUE and FALSE values...Read more
This formula uses structured references to refer to the "Amount" column in each table. The structured references in this formula resolve to normal references like this:
=SUM(Table1[Amount],Table2[Amount])
=SUM(C7...Read moreThe Excel PRICE function returns the price per $100 face value of a security that pays periodic interest. For example, the PRICE function can be used to determine the "clean price" of a bond (also known as the quoted price), which is the price of the bond excluding accrued interest.
In...Read more