on Help What is the present value of bonds with a face value of $4,000, a stated interest rate of 10%, a market rate of 9%, and a maturity date four years in the future? Interest is paid semiannually. Use Excel. (Use the PV function in Excel Assume that all payments of interest and principal occur at the end of the period.) (Round the present value to the nearest whole number.) O A. $4,862 B. $4,000 C. $3,416 OD. $4.132