Question
In: Finance
Henry is planning to purchase a Treasury bond with a coupon rate of 2.12% and face...
Henry is planning to purchase a Treasury bond with a coupon rate of 2.12% and face value of $100. The maturity date of the bond is 15 May 2033.
(a) If Henry purchased this bond on 5 May 2018, what is his purchase price (rounded to four decimal places)?
Assume a yield rate of 3.62% p.a. compounded half-yearly.
Solutions
Expert Solution
The purchase price of bond can be calculated using the PRICE function in spreadsheet
PRICE(settlement, maturity, rate, yield, redemption, frequency, [day_count_convention])
Where, settlement - The settlement date of the security, the date after issuance when the security is delivered to the buyer = 5 May 2018
maturity - The maturity or end date of the security, when it can be redeemed at face or par value = 15 May 2033
rate - The annualized coupon rate = 2.12%
yield - The expected annual yield of the security = 3.62%
redemption - The redemption amount per 100 face value = $100
frequency - The number of interest or coupon payments per year = 2 (US treasury bond has semi-annual coupon frequency)
day_count_convention - An indicator of what day count method to use = 1 (US treasury bond uses ACT/ACT day count convention)
Purchase price of bond = PRICE(5 May 2018, 15 May 2033, 2.12%, 3.62%, 100, 2, 1) = $82.7310
jeff jeffy answered 1 year agoRelated Solutions
Henry is planning to purchase a Treasury bond with a coupon rate of 1.69% and face...
Henry is planning to purchase a Treasury bond with a coupon rate
of 1.69% and face value of $100. The maturity date of the bond is
15 May 2033.
(b) If Henry purchased this bond on 2 May 2018, what is his
purchase price (rounded to four decimal places)? Assume a yield
rate of 3.97% p.a. compounded half-yearly. Henry needs to pay 23.2%
on coupon payment as tax payment and tax are paid immediately.
Select one:
a. 70.5649
b. 70.5665...
Henry is planning to purchase a Treasury bond with a coupon rate of 3.02% and face...
Henry is planning to purchase a Treasury bond with a coupon rate
of 3.02% and face value of $100. The maturity date of the bond is
15 May 2033. (a) If Henry purchased this bond on 3 May 2018, what
is his purchase price (rounded to four decimal places)? Assume a
yield rate of 2.39% p.a. compounded half-yearly.
Select one:
a. 107.8175
b. 109.3277
c. 109.3263
d. 109.11
Henry is planning to purchase a Treasury bond with a coupon rate of 3.02% and face...
Henry is planning to purchase a Treasury bond with a coupon rate
of 3.02% and face value of $100. The maturity date of the bond is
15 May 2033. (b) If Henry purchased this bond on 3 May 2018, what
is his purchase price (rounded to four decimal places)? Assume a
yield rate of 2.39% p.a. compounded half-yearly. Henry needs to pay
21.8% on coupon payment as tax payment and tax are paid
immediately.
Select one:
a. 100.7470
b. 100.7556...
Henry is planning to purchase a Treasury bond with a coupon rate of 2.22% and face...
Henry is planning to purchase a Treasury bond with a coupon rate
of 2.22% and face value of $100. The maturity date of the bond is
15 May 2033.
(b) If Henry purchased this bond on 4 May 2018, what is his
purchase price (rounded to four decimal places)? Assume a yield
rate of 1.84% p.a. compounded half-yearly. Henry needs to pay 28.3%
on coupon payment as tax payment and tax are paid immediately.
Select one: a. 97.5012 b. 97.5946...
Henry is planning to purchase a Treasury bond with a coupon rate of 3.48% and face...
Henry is planning to purchase a Treasury bond with a coupon rate
of 3.48% and face value of $100. The maturity date of the bond is
15 May 2033. (a) If Henry purchased this bond on 6 May 2018, what
is his purchase price (rounded to four decimal places)? Assume a
yield rate of 4.61% p.a. compounded half-yearly.
Henry is planning to purchase a Treasury bond with a coupon rate of 2.22% and face...
Henry is planning to purchase a Treasury bond with a coupon rate
of 2.22% and face value of $100. The maturity date of the bond is
15 May 2033.
(c) If Henry purchased this bond on 4 May 2018, what is his
purchase price (rounded to four decimal places)? Assume a yield
rate of 1.84% p.a. compounded half-yearly. Henry needs to pay 28.3%
on coupon payment and capital gain as tax payment. Assume that all
tax payments are paid immediately....
Henry is planning to purchase a Treasury bond with a coupon rate of 2.67% and face...
Henry is planning to purchase a Treasury bond with a coupon rate
of 2.67% and face value of $100. The maturity date of the bond is
15 May 2033.
(c) If Henry purchased this bond on 2 May 2018, what is his
purchase price (rounded to four decimal places)? Assume a yield
rate of 4.80% p.a. compounded half-yearly. Henry needs to pay 28.3%
on coupon payment and capital gain as tax payment. Assume that all
tax payments are paid immediately....
Henry is planning to purchase a Treasury bond with a coupon rate of 4.86% and face...
Henry is planning to purchase a Treasury bond with a coupon rate
of 4.86% and face value of $100. The maturity date of the bond is
15 May 2033.
(a) If Henry purchased this bond on 6 May 2018, what is his
purchase price (rounded to four decimal places)? Assume a yield
rate of 4.35% p.a. compounded half-yearly.
(b) If Henry purchased this bond on 6 May 2018, what is his
purchase price (rounded to four decimal places)? Assume a...
Henry is planning to purchase a Treasury bond with a coupon rate of 2.05% and face...
Henry is planning to purchase a Treasury bond with a coupon rate
of 2.05% and face value of $100. The maturity date of the bond is
15 May 2033. (a) If Henry purchased this bond on 7 May 2018, what
is his purchase price (rounded to four decimal places)? Assume a
yield rate of 2.31% p.a. compounded half-yearly.
(a) If Henry purchased this bond on 7 May 2018, what is his
purchase price (rounded to four decimal places)? Assume a...
Henry is planning to purchase a Treasury bond with a coupon rate of 4.71% and face...
Henry is planning to purchase a Treasury bond with a coupon rate
of 4.71% and face value of $100. The maturity date of the bond is
15 May 2033.
(a) If Henry purchased this bond on 3 May 2018, what is his
purchase price (rounded to four decimal places)? Assume a yield
rate of 3.12% p.a. compounded half-yearly.
(b) If Henry purchased this bond on 3 May 2018, what is his
purchase price (rounded to four decimal places)? Assume a...
ADVERTISEMENT
ADVERTISEMENT
Latest Questions
- There are a large number of tasks involved in information technology and programming, and many of...
- Using one quantitative and one qualitative health policy research method described in this chapter, design a...
- What is the Rawls' solution to the age-old question of social (economic / distributive) justice?...
- St. Johns River Shipyards' welding machine is 15 years old, fully depreciated, and has no salvage...
- The following information is available for Robstown Corporation for 20Y8: Inventories January 1 December 31 Materials...
- /* Complete the TO DO comments below */ window.onload = function() { /* TODO add a...
- Trevor Price bought 10-year bonds issued by Harvest Foods five years ago for $4,532.35. The bonds...
ADVERTISEMENT