show work on excel n formulas and please help me abswer all parts !

Problem 1 Hospital Corporation of America (HCA) is a for-profit American healthcare provider. The company has a series of $1,000 par value bonds outstanding. Each bond pays interest annually and carries an annual coupon rate of 6%. Some bonds are due in eight (8) years while others are due in twenty (20) years. If the yield-to-maturity (required rate of return on bonds) is 5%, what is the current value of: (PLEASE SHOW YOU RWORK). a) The bonds with 8 years to maturity? b) The bonds with 20 years to maturity