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
- Computation of deferred taxes under IFRS is slightly different from GAAP. For example, in the United...
- How has technology improved the following job training methods: Internships (3) Business games (3)...
- do you think that the company is wise to monitor employees in this matter? why or...
- The function print_mean() that you wrote in the previous lesson calculates an average value and prints...
- Describe Samsung's vertical integration as it relates to the 5 stages of forward and backward vertical...
- UPS is being valued. The following assumptions have been made: BV per share is estimated at...
- The assignment requires me to create a PESTLE analysis for a business idea that I created...
ADVERTISEMENT