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

Problem 2 You are called in as a financial analyst to appraise the bonds of Moderna Inc. The $1,000 par value bonds have a quoted annual interest rate of 5%, which is paid semiannually. The required interest rate on the bonds is 7% annual interest. There are 25 years to maturity a. Compute the bond's value based on semiannual analysis. b. Suppose that two years after the bonds were issued (see part a), the required interest rate rose from 7% to 8%. What would be the bonds' value? c. Suppose that two years after the bonds were issue (see part a), the required interest rate fell from 7% to 4%. What would be the bond's value? d. See part c. What wild be the bond's value at maturity? Please explain