INPUT DATA Answers MUST be derived using cell references using a formula OR Erol function Just typing in your answer derived using your calculator will NOT result in any points You MUST FORMAT ALL of your interest rates as PERCENTAGES with 2 DECIMALS You MUST FORMAT ALL of your dollar amounts as CURRENCY with 2 DECIMALS. You MUST display all of your answers in the blue shaded calls below. Do nome 550.000 100 DV pe O Valur FMT TV For questions 1 - 4 refer to the input data box highlighted in yellow above. You need to adjust your inputs as necessary. The first question is done for you. 1. What is the future value of a 1 year Certificate of Deposit (CD) and what is the effective annual rate under each of the following scenarios? Future Value EFF annual compounding? 155.250,00 5.00% b. semi-annual compounding? quarterly compounding? d. monthly compounding? daily compounding? 2. What is the future value of the CD in 5 years and what is the effective annual rate under each of the following scenarios? Future Value EFE al compounding b. manual compounding? quarterly compounding d monthly compounding daily compounding 3. Assume you want to invest $1000 into your savings account at the END of every year for the next 5 years