A Euro league basketball player is to receive a $1,000,000 signing bonus today and $2,000,000 in one year, $3,000,000 in two years, and $4,000,000 three years from now. Assuming interest rate of 10% and ignoring tax considerations, would he be better of earning $8,500,000 today? Why or why not?

I need to know how to answer this using formulas on Excel.