Skip navigation

TBILLPRICE: Calculating the price for a Treasury bill

TBILLPRICE: Calculating the price for a Treasury bill: Excel 2016: Financial Functions in Depth
TBILLPRICE: Calculating the price for a Treasury bill: Excel 2016: Financial Functions in Depth

When you evaluate a Treasury bill, or T-bill, you should determine the fair market value of the investment. In Excel, you can use the TBILLPRICE function to find that value. If you evaluate a T-bill and your formula displays a NUM error, you should check your settlement date and maturity date. T-bills have a life of one year or less, so you might have entered a date incorrectly.

Resume Transcript Auto-Scroll
Skill Level Intermediate
2h 38m
Duration
195,725
Views
Show More Show Less
Skills covered in this course
Business Spreadsheets Excel Microsoft Office

Continue Assessment

You started this assessment previously and didn't complete it. You can pick up where you left off, or start over.

Start My Free Month

Start your free month on LinkedIn Learning, which now features 100% of Lynda.com courses. Develop in-demand skills with access to thousands of expert-led courses on business, tech and creative topics.

Start My Free Month

You are now leaving Lynda.com and will be automatically redirected to LinkedIn Learning to start your free trial.