In 2018, a football player signed a contract reported to be worth $75.3 million. The contract...

In 2018, a football player signed a contract reported to be worth $75.3 million. The contract was to be paid as $10.7 million in 2018, $11.7 million in 2019, $13.1 million in 2020, $13.2 million in 2021, $13.2 million in 2022, and $13.4 million in 2023. If the appropriate interest rate is 8 percent, what kind of deal did the player snag? Assume all payments are paid at the end of the year. (Do not round intermediate calculations and enter your answer in dollars, not millions of dollars, rounded to 2 decimal places, e.g., 1,234,567.89.)

Could I please get the answer in excel formula?

Expert Solution

jeff jeffy answered 2 years ago

In 2015, a baseball player signed a contract reported to be worth $98.5 million. The contract...

In 2015, a baseball player signed a contract reported to be worth $98.5 million. The contract was to be paid as $14.7 million in 2015, $14.9 million in 2016, $17.1 million in 2017, $17.2 million in 2018, $17.2 million in 2019, and $17.4 million in 2020. If the appropriate interest rate is 9 percent, what kind of deal did the player snag? Assume all payments are paid at the end of the year. (Enter your answer in dollars, not millions...

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)?

In 2015, a running back signed a contract worth $62.3 million. The contract called for $10...

In 2015, a running back signed a contract worth $62.3 million. The contract called for $10 million immediately and a salary of $3.5 million in 2015, $9.5 million in 2016, $10 million in 2017, $9.4 million in 2018 and 2019, and $10.5 million in 2020. If the appropriate interest rate is 8 percent, what kind of deal did the running back scamper off with? Assume all payments other than the first $10 million are paid at the end of the...

Nick, a retired professional football player, signed a one-year contract effective January 1 with Grills to...

Nick, a retired professional football player, signed a one-year contract effective January 1 with Grills to promote its cooking grills. Grills also signed and promised to pay Nick $50,000 per month. Nick promised to act in six commercials for Grills, filming at times mutually agreed upon by the parties. Nick also promised to make two promotional appearances (“appearances”) every month. The contract contained the following provision: PARAGRAPH (6): If Nick engages in disreputable conduct that reflects adversely on Grills or...

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...

The baseball player Alex Rodriguez signed a contract for a stated value of $275 mil in...

The baseball player Alex Rodriguez signed a contract for a stated value of $275 mil in 2007. The amount actually consisted of $2 mil immediately, along with $28 mil in the first year and the remaining $245 mil to be paid evenly over the years 2009 through 2017. How much was the contract really worth in 2007 ? Assume an interest rate of 5%.

AMC has just signed a contract. The contract requires an initial investment of $5 million, and...

AMC has just signed a contract. The contract requires an initial investment of $5 million, and creates positive cash flows of $2 million one year from today, $1.5 million two years from today, and $2.5 million three years from today. What is the value of this contract AMC can earn 9 percent on its money?

ST Trucking just signed a $3.8 million contract. The contract calls for a payment of $1.1...

ST Trucking just signed a $3.8 million contract. The contract calls for a payment of $1.1 million today, $1.3 million one year from today, and $1.4 million two years from today. What is this contract worth today at a discount rate of 8.77 percent? $3,198,053.81 $2,108,001.32 $3,480,817.37 $3,478,523.13 $3,202,223.89

Jason just signed a $6 million 3 year contract with the patriots. The contract calls for...

Jason just signed a $6 million 3 year contract with the patriots. The contract calls for a payment of $3 million 1 year from today, $2 million 2 years from today and $1 million 3 years from today, what is the contract really worth as of today if he can earn 10% apr on his money (assume annual compounding).

St trucking just signed a $3.8 million contract. The contract calls for a payment of $1.1...

St trucking just signed a $3.8 million contract. The contract calls for a payment of $1.1 million today, $1.3 million one year from today, and $1.4 million two years from today. What is the contract worth today at a discount rate of 8.0 percent? Please show how to work this problem in excel.

Question