Tesla is considering issuing 10 -year bonds with a face value of $1,000. The coupon rate is 5% so the bonds will pay 5% of the $1,000 face value in interest every year, or $50. However, because interest is paid semiannually in two equal payments, there will be 20 coupon payments of $25 each. The $1,000 will be returned at maturity. Finally, the required rate of return (discount rate) is assumed to be 8%. Prospective bond holders want to know the present value of the bonds. Please use the present value (PV) function to determine this. Use the worksheet provided. Tesla Worksheet for IRR, NPV and PV of Bon PV of Bonds Face value of Bond: Annual Coupon Rate: Required Return: Years to Maturity: Payment Frequency: $1,000 PV of Bond