Matching Items (9)
Filtering by
- All Subjects: Financial Modeling
- Creators: School of Accountancy
- Resource Type: Text
Description
For this thesis, the authors would like to create a hypothetical Private Equity Real Estate Investment firm that focuses on creating value for partners by taking an opportunistic approach to acquiring under-performing urban multi-family properties with large upside potential for investing. The project will focus on both the market analysis and financial modeling associated with investment strategy and transactions. There is a substantial amount of complexity within commercial real estate and this thesis seeks to offer an accurate and comprehensive documentary of the process, while simplifying it for everyday readers. Additionally, there are a significant amount of risk factors associated with investment decisions, so the best practices from the industry documented in this manuscript are valuable tools for successful investing in the future. To gain the most profound and reliable industry knowledge, the authors leveraged the experience of dozens of industry professionals through research and personal interviews. Through careful analysis, the authors were able to ascertain the current economic position in the real estate cycle and to create a plan for future investing. Additionally, they were able to identify and evaluate a specific asset for purchase. As a result, the authors found that multifamily properties are a sound investment for the next two years and that the company should slowly start to shift directions to office and retail in 2018.
ContributorsBacon, David (Co-author) / Soto, Justin (Co-author) / Kashiwagi, Dean (Thesis director) / Kashiwagi, Jacob (Committee member) / Department of Finance (Contributor) / Department of Supply Chain Management (Contributor) / Department of Marketing (Contributor) / W. P. Carey School of Business (Contributor) / School of Accountancy (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
In order to discover if Company X's current system of local trucking is the most efficient and cost-effective way to move freight between sites in the Western U.S., we will compare the current system to varying alternatives to see if there are potential avenues for Company X to create or implement an improved cost saving freight movement system.
ContributorsPicone, David (Co-author) / Krueger, Brandon (Co-author) / Harrison, Sarah (Co-author) / Way, Noah (Co-author) / Simonson, Mark (Thesis director) / Hertzel, Michael (Committee member) / Barrett, The Honors College (Contributor) / Department of Supply Chain Management (Contributor) / Department of Finance (Contributor) / Economics Program in CLAS (Contributor) / School of Accountancy (Contributor) / W. P. Carey School of Business (Contributor) / Sandra Day O'Connor College of Law (Contributor)
Created2015-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
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
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
This thesis will analyze the operations of two nonprofit organizations located in different parts of the world. One local and one international nonprofit organization was chosen for this thesis/creative project because of the diverse culture, customs and regulations in each setting. The paper will discuss the operations of St. Vincent de Paul, the Chandler Conference of St. Vincent de Paul, and Sri Sai Darshan Trust (SSDT). The paper begins with a brief history of nonprofit organizations followed by a detailed background on both organizations. The management (organizational structure), finances, marketing, and legalities will be discussed of each nonprofit. The paper will then examine the specialized projects of each organization throughout the year. A PEST, SWOT, value chain, Kraljic, spend, and demand analysis were conducted based off of the research on each nonprofit. The paper will then discuss the problems each organization exhibits and the potential solutions the nonprofits can implement into their daily operations in order to resolve them. This section analyzes the similarities and differences within each business area of the nonprofit organization. Short-term solutions to current business problems and long-term solutions to organizational problems will be discussed in this section. The conclusion is the final element of the thesis. In this section, a balanced scorecard will be created for each nonprofit organization. In addition, the authors will discuss what they learned throughout the entire process. The goal of this thesis/creative project was to integrate the knowledge and concepts from business (marketing, finance, management, accounting, supply chain management, and computer information systems), and find an application for each within nonprofit organizations around the world.
ContributorsPatel, Nisha (Co-author) / Sivakumar, Akila (Co-author) / Maltz, Arnold (Thesis director) / LePine, Marcie (Committee member) / W. P. Carey School of Business (Contributor) / Department of Supply Chain Management (Contributor) / School of Accountancy (Contributor) / Division of Teacher Preparation (Contributor) / Barrett, The Honors College (Contributor)
Created2016-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