100 Nos Of Formula and Functions
In MSExcel
Part 5
81-90: Financial Functions
81. PMT - Calculates the payment
for a loan based on constant payments and a constant interest rate.
o Example: =PMT(5%/12, 60,
-10000)
82.PV - Returns the present value of an
investment.
o Example: =PV(5%/12, 60,
-200)
83.FV - Calculates the future value of
an investment.
o Example: =FV(5%/12, 60,
-100)
84.NPV - Returns the net present value
of an investment based on periodic cash flows.
o Example: =NPV(0.1, A2:A10)
85.IRR - Returns the internal rate of
return for a series of cash flows.
o Example: =IRR(A2:A10)
86.RATE - Returns the interest rate per
period of an annuity.
o Example: =RATE(60, -200,
10000)
87.SLN - Returns the straight-line
depreciation of an asset.
o Example: =SLN(10000, 2000,
5)
88.DB - Returns the depreciation of an
asset using the declining balance method.
o Example: =DB(10000, 1000,
5, 1)
89.DDB - Returns the depreciation of an
asset using the double-declining balance method.
o Example: =DDB(10000, 1000,
5, 1)
90.CUMIPMT - Returns the cumulative
interest paid on a loan between two periods.
o Example: =CUMIPMT(5%/12,
60, 10000, 1, 12, 0)
