Need help on the below question. I understand it has been answered already in Chegg, but I don't follow the formula for putting it in excel or understand how they arrived at the final answers. Thank you.

For each of the following required returns, calculate the bonds value, assuming annual interest. Indicate whether the bond will sell at a discount, at a premium, or at par value.

Required return is 6.0%.

Required return is 8.0%.

Required return is 10.0%.

***Updated info***

Evaluating Annie Heggs Proposed Investment In Atilier Industries Bonds. Annie Hegg has been considering investing in the bonds of Atilier Industries. The bonds were issued 5 years ago at their $1,000 par value and have exactly 25 years remaining until they mature. They have an 8.0% coupon interest rate, are convertible into 50 shares of common stock, and can be called any time at $1,080. The bond is rated Aa by Moodys. Atilier Industries, a manufacturer of sporting goods, recently acquired a small athletic-wear company that was in financial distress. As a result of the acquisition, Moodys and other rating agencies are considering a rating change for Atilier bonds. Recent economic data suggest that expected inflation, currently at 5.0% annually, is likely to increase to a 6.0% annual rate.