This is week 4 case study assignment APA style , based on Chapter 3 (. Time Value of Money: Valuing Cash Flow Streams) and Chapter 4 ( Time Value of Money) Due Date – 6th August 2021 Friday 11:59 PM...

Refer attached word document for case study details


This is week 4 case study assignment APA style , based on Chapter 3 (. Time Value of Money: Valuing Cash Flow Streams) and Chapter 4 (  Time Value of Money) Due Date – 6th August 2021 Friday 11:59 PM EST, USA. Week 4 Baseball Contracts Assignment Instructions The signing of a big-name athletes is often accompanied by great fanfare, but the numbers are sometimes misleading. Take for example when the New York Mets signed a $91 million contract with Mike Piazza in 1998. It was considered the richest deal in baseball history. That was not bad for someone who makes a living using the "tools of ignorance" (jock jargon for a catcher's equipment. However, while Piazza's contract was reported date $91 million, it was actually payable over seven years. It consisted of a signing bonus of $7.4 million, ($4 million payable in 1999, $3.5 million in 2002, plus a salary of $83.5 million. The salary was to be distributed as $6 million in 1999, $11 million in 200, $12.5 million in 2001, $9.5 million in 2002, $14.5 in 2003, and $15 million in both 2004 and 2005. So, we recognize that once the time value of money is considered, Piazza did not really get $91 million. Therefore, how much did he get? The tools in chapters 3 and 4 helps us answer the question. Questions : 1. Using the link for Sport trac select a MLB player's contract based on the instructions provided. (Tutor, please note that Ravish Srivastava Assigned Player is # 26 Patrick Corbin in above Spotrac Link: https://www.spotrac.com/mlb/contracts/) 2. Using an excel spreadsheet and the proper table or formulas show your calculations for your assigned player. Remember if the breakdown of the contract is not available then you should decide on the breakdown and calculate the values using (present value or future value compute the value of the contract. (30 points) 3. Detailed Discussion Subtopics 3-6 (30 points, including using APA or intext citations.) 3. Compose an essay analyzing what you computed in the excel spreadsheet 4. Describe the application of present and future values for cashflows 5. Provide a narrative on the differences between a single sum, an ordinary annuity, and an annuity due. 6. Compose a personal conclusion documenting what you learned from the concepts and application in this assignment and baseball contracts. 1) Introduction of case or topic (2) Facts as presented in the case or topic paraphrased for the report (3) A summary of the area of related Finance topic. (4) Your Detailed Discussion of the case or subtopics  including personal conclusion. You must provide sound rationale for your arguments.