An investor thought that market interest rates were going to decline. He paid $19,000 for a corporate bond with a face value of

Question

ivann1987 [24]

2 years ago

8

An investor thought that market interest rates were going to decline. He paid $19,000 for a corporate bond with a face value of

$20,000. The bond has an interest rate of 10% per year payable annually. If the investor plans to sell the bond immediately after receiving the 4th interest payment, how much will he have to receive in order to make a return of 14% per year? Solve using:
a. tabulated factors
b. the GOAL SEEK tool on a spreadsheet.

Business

1 answer:

almond37 [142] · Answer 1 · 2022-10-24T22:52:59+03:00

Answer:

Answer is explained in the explanation section below.

Explanation:

a. In this part, we need to calculate the present worth using the formula to calculate the sale price of the bond.

As the coupon rate = 10% per year

So,

The Annual dividend will = 2000 = 10% x 20,000

19000 = 2000 (P/A, 14%,4) + B(P/F,14%,4)

19000 = 2000 (2.9137) + B (0.592)

Solving for B = Desired sales price of the bond

B = $\frac{19000 - 5827.4}{0.592}$

B = 22251

b. Part b of this question is to solve using GOAL SEEK feature of a spreadsheet so, I have attached it in the attachment. Please refer to the attachment for the solution of part b.