A B c D E F G H K 89 91 Annual 90 Question 9 Mildly impressed, your two year old takes a break to ponder compounding. After lunch, a nap and two episodes of Fancy Nancy, she returns to you with another question. She believes that because of more frequent compounding, the effective annual rate cannot be 2% for all the compounding options. Calculate the effective annual rate for each of 2.000% the compounding options in Question 8. (round to three decimal places) 94 92 93 Semi-Annual 95 96 97 98 2.010% Quarterly 99 100 2.015% Monthly 101 102 103 2.018% 4 points There are 12 questions on the next sheet of this workbook. For each question, the correct solution figure is given to you in a cell highlighted in gray. Your task is to create a formula using an Excel function in the answer cell highlighted in yellow that results in the same, correct, figure. You must use an Excel function to get the answer. Functions may include pv, fv, pmt, nov, nper, rate, effect, nominal, average, stdev, etc