Instructor Spreadsheet to accompany product W36894.

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?

Student Spreadsheet to accompany product W36893.