Assignment 1 As discussed in Class please Find here detail for first Assignment FV. PV (1+i)" PVX (FVIF.) . PV. FV.[1/(1+1) = FV (PVIF..) . FVA. A [(1+1)-11/1 = AX (FVIFA) . PVA A1-(1/(1+i) 1/1 = AX(PVIFA) Above formulas are hint for FVIF, PVIF, FVIFA, and PVIFA. Use these formulas and information from internet for these calculations, use MS Excel to: a) Make Table for all four FVIF, PVIF, FVIFA, and PVIFA for 50 (1 to 50) years annually and up to 50% Interest rates starting from 1% to 50% with increment of 1% b) Now you have made the table by using this table please Claculate: FV, when PV=$800, Rate=6% for 5 years PV, when, FV=$1700, Rate =8% for 8 years FVA, when CF=$1000, Rate =7% for 5 years PVA, when CF= $700, Rate = 8% for 5 years File in MS Excel Assignment 1 As discussed in Class please Find here detail for first Assignment FV. PV (1+i)" PVX (FVIF.) . PV. FV.[1/(1+1) = FV (PVIF..) . FVA. A [(1+1)-11/1 = AX (FVIFA) . PVA A1-(1/(1+i) 1/1 = AX(PVIFA) Above formulas are hint for FVIF, PVIF, FVIFA, and PVIFA. Use these formulas and information from internet for these calculations, use MS Excel to: a) Make Table for all four FVIF, PVIF, FVIFA, and PVIFA for 50 (1 to 50) years annually and up to 50% Interest rates starting from 1% to 50% with increment of 1% b) Now you have made the table by using this table please Claculate: FV, when PV=$800, Rate=6% for 5 years PV, when, FV=$1700, Rate =8% for 8 years FVA, when CF=$1000, Rate =7% for 5 years PVA, when CF= $700, Rate = 8% for 5 years File in MS Excel