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.
Please 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
Get step-by-step solutions from verified subject matter experts
