chapter39

MACROS IN THIS WORKBOOKArrayDemo1() Matrix1()ArrayDemo3() Matrix2()ArrayDemo4() DynPV()ArrayDemoBase1() MoreDynPV()A B C D E1234567 ArrayAssign()VarArrayAssign()NewDynPV()F G1234567VARPV IN ACTIONCF VarPV NPV100 432.9477 - =VarPV(A3:A$7) 432.9477 - =NPV(0.05,A3:A$7)100 354.5951 - =VarPV(A4:A$7) 354.5951 - =NPV(0.05,A4:A$7)100 272.3248 - =VarPV(A5:A$7) 272.3248 - =NPV(0.05,A5:A$7)100 185.9410 - =VarPV(A6:A$7) 185.9410 - =NPV(0.05,A6:A$7)100 #VALUE! - =VarPV(A7:A$7) 95.2381 - =NPV(0.05,A7:A$7)A B C D E1234567NEWVARPV IN ACTIONCF VarPV NPV100 432.9477 - =NewVarPV(A3:A$7) 432.9477 - =NPV(0.05,A3:A$7)100 354.5951 - =NewVarPV(A4:A$7) 354.5951 - =NPV(0.05,A4:A$7)100 272.3248 - =NewVarPV(A5:A$7) 272.3248 - =NPV(0.05,A5:A$7)100 185.9410 - =NewVarPV(A6:A$7) 185.9410 - =NPV(0.05,A6:A$7)100 95.2381 - =NewVarPV(A7:A$7) 95.2381 - =NPV(0.05,A7:A$7)A B C D E1234567