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.

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 =

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.

none

explanation:

we're are the selections to pick from?

answer the law of increasing costs;