You expect to receive five annual payments of $1,000. If your required return is 10 percent, and the first payment is received at the end of year 6 (and subsequent payments are at the ends of years 7-10), how much is this investment worth to you today?

Please show how to do it in Excel, if possible. Thank you!