using excel formulas and references

You have been offered a unique investment opportunity. If you invest $10,000 today, you will receive $500 one year from now, $1,500 two years from now, and $10,000 ten years from now a. What is the NPV of the opportunity if the cost of capital is 6% per year? Should you take the opportunity? b-what is the NPV of the opportunity if the cost of capital is 2% per year? Should you take it now? Initial investment Cash flow year 1 Cash flow year 2 Cash flow year 10 S 10,000 500 S 1,500 s 10,000