preferible teach me how to solve it with excel please

You just won a lottery that promises to pay you $1 million exactly 10 years from today. Because the $1 million payment is guaranteed by the state in which you live, opportunities exist to sell the claim today for an immediate lump-sum cash payment. What is the least you will sell your claim for if you could earn 8.91% on similar-risk investments during the 10 -year period