Show All Functions Quarterly INPUT DATA Monthly INPUT DATA Daily INPUT DATA FV Rate = 0.06 = F61 Nper = 5 = F63 Pmt = 0 F65 PV = 0 E86 2. You invest $5,000 into a 6% nominal rate 5-year Certificate of Deposit (CD). How much will you have in 5 years and what is the effective annual rate under each of the following scenarios? 46 Populate the the INPUT DATA table provided to the night & make necessary adjustments for the 5 year CD. Future Value EFF Annual Semi 48 a. annual compounding? Excel function name INPUT DATA INPUT DATA nominal so b. semi-annual compounding? PV 51 nper c. quarterly compounding? npery 53 |PMT d. monthly compounding? FV 55 Effect 56 e. daily compounding? 57 58 59 3. Assume you want to invest $1000 into your UNO Credit Union Maverick savings account at the END of every year for the next 5 years. Annual Semi 60 Populate the Input Data table to the right for Questions 3 & 4 using a nominal rate of 6% & 6. Excelfunction name INPUT DATA INPUT DATA 61 Future Value nominal 6.00% 6.00% 62 a. What is the future value in year 5, if interest is compounded annually? , ? =FV F61,763.F6S, E86) IPV $1,0001 $1,000 63 nper 5.001 5.00 64 b. What is the future value in year 5 if interest is compounded semiannually? npery 11 2 65 Hint: You MUST use EFF for your interest rate PMT OT 0 66 FV 67 Effect 68 4. Rework question 3, assuming payments are made at the BEGINNING of each period. Type Future Value 70 a. What is the future value in year 5, if interest is compounded annually? Annual Semi 71 Excel function name INPUT DATA INPUT DATA 72 b. What is the future value in year 5 if interest is compounded semiannually? nominal 73 Hint: You MUST use EFF for your interest rate PV 74 nper 75 npery 76 PMT 77 FV Effect Type Type = number Result: 0 Done fx FV Returns the future value of an investment based on periodic, constant payments and a constant interest rate. Syntax FV(rate,nper.pmt,pv,type) , Rate: Is the interest rate per period. For example, . , use 6%/4 for quarterly payments at 6% APR. 78 79 80 Noric the total number of dode in Show All Functions Quarterly INPUT DATA Monthly INPUT DATA Daily INPUT DATA FV Rate = 0.06 = F61 Nper = 5 = F63 Pmt = 0 F65 PV = 0 E86 2. You invest $5,000 into a 6% nominal rate 5-year Certificate of Deposit (CD). How much will you have in 5 years and what is the effective annual rate under each of the following scenarios? 46 Populate the the INPUT DATA table provided to the night & make necessary adjustments for the 5 year CD. Future Value EFF Annual Semi 48 a. annual compounding? Excel function name INPUT DATA INPUT DATA nominal so b. semi-annual compounding? PV 51 nper c. quarterly compounding? npery 53 |PMT d. monthly compounding? FV 55 Effect 56 e. daily compounding? 57 58 59 3. Assume you want to invest $1000 into your UNO Credit Union Maverick savings account at the END of every year for the next 5 years. Annual Semi 60 Populate the Input Data table to the right for Questions 3 & 4 using a nominal rate of 6% & 6. Excelfunction name INPUT DATA INPUT DATA 61 Future Value nominal 6.00% 6.00% 62 a. What is the future value in year 5, if interest is compounded annually? , ? =FV F61,763.F6S, E86) IPV $1,0001 $1,000 63 nper 5.001 5.00 64 b. What is the future value in year 5 if interest is compounded semiannually? npery 11 2 65 Hint: You MUST use EFF for your interest rate PMT OT 0 66 FV 67 Effect 68 4. Rework question 3, assuming payments are made at the BEGINNING of each period. Type Future Value 70 a. What is the future value in year 5, if interest is compounded annually? Annual Semi 71 Excel function name INPUT DATA INPUT DATA 72 b. What is the future value in year 5 if interest is compounded semiannually? nominal 73 Hint: You MUST use EFF for your interest rate PV 74 nper 75 npery 76 PMT 77 FV Effect Type Type = number Result: 0 Done fx FV Returns the future value of an investment based on periodic, constant payments and a constant interest rate. Syntax FV(rate,nper.pmt,pv,type) , Rate: Is the interest rate per period. For example, . , use 6%/4 for quarterly payments at 6% APR. 78 79 80 Noric the total number of dode in