Matching Items (6)
Filtering by
- All Subjects: Excel
- Creators: Simonson, Mark
- Creators: Desouza, Kevin
Description
Social impact bonds (SIBs) are a multi-year contract between social service providers, the government, and private investors. The three parties agree on a specific outcome for a societal issue. Investors provide capital required for the service provider to operate the project. The service provider then delivers the service to the target population. The success of the project is evaluated by outside party. If the target outcome is met, the government repays the investors at a premium. Nonprofit service providers can only serve a small community as they lack the funding to scale their programs and their reliance on government funding and philanthropy leads to a lot of time focused on raising money in the short-term and inhibits them from evolving their programs and projects for long-term strategic success. Government budgets decline but social problems persist. These contracts share risk between the government and the investors and allow governments to test out programs and alleviate taxpayer burdens from unsuccessful social service programs. Arizona has a severe homelessness problem. Nightly, 6000 people are homeless in Maricopa County. In a given year, over 32,000 individuals were homeless, composed of single adults, families, children, and veterans. Homelessness is not only a debilitating and difficult experience for those who experience it, but also has considerable economic costs on society. Homeless individuals use a number of government programs beyond emergency shelters, and these can cost taxpayers billions of dollars per year. Rapid rehousing was a successful intervention model that the state has been heavily investing in the last few years. This thesis aimed to survey the Arizona climate and determine what barriers were present for enacting an SIB for homelessness. The findings showed that although there are many competent stakeholder groups, lack of interest and overall knowledge of SIBs prevented groups from taking responsibility as the anchor for such a project. Additionally, the government and nonprofits had good partnerships, but lacked relationships with the business community and investors that could propel an SIB. Finally, although rapid rehousing can be used as a successful intervention model, there are not enough years of proven success to justify the spending on an SIB. Additionally, data collection for homelessness programming needs to be standardized between all relevant partners. The framework for an SIB exists in Arizona, but needs a few more years of development before it can be considered.
ContributorsAhmed, Fabeeha (Author) / Desouza, Kevin (Thesis director) / Lucio, Joanna (Committee member) / School of Politics and Global Studies (Contributor) / Department of Economics (Contributor) / Barrett, The Honors College (Contributor)
Created2016-05
Description
Company X is one of the world's largest manufacturer of semiconductors. The company relies on various suppliers in the U.S. and around the globe for its manufacturing process. The financial health of these suppliers is vital to the continuation of Company X's business without any material interruption. Therefore, it is in Company X's interest to monitor its supplier's financial performance. Company X has a supplier financial health model currently in use. Having been developed prior to watershed events like the Great Recession, the current model may not reflect the significant changes in the economic environment due to these events. Company X wants to know if there is a more accurate model for evaluating supplier health that better indicates business risk. The scope of this project will be limited to a sample of 24 suppliers representative of Company X's supplier base that are public companies. While Company X's suppliers consist of both private and public companies, the used of exclusively public companies ensures that we will have sufficient and appropriate data for the necessary analysis. The goal of this project is to discover if there is a more accurate model for evaluating the financial health of publicly traded suppliers that better indicates business risk. Analyzing this problem will require a comprehensive understanding of various financial health models available and their components. The team will study best practice and academia. This comprehension will allow us to customize a model by incorporating metrics that allows greater accuracy in evaluating supplier financial health in accordance with Company X's values.
ContributorsLi, Tong (Co-author) / Gonzalez, Alexandra (Co-author) / Park, Zoon Beom (Co-author) / Vogelsang, Meridith (Co-author) / Simonson, Mark (Thesis director) / Hertzel, Mike (Committee member) / Department of Finance (Contributor) / Department of Information Systems (Contributor) / School of Accountancy (Contributor) / WPC Graduate Programs (Contributor) / Barrett, The Honors College (Contributor)
Created2016-05
Description
"Improving Life Outcomes for Children in Arizona: Educational Social Impact Bond" is a creative project that is structured as a pitch to the Arizona Department of Education to consider social impact bonds as a way to fund pilot education programs. The pitch begins with a brief overview of the umbrella of impact investing, and then a focus on social impact bonds, an area of impact investing. A profile of Arizona's current educational rankings along with statistics are then presented, highlighting the need for an educational social impact bond to help increase achievement. The pitch then starts to focus particularly on high school drop outs and how by funding early childhood education the chances of a child graduating high school increase. An overview of existing early education social impact bonds that are enacted are then presented, followed by a possible structure for an early education social impact bond in Arizona. An analysis of the possible lifetime cost savings of investing in early childhood education are then presented, that are as a result of decreasing the amount of high school drop outs. Lastly, is a brief side-by-side comparison of the Arizona structure to the precedent social impact bonds.
ContributorsRodriguez, Karina (Author) / Simonson, Mark (Thesis director) / Trujillo, Gary (Committee member) / Department of Finance (Contributor) / School of Accountancy (Contributor) / Barrett, The Honors College (Contributor)
Created2016-05
Description
The object of the present study is to examine methods in which the company can optimize their costs on third-party suppliers whom oversee other third-party trade labor. The third parties in scope of this study are suspected to overstaff their workforce, thus overcharging the company. We will introduce a complex spreadsheet model that will propose a proper project staffing level based on key qualitative variables and statistics. Using the model outputs, the Thesis team proposes a headcount solution for the company and problem areas to focus on, going forward. All sources of information come from company proprietary and confidential documents.
ContributorsLoo, Andrew (Co-author) / Brennan, Michael (Co-author) / Sheiner, Alexander (Co-author) / Hertzel, Michael (Thesis director) / Simonson, Mark (Committee member) / Barrett, The Honors College (Contributor) / Department of Information Systems (Contributor) / Department of Finance (Contributor) / Department of Supply Chain Management (Contributor) / WPC Graduate Programs (Contributor) / School of Accountancy (Contributor)
Created2014-05
Description
The goal of this thesis was to provide in depth research into the semiconductor wet-etch market and create a supplier analysis tool that would allow Company X to identify the best supplier partnerships. Several models were used to analyze the wet etch market including Porter's Five Forces and SWOT analyses. These models were used to rate suppliers based on financial indicators, management history, market share, research and developments spend, and investment diversity. This research allowed for the removal of one of the four companies in question due to a discovered conflict of interest. Once the initial research was complete a dynamic excel model was created that would allow Company X to continually compare costs and factors of the supplier's products. Many cost factors were analyzed such as initial capital investment, power and chemical usage, warranty costs, and spares parts usage. Other factors that required comparison across suppliers included wafer throughput, number of layers the tool could process, the number of chambers the tool has, and the amount of space the tool requires. The demand needed for the tool was estimated by Company X in order to determine how each supplier's tool set would handle the required usage. The final feature that was added to the model was the ability to run a sensitivity analysis on each tool set. This allows Company X to quickly and accurately forecast how certain changes to costs or tool capacities would affect total cost of ownership. This could be heavily utilized during Company X's negotiations with suppliers. The initial research as well the model lead to the final recommendation of Supplier A as they had the most cost effective tool given the required demand. However, this recommendation is subject to change as demand fluctuates or if changes can be made during negotiations.
ContributorsSchmitt, Connor (Co-author) / Rickets, Dawson (Co-author) / Castiglione, Maia (Co-author) / Witten, Forrest (Co-author) / Simonson, Mark (Thesis director) / Hertzel, Michael (Committee member) / Department of Finance (Contributor) / Department of Economics (Contributor) / Department of Information Systems (Contributor) / Department of Supply Chain Management (Contributor) / School of Mathematical and Statistical Sciences (Contributor) / School of Accountancy (Contributor) / WPC Graduate Programs (Contributor) / Barrett, The Honors College (Contributor)
Created2016-12
Description
"Company X," a technology company, is known for being one of the world’s largest semiconductor chip manufacturers; however, they are also one of the largest authors of software. In 2019, "Company X" entered a new paradigm where, according to the CEO, while "Company X"’s core strategy has not changed, "Company X" is embracing the transition to a data-centric company from a PC-centric company. The scope that the project examines is--in this transition to a data-centric company and based on the company's current expertise and competitive advantages--should "Company X" be branching into an additional division or leverage existing intellectual property (IP)? The goal of the project is to understand how "Company X" can leverage its expertise in hardware and software service packages to maximize the value of the company.
ContributorsArellano, Andrea (Co-author) / Roos, Bailey (Co-author) / Broas, Joshua (Co-author) / Kotti, Abhigyan (Co-author) / Simonson, Mark (Thesis director) / Hertzel, Michael (Committee member) / Dean, W.P. Carey School of Business (Contributor) / Department of Finance (Contributor) / Barrett, The Honors College (Contributor)
Created2020-05