how do we calculate T-bill Price in 365 days year.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

In Pakistan we calculate T- bill Prices on the basis of 365 yaers a day. In
the formual of T-bill Price the basis of 360 days a year. So we found an
error of calculation. Please advice me.
Regards
 
According to the Help file, the formula to calculate TBILLPRICE is:
100*(1-discount%*(Maturity Date - Settlement Date)/360).
Use this instead of the provided function and change 360 to 365.
 
Which method would be faster? One using raw Excel, or one going through an
addin function? Obviously it would depend on the user's needs.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to write XIRR formula on excel using different Year basis than 365. 5
Day Number For 365 Day Year 5
Interest and Payment Calculations 6
DAYS360 function for 365 day year 3
Excel PRICE function: How does it compute Issue Date of the Security 5
Calculate interest & withdrawals 0
I want the PMT function to calculate using 360 days not 365 5
Excel formula to incrementally increase a value by 1 every 365 day 2

Back
Top