So i waas bored earlier playing with google spreadsheets ad i made this spreadsheet that'll show you what would happen if you won the lottery.
Its pretty simple to use. there are three different color data boxes. red, blue and orange.
Blue-don't touch.... self-calculates
Orange- Instert your items and their prices here currency is already pre-set. just enter a number. Use as many or as few as you want.
Red - these two fields are required the first one is yearly upkeep costs of your initial purchases. The second one is how much you won BEFORE taxes.
now a few notes.
the assumption is that you will pay 40% in taxes on your winnings. you'll also see another box where it calculates taxes on earned interest. One other large assumption is that you took it as a lump sum. The final assuption is that you put your money in accounts with 3% interest rates.
If you choose to change the interest rates, find the interest data boxes and change appropriately (make sure its 1.04 not .04 otherwise you're losing your principle value) This will have to be done in the main interest boxes and the 50 year projection data boxes (they say 1.15 because its over five years except the last one which is 1.30 because its over ten years)
In the Item side of the spreadsheet, put your initial purchases. cars, houses, boats, 4mil to parents, etc. these are one time purchases.
on the right side of the spreadsheet are your yearly expenses. Take guesses. don't forget property taxes and such.
the savings data at the bottom is your savings after your interest earned minus your yearly expenses and then just a general interest growth for your remaining assest after your initial purchases.
not too difficult, just play with it.
Here's the spreadsheet... Enjoy!