Functions Reference

Chapter 6
|
Financial functions 55
Examples
NPV(Loan;.05) returns 156.91277445..., when the repeating field, Loan, contains -
2000 (the initial payment), 600, 300, 500, 700, and 400. The result (156.91277445...) is
the actual profit in today’s dollars that will be realized from this transaction.
NPV(Amounts;.10) returns 16758.35604870..., when the repeating field, Amounts,
contains -5000 (the initial investment), 10,000, 0, 10,000, and 10,000.
If you want each return value to return 2 decimal places, surround the current formulas
with the correct Round function: Round(Current Formula;2).
PMT
Format
PMT(principal;interestRate;term)
Parameters
principal - principal amount.
interestRate - interest rate. If the interest rate is annual, divide the rate by 12.
term - length of time, expressed in number of months.
Data type returned
number
Description
Returns the payment required to meet the requirements of the term, interestRate,
and principal you supply.
Examples
In the following example, the PMT function calculates payments for purchasing a sports
car costing $21,000, at an annual rate of 6.9% over 48 monthly payments.
PMT(21000;.069/12;48) returns the payment amount $501.90.
PMT(Cost;.13;Years) returns a payment amount, based on the purchase value
stored in Cost, at a 13 percent rate, over the duration stored in Years.
“Your payment will be “ & PMT(150000;.13/12;Months) & “.” returns Your
payment will be, followed by the payment amount, based on a total cost of $150,000, at
a 13 percent annual percentage rate, over the duration stored in Months.
ΠΜΤ παψμεντ
1 1 ιντερεστΡατε+()–
περιοδσ–
ιντερεστΡατε
-----------------------------------------------------------------------------
⎝⎠
⎛⎞
⁄=