Using Excel, provide Step by step answers and Excel formulas to provide the answer.

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?