this is done in excel. i hope this clear enough for you.

Format Painter $ - % Conditional Formatas Formatting Table Clipboard Merge & Center Alignment Font Nr Styles G18 A B G K 1 2 3 4 5 6 7 8 D F F You have just won a lottery prize and the payout options below (A, B or C) are available to you - you can ultimately only choose one of the three. Rank the order in which you prefer the options (#1 to your most preferred option down to 13 as your least preferred option). Assume that the appropriate discount rate is 10% per year and provide all supporting calculations for your ranking. These calculations must be done in Excel and use appropriate Excel formulas. 9 10 11 Options: A: Receive $8,900 now, $2,000 in 1 year and another $2,000 in 2 years (for a total of $12,900 received). B: Receive nothing now, $4,500 in 1 year, $4,500 in 2 years, and a final $4,500 in 3 years (for a total of 12 $13,500 received). C: Pay $1,000 now (to secure a higher payout later) and receive $20,000 in 4 years (for a net total of $19,000 received). Rank (1st choice2nd 17 Option choice or 3rd choice) 13 14 15 16 18 19 20 21 22 23 24 25 26 27 28 29 Instructions Credit Data and Functions Newton-Pivottable and Chart Lottery Options Decision under Risk Di... BE Type here to search O x] 2 3 4 5 6 You have just won a lottery prize and the payout options below (A, B or C) are available to you - you can ultimately only choose one of the three. Rank the order in which you prefer the options (#1 to your most preferred option down to #3 as your least preferred option). Assume that the appropriate discount rate is 10% per year and provide all supporting calculations for your ranking. These calculations must be done in Excel and use appropriate Excel formulas. 8 Options: 9 A: Receive $8,900 now, $2,000 in 1 year and another $2,000 in 2 years (for a total of $12,900 received). 10 11 B: Receive nothing now, $4,500 in 1 year, $4,500 in 2 years, and a final $4,500 in 3 years (for a total of 12 $13,500 received). 13 14 C. Pay $1,000 now (to secure a higher payout later) and receive $20,000 in 4 years (for a net total of $19,000 received). 15 16 Rank (1st choice, 2nd choice or 3rd choice) 17 Option 18 19 20 21 22 B C K 2 3 4 5 6 8 9 10 11 You have just won a lottery prize and the payout options below (A, B or C) are available to you - you can ultimately only choose one of the three. Rank the order in which you prefer the options (681 to your most preferred option down to #3 as your least preferred option). Assume that the appropriate discount rate is 10% per year and provide all supporting calculations for your ranking. These calculations must be done in Excel and use appropriate Excel formulas. Options: A: Receive $8,900 now, $2,000 in 1 year and another $2,000 in 2 years (for a total of $12,900 received). B: Receive nothing now, $4,500 in 1 year, $4,500 in 2 years, and a final $4,500 in 3 years (for a total of 12 $13,500 received). C. Pay $1,000 now (to secure a higher payout later) and receive $20,000 in 4 years (for a net total of $19,000 received). Rank (1st choice, 2nd 17 Option choice or 3rd choice) 18 19 20 21 22 13 14 15 16 B C