個案總覽

Instructor Spreadsheet to accompany product 8B18N003.

Spreadsheet to accompany product 9B18N003.

Yash Building Centre, based in Raipur, central India, was in the business of manufacturing fly ash bricks and blocks. At the beginning of 2016, after achieving decent growth and gaining goodwill among local builders and contractors, the managing partner was actively looking to expand business operations into tiles, pavers, and curbstones. He believed this expansion would improve the firm’s profitability by allowing it to take full advantage of its reputation among existing customers. It would also enable the firm to increase its size. A key question was, would this decision facilitate value creation for the firm? To make the investment decision, the managing partner needed to consider the return on investment and the capacity at which the new unit would break even.

Yash Building Centre, based in Raipur, central India, was in the business of manufacturing fly ash bricks and blocks. At the beginning of 2016, after achieving decent growth and gaining goodwill among local builders and contractors, the managing partner was actively looking to expand business operations into tiles, pavers, and curbstones. He believed this expansion would improve the firm's profitability by allowing it to take full advantage of its reputation among existing customers. It would also enable the firm to increase its size. A key question was, would this decision facilitate value creation for the firm? To make the investment decision, the managing partner needed to consider the return on investment and the capacity at which the new unit would break even.

Student spreadsheet for case W18130.

Next India Traveler (NIT) was a travel and tour operator based in Chandigarh, India. The young start-up had been in business since 2012. It offered both inbound and outbound tour and travel packages that covered all the major tourist destinations in India and the Asia-Pacific region. NIT’s motto was to provide its clients with best-in-class services for all aspects of travel and tourism, all under one roof. <br><br>An upcoming meeting with a venture capitalist firm was crucial to NIT’s future plans for growth, and the investors would certainly want to have a clear idea of the company’s value. Thus, before making his pitch to the venture capital firm, NIT’s owner wanted to perform a valuation of his start-up. Unfortunately, the lack of long-term data and a proven methodology for valuing relatively new companies meant the owner faced a considerable challenge in terms of identifying the most appropriate model for the task.

Next India Traveler (NIT) was a travel and tour operator based in Chandigarh, India. The young start-up had been in business since 2012. It offered both inbound and outbound tour and travel packages that covered all the major tourist destinations in India and the Asia-Pacific region. NIT's motto was to provide its clients with best-in-class services for all aspects of travel and tourism, all under one roof. An upcoming meeting with a venture capitalist firm was crucial to NIT's future plans for growth, and the investors would certainly want to have a clear idea of the company's value. Thus, before making his pitch to the venture capital firm, NIT's owner wanted to perform a valuation of his start-up. Unfortunately, the lack of long-term data and a proven methodology for valuing relatively new companies meant the owner faced a considerable challenge in terms of identifying the most appropriate model for the task.

Instructor spreadsheet for product 8B14N012.

Student spreadsheet for product 9B14N012.

A student in his final year at a management school has been asked by his uncle to suggest an optimal investment portfolio for the reinvestment of his retirement account. His uncle wants to invest only in mutual funds managed by reputed asset management companies that have historically given superior returns. He also wants to limit the risk involved to less than 10 per cent per annum. The student now needs to prepare a portfolio that offers the highest possible return for the risk defined by his uncle.

A student in his final year at a management school has been asked by his uncle to suggest an optimal investment portfolio for the reinvestment of his retirement account. His uncle wants to invest only in mutual funds managed by reputed asset management companies that have historically given superior returns. He also wants to limit the risk involved to less than 10 per cent per annum. The student now needs to prepare a portfolio that offers the highest possible return for the risk defined by his uncle.

Student spreadsheet for case W14232.