problem is laid out below for the sake of consistency and the boided part of the bottom te

Below are three possible investments that follow a $5-$year time horizon. You will need to mc

investments using the concepts of net present value and the internal rate of return. and ma

Invest in a basichuman resource information system:

Cost: $$300K$

Cash Flows: $$150K$ each year for $5$ years

Invest in a high$-$end human resource information system:

Cost: $$1$ Million

Cash Flows: $$500K$ each year for $5$ years

Invest in a talent acquisition function

Cost: $$500K$

Cash Flows: $$250$ Keach year for $5$ years.

Assume that your cost of capital or required rate of return. is $8\%.$ Your task is to:

Build a spreadsheel $($e$.$g$.$ using Google Sheets$)$ that models the cash flows appropriately.

$2$ Calculat$-$ the NPV and IRR for each project.

Pick the project that you would fund and explain why you picked it$.$

Which of the following accurately describes the riskiness of these projects?

Investing in a talent acquisition function is the most risky option

Investing in a basic human resourge information $5$ ystem is the leastrisky option