Answer: 1.89%
Explanation:
You can use Excel to find the IRR here:
Investment amount should be first as shown and should be in negative.
The cash flows will then follow each other by year.
Use the =IRR formula to select all the cells and the IRR will show.'
IRR here = 1.89%
Based on the available data for a player of Titus Johnston's profile, his guaranteed amount would be $32.74 million.
<h3>Calculations and Parameters</h3>Given that Casey Deeselis a sports agent negotiating a contract for Titus Johnston, an athlete in the National Football League
He has generated data on 506 NFL athletes who have recently signed new contracts and who get paid a percentage of his team's plays that the athlete is on the field.
With this, each award they get, each minute they spend on the field, each game missed, and then guaranteed money are all accounted for which is displayed in the attached image below.
If we observe the best-pruned tree given below, based on the arrows and circles,
For Snap percent = 96
Awards = 7
Games missed = 3
The conclusion is that with the profile of Titus Johnston, he would receive a guaranteed amount of $32.74 million.
Read more about regression tree here:
#SPJ1
