PLEASE HELP ME DO IT ON EXCEL AND SHOW CLEARLY THE WHOLE EXCEL FORMULA TO DO I

THANK YOU VERY MUCH

Part A What is the value of a 10-year, $1,000 par value bond with a 10% annual coupon if its required return is 11.5%? Part B (1) What is the value of a 13% coupon bond that is otherwise identical to the bond described in part A? Would we now have a discount or a premium bond? (2) What is the value of a 7% coupon bond with these characteristics? Would we now have a discount or a premium bond? (3) What would happen to the values of the 7%, 10%, and 13% coupon bonds over time if the required return remained at 11.5%? Part C (1) What is the yield to maturity on a 10-year, 10.5% annual coupon, $1,000 par value bond that sells for $887.00 (a)? That sells for $1,134.20 (b)? (2) What are the total return, the current yield, and the capital gains yield for the discount bond? Assume that it is held to maturity and the company does not default on it. Part D How does the equation for valuing a bond change if semiannual payments are made? Find the value of a 10-year, semiannual payment, 10% coupon bond if nominal rd = 14.5%. Part E Suppose for $1,000 you could buy a 11.5%, 10-year, annual payment bond or a 11.5%, 10- year, semiannual payment bond. They are equally risky. Which would you prefer? If $1,000 is the proper price for the semiannual bond, what is the equilibrium price for the annual payment bond