The original issued discount (OID) is a type of interest that is not payable as it accrues, which plays a critical role in corporate tax provision and return. The calculation of OID for pools of credit card receivable (CCR pools) is very complicated and involves intensive data manipulation and computation from multiple sources.
While Microsoft Excel is the default tool for tracking information and managing tasks in the corporate world, Jinli Ma explains how the Jupyter Notebook does a better job than Microsoft Excel with the OID calculation process. Jinli focuses on data management, automation, and documentation of the process. He first demonstrates how the OID process is constructed, executed, updated, and maintained in Microsoft Excel and shares challenges and limitations experienced during each phase. He then explains how this process is developed, innovated, automated, validated, executed, maintained, extended, and documented in the Jupyter Notebook and details how each challenge encountered with Microsoft Excel is resolved.
ED Ma is the vice president of tax data analytics at Synchrony Financial. His work experience includes data analytics, model development, model review, and model governance in financial industry. He holds a master’s degree in computer information technologies, a master’s degree in financial engineering, and a bachelor’s degree in applied mathematics.
Help us make this conference the best it can be for you. Have questions you'd like this speaker to address? Suggestions for issues that deserve extra attention? Feedback that you'd like to share with the speaker and other attendees?
Join the conversation here (requires login)
©2018, O'Reilly Media, Inc. • (800) 889-8969 or (707) 827-7019 • Monday-Friday 7:30am-5pm PT • All trademarks and registered trademarks appearing on oreilly.com are the property of their respective owners. • email@example.com