Question

In: Finance

The Nashville Geetars, a professional foosball team, has just signed its star player Harold "The Wrist"...

The Nashville Geetars, a professional foosball team, has just signed its star player Harold "The Wrist" Thornton to a new contract. One of the terms requires the team to make a lump sum payment of $13.39 million to the The Wrist exactly 8 years from today. The team plans to make equal annual deposits into an account that will earn 5.17 percent in order to fund the payment. How much must the team deposit each year?

Solutions

Expert Solution

Here FV = $13.39 million or $13,390,000

nper = 8 and rate = 5.17%. Thus we have to compute the PMT.

The formula will be: PMT (5.17%, 8, 0, 13390000).

This will give a value of $1,393,722.33 (rounded to 2 decimal place). Thus the team will have to deposit $1,393,722.33 each year.

Year (n) CF 1+r FVIF = (1+r)^(8-n) FV = CF*FVIF
          1.00    1,393,722.33      1.0517                           1.4231      1,983,441.41
          2.00    1,393,722.33                           1.3532      1,885,938.40
          3.00    1,393,722.33                           1.2866      1,793,228.48
          4.00    1,393,722.33                           1.2234      1,705,076.05
          5.00    1,393,722.33                           1.1633      1,621,257.06
          6.00    1,393,722.33                           1.1061      1,541,558.49
          7.00    1,393,722.33                           1.0517      1,465,777.78
          8.00    1,393,722.33                           1.0000      1,393,722.33
Total    13,390,000.00

Related Solutions

The Nashville Geetars, a professional foosball team, has just signed its star player Harold "The Wrist"...
The Nashville Geetars, a professional foosball team, has just signed its star player Harold "The Wrist" Thornton to a new contract. One of the terms requires the team to make a lump sum payment of $13.17 million to the The Wrist exactly 9 years from today. The team plans to make equal annual deposits into an account that will earn 4.84 percent in order to fund the payment. How much must the team deposit each year? What is the effective...
The Nashville Geetars, a professional foosball team, has just signed its star player Harold "The Wrist"...
The Nashville Geetars, a professional foosball team, has just signed its star player Harold "The Wrist" Thornton to a new contract. One of the terms requires the team to make a lump sum payment of $13.17 million to the The Wrist exactly 9 years from today. The team plans to make equal annual deposits into an account that will earn 4.84 percent in order to fund the payment. How much must the team deposit each year? What is the effective...
A professional baseball player just signed a contract to pitch for the Houston Astros. The contract...
A professional baseball player just signed a contract to pitch for the Houston Astros. The contract specified that the player would earn $1,000,000.if he were healthy and could pitch. The contract also specified that he would earn $0. if he became I injured and unable to putch. There is a 10% (.1 probability) chance that the pitcher would become injured. 1). What is the Expected Utility for the Beneficiary( Baseball Pitcher) with insurance? 2). What is the Actuarially Fair price...
A professional baseball player signs a contract for $158 million to play with a team for...
A professional baseball player signs a contract for $158 million to play with a team for 7 years. He and his team agree that the contract will be spread out so that the player is paid beyond the 7 years. The payment plan for the contract is as follows: $19 million each year for years 1 through 7. $3.1 million each year for the next 8 years. $1.4 million each year for the next 8 years. You should assume that...
Ezekiel Elliot (a professional football player) recently signed a contract that will pay him the following...
Ezekiel Elliot (a professional football player) recently signed a contract that will pay him the following amount (in millions) Year Payment 2021 18 2022 11 2023 13 2024 10 2025 12 If the annual interest rate is 5%, what is the present value (in millions) of Elliot’s contract (consider 2020 as time 0)?
Margaret Putter is a professional golfer who has just signed a $3 million contract. The terms...
Margaret Putter is a professional golfer who has just signed a $3 million contract. The terms are five annual payments of $600,000 each. Determine the present value of the contract to Margaret, assuming her interest rate is 5%.
Joey “8 seconds baby!” Johnson is a professional bronc rider who has just signed a big...
Joey “8 seconds baby!” Johnson is a professional bronc rider who has just signed a big endorsement contract. Red Bull has agreed to pay Joey a guaranteed $100,000 per year for 15 years to wear a Red Bull helmet whenever he rides. The media are reporting that Joey has signed a $1.5 million dollar contract, but, assuming a discount rate of 6%, the actual present value of this endorsement contract to Joey is approximately
(Growth annuity) Michael has just signed a professional basketball contract where he will earn $2,500,000 the...
(Growth annuity) Michael has just signed a professional basketball contract where he will earn $2,500,000 the first year and will receive a 5% annual increase every year for 10 years. He plans to save 50% of his annual salary each year in a mutual fund where he expects to earn 16% annually. How much will she have in his savings after 10 years. Please show all work in excel, thank you!
The four actors below have just signed a contract to star in a dramatic movie about...
The four actors below have just signed a contract to star in a dramatic movie about relationships among hospital doctors. Each person signs independent contracts with the following terms: Contract Terms Contract Amount Payment Date Derek $ 540,000 2 years Isabel 580,000 3 years Meredith 450,000 Today George 440,000 1 year Required: 1-a. Assuming an annual discount rate of 9%, calculate the present value of the contract amount. (FV of $1, PV of $1, FVA of $1, and PVA of...
The four actors below have just signed a contract to star in a dramatic movie about...
The four actors below have just signed a contract to star in a dramatic movie about relationships among hospital doctors. Each person signs independent contracts with the following terms: Contract Terms Contract Amount Payment Date Derek $ 580,000 2 years Isabel 620,000 3 years Meredith 490,000 Today George 480,000 1 year Required: 1-a. Assuming an annual discount rate of 8%, calculate the present value of the contract amount. (FV of $1, PV of $1, FVA of $1, and PVA of...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT