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. A B D E F G H K 71 72 Question 8 73 Annual Your two year old has come to you with concerns about her retirement. She has learned of the concept of compounding by binge watching the Suzi Orman Show. She would like you to build her an Excel model that demonstrates the impact of more frequent compounding. Demonstrate compounding to your child by calculating (with Excel functions of course) what the value of $100 at 2% would be in 5 years with annual, semi-annual, quarterly and monthly compounding. 74 75 76 77 $110.41 Semi-Annual 78 79 $110.46 Quarterly 80 81 82 $110.49 Monthly 83 84 $110.51 8 points 85