Search results

Spiegel Online (www.spiegel.de) is the leading news Web site in Germany. The site was first designed to accompany Der Spiegel, one of Europe's largest and Germany's most influential weekly magazine, which has a weekly circulation of around one million. The site's content is produced by a team of more than fifty journalists writing in several categories: politics, business, networld, panorama, arts and entertainment, science, university, school, sports, travel, weather, and automobiles. The original content is complemented by articles purchased from news agencies and selected articles from the print edition. Spiegel-Verlag is a major contributor to the Hamburg Media School, which offers professional master's degree programs in Media Management (MBA), film, and journalism. In their second year, MBA students typically engage in consulting projects with major media companies. In a recent assignment, Spiegel Online posed two questions to the MBA team: are there any chances for an economically successful entry into the market for interactive classifieds? And if so, what should the business model look like in detail? A student team analyzed markets for classified ads and found one market segment that appeared to be particularly promising: the market for art objects. During the development of a business plan for a new venture in this market it became apparent that there is much uncertainty about the key input parameters to the business plan. As a result, it is very difficult to assess the viability of the business idea. How can the team properly account for the uncertain input parameters? What is the impact of this uncertainty on the bottom line? Will a Web site for art objects earn or lose money? How can the team communicate this uncertainty to a group of high-level decision makers who want a simple “go or no-go” recommendation?

The objective is to make students aware of the applicability of Monte Carlo simulation to the analysis of complex business plans. Students should learn how to explicitly account for uncertain inputs in a business plan, how to assess the impact of uncertainty on the bottom line via Monte Carlo simulation, and how to communicate the results of their analysis to high-level decision makers.

After completing this case, students should be able to: identify and compute relevant cash flows in relation to a real estate project and compute the net present value (NPV). Determine the target return or cost of capital (by looking at historical economic indicators). Design or formulate a sensitivity analysis to determine the drivers of the project value. Evaluate real estate and other investments taking qualitative and quantitative factors into consideration. Demonstrate the computation of a break-even rate to determine the minimum or maximum revenue or cost required for a project to be viable.

This case study is about the Golden Beak Securities Pension Fund that wanted to invest in a Hostel Project in one of the universities in Ghana. Most universities in Ghana faced an acute shortage of on-campus accommodation. Also, the Government of Ghana, in 2017, implemented a programme to make Senior High School in Ghana free. This was expected to increase the number of students who will enter the existing universities. The project was therefore seen as strategic, as it would help ease the pressure of on-campus accommodation while providing diversification for the pension fund. As part of the investment committee’s (IC) quest to improve the skill set available to it, especially in relation to real estate investments, Esi Abebrese was appointed as one of the members of the IC of GSB. Her main task was to collect information on key macroeconomic variables, as well as granular information on project costs and revenues and conduct investment appraisal. Esi was scheduled to make a presentation to the IC on the 15th of October 2019 following which the Committee will debate and make a decision. The project had an estimated cost of GH¢52m with a total number of 3,424 student beds and ancillary facilities. Undertaking the project required moving funds from investments in money market securities with one of the banks in Ghana. The investments in the money market securities were currently yielding about 16% a year. The determination of the cost of capital was critical and Esi and Nana eventually settled on a long-term weighted average cost of capital of 14%. This was after considering the trend of inflation, monetary policy rates, treasury rates, stock market returns and a report on returns on commercial real estate properties in Ghana. An exit capitalisation rate of 20% was also estimated for the purposes of determining the value of the property at the end of the investment horizon. Esi also obtained estimates of cost and revenue for the project and proceeded to carry out a feasibility analysis on the project. This consisted of an NPV analysis and sensitivity analysis on various factors to determine the drivers of the project value. The IC had to take several factors (both quantitative and qualitative) into consideration before making a decision. Esi believed that these factors included the diversification of the fund’s assets, the return on investment, potential oversupply of hostel accommodation, the social responsibility of providing student accommodation and the impact of any prolonged shutdown of the university.

Masters/advanced undergraduate.

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

CSS 1: Accounting and Finance.