Please help me solve this using using appropriate time value functions using excel
1. You own a bond that is currently quoted at 97, has a face of $1,000, a coupon of 6% and matures in 10 years. You are considering selling the bond.
a. Should you sell it if your wish to earn 7% on your money? Explain.
b. Suppose the bond is quoted at 89. Should you sell it? Explain.
c. What is the lowest price for which you would sell the bond? Explain.