Asian Paints India Complete Fundamental Analysis

Description
Asian paints is the largest paint company in India and 3rd largest in Asia after Nippon and Kansai of Japan. It is currently the 9th largest paint company in the world. Asian Paints has 27 manufacturing plants in India and is a constituent of both the Sensex and Nifty stock indices. It has operations in 16+ countries and employees 7500+ people across the world.

The company has 50+ years of market leadership in India. They have a dealer network of 65,000+ and is a leader across all geographies except the Kashmir region in India. Asian Paints have deeply penetrated the Indian market down to the rural economy where they sell distemper paints, to the automobile sector where they currently have 20% of the total market.

The major competitors are Kansai Nerolac and Berger paints in India. These companies, however, have not been able to establish a solid market presence and compete with Asian paints in the organised sector. The company is also focused on R&D and introduces 25 colour additions every year. They also have installed paint dispensing (NNG) machines with almost all retailers which saves them warehousing and encourage retailers to sell Asian Paint products

The Model covers all the major fundamental aspects of Asian Paints India Ltd over the ten year period. The model is easy to edit and update for the future years as well. It includes:
1. Growth Ratios
2. Profitability Ratios
3. Cash Flow Ratios
4. Liquidity and Solvency Ratios
5. Efficiency Ratios
6. Valuation Ratios
7. ROE (Du Pont Analysis)
8. Common Size analysis
9. Enterprise Valuation
10. Financial Strength Analysis

Further Qualitative analysis is also done considering these factors and ratings have been assigned. The analysis is in the word document along with the excel model.