excel formula please thank you You have just won your...
80.2K
Verified Solution
Link Copied!
Question
Accounting
excel formula please thank you
You have just won your state's big lottery, the Mega Power Pick-6! The jackpot is $123,000,000. You have the option of receiving a check for $12,300,000 at the end of each of the next 10 years. You would receive the first check in a year. The state lottery commission also allows you the option of receiving a one-time payment of $99,764,018 when you turn in the winning ticket. What interest rate is the state lottery commission using to determine the one-time payment? (Use the present value and future value tables, a financial calculator, a spreadsheet or the formula method for your calculations. If using present and future value tables or the formula method, use factor amounts rounded to five decimal places, X.XXXXX. Round the interest rate to the nearest whole percent.) (Click the icon to view the Future Value of $1 table.) (Click the icon to view the Present Value of $1 table.) (Click the icon to view the Future Value of an Ordinary Annuity table.) (Click the icon to view the Present Value of an The state lottery commission is using a(n) % interest rate annually to determine the one-time payment
Answer & Explanation
Solved by verified expert
Get Answers to Unlimited Questions
Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!
Membership Benefits:
Unlimited Question Access with detailed Answers
Zin AI - 3 Million Words
10 Dall-E 3 Images
20 Plot Generations
Conversation with Dialogue Memory
No Ads, Ever!
Access to Our Best AI Platform: Zin AI - Your personal assistant for all your inquiries!
