You are the manager of a sports team and want to know if hiring a super star player makes economic sense. One of your concerns is that the longer the player stays in your team, the more probable is that he gets an injury or loses its popularity, so you will only hire him if you recover your investment in 3 years or less. You will sign a 5-year contract with him, after which he will retire. With the following information obtain the Net Cash Flow, calculate the Net Present Value and the Discounted Payback Period. Use a MARR of 15% per year. Should you hire the player? USE EXCEL AND UPLOAD THE SCRRENSHOT OF THE EXCEL

Transfer fee to its current team: $80,000,000

Signing bonus to the player: $2,000,000

Players salary: $8,000,000 per year

Increase in annual revenues from TV rights: $20,000,000

Profits for each T-Shirt with his name sold: $100

Expected sales of T-Shirts with his name: 10,000 per month

Increase in monthly revenues from sponsors: $600,000

Increase in the attendance to each local match: 10,000 people per match

Local matches per year: 20

Average local matches ticket price: $24