uli Condition Formatti SS B D F G H I K M N RofR Increase Perio Amount 0 1 2 3 4 Complete this spreadsheet as indicated. It should look nice and be formatted appropriately. You should setup this scenario as we have done in class and homework and use the concept of "periods. All formulas and functions should use absolute references where needed and cell references where available. Do not hardcode any values within formulas or functions on this sheet. 6 Total You have an investment opportunity. You need to decide if you should invest in the opportunity. You will invest $325,000 today. You will receive $65,000 in each of the next two years (year 1 and year 2). In the third year you will receive $50,000. Then for three years after that the amount will increase by 15%. There is a total of six years that elapse since the investment Enter a function to calculate the total of all of the money. Then, using a rate of return of 5.35% use a function to tell me how much all amounts are worth in today's dollars? Use a function to tell me what the break even rate of return percentage is for this opportunity Tell me somewhere on the sheet if this is a good opportunity 10 points 2 Rate of 4 Period Option 1 Option 2 Option 3 0 1 2 3 Complete this spreadsheet as indicated It should look "nice" and be formatted appropriately. You should use the concept of periods as we have done in class and homework. All formulas and functions should use absolute references where needed and cell references where available. Do not hardcode any values within formulas or functions on this sheet. Thave placed some headings on this sheet but not necessarily all that are required 4 5 10 12 14 Complete this sheet with the information below to select the best option based on what we have done in class and the function we have used in class. The rate of return for each option that requires it is 6.25%. Somewhere on the sheet indicate the best option Option 3 - you will invest $25,000 today. For each of the next five years you will receive 58,500. There is a total of five years Option 2 - you invest $95.000 today. You will get sero in year one. In the second year you will get $25,000. You will then get a 10% increase each year for the next three years, for a total of five years. Option 3. You will get $10,000 today 15 points 15 13 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37
