Your good friend is looking to buy a bond that pays semi-annual interest. The par value is $1,000 and the coupon rate is 4%. Your friend plans to hold the bond to its maturity, which is 10 years from now. If her required rate of return is 3%, what is the most you recommend your friend pay for the bond? (round to nearest cent) Can you please show me how I would enter tjis in Excel!! Thank you!!!!!