Differences
This shows you the differences between two versions of the page.
| a_f:f:99_a:nper [2022/09/01 06:39] – created - external edit 127.0.0.1 | a_f:f:99_a:nper [2022/09/02 02:41] (current) – ↷ Page moved from a_f:f:99_a:nper to a_f:f:f:nper administrator | ||
|---|---|---|---|
| Line 1: | Line 1: | ||
| - | {{tag> | ||
| - | ====== NPER ====== | ||
| - | ===== Description ===== | ||
| - | Calculates total number of payment periods in an annuity | ||
| - | ===== Parameters ===== | ||
| - | - Rate – interest rate per period (in percents, 50% is 0.5). | ||
| - | - Payment – payment made each period | ||
| - | - Future value (optional) – future value or the cash balance that is attained after the last payment is made. If omitted assumed to be 0 | ||
| - | - Present value (optional) – present value or the lump-sum amount that a series of future payments is worth right now. If omitted assumed to be 0 | ||
| - | - Type (optional) – indicates when payments are due. 0 or omitted – at the end of the period; 1 – at the start of the period | ||
| - | ===== Example ===== | ||
| - | <code aim>NPER (0.08, 500, 0, 0, 0) </ | ||