Skip navigation

On September 14th, 2017, we published revised versions of our Privacy Policy, Terms of Service and Website Use Policy and published a Cookie Policy. Your continued use of Lynda.com means you agree to these revised documents, so please take a few minutes to read and understand them.

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
107,347
Views
Show More Show Less
Skills covered in this course
Business Spreadsheets Excel

Continue Assessment

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

Start Your Free Trial Now

Start your free trial now, and begin learning software, business and creative skills—anytime, anywhere—with video instruction from recognized industry experts.

Start Your Free Trial Now