You are negotiating the contract buyout of a professional basketball coach. The annual contract is for $2,500,000

Fantastic news! We've Found the answer you've been seeking!

Question:

You are negotiating the contract buyout of a professional basketball coach. The annual contract is for $2,500,000 and there are four years remaining. It is anticipated the coach can earn 6% annually on his investments. How much is this contract worth in present dollars given these assumptions? Write excel formula