• Mahindra Finance: Investor's Dilemma - Student Spreadsheet

    Student Spreadsheet to accompany product W36893.
    詳細資料
  • Mahindra Finance: Investor's Dilemma

    In the summer of 2023, an analyst was considering the valuation of Mahindra and Mahindra Financial Services Ltd. (Mahindra Finance) and tracking the performance of the non-banking financial company (NBFC) industry in India. Mahindra Finance’s stock had been volatile over the past five years, reaching a low share price of ₹76.46 in May 2020 and a high of ₹373.80 in February 2020. This share price volatility could be attributed to the average asset quality. The firm’s ongoing process transformation, Vision 2025, was expected to bring some stability and a reduction in volatility. The company’s management had formulated objectives for 2025 that were aimed at increasing the company’s assets under management by a factor of two in comparison to 2023. Given that the company was poised to achieve growth in the future, the analyst wanted to know the intrinsic value of Mahindra Finance. What would be the fair price for each share of Mahindra Finance? What method of valuation would provide the closest approximation of the intrinsic value of the company and its performance?
    詳細資料
  • Mahindra Finance: Investor's Dilemma - Instructor Spreadsheet

    Instructor Spreadsheet to accompany product W36894.
    詳細資料
  • HDFC Life: Free Cash Flow Valuation - Instructor Spreadsheet

    Instructor Spreadsheet to accompany product W34076.
    詳細資料
  • HDFC Life: Free Cash Flow Valuation

    In June 2022, two MBA students from a post-secondary institution in India were asked by their professor to build a valuation model for HDFC Life Insurance Company Limited to assess the company’s stock price for investors. The students understood the importance of the task and tracked the company’s historic stock price. They found that its share price dropped considerably in 2021, as the company’s profits decreased due to a high number of claims during the COVID-19 pandemic. In 2022, however, the company witnessed a rise in profits mainly due to a high number of premiums, as fears from COVID-19 infections led more people to buy insurance coverage. Given that the company’s profits and performance had been fluctuating, the students wanted to know whether the stock was undervalued, overvalued, or fairly priced. Their task was to determine the ideal stock price and whether to recommend the stock to investors.
    詳細資料
  • HDFC Life: Free Cash Flow Valuation - Student Spreadsheet

    Student Spreadsheet to accompany product W34075.
    詳細資料
  • HDFC Life: Free Cash Flow Valuation, Student Spreadsheet

    Spreadsheet Supplement for Case W34075.
    詳細資料
  • HDFC Life: Free Cash Flow Valuation

    In June 2022, two MBA students from a post-secondary institution in India were asked by their professor to build a valuation model for HDFC Life Insurance Company Limited to assess the company's stock price for investors. The students understood the importance of the task and tracked the company's historic stock price. They found that its share price dropped considerably in 2021, as the company's profits decreased due to a high number of claims during the COVID-19 pandemic. In 2022, however, the company witnessed a rise in profits mainly due to a high number of premiums, as fears from COVID-19 infections led more people to buy insurance coverage. Given that the company's profits and performance had been fluctuating, the students wanted to know whether the stock was undervalued, overvalued, or fairly priced. Their task was to determine the ideal stock price and whether to recommend the stock to investors.
    詳細資料
  • Federal Bank: Dividend Discount Valuation

    In mid-2014, an investor was examining Federal Bank stock and its valuation. In order to fund her children’s educational savings for the future, the investor had been looking for high-growth but undervalued investment stocks. Based on her current market analysis, she had narrowed her search to Federal Bank Limited. Could Federal Bank be the undervalued stock that the investor was looking for? What would be the fair fundamental value of the bank? The dividend discount valuation model, a technique to identify and value undervalued stocks, would determine whether Federal Bank was a potential investment target.
    詳細資料
  • Federal Bank: Dividend Discount Valuation

    In mid-2014, an investor was examining Federal Bank stock and its valuation. In order to fund her children's educational savings for the future, the investor had been looking for high-growth but undervalued investment stocks. Based on her current market analysis, she had narrowed her search to Federal Bank Limited. Could Federal Bank be the undervalued stock that the investor was looking for? What would be the fair fundamental value of the bank? The dividend discount valuation model, a technique to identify and value undervalued stocks, would determine whether Federal Bank was a potential investment target.
    詳細資料
  • Federal Bank: Dividend Discount Valuation, Student Spreadsheet

    Student spreadsheet for case W17123.
    詳細資料
  • Federal Bank: Dividend Discount Valuation - Student Spreadsheet

    Student spreadsheet for product 9B17N005.
    詳細資料
  • Federal Bank: Dividend Discount Valuation - Instructor Spreadsheet

    Instructor spreadsheet for product 8B17N005.
    詳細資料
  • Pidilite Industries: Assessing Credit Quality

    In mid-2015, a credit analyst with a leading investment company was tasked with assessing the overall credit quality of a chemical company that equity analysts had recommended as a long-term investment for his firm’s insurance equity fund. The analyst set out to use various financial parameters—liquidity, working capital, profitability, efficiency, capital structure, and debt servicing. He believed that a fair assessment of credit quality could help capture a firm’s financial health in its entirety, and had a lot to consider as he began his analysis. The case illustrates best practices for credit analysts in assessing a target company’s overall financial risk profile using the company’s publicly available audited financial statements.
    詳細資料
  • Pidilite Industries: Assessing Credit Quality

    In mid-2015, a credit analyst with a leading investment company was tasked with assessing the overall credit quality of a chemical company that equity analysts had recommended as a long-term investment for his firm's insurance equity fund. The analyst set out to use various financial parameters-liquidity, working capital, profitability, efficiency, capital structure, and debt servicing. He believed that a fair assessment of credit quality could help capture a firm's financial health in its entirety, and had a lot to consider as he began his analysis. The case illustrates best practices for credit analysts in assessing a target company's overall financial risk profile using the company's publicly available audited financial statements.
    詳細資料
  • United Bank of India: Present Fiasco and Future Plans

    In 2013, United Bank of India (UBI), predominantly present in the eastern and northeastern parts of India, faces considerable difficulty in managing its swelling amounts of bad debt. A forensic enquiry by an external agency has identified some serious problems in the bank’s credit appraisal process, loan disbursement procedures, and non-performing assets (NPA) detection system. With the bank’s year-over-year growth of NPAs surpassing the growth of its credit, the management team faces the urgent task of developing an effective turnaround strategy to bring the bank back into a profit position.
    詳細資料
  • United Bank of India: Present Fiasco and Future Plans

    In 2013, United Bank of India (UBI), predominantly present in the eastern and northeastern parts of India, faces considerable difficulty in managing its swelling amounts of bad debt. A forensic enquiry by an external agency has identified some serious problems in the bank's credit appraisal process, loan disbursement procedures, and non-performing assets (NPA) detection system. With the bank's year-over-year growth of NPAs surpassing the growth of its credit, the management team faces the urgent task of developing an effective turnaround strategy to bring the bank back into a profit position.
    詳細資料
  • Bandhan Microfinance: Is Transformation to Bank Status Required?

    Bandhan, the largest microfinance institution in India, has 13,000 staff members and 2,016 branches in 22 states and union territories, 5.2 million borrowers and loans outstanding of INR 57.04 billion. However, its overdependence on external sources of funds along with recent steps by the country’s banking regulator have started worrying Bandhan’s management, from a profitability and sustainability perspective. The banking licence policy declared by India’s central bank in February 2013 came as an opportunity for Bandhan to resolve the predicament it had met. The founder chairman and managing director is now trying to address the question of transforming Bandhan into a bank. Does the present business require any change? As a bank, the cost of funds for Bandhan would come down, as it would be able to raise funds by drawing deposits from clients. But is Bandhan ready to become a bank? How will it meet the various challenges in achieving business transformation?
    詳細資料
  • Bandhan Microfinance: Is Transformation to Bank Status Required?

    Bandhan, the largest microfinance institution in India, has 13,000 staff members and 2,016 branches in 22 states and union territories, 5.2 million borrowers and loans outstanding of INR 57.04 billion. However, its overdependence on external sources of funds along with recent steps by the country's banking regulator have started worrying Bandhan's management, from a profitability and sustainability perspective. The banking licence policy declared by India's central bank in February 2013 came as an opportunity for Bandhan to resolve the predicament it had met. The founder chairman and managing director is now trying to address the question of transforming Bandhan into a bank. Does the present business require any change? As a bank, the cost of funds for Bandhan would come down, as it would be able to raise funds by drawing deposits from clients. But is Bandhan ready to become a bank? How will it meet the various challenges in achieving business transformation?
    詳細資料