Matching Items (10)
Filtering by
- All Subjects: Financial Modeling
- Creators: Simonson, Mark
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
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
Beyond Meat revolutionized the meat substitute industry after creating a product similar to real meat in taste, texture, and appearance. Beyond Meat quickly rose to success, but that success brought new competitors, regulatory pushback, and the realization that Beyond Meat's market size is smaller than touted. This paper aims to predict the future financials and valuations of Beyond Meat under different assumptions while detailing the company's rapid growth and subsequent stagnation.
ContributorsPetrie, Kyle (Author) / Simonson, Mark (Thesis director) / Castillo, Elizabeth (Committee member) / Barrett, The Honors College (Contributor) / Dean, W.P. Carey School of Business (Contributor) / Department of Finance (Contributor)
Created2023-05
Description
There is a growing demand for discrete graphics processing units (dGPU) in the internet of things. Our subject company, Company X, has decided to develop a dGPU to be used in client computing (desktops, laptops, etc). This project will address whether or not company X should invest time and money into adopting their existing client focused dGPU for applications in IoT such as digital signage, gaming, or medical imaging. If this investment is to be made, we will also make specific recommendations about how Company X should enter the IoT space. The project will be completed in 3 stages. The first stage will consist of an analysis of the competitive landscape and research on dGPUs and how they differ from integrated GPUs. Stage two will focus primarily on the IoT space and how the competitors are using dGPUs in the IoT along with an analysis of three potential use cases for Company X’s dGPU. Finally, we will build a comprehensive financial model based on our research of one specific IoT segment where Company X could potentially enter. Based on these stages, we will then offer a conclusion and recommendation on whether Company X should invest in this project.
ContributorsNickel, Jack Peter (Co-author) / Bergauer, Kevin (Co-author) / Morey, Jake (Co-author) / Nickel, Jack (Co-author) / Sethia, Priyanka (Co-author) / Smith, Jesse (Co-author) / Simonson, Mark (Thesis director) / Kreutner, Caleb (Committee member) / Department of Finance (Contributor) / Barrett, The Honors College (Contributor)
Created2019-05