TBILLPRICE function - The function calculates the value of treasury bonds by the $ 100 face value in Excel
The following article details the meaning and usage of the TBILLPRICE function - The function of calculating the value of treasury bonds at $ 100 face value in excel.
Description: The function calculates a value based on the $ 100 face value for treasury bonds.
Syntax : = TBILLPRICE (settlement, maturity, discount) .
Inside:
- settlement : The settlement date for securities is the date after the issuance date of bonds to be sold to buyers.
- maturity : The maturity date or the maturity date of the bond.
- discount : The discount rate or the rate of return on bonds.
Attention:
- Functions that perform calculations based on formulas:
In which: DSM is the number of days from the settlement to the expiry date.
- If maturity > discount or discount - maturity > 12 months -> the function returns the error value NUM!
- Where maturity and discount are not valid dates -> the function returns the value #VALUE.
For example:
Calculating the value of bonds with settlement date is 1/1/2016, maturity date is 1/12/2016 and discount rate is 8.9%.
In the cell where the value to enter the formula to calculate: = TBILLPRICE (B6, C6, D6) .
Press Enter -> value of the bond based on face value of $ 100 with an 8.9% discount rate is:
If you enter due date - settlement date> 12 months, the function returns the #NUM error value .
Above is the usage and some notes when using the TBILLPRICE function .
Good luck!
You should read it
- How to use the DAVERAGE function in Excel
- How to use SUMPRODUCT function in Excel
- DB function - The function calculates the depreciation of assets with specific maturity in Excel
- Basic Excel functions that anyone must know
- How to use the SUM function to calculate totals in Excel
- VAR.S function - Function that calculates variance based on a sample, ignoring logical values and text in Excel
- VAR.P function - Function that calculates variance based on the entire set, ignoring logical values and text in Excel
- NPER function - The function calculates the period number of an investment in Excel
May be interested
- NPER function - The function calculates the period number of an investment in Excelcalculating interest rates for securities are usually calculated by period. so if you are a stock player, please know this calculation offline to be able to actively calculate the interest received. the following article shows how to use the nper function to calculate the number of periods for an investment.
- DATEDIF function - The function calculates the number of days, months, years between 2 dates in Exceldatedif function: the function performs the calculation of number of days, months, years between 2 dates in excel. functions are useful in formulas for calculating age numbers. syntax: datedif (start_date, end_date, unit)
- FREQUENCY function - Function that calculates and returns the frequency of occurrences of values in a range in Excelfrequency function: function that calculates and returns the frequency of occurrences of values within a certain range and returns a vertical number array. syntax: frequency (data_array, bins_array)
- Coupdays function - Calculates the number of days in a coupon period and contains the settlement date in Excelthe following article details how to use the coupdays function in excel. function meaning: the coupdays function calculates the number of days in the coupon period and contains the settlement date. syntax: coupdays (settlement, maturity, frequency, [basis]).
- CUMPRINC function - The function calculates the cumulative capital amount payable in Excelthe following article shows how to use the cumprinc function to help you calculate by calculating the cumulative capital amount to pay.
- VARPA function - Function that calculates variance based on the entire set, including logical values and text in Excelvarpa function: function that calculates variance based on the entire set, including logical values and text. syntax: varpa (value1, [value2], ...)
- The SUMIFS function, how to use multiple conditional calculation functions in Excelthe sumifs function in excel calculates multiple conditions, combining multiple conditions.
- SUBTOTAL function - The calculation function for a group in a list in Excelsubtotal function: a function that calculates a subgroup in a book set or a data table depending on the calculation involving the first parameter.
- Basic Excel functions that anyone must knowthe basic functions in excel such as the excel function, the excel statistics function we summarized below will be very helpful for you who often have to work on excel spreadsheets, especially in the field of accounting. let's refer to offline.
- ISPMT function - The function that calculates interest for a specified period in Excelispmt function - the function that calculates interest for a specified period in excel