A bond has a coupon rate of 4% and a yield or required return of 5%, $100 face value and 10 years to maturity. Assume coupon payments are made semi-annually.

Group of answer choices

Excel function PV(2.5%, 20, -2) can be used to find the present value of coupon payments.

Excel function PV(2%, 20, 0, -100) can be used to find the present value of face value.

Excel function PV(2.5%, 20, -2, 100,) can be used to find the value of the bond.