Calculate this problem using an excel spreadsheet: A bond will pay $40 of interest at the end of each of the next five years, plus the principal of $1,000 at the end of year five. If the required yield-to-maturity is 5% and the present market price is $935, the NPV is:

(a) - $22. (b) - $41. (c) + $8. (d) + $22.