Use Microsoft Excel to assess the NPV of an IT initiative. The initiative will require an initial investment of $$250,000$ and is expected to return $$150,000$ per year for the next $3$ years. Assume a discount rate of $10$ percent. What is the NPV$?$

Required:

a$.$ If discount rate is $10\%,$ the net present value is:

multiple choice $1$

$$17,213$

$$123,027\mathrm{.}80$

$$80,421$

$$120,313$

Required:

b$.$ If discount rate is $15\%,$ the net present value is:

multiple choice $2$

$$17,213$

$$111,843$

$$92,483\mathrm{.}77$

$$120,313$