Solve the following questions using TVM functions in Excel. You will receive no credit if you type in numbers instead of using equations/functions/references in cells other than inputs.

4. What is the NPV of $500 received for the next four years and $2,000 received at the end of the fifth year if your required return is 8%