Search results

Zoe Greenwood, vice president at Foundation Investment Advisors, was glancing through the offering memorandum for a new commercial mortgage-backed securities (CMBS) deal on April 1, 2010, a time when the opportunities for commercial mortgage investors had been bleak to the point of comical. This new CMBS deal represented the first opportunity to buy CMBS backed by loans to multiple borrowers since credit markets had shut the securitization pipeline in June 2008.

The offering gave Greenwood a new investment opportunity to suggest to her firm's latest client. She had planned to recommend an expansion in her client's traditional commercial mortgage business, but these new bonds looked intriguing. Could the new CMBS offer her client a superior risk-return tradeoff compared with making individual mortgage loans?

After students have analyzed the case they will be able to:

• –Learn how to construct promised cash flows from both commercial mortgages and commercial mortgage-backed securities

• –Understand the benefits and costs of direct lending versus indirect lending (purchase of mortgage-backed bonds)

• –Underwrite commercial mortgage loans issued by others to identify potentially hidden risks

• –Evaluate at what price a mortgage-bond investment makes financial sense

–Learn how to construct promised cash flows from both commercial mortgages and commercial mortgage-backed securities

–Understand the benefits and costs of direct lending versus indirect lending (purchase of mortgage-backed bonds)

–Underwrite commercial mortgage loans issued by others to identify potentially hidden risks

–Evaluate at what price a mortgage-bond investment makes financial sense

The case concerns a real $25 million program consisting of nine concurrent projects to deliver and implement a custom-built in-store customer relationship management (CRM) system and a new point-of-sale system in 400 stores of a national retail chain. The name of the company has been disguised for confidentiality reasons. Once deployed, the new system should give Clothes ‘R’ Us a significant strategic advantage over competitors in the marketplace; it will increase in-store manager productivity, cut costs, and ultimately drive increased sales for the retail chain. The program is in crisis, however, because the product managers have just left to join a competitor. The explicit details of the program are given, including examples of best practice program governance and the real activity network diagram for the program. Detailed Excel spreadsheets are also provided with the actual earned value data for the program. Students analyze the spreadsheets and the data given in the case to diagnose the impact of the most recent risk event and past risk events that occurred in the program. Ultimately students must answer the essential executive questions: What is wrong with the program? How should it be fixed, and what is the impact in time and money to the program? In addition, qualitative warning signs are given throughout the case—these warning signs are red flags to executives for early proactive intervention in troubled projects.

The goal of the case is to teach complex program oversight. Students analyze actual earned value data for a real $25 million program consisting of nine concurrent programs and assess the impact of risk events as they occur in the program. A key takeaway of the case is that relatively simple tools (Excel spreadsheets and time tracking) combined with good project planning can be used to effectively control very complex projects. Students also learn the qualitative warning signs within programs that can serve as early indicators of problems.

Management Accounting and Financial Modelling.

Undergraduate and post-graduated levels.

Aiman, the Area Manager of GEZ Berhad, realised the importance for petrol station operators to have an understanding of fundamental management accounting concepts such as cost behaviour and cost–volume–profit (CVP) analysis. He also believed that the petrol station operators should be proficient in using Microsoft Excel functionality and able to construct “intelligent” financial model with extended sensitivity analysis. Being a manager responsible for training the petrol station operators, Aiman would like to introduce the CVP concepts and spreadsheet model-building process to the petrol station operators, to aid them in planning and decision making. To construct the Excel spreadsheet model, Aiman sought the assistance of Rizal, a university lecturer in accounting, who in turn gathered the relevant operational and financial data from Baron Service Station, a typical petrol station under GEZ stable. The model should be flexible enough to allow the petrol station operator to anticipate, for example: What will happen to overall profitability of the petrol station if the fuel prices go up? What is the minimum volume of fuel that needed to be sold to break even? How much extra profit can be generated if credit card sale is reduced? and Is it viable to install an automated teller machines (ATM) kiosk and incurring administrative charges from bank to lure more customers to visit the petrol station? As the petrol station sells multiple products (petrol, diesel and convenience goods), the owner is also interested to know which product lines are the most and least profitable. Thus, the model should be able to generate segmented income statement with appropriate allocation of the common fixed costs to the each of the products.

The case discussion is intended to achieve the following learning outcomes: students are able to prepare a financial model which include a segmented contribution income statement based on the information on product mix; students are able to calculate the break-even point and distinguish between fixed and variable costs; students are able to differentiate between traceable fixed costs and common fixed costs; students are able to build a financial model that is sufficiently flexible to allow various what if analysis to be performed; and students are able to use what if analysis tools in Excel such as Goal Seek and Data Tables.

Teaching notes are available for educators only. Please contact your library to gain login details or email support@emeraldinsight.com to request teaching notes.

Set in September 1992, this exercise provides teams of students the opportunity to negotiate terms of a merger between AT&T and McCaw Cellular. AT&T, one of the largest U.S. corporations, was the dominant competitor in long-distance telephone communications in the United States. McCaw was the largest competitor in the rapidly growing cellular-telephone communications industry. Prior to the negotiations, AT&T had no position in cellular communications. This case and its companion (F-1143) are designed to allow students to be assigned roles to play. The case may pursue some or all of the following teaching objectives: exercising valuation skills, practicing strategic analysis, exercising bargaining skills, and illustrating practical aspects of mergers and acquisitions.

The key objectives of this case are to: (1) familiarize students with a simple version of the Markowitz optimal-asset allocation model; (2) develop students' intuition regarding optimal-asset allocation as specific inputs into the model (e.g., expected returns, standard deviations, correlations) change values; and (3) develop students' intuition regarding constraints that alternative investors may face (e.g., the presence of shorting constraints) and their impact on the optimal portfolio. The case includes an Excel spreadsheet, which contains relevant data (e.g., returns, standard deviations, correlations) on several assets and an Excel model that takes three of those assets and makes use of the Excel Solver Add-In to compute optimal weights for the three asset portfolio as well as the expected return, standard deviation, and Sharpe ratio of the optimal portfolio. Students are asked to alter many of the inputs into the model and explain the effects of those changes on the optimal portfolio.

In the (A) case, Jason Phillips, Chief Financial Officer of a soup manufacturing business, is given the task of maximizing the value of the firm twelve months after the case is set. Although he does not want to break any legal rules, Jason is interested to see whether accounting and real action choices can be used to enhance the company's financial position and increase its perceived value to investors. The case permits him to select from a menu of options, including decisions on product pricing, inventory levels, accounts receivables, leasing or purchasing a new machine and valuation or sale of securities. These choices are fed into an Excel spreadsheet which adjusts financial projections and accounting disclosures accordingly.

In the (B) case, Ben Kerr, Chief Investment Officer at one of Dragon's main competitors, considers the financial statements produced by Dragon to unravel any earnings management behavior and establish a true value for the company. Although the case can be focused on the accounting consequences of real decisions, a richer discussion is obtained when considering the ethical angles of the decision process. In particular, how much “earnings management” should be pursued and what types of behaviors are simply going to be unraveled by investors?

Students will explore: the concepts of “legal” earnings management as compared to true value optimization; whether sophisticated investors misled by such behaviors; and the management of information flows to investors.

In April 1992, this multinational consumer foods and beverages company is the focus of takeover rumors, which have prompted an assessment of the firm's returns. The student must choose among the principal methods of estimating the weighted-average cost of capital (WACC) for GrandMet and its three main business segments, and must then produce WACC estimates in order to evaluate the firm's performance.

Route 11 Chips, a regional potato chip company, is struggling with whether to reduce the number of flavors it markets. Additional flavors add operational cost, but management believes that some of the flavors are important to Route 11's brand image and that trimming the line might damage the brand. Route 11 has also taken a price increase recently and management is interested in finding out if there is additional room to raise prices. To analyze these issues in the case, students have access to five years of data on sales by flavor and package size as well as actual price and margin information (in a supplemental Excel spreadsheet).

A small adhesives company faces exchange rate risks as it makes its first foray into international sales. The receipt of payment from an unhedged foreign-currency-denominated past sale illustrates potential currency risks while a potential follow-on order provides a context to discuss potential hedges. Sufficient detailed information is provided for the students to construct and analyze both a forward and money market hedge. A teaching note and instructor and student Excel spreadsheets are available.

In the (A) case, Jason Phillips, Chief Financial Officer of a soup manufacturing business, is given the task of maximizing the value of the firm twelve months after the case is set. Although he does not want to break any legal rules, Jason is interested to see whether accounting and real action choices can be used to enhance the company's financial position and increase its perceived value to investors. The case permits him to select from a menu of options, including decisions on product pricing, inventory levels, accounts receivables, leasing or purchasing a new machine and valuation or sale of securities. These choices are fed into an Excel spreadsheet which adjusts financial projections and accounting disclosures accordingly.

In the (B) case, Ben Kerr, Chief Investment Officer at one of Dragon's main competitors, considers the financial statements produced by Dragon to unravel any earnings management behavior and establish a true value for the company. Although the case can be focused on the accounting consequences of real decisions, a richer discussion is obtained when considering the ethical angles of the decision process. In particular, how much “earnings management” should be pursued and what types of behaviors are simply going to be unraveled by investors?

Students will explore: the concepts of “legal” earnings management as compared to true value optimization; whether sophisticated investors misled by such behaviors; and the management of information flows to investors.