A basketball player is offered the following contract today, Jan. 1, 2012: $2 million immediately, $2.40 million in 2012, $2.90 million in 2013, $3.60 million in 2014, and $3.80 million in 2015. Assume all payments other than the first $2 million are paid at the end of the year. If the appropriate discount rate is 10 percent per year, what is the present value of the deal?
Show excel reference/excel function please