A t bill yield calculator Singapore investors can use turns the cut-off yield of a Treasury bill auction into a price per S$100, the amount you pay, and the return you earn by holding the bill to maturity. You can also enter a price and find the yield it implies.
How to use the t bill yield calculator singapore
- Choose whether to work out the price from the yield or the yield from the price.
- Enter the cut-off yield or the price, and the days to maturity.
- Enter the amount you apply for, in multiples of S$1,000.
- Press Calculate and read the price, the cost and the return.
How a Treasury bill is priced
A Singapore Treasury bill is sold at a discount to its face value and repaid at face value when it matures. The MAS T-bills FAQ gives the formula: the discount D equals the days to maturity divided by 365, times the yearly discount rate R, and the price P per S$100 of face value is S$100 minus D [1]. The yield quoted at the auction is that discount rate.
A worked example from MAS
The MAS FAQ uses a bill with 182 days to maturity and a yield of 4.00 percent. The discount is 182 divided by 365 times 4, which is 1.9945, so the price is S$98.005 per S$100. An allotment of S$1,000 therefore costs S$980.05 [1]. The calculator reproduces this figure. MAS says the cut-off price is shown to three decimals, and that competitive yield bids are made to two decimals [1].
Tenors, amounts and the auction
MAS says Treasury bills for individuals come in 6-month and 1-year tenors, with a minimum of S$1,000 and further amounts in multiples of S$1,000. The auction is a uniform price auction, so every successful bidder pays the same cut-off price, and non-competitive bids go up to S$1 million per auction [2]. Allotments are in denominations of S$1,000 [1]. The tool therefore asks for a multiple of S$1,000.
Why the yield is not the return
The cut-off yield is a discount rate, measured against the face value, while you pay less than the face value. The return on the money you actually pay is a little higher. For the example, the discount of S$1.995 on a price of S$98.005 is a return of 2.036 percent over 182 days. Scaled to a year at 365 days, that is about 4.08 percent. This arithmetic is our own working, and the compounded yearly figure would be a little higher still.
Finding the yield from a price
If you know the price, for instance from a bank quote, switch the mode. The tool takes the discount, which is S$100 minus the price, divides it by the days, and multiplies by 365 to give the yearly discount rate. A price of S$98.005 over 182 days gives 4.00 percent. Because the price is rounded to three decimals, the yield found back can differ from the quoted one in the third decimal.
Days to maturity
The number of days depends on the auction. A 6-month bill is about 182 days and a 1-year bill about 364 days, but the pages we read do not state the exact count, so you enter the days from the auction notice. The tool accepts up to 400 days.
What the tool does not do
It does not use live data, so you type the yield from the latest auction result. It does not include bank fees or any difference between a competitive and a non-competitive bid, and a non-competitive bid gets the cut-off price [1]. Tax is not considered.
Checking the result
The price follows the MAS formula, so it should match the auction result for the same yield and days. The return lines are our own working. Always confirm the price and the allotment with MAS or the bank or broker you use before you apply.
A second worked example
This example is our own working from the MAS formula. Take a 1-year bill of 364 days with a yield of 3.50 percent. The discount is 364 divided by 365 times 3.5, which is 3.4904, so the price is S$96.510 per S$100. An application for S$5,000 costs S$4,825.50, and the discount earned is S$174.50. The return on the amount paid is 3.616 percent over 364 days, which scales to about 3.63 percent a year on a 365-day basis.
Reading the lines
The price line is the figure that follows the MAS formula. The amount you pay is the application amount times the price divided by 100. The discount earned is what you receive at maturity, which is the face value, minus what you paid. The return lines are extra information that MAS does not give, so they are marked as our own working.
Comparing bills
Because the yield is quoted on the face value, two bills with the same yield and different tenors have different prices. A longer bill has a bigger discount, so it costs less per S$100, and the calculator lets you test that by changing the days while keeping the yield.
Common mistakes
- Treating the yield as the return. The yield is a discount rate, so the return on the price you pay is higher.
- Using months instead of days. The formula uses days divided by 365, so enter the days from the notice.
- Entering an amount that is not a multiple of 1,000. Allotments are in S$1,000 lots, so the tool asks for one.
- Using an old yield. The cut-off yield changes at every auction, so use the latest result.
What next
Use this often? Add Singapore T- to your Home screen.
Frequently asked questions
How does the t bill yield calculator singapore find the price?
It uses the MAS formula: the discount is days divided by 365 times the yield, and the price per S$100 is 100 minus the discount, rounded to three decimals.
Does the calculator reproduce the MAS example?
Yes. For 182 days at 4.00 percent it gives a price of S$98.005, so S$1,000 costs S$980.05.
Is the cut-off yield the same as my return?
No. The yield is a discount rate on the face value. The return on the amount you pay is a little higher, and the tool shows it as our own working.
What amounts can I apply for?
MAS says the minimum is S$1,000, in multiples of S$1,000, and non-competitive bids can go up to S$1 million per auction.
Why do I have to type the yield and the days?
The tool has no live data. The yield changes at each auction and the days are in the auction notice.
Sources
Was this tool helpful?
What went wrong?
We only receive the reason you pick, never what you typed into the tool.
Thanks for your feedback.