Lance Whittingham IV specializes in buying deep discount bonds. These represent bonds that are trading at well below par value. He has his eye on a bond issued by the Leisure Time Corporation. The $1,000 par value bond with semiannual payments has 4 percent annual interest and has 16 years remaining to maturity. The current yield to maturity on similar bonds is 10 percent.

A. What is the current price of the bonds?

B. By what percent will the price of the bonds increase between now and maturity?

C. What is the annual compound rate of growth in the value of the bonds? (An approximate answer is acceptable.)

I need help with setting he answers in excel, please