[Libreoffice-bugs] [Bug 119573] YIELD function shows inconsistent results for basis 3
bugzilla-daemon at bugs.documentfoundation.org
bugzilla-daemon at bugs.documentfoundation.org
Sun Sep 23 16:01:15 UTC 2018
https://bugs.documentfoundation.org/show_bug.cgi?id=119573
--- Comment #7 from Winfried Donkers <winfrieddonkers at libreoffice.org> ---
I looked into this and I have a problem... with Excel's answers.
The calculations in column A and D both have a frequency value of 2, meaning
that twice a year the interest is applied: at the 30 June - 1 July crossing and
the 31 December - 1 January crossing.
As the settlement date differs between column A and D, the time from settlement
to first coupon date differs too. Consequently, the interest accrued differs
and therefore the yield.
As I am not a financial expert, I am not 100% certain of my conclusion, but
currently I have confidence in Calc's results of YIELD.
--
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20180923/49422c68/attachment.html>
More information about the Libreoffice-bugs
mailing list