An investment that you are considering promises to pay 1,000 semiannually for the next two years, beginning six months from now. you have determined that the appropriate opportunity cost (discount) rate is 8 percent, compounded quarterly. What is the value of this investment? I need to know answer using the EFFECT and PV function in excel