please show work on an excel spreadsheet

2DOM EFF SAVE YOUR FILE AS LASTNAMEHRSTN Please type in your name here October 30th, 11:50 pm 100 REQUIREMENTS TO OBTAIN ALL 100 POINTS INPUT DATA Definition Excel function nam Answers MUST be derived using cell references using a formula OR Excel function. 5.00% nominal Interest rate nominal Just typing in your answer derived using your calculator will NOT result in any points. $5,000.00 Present value PV You MUST FORMAT ALL of your interest rates as PERCENTAGES with 2 DECIMALS. 1.00 Total Number of years nper You MUST FORMAT ALL of your dollar amounts as CURRENCY with 2 DECIMALS. 1 of compounding periods per year npery You MUST display all of your answers in the blue shaded cells below. payment PMT o Future Value FV Oleffective interest rate effect 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 annual compounding? SS 250.00 5.00% b. semi-annual compounding? c. quarterly compounding? d. monthly compounding? e 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 EFF annual compounding? b. semi-annual compounding? c. quarterly compounding? d. monthly compounding? e daily compounding? 3. Assume you want to invest $1000 into your savings account at the END of every year for the next 5 years. Future Value What is the future value in years, interest is compounded annually? b. What is the future value in year if interest is compounded semiannually? Hint: You MUST EFF for your interest rate 4. Rework question 3, assuming payments are made at the BEGINNING of each period. Future Value a. What is the future value in year 5, if interest is compounded annually? b. What is the future value in year si interest is compounded semiannually? for your interest rate For problems 5 & 6 use required nominal annual return of 8.00% 5. Consider the following end-of-year cash flows: Hint: You MUST MacBook Air