https://bugs.documentfoundation.org/show_bug.cgi?id=129361
Bug ID: 129361
Summary: YIELD function in Calc provides different result than
Excel, when there is one coupon period or less until
redemption.
Product: LibreOffice
Version: 6.0.7.3 release
Hardware: All
OS: Linux (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: libreoffice-bugs@lists.freedesktop.org
Reporter: russell_jackson...@hotmail.com
Description:
For example:
Settlement: 12/16/19
Maturity: 12/30/19
Rate 0.054
Price: 100
Redemption: 100
Frequency: 2
Basis: 4
Applying YIELD to this, results in 0.05268806713 in Excel, and
0.053332866925242 in LibraOffice Calc.
Excel uses a special formula when there is "one coupon period or less until
redemption:
https://support.office.com/en-us/article/yield-function-f5f5ca43-c4bd-434f-8bd2-ed3c9727a4fe
Steps to Reproduce:
Settlement: 12/16/19
Maturity: 12/30/19
Rate 0.054
Price: 100
Redemption: 100
Frequency: 2
Basis: 4
YIELD(12/16/19,12/30/19,0.054,100,100,2,4)
Actual Results:
Results in 0.053332866925242 in LibraOffice Calc.
Expected Results:
Results in 0.05268806713 in Excel
Reproducible: Always
User Profile Reset: No
Additional Info:
Should have had that same result as Excel.
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs