Please calculate using excel or show how to calculate using excel

. How is the value of a bond determined? What is the value of a 10-year, $1,000 par value bond with a 10% annual coupon if its required rate of return is 10%? . (1) What would be the value of the bond described in Part d if, just after it had been issued, the expected inflation rate rose by 3 percentage points, causing investors to require a 13% return? Would we now have a discount or a premium bond? (2) What would happen to the bond's value if inflation fell and ra declined to 7%? Would we now have a premium or a discount bond? (3) What would happen to the value of the 10-year bond over time if the required rate of return remained at 13%? If it remained at 7%? (Hint : With a financial calculator, enter PMT, I/YR, FV, and N, and then change N to see what happens to the PV as the bond approaches maturity.) . (1) What is the yield to maturity bond that sells for $887.00? That sells for $1,134.20? What does the fact that a bond sells at a discount or at a premium tell you about the relationship between ra and the bond's coupon rate? (2) What are the total return, the current yield, and the capital gains yield for the discount bond? (Assume the bond is held to maturity and the company does not default on the bond 10-year, 9% annual coupon, $1,000 par value on a