Get documents about "PV FV PMT Rate Calculators
Document Sample
PV FV PMT Rate Calculators
**Positive and Negative signs are important for payment, PV, and FV
Even Cash Flows Unev
Present Value Net
General Form = PV(rate,#periods,payment,FV,type) General Form = N
type = 0 if end of period, 1 if beginning of period
Rate per period # periods Payment FV Type PV
0 0 - - 0 -
Even Cash Flows
Future Value
General Form = FV(rate,#periods,payment,PV,type)
type = 0 if end of period, 1 if beginning of period
Rate per period # periods Payment PV Type FV
0 0 - - 0 -
Even Cash Flows
Compute the Payment
General Form = PMT(rate,#periods,PV,FV,type)
type = 0 if end of period, 1 if beginning of period
Rate per period #periods PV FV Type PMT
0 0 - - 0 #DIV/0!
Even Cash Flows
Compute the Interest Rate
General Form = RATE(#periods,payment,PV,FV,type)
type = 0 if end of period, 1 if beginning of period
#periods Payment PV FV Type Rate per period
0 - - - 0 #NUM!
Even Cash Flows
Compute the Number of Periods
General Form = NPER(rate,payment,PV,FV,type)
type = 0 if end of period, 1 if beginning of period
Rate per period Payment PV FV Type #Periods
0 - - - 0 #DIV/0!
Page 1
PV FV PMT Rate Calculators
**Must enter a 0 for a $0 cash flow for all periods prior to final period
Uneven Cash Flows
Net Present Value
General Form = NPV(rate, value1, value2,...)
Rate per period Period Cash flow NPV
0 0 - -
1 -
2 -
3 -
4 -
5 -
6 -
7 -
8 -
9 -
10 -
11 -
12 -
13 -
14 -
15 -
16 -
17 -
18 -
19 -
20 -
21 -
22 -
23 -
24 -
25 -
Page 2
Related docs
