1. Pick up Britannia and its annual reports for the latest 3 years that are available (If FY21 annual report is not available, use the last years.
2. Go through the Management Discussion and Analysis portions for the last 3 years, and write down key points that you think are relevant
3. Go to the Consolidated Financials – and put in the numbers for the last 4 years from only the annual report. Do not use any other database. The numbers need to be manually put in from the annual report. Other sources such as Moneycontrol, Screener, CMIE, ACE Equity etc will not be accepted.
4. Calculate ratios – all that have been discussed in the videos
5. Identify any increasing, decreasing trends. Identify any numbers which you think are too high or too low, when compared to the sector
6. Try and find the reasons for the trends in point 5 above, by linking data from point 2. You may not have answers to all questions, but basically try and ask the question Why?
7. Debt Analysis
   1. Long term vs Short Term Debt
   2. Analysis of Secured vs Unsecured Debt
   3. Cost of Debt
   4. Domestic vs Foreign Debt (if breakup available in Non Current Liabilities Notes, else try and find from cost of debt)
   5. Interest paid from P&L vs Cash Flow vs Notes to Accounts
8. Dupont Analysis
9. Operating Leverage Analysis
10. Key Costs Analysis – which are the largest costs, and how are they moving? Why are they going up or down?
11. Any other numbers that catch your eye from the notes to accounts.
12. Any specific Corporate Governance Issues
13. Calculate Dividend Yield, and note the dividend, stock split or bonus history if any.

Make a summary of your observations. You need to prepare an excel file and a supporting word document. The word document need not reproduce the data on excel, but should speak more about observations. You should also put in those observations in the excel file, wherever possible.

Answer rating: 100% (QA)

Answer 1 Britannia Industries Limited BIL is one of the leading food companies in India with a presence in over 90 countries BIL is a public limited company listed on the Bombay Stock Exchange BSE and ... View the full answer