Question

An MLB player is in contract negotiations. The current contract is as follows:                         Year    &nb

An MLB player is in contract negotiations. The current contract is as follows:

                        Year                                         Salary

0 $8,000,000 (Signing Bonus)

1 $4,000,000

2 $4,800,000

3 $5,700,000

4 $6,400,000

5 $7,000,000

6 $7,500,000

Assume the payments are at the end of the year. Interest rate is 8%.

The player has asked you as his agent to negotiate the terms of a new contract:

1. He wants a contract increase of $750,000 over the previous contract.

2. He wants the new 6-year contract paid out in the following way: A $9 million signing bonus payable today and an equal salary paid every three months (quarterly) with the first paycheque three months from now.

Assuming the team agrees to his new demands, if the interest rate is 8% annually what is the amount of his quarterly payment?

0 0
Add a comment Improve this question Transcribed image text
Answer #1

First, we calculate the value of the current contract. This is calculated as the present value of salary payments.

Present value of each payment = payment / (1 + interest rate)year.

Value of current contract = $34,538,319

fixB6/(1+8%)^A6 C6 C D Present Value 1 Year Salary 0 $8,000,000 $4,000,000 $4,800,000 $5,700,000 $8,000,000 2 $3,703,704 $4,1

B C Present Value =82/(1+8%)^A2 B3/(1+8%)^A3 84/(1+8%)^A4 B5/(1+8%)^A5 B6/(1+8%)^A6 87/(1+8%)^A7 B8/(1+8%)^A8 -SUM(C2:C8) Sal

Value of new contract =  $34,538,319 + $750,000 = $35,288,319.

Signing bonus = $9,000,000.

The present value of salary payments = value of new contract - signing bonus.

The present value of salary payments = $35,288,319 -   $9,000,000 = $26,288,319.

The quarterly payment is calculated using PMT function in Excel:

rate = 8%/4 (converting annual rate into quarterly rate)

nper = 6 * 4 (6 years with 4 quarterly payments each year).

pv = 26288319 (present value of salary payments)

PMT is calculated to be $1,389,892.27.

The amount of his quarterly payment is $1,389,892.27.

Add a comment
Know the answer?
Add Answer to:
An MLB player is in contract negotiations. The current contract is as follows:                         Year    &nb
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • An All-Pro defensive lineman is in contract negotiations. The team has offered the following salary structure:...

    An All-Pro defensive lineman is in contract negotiations. The team has offered the following salary structure:    Time Salary 0 $ 6,400,000 1 5,000,000 2 5,500,000 3 6,000,000 4 7,400,000 5 8,100,000 6 8,900,000    All salaries are to be paid in a lump sum. The player has asked you as his agent to renegotiate the terms. He wants a $9.9 million signing bonus payable today and a contract value increase of $1,900,000. He also wants an equal salary paid...

  • A Major League Baseball team signs a free agent player to a new contract, which includes...

    A Major League Baseball team signs a free agent player to a new contract, which includes a $2 million signing bonus. If the player puts the money into an account earning 9%, compounded quarterly, how much will be in the account at the end of 5 years when his contract expires? Show work in excel

  • In 2019, Lamar, a top college quarterback, signed a $40.4 million football contract structured as follows:...

    In 2019, Lamar, a top college quarterback, signed a $40.4 million football contract structured as follows: for the years 2019 through 2024 inclusive, it paid him equal annual upfront payments which totaled $3.9 million. He also received an upfront signing bonus of $500K. The balance of the contract was paid out equally for 30 years (end of year) following the initial series of annual payments. On the other hand, Melvin, a star running back, signed a deal which paid him...

  • Business Law: Text and Cases 14th Edition Chapters 11 & 18 Lucy decides that it is...

    Business Law: Text and Cases 14th Edition Chapters 11 & 18 Lucy decides that it is time that she and Schroeder marry. As an inducement, Lucy promises to buy Schroeder a new piano if he will marry her. He agrees. She also tells him that she wants a prenuptial agreement. She is very concerned that in the event the marriage does not work out, that Schroeder will be able to receive a portion of her real estate holdings. She is...

  • 1. Calculate the accumulated value of an ordinary annuity of $4,200 a year for 6 years...

    1. Calculate the accumulated value of an ordinary annuity of $4,200 a year for 6 years if the money is worth 71 2 %. 2. Find the future value of the cash flow of $600 a month for 5 years at 9% interest compounded monthly. 3. If Gabe makes a $450 deposit into his savings fund at the end of each quarter for 6 years, how much will he be able to collect at the end of the sixth year...

  • A cash-flow budget uses the same format as a cash-flow statement. It is prepared on a...

    A cash-flow budget uses the same format as a cash-flow statement. It is prepared on a monthly basis and it reflects budgeted income and expenses.In addition to the cash-flow statement, Deon and May made a list of budget assumptions: . Deon's income will increase by 5%, effective January 1 . His bonus is generally 10% of his income in the previous year, and he receives it in January. . May's raise will be 3%, effective January 1, Interest and dividend...

  • 31. Arnie is a self-employed handyman. During the current year, customers pay him $10,000 in cash...

    31. Arnie is a self-employed handyman. During the current year, customers pay him $10,000 in cash for his services. Arnie gives the $10,000 to his daughter, Ariel, who uses it to pay college expenses. Is Arnie or Ariel taxed on the $10,000? Explain. 33. For each of the following situations, determine the proper year for recog- nition of the income or deduction if the taxpayer is (1) a cash basis taxpayer and (2) an accrual basis taxpayer: Tindle Corporation purchases...

  • what information do you need Exercise 6-15 John Bogut just received a signing bonus of $1,019,200....

    what information do you need Exercise 6-15 John Bogut just received a signing bonus of $1,019,200. His plan is to invest this payment in a fund that will earn 10 % , compounded annually. Click here to view factor tables If Bogut plans to establish the AB Foundation once the fund grows to $2,403,223, how many years until he can establish the foundation? years LINK TO TEXT LINK TO TEXT Instead of investing the entire $1,019,200, Bogut invests $315,300 today...

  • These are business Law questions. QUESTION 12 Following a year of record revenue generation, Produce Packaging...

    These are business Law questions. QUESTION 12 Following a year of record revenue generation, Produce Packaging Company promised that it would give a $1,000 bonus to each employee who was on the payroll at any time during the last year. With respect to this promise, it is likely a. Enforceable, because the bonus is warranted. b. Unenforceable, because the employees have not given consideration in return. OC. Unenforceable, because Produce could have paid more. od. Enforceable, because the employees' hard...

  • A cash-flow budget uses the same format as a cash-flow statement. It is prepared on a...

    A cash-flow budget uses the same format as a cash-flow statement. It is prepared on a monthly basis and it reflects budgeted income and expenses. In addition to the cash-flow statement, Deon and May made a list of budget assumptions, listed for you here: • Deon’s income will increase by 5%, effective January 1. His bonus is generally 10% of his income in the previous year, and he receives it in January. • May’s raise will be 3%, effective January...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT