Categories
Excel Macros Microsoft Office

TBILLPRICE function in Excel

[ad_1]

In Excel, there are many calculation functions, serving in fields such as statistics, mathematics, securities, treasury … And the TBILLPRICE function in Excel is one of the functions used by many users to calculate the value. of Treasury bonds at $ 100 face value.


As the introduction says, TBILLPRICE function in Excel is the calculation function to return the value of a bond in the treasury based on the $ 100 face value.

Ham tbillprice in excel

TBILLPRICE function in Excel

How to use the TBILLPRICE function in Excel

1. Description and syntax used

This is a function that calculates a value based on the $ 100 face value for treasury bonds.

Syntax:

TBILLPRICE (settlement, maturity, discount)

Inside:

Settlement: The settlement date of the securities is the date after the issuance date of bonds to be sold to buyers.

Maturity: Expiry date or maturity date of the bond.

Discount: The discount rate or the rate of return on the bond.

Attention:

– Functions that perform calculations based on formulas:

Ham tbillprice in excel 2

In which: DSM is the number of days from settlement to expiry.

– If Maturity> Discount or Discount – Maturity> 12 months -> function returns error value #NUM!

– Case Maturity and Discount not valid date -> function returns value #VALUE.

– If Discount ≤ 0 -> function returns error value #NUM!

2. Examples of specific situations

Suppose you need to calculate the value of a bond with the settlement date of January 1, 2018, the maturity date of December 1, 2018, and the discount rate of 8.5%.

Ham tbillprice in excel 3

Step 1: In the cell to calculate the value -> you enter the formula: = TBILLPRICE (A3, B3, C3)

Ham tbillprice in excel 4

Step 2: Press Enter -> The value of the bond is based on face value of $ 100 with a discount rate of 8.5% as:

Ham tbillprice in excel 5

Where if you enter Due date – Settlement date> 12 months The function returns the error value #NUM!

Ham tbillprice in excel 6

Where if Maturity and Discount is not a valid date -> function returns value #VALUE.

Ham tbillprice in excel 7

If Discount ≤ 0 ->, the function returns the error value #NUM!

Ham tbillprice in excel 8

https://thuthuat.taimienphi.vn/ham-tbillprice-in-excel-43740n.aspx
Above is the usage and some special cases of TBILLPRICE function in Excel. Use this function to help you calculate values ​​based on $ 100 face value for treasury bonds. Good luck!

.

[ad_2]

Leave a Reply

Your email address will not be published. Required fields are marked *