Lily made an investment of $50,000. For each of the five years after the investment, Lily earns $8000, $10,000, $12,000, $16,000, $21,000.At which of the following discount rates of return will the NPV be close to zero?

A.3%

B.12%

C.9%

D.19%

please use excel to resolve the question and show the how to set up the fomular

Thank you