PV FV PMT Rate Calculators by fsd65350

VIEWS: 16 PAGES: 2

									                                               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