I for one like it. I was wondering what formula you used for the annuity? I had to learn that back in Finance 101 and am just curious if the "pros" use the same formulas or something more complex.
You can see I didn't even fuss with the state tax issue.
History of Megabucks Jackpots
Date Place Amount won 02/21/10 Reno Airport, Reno, NV $ 10,422,754.08 12/28/09 Bellagio's Resort & Casino, Las Vegas $ 12,262,968.60 07/29/09 Casino Royale, Las Vegas $ 12,236,709.00 04/12/09 Terrible's Rail City Casino, Sparks, NV $ 33,000,563.00 05/07/08 The Palms $ 21,030,657.77 05/19/07 Fremont $ 10,762,066.40 02/05/07 Orleans $ 12,076,530.00 09/02/06 Wynn Las Vegas $ 10,828,990.00 07/28/06 Wynn Las Vegas $ 12,317,717.96 06/05/06 Cannery $ 20,519,025.00 10/16/05 Aladdin $ 11,909,745.00 10/16/05 Cannery $ 21,147,947.00
Using the statewide revenue from non restricted sites, from February 2007 to February 2010, I get the following data (in thousands)
Total amount wagered: $1,893,366 = 100%
Total Won: $1,582,459 = 83.586%
Jackpots: $ 89,293 = 4.72%
Reseeds: $ 60,000 = 3.17%
So, for me, your table would look like the following:
Fixed Wins: 83.58
Meter Reset: 3.17
Since your data set is greater than mine, I would agree with your figures except I think the fixed wins are higher because gaming shows an average monthly profit when there is no jackpot of 12.87%.
On the other hand, in months when there is a win, the profit does not go down by the jackpot value given out for the month, meaning that there is some weird formula being used to accrue the payout, but the profit does go down in months when jackpots are won, just not be the corresponding amount...
I'm almost ready to announce my new page on Megabucks on my "Odds" site. However, I'd be interested in any initial comments or questions on it. Just click on the link above to see a rough draft.
I like the info, but do you think you should add as a credit at the bottom: Photography by the guy who destroyed me in liars poker last weekend?
I don't know the answer to those questions based on the data either. For example, when the jackpot is won close to the end of the month, it seems that the revenue dips the following month. Let me put on my accountant hat.