In: Finance
***Basic company facts: Name of the firm: Britannia Category of the firm: FMCG State of incorporation: Kolkata, West Bengal, India. Year of foundation: 1918 Primary & secondary SIC codes: N/A Independent auditor: BSR & Co Shares listed in: Bangalore stock exchange, national stock exchange, OTCEI, madras stock exchange, Delhi stock exchange, MCX stock exchange etc. Stock ticker symbol: BRITANNIA
1.)
Summarize your firm’s margins that you computed in No. 6 for each of the last three years.
| 
 Margins  | 
 Most Recent Year  | 
 Next Most Recent Year  | 
 Second Most Recent Year  | 
| 
 Gross profit margin % (gross margin/sales revenue  | 
|||
| 
 Operating profit margin % (Operating income/sales revenue  | 
|||
| 
 Net profit margin % Net income/sales revenue  | 
Source of the data: "Britannia Industries Ltd." retrieved from https://economictimes.indiatimes.com/britannia-industries-ltd/profitandlose/companyid-13934.cms on February 3, 2019
Please see the table below:
The column linkage will help you understand how each of the figures in the cell had been calculated.
| 
 Select data from P&L Statement  | 
 Linkage  | 
 Most Recent Year  | 
 Next Most Recent Year  | 
 Second Most Recent Year  | 
| 
 All financials below in Rs. Cr  | 
 Mar'18  | 
 Mar'17  | 
 Mar'16  | 
|
| 
 Net Sales  | 
 S  | 
 9,304.06  | 
 8,414.37  | 
 7,947.90  | 
| 
 [-] Manufacturing Expenses  | 
 94.98  | 
 75.04  | 
 57.06  | 
|
| 
 [-] Material Consumed  | 
 5,792.31  | 
 5,213.99  | 
 4,635.98  | 
|
| 
 [-] Personal Expenses  | 
 294.87  | 
 241.68  | 
 209.21  | 
|
| 
 Gross profit  | 
 GP  | 
 3,121.90  | 
 2,883.66  | 
 3,045.65  | 
| 
 [-] Selling Expenses  | 
 345.43  | 
 322.07  | 
 384.25  | 
|
| 
 [-] Administrative Expenses  | 
 1,365.99  | 
 1,357.44  | 
 1,529.58  | 
|
| 
 [-] Depreciation  | 
 119.76  | 
 96.43  | 
 86.89  | 
|
| 
 EBIT (Operating Income)  | 
 EBIT  | 
 1,290.72  | 
 1,107.72  | 
 1,044.93  | 
| 
 Profit and Loss for the Year  | 
 NI  | 
 947.89  | 
 843.69  | 
 759.42  | 
| 
 Gross profit margin % (gross margin/sales revenue  | 
 GP / S  | 
 33.55%  | 
 34.27%  | 
 38.32%  | 
| 
 Operating profit margin % (Operating income/sales revenue  | 
 EBIT / S  | 
 13.87%  | 
 13.16%  | 
 13.15%  | 
| 
 Net profit margin % Net income/sales revenue  | 
 NI / S  | 
 10.19%  | 
 10.03%  | 
 9.55%  |