You are offered an asset that costs $3000 and has cash flows of $500 every six month (end of period) of the next 10 years. a. If your cost of capital...

You are offered an asset that costs $3000 and has cash flows of $500 every six month (end ofperiod) of the next 10 years.a. If your cost of capital is 8 percent, should you purchase it?b. What is the IRR of the asset?c. What is the NPV of the asset?(Setup cash flows in Excel spreadsheets and use following Excel Financial functions, IRR andNPV to derive your answers.)