Question
NEEDS TO BE DONE ON EXCEL You have just been notified that you have won the local Bucks for Life lottery. The lottery rules state
NEEDS TO BE DONE ON EXCEL
You have just been notified that you have won the local Bucks for Life lottery. The lottery rules state that you have the option of receiving $25,000 annually for the rest of your life beginning immediately or a single lump sum today. You are not sure which option to take but to begin with you want to be assured that the lottery has enough money set aside to make the annual payments if you choose that option. Your accountant emails you to let you know that it appears that the lottery has $200,000 in a separate bank account to cover your annual payment. Assuming an interest rate of 12%, is this enough cash to cover the annual payments of $25,000 over your lifetime? (5 Marks)
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