Skip navigation

Calculating the price for a Treasury bill (TBILLPRICE)

Calculating the price for a Treasury bill (TBILLPRICE): Excel 2013: Financial Functions in Depth
Calculating the price for a Treasury bill (TBILLPRICE): Excel 2013: 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
19,326
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