please help. please answer in excel and show formulas.

Metro Company purchased $200,000, 7.5%, 5-year bonds on January 1, 20x1 when the market yield was 8.4%. Interest is payable on June 30 and December 31. The market value on December 31, 20x1 was $195,000. All bonds were sold for $197,500 on January 1, 20x2. A broker's fee of $1,500 was paid when sold. Metro is a calendar year company in which its fiscal year ends on December 31.

Required:

1. Using the Excel, compute the purchase price of the bonds.

2. Using the Excel, prepare the amortization schedule for 5 years. Make sure to come up with the face value at maturity, $200,000.

3. Prepare the journal entries on January 1, 20x1, June 30, 20x1, December 31, 20x1 and January 1, 20x2 assuming the bond investment is classified as

(Trading Security)

1/1/20x1 (Investment). Premium or Discount account is not used.

6/30/20x1 (Cash receipt)

12/31/20x1

1) Cash receipt

2) Market value adjustment, if any.

1/1/20x2 (Sale)

(Available for Sales Security)

1/1/20x1 (Investment). Premium or Discount account is not used.

6/30/20x1 (Cash receipt)

12/31/20x1

1) Cash receipt

2) Market value adjustment, if any.

1/1/20x2 (Sale)

(Held to Maturity Security)

1/1/20x1 (Investment). Premium or Discount account is not used.

6/30/20x1 (Cash receipt)

12/31/20x1

1) Cash receipt

2) Market value adjustment, if any.

1/1/20x2 (Sale)