Bug 141022 - Calc Financial Functions Should Not Require Negative Values
Summary: Calc Financial Functions Should Not Require Negative Values
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
(earliest affected) release
Hardware: All All
: medium minor
Assignee: Not Assigned
Depends on:
Blocks: Calc-Function
  Show dependency treegraph
Reported: 2021-03-14 15:28 UTC by FR
Modified: 2021-03-15 16:30 UTC (History)
0 users

See Also:
Crash report or crash signature:


Note You need to log in before you can comment on or make changes to this bug.
Description FR 2021-03-14 15:28:15 UTC
The Calc financial functions that I use require certain parameters to be entered as negative numbers.  This tends to be very confusing because financial values such as payments, interest, periods, etc. are normally considered to be positive values and such confusion can lead to significant error.

An example is now given.

The exact data for a loan is as follows:

Annual Rate -- 0.0329
Period Rate -- 0.0329/12 = 0.0027417
No. of Periods -- 72
Present Value -- 58238.17
Payment -- 892.43

In order to obtain these values using Calc functions, certain parameters have to be entered as the negative:

=NPER(0.0027417,-892.43,58238.17) -- payment must be negative

=PMT(0.0027417,72,-58238.17) -- present value must be negative

=PV(0.0027417,72,-892.43) -- payment must be negative

=RATE(72,-892.43,58238.17) -- payment must be negative

Unless the indicated parameters are entered as the negative value significant error will occur.

The underlying formulas to these Calc functions can be easily adjusted to use positive values only.  Doing so would lead to less confusion and less potential error.

I have not examined the many other financial functions but they may also have the same problem.
Comment 1 Roman Kuznetsov 2021-03-14 19:17:47 UTC
I don't think so