Reference no: EM13890230
Cedric Benson, a top five draft pick of the Chicago Bears and his agent are evaluating three contract options. In each case there is a signing bonus and a series of payments over the life of the contract. He uses a 10.25 percent rate of return to evaluate the contracts.
Given the cash flows for each option below, which one should he choose?
Year Cash Flow Type Option A Option B Option C
0 Signing Bonus $3,100,000 $4,000,000 $4,250,000
1 Annual Salary $650,000 $825,000 $550,000
2 Annual Salary $715,000 $850,000 $625,000
3 Annual Salary $822,250 $925,000 $800,000
4 Annual Salary $975,000 $1,250,000 $900,000
5 Annual Salary $1,100,000 $1,000,000
6 Annual Salary $1,250,000
Hint: Determine the present value of each option and compare. Create a solution using time value of money equations and then use the NPV financial function to solve: NPV(rate,value1,value2, ...). Make sure that all cells are properly formatted.
Option A Option B Option C
Enter: CF0 = Enter: CF0 = Enter: CF0 =
Enter: CF1 = Enter: CF1 = Enter: CF1 =
Enter: CF2 = Enter: CF2 = Enter: CF2 =
Enter: CF3 = Enter: CF3 = Enter: CF3 =
Enter: CF4 = Enter: CF4 = Enter: CF4 =
Enter: CF5 = Enter: CF5 =
Enter: CF6 =
Enter: I = Enter: I = Enter: I =
Results (equation): PV0 =
Results (NPV function): PV0 = Result: PV0 = Result: PV0 =
Given the analysis above, the best alternative for Mr. Benson is?
|
Fixed rate mortgage-monthly payments to finance purchase
: You are buying a house and will borrow $220,000 on a 25-year fixed rate mortgage with monthly payments to finance the purchase. Your loan officer has offered you a mortgage with an APR of 4.50 percent. What are the most points you would be willing to..
|
|
Adjust the book balance of cash to the reconciled balance
: adjust the book balance of cash to the reconciled balance
|
|
Forecast broussards additional funds needed for coming year
: Broussard Skateboard’s sales are expected to increase by 15% from $8 million in 2013 to $9.2 million in 2014. Its assets totaled $5 million at the end of 2013. Broussard is already at full capacity, so its assets most grow at the same rate as project..
|
|
Finding substantial earnings decreases
: Aimed at finding substantial earnings decreases, a random sample of 23 firms with substantial earnings decreases showed that the mean return on assets 3 years previously was 0.058 and the sample standard deviation was 0.055.
|
|
Evaluating three contract options
: Cedric Benson, a top five draft pick of the Chicago Bears and his agent are evaluating three contract options. In each case there is a signing bonus and a series of payments over the life of the contract. He uses a 10.25 percent rate of return to eva..
|
|
Which would be used for activity-based decision making
: The reports that follow are from a grocery store. Which report would be used for financial purposes, and which would be used for activity-based decision making? Why?
|
|
What will be its dividend payout ratio
: Puckett product is planning for $5 million in capital expenditures next year. Puckett’s target capital structure consists of 60% debt and 40% equity. If net income next year is $3 million and Puckett follows a residual distribution policy with all di..
|
|
Stock pays no dividend and the riskless rate is positive
: Even though the underlying stock pays no dividend and the riskless rate is positive, exhibit a scenario in which early exercising an American put could be more beneficial than holding it till expiry.
|
|
How it pays or compensates its employees
: Using the internet, find a company that has been in legal trouble for how it pays/compensates its employees and post a link to the article. Why is this so important
|