Please answer all parts

ADTF Distributors is opening a corporate office building in Kansas, near the campus of CLU. They contact the business college at CLU to solicit applications from students for consideration for several openings in the Finance division at the new site. Applicants invited to the first round of interviews were asked to use the block of cells A1-C11 in the above spreadsheet applet. These cells are programmed to display data for a scenario where $1 is invested at 100% interest compounded n times per year. Column A gives possible yalues. Applicants invited to the first round of interviews were asked to use the block of cells A1-C11 in the above spreadsheet applet. These cells are programmed to display data for a scenario where $1 is invested at 100% interest compounded n times per year. Column A gives possible values for the number of compounding periods and Column C gives the balance at the end of 1 year. Note: There are formulas entered in Columns B and C of row 3 . If you delete the data in these cells, you can refresh the applet (or reload the page) to restore them. If you grab the lower right corner of a coll with a formula, you can drag the formula to fill down the column. For example, you could do this with cell B3. See how well you would perform at the first round of interviews by completing the exercises below. INTERVIEW - ROUND ONE (a) Let n stand for the number of compounding periods. Then, using the compound interest formula, the future value when $1 is invested at 100% interest for 1 year will be (1+,1) This simplifies to (1+n1)n. (b) Suppose that interest is compounded 6200 times per year (see row 7 in the applet). Then, we may conclude that when 4 is invested at % interest compounded times per year, the balance at the end of one year will be : (round to 5 decimal places). In other words, (1+11000a (c) Suppose that interest is compounded 76900 times per year (see row 8 in the applet). Then, we may conclude that when 4 is invested at % interest compounded times per year, the balance at the end of one year will be 1 (round to 6 decimal places), In other words, (1+rrenoo= (d) Column A is used to investigate what happens as you let the number of compounding periods increase without bound. in other words, to mimic what happens as we let n. Because we cannot use as a number of compounding periods, we refer to this type of compounding (when n ) as continuous compounding. Looking at the values down Column C, it appears that the balance at the end of 1 year at 100% interest compounded continuously (rounded to the nearest cent) is \$ Which means tho account earned $ in interest. (e) Correct to 5 decimat places, it appears that as n, (1+n1)n Did you conclude that the limiting value of (1+1)n as n is equal to c (the natural base)? Then, congratulations, you are moving on to the second round of interviews. INTERVIEW - ROUND TWO Applicants invited to the second round of interviews were asked to use the block of cells A16-C24 in the above spreadsheet applet. These cells are programmed to display data for a scenario where $1 is invested at 22% interest compounded n times per year, Column A gives possible values for the number of compounding periods and Column C gives the balance at the end of 1 year. Note: There are formulas entered in Columns B and C of row 17. If you delete the data in these cells, you can refresh the applet for reload the page) to restore them. If you grab the lower right corner of a cell with a formula, you can drag the formula to fill down the column. For example, you could do this with cell B18 into B19. (f) Let n stand for the number of compounding periods. Then, using the compound interest formula, the future value when $1 is invested at 22% interest for 1 year will be (1+) This simplifies to (1+n0.22)n This simplifies to (1+n0.22)n. (9) Suppose that interest is compounded 6200 times pec year (seo row 20 in the applet). Then, we may conclude that when 1 is invested at En interest compounded times per yeac, the balance at the end of one yoar will be 1 (round to 5 decimal places), in other words, (1+cos3 (h) Suppose that interest is compounded 76900 times per year (see row 21 in the applet). Then, we may conclude that when s is invested at \% interest compounded times per year, the balance at the end of one yoar will be 1 (round to 6 decimal places). In other words. (0) Column A is used to investigate what happens as you let the number of compounding periods increase without bound. in other words, to mimic what happens as we let n. Eecause we cannot use as a number of compounding periods, we refer to ths type of compounding (when n ) as continuous compounding. Looking at the values down Column c, it appears that the batance at the end of 1 yesr at 22% interest compounded continuously (rounded to the nearest cent) is 1 which means the account earned 1 in interest. (6) Correct to 5 decimal places, it appears that as n, (1+n0.22)n Did you conclude that the limiting value of (1+0.22)n as n is equal to e0.22 ? Then, congratulations, you have passed the second round of interviews. Watch the mail for an offer letter from ADTF Distributors