Download Filemaker Pro 8.5 Retail
Transcript
Chapter 6 | Financial functions 61 interestRate - interest rate. Data type returned number Description Returns the net present value of a series of unequal payments made at regular intervals, assuming a fixed interestRate per interval. For example, suppose someone borrows money from you and pays you back in unequal amounts over a period of several years. You can calculate the result using the NPV function. loan amount - + -------------------------------------------first payment - + -------------------------------------------second payment - + … + ---------------------------------------------------n th payment NPV = ------------------------------------1 + interestRate ( 1 + interestRate ) 2 ( 1 + interestRate ) 3 ( 1 + interestRate ) n + 1 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. 1 – ( 1 + interestRate ) PMT = payment ⁄ ⎛⎝ --------------------------------------------------------------------⎞⎠ interestRate – periods
Related documents