Formula Finansial dalam Excel

Ada beberapa formula keuangan dalam excel diantaranya adalah : Fv | Ipmt | Npv | Pmt | Ppmt
------------------------------------

Fv
What is the use of Fv formula?
Finds out how much a series of payments is worth in future

Syntax of Fv formula:
fv(at this rate, this many payments, of each)

Examples of Excel Fv formula:
fv(10%,12,-1000) = 21,384.28
------------------------------------

Ipmt
What is the use of Ipmt formula?
Tells you how much of your mortgage goes towards interest in specified month

Syntax of Ipmt formula:
ipmt(at this rate, on this payment, out of this many payments, for this much amount)

Examples of Excel Ipmt formula:
ipmt(10%,3,12,-100000) = 9017.97
------------------------------------

Npv
What is the use of Npv formula?
Calculates net present value from a series of future payments

Syntax of Npv formula:
npv(at this rate, list of payments)

Examples of Excel Npv formula:
npv(10%,100,100,100,100,100) = 379.07
------------------------------------

Pmt
What is the use of Pmt formula?
Tells you how much you should pay on your mortage (every month ..)

Syntax of Pmt formula:
pmt(at this rate, this many payments, for this much amount)

Examples of Excel Pmt formula:
pmt(10%,12,-100000) = 14676.33
------------------------------------

Ppmt
What is the use of Ppmt formula?
Tells you how much of your mortgage goes towards principle in specified month

Syntax of Ppmt formula:
ppmt(at this rate, on this payment, out of this many payments, for this much amount)

Examples of Excel Ppmt formula:
ppmt(10%,3,12,-100000) = 5658.36
------------------------------------

Sumber : http://chandoo.org/