(This is Productions)

Emphas Heading Normal Assignment 1. 1. Suppose that an individual has an annual strategy that calls for the withdrawal of $25,000 $40,000, $50,000 or $60,000 from his retirement portfolio depending how the stock market behaved in the previous year. Suppose that historical data indicates the number of occurrences (for the past 50 years) of the conditions that would have led to the various withdrawals is: $25,000 $60,000 Withdrawal Amount # Times Last 50 Years $40,000 23 $50,000 18 (a) Use the Excel template below to construct an appropriate table for a VLOOKUP for generating withdrawals, assuming that the stock market conditions occur randomly and independently over time. A B C D E F G H (b) Complete Column C using the Random Numbers that are given in Column B to generate 8 years of portfolio withdrawals for the individual. TD F G Year Withdrawal Rand. # 37625 United States) Focus MacBook Pro B / C D . r Asconacer Ascore (b) Complete Column C using the Random Numbers that are given in Column B to generate 8 years of portfolio withdrawals for the individual. Year Withdrawal 3 Rand. 37625 61936 25833 .96228 41687 53940 6 04227 37411 (c) What would you type into Cell C11 in Excel to generate the first year's annual Withdrawal? "2. The design team at Ehinger Electronics has developed a new flash drive that can hold up to 4 times the amount of data as their competitor's drives. Management at Ehinger has decided to go ed States DF G H J K 37625 .61936 .25833 .96228 .41687 .53940 5 6 17 7 8 .04227 37411 I (c) What would you type into Cell C11 in Excel to generate the first year's annual Withdrawal? MacBook Pro command command