Please answer question C. Thank you

AutoSave ( OFF A A PIG... PV_FV_Excel_HW Home Insert Draw Page Layout Formulas Data Review View Tell me Times New Roman ~ 14 A ab Wrap Text v General Paste BIUV V AVA Merge & Center v $ ~ % 9 Conditional For Formatting as Font Number Clipboard Alignment Sty N17 XV fx A D G Problem 5-39 Compounding frequency, time value, and effective annual rates. For each of the cases in the table below: Compounding Amount of Nominal frequency, m Deposit period Case initial deposit annual rate, r (times/year (years) A $2,500 5% 2 50,000 12 a C 1,000 5 10 10 20,000 16 6 13 a. Calculate the future value at the end of the specified deposit period. 14 b. Determine the effective annual rate, EAR. C. Compare the nominal annual rate, r, to the effective annual rate, EAR. What relationship exists between compounding frequency and the nominal 15 and effective annual rates? 16 Solution Compounding Amount of Nominal frequency, m Deposit period FV (a) EAR (b) Case initial deposit annual rate, r (times/year) (years) A $2,500 6% 2 $3,359.79 6.1% B $50,000 12% 6 $71,412.31 12.6% C $1,000 5% 10 $1,628.89 5.0% $20,000 16% $51,266.08 17.0% + Compare the nominal annual rate, r, to the effective annual rate, EAR. What relationship exists between compounding frequency and the nominal and effective annual rates? Problem 5-3 Problem 5-4 Problem 5-7 Problem 5-11 Problem 5-17 Problem 5-19 Problem 5-26 Problem 5-30 Ready