Question

In: Finance

On Feb 1, 2019, the price of a T-bill maturing on July 31, 2019 is $96.98,...

On Feb 1, 2019, the price of a T-bill maturing on July 31, 2019 is $96.98, the price of a T-bill with maturity on Jan 31, 2020 is $97.11, and the price of a stripe with maturity on July 31 of 2020 is $97.76. A semiannual coupon treasury note that has the coupon rate 4.75% and will mature on July 31, 2020. What is the price of this T-note?

Solutions

Expert Solution

A B C D E F G H I J
2
3 Price of bond with face value F, years to maturity of n and yield of y can be written as follows:
4 Price of bond, P = F/ (1+y)n
5
6 For semi-annual bond,
7 Price of bond, P = F/ (1+y/2)2n
8
9 Using the above formula price of the bond P can be calculated as follows:
10
11 Year to maturity (n) Price Face Value Yield
12 0.5 $96.98 $100 6.23% =2*(((E12/D12)^(1/(2*C12)))-1)
13 1 $97.11 $100 2.95%
14 1.5 $97.76 $100 1.52%
15
16 Calculation of price of the coupon bond:
17
18 Face Value $1,000
19 Coupond rate 4.75%
20
21 Semi-annual coupon $47.50
22
23 Price of the T-note will be the present value of the future cash flows.
24
25 Cash Flow of the bond will be as follows:
26 Semi-annual period 0 1 2 3
27 Cash flow of the bond $47.50 $47.50 $1,047.50
28 Semi-annual yield 3.11% 1.48% 0.76%
29 Present Value of cash flows $46.07 $46.13 $1,024.04 =G27/((1+G28)^G26)
30 Price of the Bond $1,116.23 =SUM(E29:G29)
31
32 Hence the price of the bill is $1,116.23
33

Formula sheet

A B C D E F G H I J
2
3 Price of bond with face value F, years to maturity of n and yield of y can be written as follows:
4 Price of bond, P = F/ (1+y)n
5
6 For semi-annual bond,
7 Price of bond, P = F/ (1+y/2)2n
8
9 Using the above formula price of the bond P can be calculated as follows:
10
11 Year to maturity (n) Price Face Value Yield
12 0.5 96.98 100 =2*(((E12/D12)^(1/(2*C12)))-1) =getformula(F12)
13 1 97.11 100 =2*(((E13/D13)^(1/(2*C13)))-1)
14 1.5 97.76 100 =2*(((E14/D14)^(1/(2*C14)))-1)
15
16 Calculation of price of the coupon bond:
17
18 Face Value 1000
19 Coupond rate 0.0475
20
21 Semi-annual coupon =D18*D19
22
23 Price of the T-note will be the present value of the future cash flows.
24
25 Cash Flow of the bond will be as follows:
26 Semi-annual period 0 1 2 3
27 Cash flow of the bond =$D$21 =$D$21 =$D$21+D18
28 Semi-annual yield =F12/2 =F13/2 =F14/2
29 Present Value of cash flows =E27/((1+E28)^E26) =F27/((1+F28)^F26) =G27/((1+G28)^G26) =getformula(G29)
30 Price of the Bond =SUM(E29:G29) =getformula(D30)
31
32 Hence the price of the bill is =D30
33

Related Solutions

On March 15, 2018, the price of a T-bill maturing on Sep 15, 2018 is $97.28,...
On March 15, 2018, the price of a T-bill maturing on Sep 15, 2018 is $97.28, the price of a T-bill with maturity on March 15, 2019 is $97.67, and the price of a semiannual coupon (coupon rate 3.75%) treasury note that will mature on Sep 15, 2019 is $99.97. What is the price of a stripe with maturity on Sep 15 of 2019?
Find the following present values on October 31, 2020. a) Canadian T-bill maturing for $1.2 million...
Find the following present values on October 31, 2020. a) Canadian T-bill maturing for $1.2 million in 273 days based on a yield rate of 1.25% b) $10,000 due on March 31, 2025 at a force of interest of 5% c) $3,600 due on April 30, 2022 at a nominal rare of discount of 6%, compounded 6 times a year. d) Payments on $10,000 made every November 1 from 2020 to 2025 at 6.5% interest.
Price of T-Bill
What is the price of a T-Bill 98 days prior to maturity if the face amount is 100 and the yield (the simple interest rate) is 2.7% per annum.
Bill-Ross Corporation is a private corporation using ASPE. At July 31, 2019, an analysis of the...
Bill-Ross Corporation is a private corporation using ASPE. At July 31, 2019, an analysis of the accounts and discussions with company officials included the following account balances and other information: Supplies inventory 40,000 Purchase discounts 9,000 Accounts payable 30,000 Dividends declared and paid 16,000 Loss from fire (net of $4,000 tax) 12,000 Accounts receivable $102,000 Selling expenses 46,000 Common shares (20,000 issued; no change during 2017) 200,000 Accumulated depreciation 90,000 Long term note payable (due Oct 1, 2021) 100,000 Inventory,...
The HST/GST return is due on March 31, 2019 for reporting period Dec.1, 2018 to Feb....
The HST/GST return is due on March 31, 2019 for reporting period Dec.1, 2018 to Feb. 28, 2019.   Required: Round all answers to the nearest DOLLAR. –COMPLETE and HAND IN the ATTACHED WORKSHEETS Prepare the journal entries to record the payment/refund of GST/HST (see attachment 2) Sales information: Invoice amount Includes all applicable taxes, unless otherwise stated. Assume customers are in Ontario unless otherwise noted.                                                                                                                                                    Invoice Date   Invoice #        Customer Name                                                                                      Invoice Amount Dec. 4, 2018      11100       ...
On August 1, 2019, the accountant for Western Imports downloaded the company's July 31, 2019, bank...
On August 1, 2019, the accountant for Western Imports downloaded the company's July 31, 2019, bank statement from the bank's Website. The balance shown on the bank statement was $28,860. The July 31, 2019, balance in the Cash account in the general ledger was $13,202. Jenny Irvine, the accountant for Western Imports, noted the following differences between the bank's records and the company's Cash account in the general ledger: An electronic funds transfer for $15,400 from Foncier Ricard, a customer...
On August 1, 2019, the accountant for Western Imports downloaded the company's July 31, 2019, bank...
On August 1, 2019, the accountant for Western Imports downloaded the company's July 31, 2019, bank statement from the bank's Website. The balance shown on the bank statement was $28,670. The July 31, 2019, balance in the Cash account in the general ledger was $14,821. Jenny Irvine, the accountant for Western Imports, noted the following differences between the bank's records and the company's Cash account in the general ledger: An electronic funds transfer for $13,500 from Foncier Ricard, a customer...
On August 1, 2019, the accountant for Western Imports downloaded the company’s July 31, 2019, bank...
On August 1, 2019, the accountant for Western Imports downloaded the company’s July 31, 2019, bank statement from the bank’s website. The balance shown on the bank statement was $28,760. The July 31, 2019, balance in the Cash account in the general ledger was $14,042. Jenny Irvine, the accountant for Western Imports, noted the following differences between the bank’s records and the company’s Cash account in the general ledger: An electronic funds transfer for $14,600 from Foncier Ricard, a customer...
On August 1, 2019, the accountant for Western Imports downloaded the company's July 31, 2019, bank...
On August 1, 2019, the accountant for Western Imports downloaded the company's July 31, 2019, bank statement from the bank's Website. The balance shown on the bank statement was $28,770. The July 31, 2019, balance in the Cash account in the general ledger was $14,131. Jenny Irvine, the accountant for Western Imports, noted the following differences between the bank's records and the company's Cash account in the general ledger: An electronic funds transfer for $14,500 from Foncier Ricard, a customer...
On August 1, 2019, the accountant for Western Imports downloaded the company's July 31, 2019, bank...
On August 1, 2019, the accountant for Western Imports downloaded the company's July 31, 2019, bank statement from the bank's Website. The balance shown on the bank statement was $28,800. The July 31, 2019, balance in the Cash account in the general ledger was $13,798. Jenny Irvine, the accountant for Western Imports, noted the following differences between the bank's records and the company's Cashaccount in the general ledger: An electronic funds transfer for $14,800 from Foncier Ricard, a customer located...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT