How to Calculate the Total Cash Value of a Lotto Win
Original post by Craig Woodman of Demand Media
The big lottery jackpots that are advertised are not money paid all at once. Lottery winnings are typically paid out over many years, in installments. Some lotteries allow the winner an option to take a cash payout up front, but at a substantially reduced amount. If this is not offered, other independent companies will pay a lump sum if you turn over the yearly payments to them. To decide if this is the best option, you must know today's cash value of the yearly payments. Microsoft Excel or other spreadsheet software will help you calculate this value.
Determine the total amount of payments you will receive and the time frame in which you will be receiving these payments. Payout time periods vary according to the state overseeing the lottery. Florida has the longest payout period at 30 years.
Set up an Excel spreadsheet labeling individual cells for the variables involved in the calculation. Starting at the top, in column A, label the cell in row one "rate," followed by "number of years." Name the third cell "payment," and the fourth cell "value." In column B, next to the "value" label, enter the formula to calculate the present value: =pv(b1,b2,b3,1). This calculates the present value of the payments in today's money. If you are using the free open-source spreadsheet from Open Office, substitute semi-colons for commas in the formula.
Enter the appropriate values in the cells in the "B" column. Beside the "rate" label, enter the projected interest rate that you would receive for the money. Beside the "number of years" label, enter the number of years that you would receive the payment. Enter the payment amount next, as a negative number. Negative numbers in spreadsheets indicate that money has been paid to you.
View the cash value of the lottery winnings in today's money beside the "value" label. The formula will automatically compute this amount for you.
Tips & Warnings
- Try different numbers for interest rate, to see the difference between conservative or aggressive investments of the lottery winnings. You can use a financial calculator to figure the value as well, using the keys that correspond to the appropriate values.
- computer running Excel or other spreadsheet software, or a financial calculator
- MSN Money; So, You Won the Lottery, Now What?; Liz Pulliam Weston; July 2010
- Open Office: The Free and Open Productivity Suite
- Microsoft Office: Excel Functions for Personal Finance Decisions
- Bankrate; You've Won the Lottery! Now What?; Ellen Goodstein; November 2004
About the Author
Craig Woodman began writing professionally in 2007. Woodman's articles have been published in "Professional Distributor" magazine and in various online publications. He has written extensively on automotive issues, business, personal finance and recreational vehicles. Woodman is pursuing a Bachelor of Science in finance through online education.