- This Question Should Be Answered In An Excel File When You Have Answered The Question Name Your File Your Last Name 4 1 (95.41 KiB) Viewed 23 times
THIS QUESTION SHOULD BE ANSWERED IN AN EXCEL FILE. WHEN YOU HAVE ANSWERED THE QUESTION, NAME YOUR FILE YOUR LAST NAME_#4 AND UPLOAD IT TO CANVAS. 4) You have won the lottery and have 3 choices: 1. A) You can choose to receive $1,500,000 immediately in cash. 2. B) Your second option is to receive a single payment of $2,500,000 at the end of 15 years. 3. C) Your third option is to receive payments of $150,000 a year for 15 years. Which option should you choose if your discount rate is 5%? Show your calculations using Excel formulas for each option. Upload Choose a File