Difference between revisions of "Documentation/How Tos/Calc: NPER function"
From Apache OpenOffice Wiki
< Documentation | How Tos
m |
|||
(9 intermediate revisions by 5 users not shown) | |||
Line 1: | Line 1: | ||
− | __NOTOC__ | + | {{DISPLAYTITLE: NPER function}} |
+ | {{Documentation/CalcFunc FinancialTOC | ||
+ | |ShowPrevNext=block | ||
+ | |PrevPage=Documentation/How_Tos/Calc:_MIRR_function | ||
+ | |NextPage=Documentation/How_Tos/Calc:_NPV_function | ||
+ | }}__NOTOC__ | ||
== NPER == | == NPER == | ||
Line 17: | Line 22: | ||
: <tt>'''NPER'''</tt> returns the number of payment periods implied by a lump sum (<tt>'''presentvalue'''</tt>) at the start of the term, a <tt>'''payment'''</tt> being made each period for <tt>'''numperiods'''</tt> periods, at fixed rate interest, compounded each period, and a lump sum (<tt>'''futurevalue'''</tt>) at the end of the term. | : <tt>'''NPER'''</tt> returns the number of payment periods implied by a lump sum (<tt>'''presentvalue'''</tt>) at the start of the term, a <tt>'''payment'''</tt> being made each period for <tt>'''numperiods'''</tt> periods, at fixed rate interest, compounded each period, and a lump sum (<tt>'''futurevalue'''</tt>) at the end of the term. | ||
− | : See | + | : See [[Documentation/How_Tos/Calc: Derivation of Financial Formulas|Derivation of Financial Formulas]] for the underlying formula. |
=== Example: === | === Example: === | ||
<tt>'''NPER(5%; -100; 0; 1000; 0)'''</tt> | <tt>'''NPER(5%; -100; 0; 1000; 0)'''</tt> | ||
: returns approximately <tt>'''8.31'''</tt>, the number of periods to realise this scenario. | : returns approximately <tt>'''8.31'''</tt>, the number of periods to realise this scenario. | ||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
=== Issues: === | === Issues: === | ||
* The number of periods returned can be fractional. The fraction results from solving the equation, and is not in itself meaningful. Real life periods will be whole. | * The number of periods returned can be fractional. The fraction results from solving the equation, and is not in itself meaningful. Real life periods will be whole. | ||
* Take care that you understand how this function compounds the interest each period. Many financial calculators allow you to set a separate compounding period - spreadsheets do not. Choose the interest rate appropriately. | * Take care that you understand how this function compounds the interest each period. Many financial calculators allow you to set a separate compounding period - spreadsheets do not. Choose the interest rate appropriately. | ||
+ | |||
+ | {{SeeAlso|EN| | ||
+ | * [[Documentation/How_Tos/Calc: PV function|PV]] | ||
+ | * [[Documentation/How_Tos/Calc: FV function|FV]] | ||
+ | * [[Documentation/How_Tos/Calc: IPMT function|IPMT]] | ||
+ | * [[Documentation/How_Tos/Calc: PMT function|PMT]] | ||
+ | * [[Documentation/How_Tos/Calc: PPMT function|PPMT]] | ||
+ | * [[Documentation/How_Tos/Calc: RATE function|RATE]] | ||
+ | * [[Documentation/How_Tos/Calc: Derivation of Financial Formulas|Derivation of Financial Formulas]] | ||
+ | * [[Documentation/How_Tos/Calc: Financial functions|Financial functions]] | ||
+ | * [[Documentation/How_Tos/Calc: Functions listed alphabetically|Functions listed alphabetically]] | ||
+ | * [[Documentation/How_Tos/Calc: Functions listed by category|Functions listed by category]]}} | ||
+ | [[Category: Documentation/Reference/Calc/Financial functions]] |
Latest revision as of 15:57, 30 January 2024
Depreciation
Payment Streams, Annuities, Loans
Securities
Coupons
Miscellaneous
< {{#switch:Previous Page | Previous Section = Previous Section | Next Section = Next Section | Previous Page = Previous Page | Next Page = Next Page | }} | {{#switch:Next Page | Previous Section = Previous Section | Next Section = Next Section | Previous Page = Previous Page | Next Page = Next Page | }} > |
NPER
Returns the number of payment periods for an annuity.
Syntax:
NPER(rate; payment; presentvalue; futurevalue; type)
- rate: the (fixed) interest rate per period.
- payment: the payment made each period.
- presentvalue: the lump sum payment at the start of the term.
- futurevalue: the cash balance paid at the end of the term (optional - defaults to 0).
- type: when payments are made (optional - defaults to 0):
- 0 - at the end of each period.
- 1 - at the start of each period (including a payment at the start of the term).
- NPER returns the number of payment periods implied by a lump sum (presentvalue) at the start of the term, a payment being made each period for numperiods periods, at fixed rate interest, compounded each period, and a lump sum (futurevalue) at the end of the term.
- See Derivation of Financial Formulas for the underlying formula.
Example:
NPER(5%; -100; 0; 1000; 0)
- returns approximately 8.31, the number of periods to realise this scenario.
Issues:
- The number of periods returned can be fractional. The fraction results from solving the equation, and is not in itself meaningful. Real life periods will be whole.
- Take care that you understand how this function compounds the interest each period. Many financial calculators allow you to set a separate compounding period - spreadsheets do not. Choose the interest rate appropriately.
{{#switch:EN
| RU = Смотрите также:
| UA = Дивіться також:
| EN = See Also
| PT = Ver também
| #default = See Also
}}