Please help me solve it using excel ..

Please provide and answer to the following problems using Excel. For your Excel answer.

FIN220 Fundamentals of Financial Management Excel Assignment Please provide and answer to the following problems using Excel. For your Excel answer, please follow the Excel format and functions presented in Chapter 5 of the textbook. missiO . A football player is negotiating his new contract. His opportunity cost is 9%. He has been offered three possible 4-year contracts. Payments are guaranteed, and they would be made at the end of each year. Terms of each contract are as follows Years 1 2 3 4 Contrac KD 1,000,000 ,000,000 000,000 ,000,000 Contract 2: KD 1,500,000 500,000 500,000 500,000 Contract 3 KD 500,000 500,000 500,000 ,500,000 As his adviser, which contract would you recommend that he accepts? 2. Asaad is considering taking early retirement, having saved KD 500,000 years the savings will last if KD Asaad feels the She desires to determine how many 55,000 savings can earn 10% per year per year is withdrawn at the end of each year 3. Suppose today is July 1, 2010, and you deposit KD 10,000 into an account today. Then you deposit KD 2,500 into the same account each July 1, 2011 and continuing until the last KD 2,500 deposit is made on July 1, 2016. Also, assume you withdraw KD 17,500 on July 1, 2018. Assuming a 6% annual compound interest rate, what will be the balance in the account at the end of July 1, 2020? (hint: find the present value for CFs then the future value for lump sum) 4. Your sister turned 20 today, and she is planning to save S5,000 per year for retirement, with the first deposit to be made one year from today She wl invest in a mutual fund that's expected to provide a return of 8% per year. She plans to retire 35 years from today, when she turns 55, and she expects to live for 25 years after retirement, to age 85. Under these assumptions, how much can she spend each year after she retires if she can still earn 8% a year during her retirement years? Her first