# PV FV PMT Rate Calculators by fsd65350

VIEWS: 16 PAGES: 2

• pg 1
```									                                               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

```
To top