Project 1 - Contract Review
Andrew Luck, signed a 5 year contract with Indianapolis Colts. Andrew intends to will play professional football for the Colts for the duration of the contract, and will reside in Indianapolis during this time.
Details regarding Andrew's contract are summarized below, and can also be found online.
Year Base Salary Signing Bonus Total Salary
2016 $12,000,000 $6,400,000 $18,400,000
2017 $7,000,000 $6,400,000 $13,400,000
2018 $13,000,000 $6,400,000 $19,400,000
2019 $9,125,000 $6,400,000 $18,250,000
2020 $11,000,000 $6,400,000 $17,400,000
$52,125,000 $32,000,000 $86,850,000
Please compile a summary, to be discussed with the client, showing what his "bot***** *****ne" will be each year, after accounting for federal and state taxes, union dues of $16,500 per year, and spending of $25,000 per month. Please ignore any future / present value implications.
Please utilize your creativity as there is no exact format.
These were the instructions used for the intern project:
Using Microsoft Excel, please create a spreadsheet to display Andrew Luck’s new 5 year contract. This contract can be found on spotrac.com or any other website that displays contract information. For each year of his contract, please incorporate what his “bottom-line” will be after federal and state taxes, future/present value, and $300,000 of yearly spending. Please utilize your creativity as there is no exact format.
Submitted: 10 months ago.
Category: Microsoft Office