4. If you were to purchase an annuity today that is projected to pay you $1000 in semi-annual payments (END - Ordinary Annuity mode) for 14 years, followed by a lump sum (FV) of $4000, what would you expect to pay if you discounted all cash flows using a 9.0% APR (semi-annual compounding)? Please show your answer and Excel/calculator inputs. (1 pt.) How would you mathematically (starting with first few cash flows) interpret your answer? (2 pts.) Verbally explain what your calculator embedded in Excel is computing. (1 pt.)