Question: I need an example for three Data Tables in excel. Below is a picture with an example from class. My example cannot invlolve salarys, anuities,

I need an example for three Data Tables in excel. Below is a picture with an example from class. My example cannot invlolve salarys, anuities, or bank interest. I need an example for three Data Tables in excel. Below isPlease help me write an example like the one written in the blue overview box so that I can build my data table.

OVERVIEW: Brooke Denesik is being recruited to play professional soccer. Three teams are offering her a contract with different salaries and annual pay increases. Kahzakstan offers her a contract paying $100,000 per year with a 5% pay increase each year. Iceland offers her a contract paying $90,000 with a 10% increase and Switzerland offers her a contract paying $97,000 with a 7% pay increase. She feels that a 3% discount rate is reasonable for each contract. From a financial perspective the numbers in this analysis will greatly help Brooke to decide on the best contract. OVERVIEW: Brooke Denesik is being recruited to play professional soccer. Three teams are offering her a contract with different salaries and annual pay increases. Kahzakstan offers her a contract paying $100,000 per year with a 5% pay increase each year. Iceland offers her a contract paying $90,000 with a 10% increase and Switzerland offers her a contract paying $97,000 with a 7% pay increase. She feels that a 3% discount rate is reasonable for each contract. From a financial perspective the numbers in this analysis will greatly help Brooke to decide on the best contract

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!