{"action":"created","issue":{"url":"https://api.github.com/repos/kbower/tickettest1/issues/1630","repository_url":"https://api.github.com/repos/kbower/tickettest1","labels_url":"https://api.github.com/repos/kbower/tickettest1/issues/1630/labels{/name}","comments_url":"https://api.github.com/repos/kbower/tickettest1/issues/1630/comments","events_url":"https://api.github.com/repos/kbower/tickettest1/issues/1630/events","html_url":"https://github.com/kbower/tickettest1/issues/1630","id":196603968,"number":1630,"title":"Texas Installment Contracts calculation error","user":{"login":"kbower","id":4621154,"avatar_url":"https://avatars.githubusercontent.com/u/4621154?v=3","gravatar_id":"","url":"https://api.github.com/users/kbower","html_url":"https://github.com/kbower","followers_url":"https://api.github.com/users/kbower/followers","following_url":"https://api.github.com/users/kbower/following{/other_user}","gists_url":"https://api.github.com/users/kbower/gists{/gist_id}","starred_url":"https://api.github.com/users/kbower/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/kbower/subscriptions","organizations_url":"https://api.github.com/users/kbower/orgs","repos_url":"https://api.github.com/users/kbower/repos","events_url":"https://api.github.com/users/kbower/events{/privacy}","received_events_url":"https://api.github.com/users/kbower/received_events","type":"User","site_admin":false},"labels":[{"id":502425680,"url":"https://api.github.com/repos/kbower/tickettest1/labels/bug","name":"bug","color":"ee0701","default":true},{"id":502436258,"url":"https://api.github.com/repos/kbower/tickettest1/labels/isf","name":"isf","color":"fef2c0","default":false}],"state":"open","locked":false,"assignee":{"login":"kentbower","id":5034099,"avatar_url":"https://avatars.githubusercontent.com/u/5034099?v=3","gravatar_id":"","url":"https://api.github.com/users/kentbower","html_url":"https://github.com/kentbower","followers_url":"https://api.github.com/users/kentbower/followers","following_url":"https://api.github.com/users/kentbower/following{/other_user}","gists_url":"https://api.github.com/users/kentbower/gists{/gist_id}","starred_url":"https://api.github.com/users/kentbower/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/kentbower/subscriptions","organizations_url":"https://api.github.com/users/kentbower/orgs","repos_url":"https://api.github.com/users/kentbower/repos","events_url":"https://api.github.com/users/kentbower/events{/privacy}","received_events_url":"https://api.github.com/users/kentbower/received_events","type":"User","site_admin":false},"assignees":[{"login":"kentbower","id":5034099,"avatar_url":"https://avatars.githubusercontent.com/u/5034099?v=3","gravatar_id":"","url":"https://api.github.com/users/kentbower","html_url":"https://github.com/kentbower","followers_url":"https://api.github.com/users/kentbower/followers","following_url":"https://api.github.com/users/kentbower/following{/other_user}","gists_url":"https://api.github.com/users/kentbower/gists{/gist_id}","starred_url":"https://api.github.com/users/kentbower/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/kentbower/subscriptions","organizations_url":"https://api.github.com/users/kentbower/orgs","repos_url":"https://api.github.com/users/kentbower/repos","events_url":"https://api.github.com/users/kentbower/events{/privacy}","received_events_url":"https://api.github.com/users/kentbower/received_events","type":"User","site_admin":false}],"milestone":{"url":"https://api.github.com/repos/kbower/tickettest1/milestones/16","html_url":"https://github.com/kbower/tickettest1/milestone/16","labels_url":"https://api.github.com/repos/kbower/tickettest1/milestones/16/labels","id":2206392,"number":16,"title":"Sprint 16","description":null,"creator":{"login":"kbower","id":4621154,"avatar_url":"https://avatars.githubusercontent.com/u/4621154?v=3","gravatar_id":"","url":"https://api.github.com/users/kbower","html_url":"https://github.com/kbower","followers_url":"https://api.github.com/users/kbower/followers","following_url":"https://api.github.com/users/kbower/following{/other_user}","gists_url":"https://api.github.com/users/kbower/gists{/gist_id}","starred_url":"https://api.github.com/users/kbower/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/kbower/subscriptions","organizations_url":"https://api.github.com/users/kbower/orgs","repos_url":"https://api.github.com/users/kbower/repos","events_url":"https://api.github.com/users/kbower/events{/privacy}","received_events_url":"https://api.github.com/users/kbower/received_events","type":"User","site_admin":false},"open_issues":1,"closed_issues":16,"state":"open","created_at":"2016-12-20T04:24:19Z","updated_at":"2016-12-20T07:26:32Z","due_on":null,"closed_at":null},"comments":2,"created_at":"2016-12-20T07:26:32Z","updated_at":"2016-12-20T07:26:33Z","closed_at":null,"body":"_Imported from trac ticket 1630.\nCreated by **rneville, sal, michelle**\nOpened in trac: May 7, 2012, 9:55:38 AM\nLast modified in trac: May 7, 2012, 10:49:25 AM_\n***\n_by rneville, sal, michelle:_\nNothing has changed about the calculations for contracts in several weeks, no.\n\nI think I know what may be going on though. There's a routine that runs at the end of the algorithm that attempts to shift cash flows to make the reported APR fall under its \"maximum\" value (if necessary). For LA for example, that's 24%. The way the maximum APR is determined is by looking at the database for the highest rate for that state and using that as the ceiling. So if the calculated cash flows are causing the APR to come out to 24.1%, it will shift a dollar off each month and put it on the last month and then recalculate the APR...it will keep doing this until either a) the APR comes out as less than or equal to the ceiling value or b) a maximum of 20% of the standard monthly payment amount has been \"shifted\", regardless of the APR that results in.\n\nFor LA, it almost NEVER needs to do this anymore after several tweaks over the last several months.\n\nFor TX, I see the flaw in the algorithm. In the database, the maximum rate is 12%...but because that's add-on interest, the APR is much much higher than that. So, with uneven payments, it's trying to drive the APR as close to 12% as it can and it's reaching the (b) scenario above where it's moved the maximum amount to the final payment the algorithm will allow.\n\nI think if I remove that routine for add-on interest, we'll get much closer answers.\n\nI will open a ticket for that.\n\nRob,\n\nI have attached screen shots of Texas Installment contract worksheets for\nLoft and Gers. 12 & 24 mos. The even monthly payment option looks ok but the\nuneven monthly payments are not correct. The final payment is much larger on\nLoft than Gers. Also, Property and Accident & Health calculations are off a\nbit. I don't recall the final payment being larger when I tested last month.\nI have Texas stores using the even payments for outside financing but we\njust now started using the uneven payments for inhouse financing. Did\nsomething change?\n\nI have 3 Texas Installment stores live on Loft & bringing 2 more up next\nweek. Please let me know.\n\nThanks\nMichelle\n<Texas Installment_ uneven payments.doc>\n"},"comment":{"url":"https://api.github.com/repos/kbower/tickettest1/issues/comments/268173829","html_url":"https://github.com/kbower/tickettest1/issues/1630#issuecomment-268173829","issue_url":"https://api.github.com/repos/kbower/tickettest1/issues/1630","id":268173829,"user":{"login":"kbower","id":4621154,"avatar_url":"https://avatars.githubusercontent.com/u/4621154?v=3","gravatar_id":"","url":"https://api.github.com/users/kbower","html_url":"https://github.com/kbower","followers_url":"https://api.github.com/users/kbower/followers","following_url":"https://api.github.com/users/kbower/following{/other_user}","gists_url":"https://api.github.com/users/kbower/gists{/gist_id}","starred_url":"https://api.github.com/users/kbower/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/kbower/subscriptions","organizations_url":"https://api.github.com/users/kbower/orgs","repos_url":"https://api.github.com/users/kbower/repos","events_url":"https://api.github.com/users/kbower/events{/privacy}","received_events_url":"https://api.github.com/users/kbower/received_events","type":"User","site_admin":false},"created_at":"2016-12-20T07:26:33Z","updated_at":"2016-12-20T07:26:33Z","body":"_**rneville** trac status change on May 7, 2012, 10:49:25 AM:_ **closed**"}}
{"actor":{"display_login":"kbower"}}