FV(Rate, Nper, PMT, PV, Type) %per period N of periods 10% 10 PMT PV Type 1000 Excel instruction: in cells or numbers Answer -FV(b2,b3,b4, -b5,b6) =FV(1096,100,-1000,0) $2,593.74 Case 2: Determine PV of $1 ($1,000 received after ten years is worth how much today at 10%?) PV(Rate, Nper, PMT, FV, Type) % per period N of periods PMT 10 FV 1000 Type Excel instruction: in cells or numbers -PV(b2,b3,b4,-bS,b6) -PV( 10%, 10,0,-1000,0) $385.54 Case 3: Determine FV of an ordinary annuity and an annuity due of $1 52,000 received each year grows to how much in ten years at 10%?) FV(Rate, Nper, PMT, PV, Type) FV(Rate, Nper, PMT, PV, Type) Annuity Due % per period N of periods 10% 10 % per period N of periods PMT PV Type 10% 2000 2000 PV 1496 Page 93 of 820 44 F7