Easy-to-follow video tutorials help you learn software, creative, and business skills.Become a member
When you evaluate a Treasury bill, you will occasionally know the start date, end date, and price but not the yield. If you know those first three values you can calculate the yield by using the TBILLYIELD function. To make that calculation you need to know three things. First is the settlement date and that is the date that you take possession of the investment. Then the maturity date which is the date that your original principle and any accrued interest is due to you. And then finally, you have the price.
So the price in this case is $97.50 and that is the amount that you need to pay to invest in this T-bill. And the redemption value is assumed to be $100. That's just an assumption that the function makes. So now, we can click in cell C8 and create our formula. So to start type an equal sign and then tbillyield, left parentheses, and then we can enter in the cell references for these values.
So settlement date is C3, comma, maturity date C4, comma, and the price is in C5. Type the right parentheses. Make sure that all of my arguments line up, they do and press Tab. When I do, we find out that the T- bill yield for this investment is 10.14%. As with the T-bill price function I covered in the last movie, you might find your formula displays a NUM error. If it does, check your settlement date and maturity date.
T-bills by definition have a life of one year or less, so you might have entered a date incorrectly.
Get unlimited access to all courses for just $25/month.Become a member
82 Video lessons · 70380 Viewers
80 Video lessons · 127582 Viewers
52 Video lessons · 62491 Viewers
59 Video lessons · 48198 Viewers
Access exercise files from a button right under the course name.
Search within course videos and transcripts, and jump right to the results.
Remove icons showing you already watched videos if you want to start over.
Make the video wide, narrow, full-screen, or pop the player out of the page into its own window.
Click on text in the transcript to jump to that spot in the video. As the video plays, the relevant spot in the transcript will be highlighted.
Your file was successfully uploaded.