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.
Comments on this page are now closed.
©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. • firstname.lastname@example.org