ACCRINTM.php 1.3 KB

12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455565758
  1. <?php
  2. // Issue date, Settlement, Rate, Par, Basis, Result
  3. return [
  4. [
  5. 20.547945205478999,
  6. '2008-04-01', '2008-06-15', 0.10, 1000, 3,
  7. ],
  8. [
  9. 800,
  10. '2010-01-01', '2010-12-31', 0.08, 10000,
  11. ],
  12. [
  13. 800,
  14. '2010-01-01', '2010-12-31', 0.08, 10000, null,
  15. ],
  16. [
  17. 365.958904109589,
  18. '2012-01-01', '2013-02-15', 0.065, 5000, 3,
  19. ],
  20. [
  21. 73.1917808219178,
  22. '2012-01-01', '2013-02-15', 0.065, 1000, 3,
  23. ],
  24. [
  25. '#NUM!',
  26. '2008-03-05', '2008-08-31', -0.10, 1000, 2,
  27. ],
  28. [
  29. '#VALUE!',
  30. 'Invalid Date', '2008-08-31', 0.10, 1000, 2,
  31. ],
  32. 'Non-numeric Rate' => [
  33. '#VALUE!',
  34. '2008-03-01', '2008-08-31', 'NaN', 1000, 2,
  35. ],
  36. 'Invalid Rate' => [
  37. '#NUM!',
  38. '2008-03-01', '2008-08-31', -0.10, 1000, 2,
  39. ],
  40. 'Non-numeric Par Value' => [
  41. '#VALUE!',
  42. '2008-03-01', '2008-08-31', 0.10, 'NaN', 2,
  43. ],
  44. 'Invalid Par Value' => [
  45. '#NUM!',
  46. '2008-03-01', '2008-08-31', 0.10, -1000, 2,
  47. ],
  48. 'Non-numeric Basis' => [
  49. '#VALUE!',
  50. '2008-03-01', '2008-08-31', 0.10, 1000, 'NaN',
  51. ],
  52. 'Invalid Basis' => [
  53. '#NUM!',
  54. '2008-03-01', '2008-08-31', 0.10, 1000, 99,
  55. ],
  56. ];