Instructor Spreadsheet for product 8B16N015.

Student Spreadsheet for product 9B16N015.

In early 2013, an analyst at an insurance company was examining whether IndusInd Bank, a mid-size bank in India, would be a good investment for the insurance fund’s equity portfolio. From January 2008 until March 30, 2013, the bank’s stock had tripled under its new management. The analyst wondered whether deploying funds in the bank would yield any significant returns. He decided to use the available financial information and the residual income valuation method to forecast the company’s stock price.

In early 2013, an analyst at an insurance company was examining whether IndusInd Bank, a mid-size bank in India, would be a good investment for the insurance fund's equity portfolio. From January 2008 until March 30, 2013, the bank's stock had tripled under its new management. The analyst wondered whether deploying funds in the bank would yield any significant returns. He decided to use the available financial information and the residual income valuation method to forecast the company's stock price.

Student spreadsheet for case W16287.