The YIELD function returns the yield on a security that pays periodic interest. In the example shown, the formula in F6 is:
=YIELD(C9,C10,C7,F5,C6,C12,C13)
with these inputs, the YIELD function returns 0.08 which, or 8.00% when formatted...Read more
The Excel TBILLEQ function returns the bond-equivalent yield for a Treasury bill, based on a settlement date, a maturity date, and a discount rate. In the example shown, the settlement date is 5-Feb-2019, the maturity date is 1-Feb-2020, and the discount rate is 2.54...Read more
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