Question
July 1 is Bobby Bonilla Day! The owner of the NY Mets tweeted that this day is his favorite day of the year. Why? In
July 1 is Bobby Bonilla Day! The owner of the NY Mets tweeted that this day is his favorite day of the year. Why? In 2000, retiring Mets player Bobby Bonilla was owed $5.9 million on his contract to play for the NY Mets baseball team. Rather than a one-time buyout, however, he and the Mets agreed that Bobby would be paid zero dollars until July 1, 2011. On that day, and on each July 1 thereafter until and including 2035, Bobby would be paid $1,193,248. Calculate the $0 values from 2012 to 2020 in spreadsheet and show the excel formula w/IRR of 8%
2011 | 2012 | 2013 | 2014 | 2015 | 2016 | 2017 | 2018 | 2019 | 2020 |
$1,193,248 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
$1,193,248 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
$ 13,756,670 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
($1,193,248) | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
$12,563,422 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started