Filtering by
- All Subjects: Accounting
- Creators: Department of Information Systems
- Creators: Department of Finance
- Creators: Kaplan, Steve
The PPP Loan Program was created by the CARES Act and carried out by the Small Business Administration (SBA) to provide support to small businesses in maintaining their payroll during the Coronavirus pandemic. This program was approved for $350 billion, but this amount was expanded by an additional $320 billion to meet the demand by struggling businesses, since initial funding was exhausted under two weeks.<br/><br/>Significant controversy surrounds the program. In December 2020, the Department of Justice reported 90 individuals were charged for fraudulent use of funds, totaling $250 million. The loans, which were intended for small business, were actually approved for 450 public companies. Furthermore, the methods of approval are<br/>shrouded in mystery. In an effort to be transparent, the SBA has released information about loan recipients. Conveniently, the SBA has released information of all recipients. Detailed information was released for 661,218 recipients who have received a PPP loan in excess of $150,000. These recipients are the central point of this research.<br/><br/>This research sought to answer two primary questions: how did the SBA determine which loans, and therefore which industries are approved, and did the industries most affected by the pandemic receive the most in PPP loans, as intended by Congress? It was determined that, generally, PPP Loans were approved on the basis of employment percentages relative to the individual state. Furthermore, in general, the loans approved were approved fairly, with respect to the size of the industry. The loans, when adjusted for GDP and Employment factors, yielded a clear ranking that prioritized vulnerable industries first.<br/><br/>However, significant questions remain. The effectiveness of the PPP has been hindered by unclear incentives and negative outcomes, characterized by a government program that has essentially been rushed into service. Furthermore, limitations of available data to regress and compare the SBA's approved loans are not representative of small business.
Developed a business product with a team of CS Students
Corporate buzzword terms like “big data” and “data analytics” are vague in meaning, and are thrown around by media sources often enough to obfuscate their actual meanings. These concepts are then associated with company-wide initiatives beyond the reach of the individual, in a nebulous world where people know that analytics happens, but don’t understand what it is.
The power of data analytics is not reserved for company-wide initiatives, or only employed by Silicon Valley tech start-ups. Its impacts are visible down at the team or department level, and can be conducted by the individual employees. The field of data analytics is evolving, and within it exists a rapid transition in which the individual employee is becoming a source for insight and value creation through the adoption of analytics based approaches.
The purpose of this thesis is to showcase an example of this claim, and demonstrate how an analytics based approach was applied to an existing accounting process to create new insights and information. To do this, I will discuss my development of an Excel based Dashboard Analytics tool, which I completed during my internship with Bechtel Corporation throughout the summer of 2018, and I will use this analytics tool to demonstrate the improvements that small-scale analytics had on a pre-existing process. During this discussion, I will address conceptual aspects of database design that related to my project, and will show how I applied this classroom learning to a working environment. The paper will begin with an overview of the desired goals of the group in which I was based, and will then analyze how the needs of the group led to the creation and implementation of this new analytics-based reporting tool. I will conclude with a discussion of the potential future use of this tool, and how the inclusion of these analytical approaches will continue to shape the working environment.