Matching Items (13)
Filtering by
- All Subjects: Financial Modeling
- All Subjects: Business
- Creators: Simonson, Mark
- Member of: Theses and Dissertations
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
This thesis details our experience assisting BASE Equity Partners, a private equity firm based in New York City, on three prospective agricultural dealership deals over the course of this past academic year. The firm is currently structured as a Fundless Sponsor. This distinct structural trait is common for a type of private equity firm known among practitioners as pledge funds. This creates an interesting element for our experience as there is very limited academic research on these types of firms, which, since the Great Recession, have become popular players in middle-market private equity deals. We, first, provide some historical context on pledge funds and identify their primary differences with traditional private equity. The remainder of the paper documents our experience working on the agricultural dealership deals. We have organized this portion after the manner in which we received assignments. We go into detail on the specific projects with which we were tasked, our interactions with the partners and the major takeaways we had from this learning experience. This thesis paper will enrich the academic knowledge regarding pledge funds—and private equity generally—by documenting a real experience of what it is like performing analyst-level tasks at a real firm. Additionally, we were privy to information that is highly confidential, and though we have protected the confidentiality of the companies through pseudonyms and redaction of confidential material, all of the financial data shown, models provided and qualitative discussion is real.
ContributorsTang, Ivan (Co-author) / Johnson, Bradley (Co-author) / Panosian, Tro (Co-author) / Simonson, Mark (Thesis director) / Bonadurer, Werner (Committee member) / Barrett, The Honors College (Contributor) / Department of Finance (Contributor) / Department of English (Contributor) / School of Accountancy (Contributor) / School of International Letters and Cultures (Contributor)
Created2015-05
Description
The global network, serving as the backbone of the Internet and the flow of all digital information, has evolved since the birth of the internet in 1983 1. From the first generation of networks that supported the first cell phones, the system has matured to the existing fourth generation (4G), providing greater speed and expanded capabilities beyond basic calling and texting. The goal of our project was to identify how well Company X is positioned to capitalize on the transition to 5G, which will involve almost twice the amount of interconnected devices than today. To do this, we completed the following various tasks: 1. Identify the networking segments to focus our research. 2. Identify the major customers in these segments and how much of the market share each occupies. 3. Analyze the major benchmarks and metrics these customers value when purchasing the microprocessors for their networking devices. 4. Identify Company X's major competitors and their comparable products. 5. Compare the benchmark performances of Company X's offerings and its competitors 6. Create a model that provides a 5-year NPV as well as Company X's market share 7. Employ this model to evaluate various pricing strategies. 8. Determine the optimal pricing strategy and make a final recommendation. As 5G evolves, the demand for high-quality, low-power networking devices (e.g. routers, switches, access points) will increase. After performing our analyses, we will be able to decide how Company X's networking-oriented SoCs (chipset) compare to those of the other major competitors and use this relative performance to determine an appropriate ASP (average selling price) for these SoCs.
ContributorsDimitroff, Alex (Co-author) / Arias, Stephen (Co-author) / Masson, Taylor (Co-author) / McCall, Kyle (Co-author) / Hardy, Sebastian (Co-author) / Simonson, Mark (Thesis director) / Haller, Marcie (Committee member) / Department of Finance (Contributor) / Barrett, The Honors College (Contributor)
Created2018-05
Description
Leveraged buyouts have gone in and out of popularity over the last four decades. The first wave began in the 1980's with the rising popularity of junk bonds, followed by years of economic downturn, and then a rise and respective fall from the dot com era. However, in the 2000's, attitudes were high and a period of low interest rates, covenant-lite loans, and relaxed lending conditions gave rise to some of the largest leveraged buyouts in US history. As the name implies, leveraged buyouts are predominantly structured with debt, around 70% of the total transaction value. Private equity firms execute leveraged buyouts on companies in strong industries, who have proven, stable cash flows, with the intent of cutting costs, divesting unneeded assets, and making the chain more efficient. After a time period of five to seven years, the private equity firm exits the deal through an initial public offering of the target company, a sale to another buyer, or dividend recapitalization. The Blackstone Group is one of the largest private equity firms in the US, and, with the favorable leveraged buyout conditions, especially in the real estate market, it wanted to build its real estate portfolio with an acquisition of Hilton Hotels & Resorts. At the time of consideration, Hilton was one of the largest hotel companies in the world, but was beginning to lag compared to its competitors Marriott and Starwood. After months of talks, Hilton agreed to be bought out by Blackstone at $47.50/share, for a total purchase price of $26bn. Blackstone had injected $5.7 of its own equity into the deal. The Great Recession caused a lot of investors to worry about Hilton's debt obligations, and Blackstone was able to restructure a significant portion of the debt to benefit both themselves and their creditors. As new CEO, Christopher J. Nassetta was able to strengthen Hilton by rearranging management, increasing franchising fees, expanding its capital-lite segments, and building more rooms internationally, Hilton was able to grow quicker than its competitors from 2007-2013 while minimizing operating expenses. On December 2, 2013, Hilton went public on the NYSE as HLT. Its enterprise value increased from $26bn to $33bn, and Blackstone was able to achieve an internal rate of return of 19%, while continuing to own 75% of Hilton's shares.
ContributorsNelson, Corey Mitchell (Author) / Simonson, Mark (Thesis director) / Aragon, George (Committee member) / School of Accountancy (Contributor) / Department of Finance (Contributor) / Barrett, The Honors College (Contributor)
Created2017-05
Description
We chose to analyze Apple's current cash and cash equivalents balance of $246.1 billion. To fully understand how to maximize Apple's investment using this cash balance, we performed detailed due diligence on the company. We analyzed the history of apple, a timeline of their major product releases, their financial statements, product mix, and the industries in which they operate. This allowed us to gain a deeper understanding of available opportunities. After doing our due diligence on the company, we look at their current cash levels and potential reasons that the cash balance has been increasing so quickly. Another component of their cash balance is the implications of a tax holiday for repatriation, so we also looked at the potential effects of this on Apple's cash balance. Finally, we begin the main portion of our project where look at the six potential options for the cash. We cover share buybacks, dividends or a special dividend, paying down debt, investing in research and development, making a large acquisition, or continuing to build a high cash balance. We pull data on each of these, look at financial metrics and many different numbers to evaluate which of these six options would maximize shareholder value. A large portion of our work was spent looking at acquisition targets. We finally vetted three potential targets: Tesla, Netflix, and Disney. These companies made sense for a number of different qualitative reasons, but after looking at them from a financial standpoint we concluded Disney was the only company worth modeling out. A detailed financial model was built on Disney to find a purchase price. Included in this was a discounted cash flow analysis, comparable company's analysis, analyzing precedent transactions, and then finding an enterprise value based on the model. We also built an accretion dilution model to see what the effect on earnings per share is and also what the combined entity would look like. In order to present our findings, we built a pitch book. A pitch book is the standard type of presentation that investment banks use in order to show their recommendations to companies.
ContributorsMuscheid, Michael (Co-author) / Klein, Matthew (Co-author) / Lauro, John (Co-author) / Gagner, Landon (Co-author) / Simonson, Mark (Thesis director) / Stein, Luke (Committee member) / Department of Economics (Contributor) / Department of Finance (Contributor) / School of Accountancy (Contributor) / W. P. Carey School of Business (Contributor) / Barrett, The Honors College (Contributor)
Created2017-05
Description
This thesis examines the value creation potential of renovating an existing commercial real estate asset to a medical office. It begins by examining commercial real estate and the medical sector at a high level. It then discusses the various criteria used to select a subject property for renovation. This renovation is then depicted through a modified pitch book that contains a financial model and pro forma.
ContributorsLarrea, Justin (Co-author) / Berger, Nicholas (Co-author) / Peters, Matthew (Co-author) / Simonson, Mark (Thesis director) / Gray, William (Committee member) / Department of Finance (Contributor) / Department of Supply Chain Management (Contributor) / Barrett, The Honors College (Contributor)
Created2021-05
Description
This thesis examines the value creation potential of renovating an existing commercial real estate asset to a medical office. It begins by examining commercial real estate and the medical sector at a high level. It then discusses the various criteria used to select a subject property for renovation. This renovation is then depicted through a modified pitch book that contains a financial model and pro forma.
ContributorsBerger, Nicholas James (Co-author) / Larrea, Justin (Co-author) / Peters, Matthew (Co-author) / Simonson, Mark (Thesis director) / Gray, William (Committee member) / School of Accountancy (Contributor) / Dean, W.P. Carey School of Business (Contributor) / Department of Finance (Contributor) / Barrett, The Honors College (Contributor)
Created2021-05
Description
This thesis examines the value creation potential of renovating an existing commercial real estate asset to a medical office. It begins by examining commercial real estate and the medical sector at a high level. It then discusses the various criteria used to select a subject property for renovation. This renovation is then depicted through a modified pitch book that contains a financial model and pro forma.
ContributorsPeters, Matthew Scott (Co-author) / Larrea, Justin (Co-author) / Berger, Nicholas (Co-author) / Simonson, Mark (Thesis director) / Gray, William (Committee member) / Department of Finance (Contributor, Contributor) / Department of Information Systems (Contributor) / Barrett, The Honors College (Contributor)
Created2021-05
Description
This paper serves as an analysis of the current operational conditions of a real-world company – referred to as “Company X” – with respect to the IC substrate industry. The cost of substrates, a crucial component in the production of Company X’s product, has recently diverged from Company X’s predictions and is contributing to declining profitability. This analysis aims to discover the underlying cause for price divergence and recommend potential resolutions to improve the forecast of substrate costs and profitability. The paper is organized as follows: Chapter 1 is an introduction to IC substrates and the industry as a whole, Chapter 2 is a breakdown of the specific factors responsible for substrate prices, and Chapter 3 delivers a final recommendation to Company X and concludes the paper.
ContributorsO'Loughlin, Connor (Author) / Fares, Ari (Co-author) / Aggarwal, Bianca (Co-author) / King, Camden (Co-author) / Guillaume, Riley (Co-author) / Simonson, Mark (Thesis director) / Hertzel, Mike (Committee member) / Barrett, The Honors College (Contributor) / Department of Finance (Contributor) / School of Mathematical and Statistical Sciences (Contributor)
Created2023-05
Description
Company X once dominated the server chip market, but its share has begun to diminish due to numerous competitors, product delays, and smaller profit margins. This market will only keep growing as advancement and demand for server technologies continues to expand, therefore, regaining market share is of utmost importance for Company X. This project analyzes how Company X can look into regaining server market share through a diversion of funds into emerging markets. The paper highlights the importance of being an early entrant into a relatively untapped, promising regional market by addressing the economics, potential consumers, and competition. Analysis of these factors shows the potential net present value (NPV) that can be achieved by increasing investments in India.
ContributorsNguyen, Andre (Author) / Kam, Manton (Co-author) / Amundson, Tegan (Co-author) / Johnson, Tyler (Co-author) / Simonson, Mark (Thesis director) / Hertzel, Michael (Committee member) / Barrett, The Honors College (Contributor) / Department of Finance (Contributor) / Department of Economics (Contributor)
Created2023-05