(35 pts) The effective ANNUAL rate can be found using the EFFECT function in Excel "=EFFECT(nominal_rate, npery)" where npery is the number of compounding periods per year. Please create the Excel table in Figure 5.2 at page 67. (each column from C to H is 7 points) B C D H 1 Amount deposited 2 Compounding frequency 3 #of compoundings per year 4 Annual percentile rate (nominal per year) PV 5 Nominal rate per period (compounding frequency) NPERY APR 6.0000% 6.0000% 6.0000% 6.0000% 6.0000% Nom/period 6.0000% 1.5000% 0.5000% 0.1154% 0.0164% 12 ($10,000) ($10,000) ($10,000) ($10,000) ($10,000) Yearly Quarterly Monthly Weekly Daily 1 365 Formulas 52 +B4/B3 6 7 Effective rate per year 8 9 Ending balance (using the effective rate) 10 11 # of times compounding happens in a year EFFECT 6.0000% 6.1364% 6.1678% 6.1800% 6.1831% -EFFECT(B4,83) FV $10,600.00 $10,613.64 $10,616.78 $10,618.00 $10,618.31 | FV(C7,1,0,1,0) NPER 1 4 12 52 365 12 13 Ending balance (using the nominal rate per period) FV $10,600.00 $10,613.64 $10,616.78 $10,618.00 $10,618.31 =FV(C5C11,0,C1) Figure 5.2. Finding Future Value for Various Compounding Frequencies