Company P&L and BS from Moneycontrol.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd\n",
    "import lxml as lxml\n",
    "import numpy as np\n",
    "import html5lib as ht\n",
    "from pandas.io.html import read_html"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [],
   "source": [
    "pl1 = 'https://www.moneycontrol.com/financials/marutisuzukiindia/profit-lossVI/MS24/#MS24'\n",
    "pl2 = pl1.replace('#','2#')\n",
    "pl3 = pl1.replace('#','3#')\n",
    "bl2 = pl2.replace('profit-lossVI','balance-sheetVI')\n",
    "bl3 = bl2.replace('2#','3#')\n",
    "bl1 = bl2.replace('2#','#')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {},
   "outputs": [],
   "source": [
    "p1 = read_html(pl1,  attrs={\"class\":\"mctable1\"}, index_col=0, header=0)\n",
    "p1 = pd.DataFrame(p1[0])\n",
    "p2 = read_html(pl2,  attrs={\"class\":\"mctable1\"}, index_col=0, header=0)\n",
    "p2 = pd.DataFrame(p2[0])\n",
    "p3 = read_html(pl3,  attrs={\"class\":\"mctable1\"}, index_col=0, header=0)\n",
    "p3 = pd.DataFrame(p3[0])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {},
   "outputs": [],
   "source": [
    "b1 = read_html(bl1,  attrs={\"class\":\"mctable1\"}, index_col=0, header=0)\n",
    "b1 = pd.DataFrame(b1[0])\n",
    "b2 = read_html(bl2,  attrs={\"class\":\"mctable1\"}, index_col=0, header=0)\n",
    "b2 = pd.DataFrame(b2[0])\n",
    "b3 = read_html(bl3,  attrs={\"class\":\"mctable1\"}, index_col=0, header=0)\n",
    "b3 = pd.DataFrame(b3[0])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {},
   "outputs": [],
   "source": [
    "index = p1.index.name\n",
    "index2 = b1.index.name"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {},
   "outputs": [],
   "source": [
    "pt = p1.merge(p2, on = index)\n",
    "p = pt.merge(p3, on = index)\n",
    "bt = b1.merge(b2, on = index2)\n",
    "b = bt.merge(b3, on = index2)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {},
   "outputs": [],
   "source": [
    "p = p[:27]\n",
    "p = p.drop([p1.index[0]])\n",
    "b = b.drop([p1.index[0]])\n",
    "f = p.append(b)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "metadata": {},
   "outputs": [
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "C:\\Users\\krrish\\Anaconda3\\lib\\site-packages\\ipykernel_launcher.py:3: FutureWarning: convert_objects is deprecated.  To re-infer data dtypes for object columns, use DataFrame.infer_objects()\n",
      "For all other conversions use the data-type specific converters pd.to_datetime, pd.to_timedelta and pd.to_numeric.\n",
      "  This is separate from the ipykernel package so we can avoid doing imports until\n"
     ]
    }
   ],
   "source": [
    "f = f.sort_index(axis=1 ,ascending=True)\n",
    "f = f.drop(f.columns[[-3,-2,-1]], axis = 1)\n",
    "f = f.convert_objects(convert_numeric=True)\n",
    "f = f.replace(np.nan, \"\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Mar 05</th>\n",
       "      <th>Mar 06</th>\n",
       "      <th>Mar 07</th>\n",
       "      <th>Mar 08</th>\n",
       "      <th>Mar 09</th>\n",
       "      <th>Mar 10</th>\n",
       "      <th>Mar 11</th>\n",
       "      <th>Mar 12</th>\n",
       "      <th>Mar 13</th>\n",
       "      <th>Mar 14</th>\n",
       "      <th>Mar 15</th>\n",
       "      <th>Mar 16</th>\n",
       "      <th>Mar 17</th>\n",
       "      <th>Mar 18</th>\n",
       "      <th>Mar 19</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>INCOME</th>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Revenue From Operations [Gross]</th>\n",
       "      <td>13458.2</td>\n",
       "      <td>14898.8</td>\n",
       "      <td>17358.4</td>\n",
       "      <td>21200.4</td>\n",
       "      <td>23381.5</td>\n",
       "      <td>32174.1</td>\n",
       "      <td>40102.1</td>\n",
       "      <td>38614.1</td>\n",
       "      <td>48114.7</td>\n",
       "      <td>47822.8</td>\n",
       "      <td>53768.5</td>\n",
       "      <td>63957.7</td>\n",
       "      <td>76140.8</td>\n",
       "      <td>80336.5</td>\n",
       "      <td>83026.5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Less: Excise/Sevice Tax/Other Levies</th>\n",
       "      <td>2411.9</td>\n",
       "      <td>2700.9</td>\n",
       "      <td>2552</td>\n",
       "      <td>3133.6</td>\n",
       "      <td>2652.1</td>\n",
       "      <td>2856.4</td>\n",
       "      <td>4253.1</td>\n",
       "      <td>3908.2</td>\n",
       "      <td>5502.1</td>\n",
       "      <td>5178</td>\n",
       "      <td>5163</td>\n",
       "      <td>7516.5</td>\n",
       "      <td>9231.4</td>\n",
       "      <td>2231.7</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Revenue From Operations [Net]</th>\n",
       "      <td>11046.3</td>\n",
       "      <td>12197.9</td>\n",
       "      <td>14806.4</td>\n",
       "      <td>18066.8</td>\n",
       "      <td>20729.4</td>\n",
       "      <td>29317.7</td>\n",
       "      <td>35849</td>\n",
       "      <td>34705.9</td>\n",
       "      <td>42612.6</td>\n",
       "      <td>42644.8</td>\n",
       "      <td>48605.5</td>\n",
       "      <td>56441.2</td>\n",
       "      <td>66909.4</td>\n",
       "      <td>78104.8</td>\n",
       "      <td>83026.5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Total Operating Revenues</th>\n",
       "      <td>11046.3</td>\n",
       "      <td>12197.9</td>\n",
       "      <td>14806.4</td>\n",
       "      <td>18066.8</td>\n",
       "      <td>20729.4</td>\n",
       "      <td>29317.7</td>\n",
       "      <td>36618.4</td>\n",
       "      <td>35587.1</td>\n",
       "      <td>43587.9</td>\n",
       "      <td>43700.6</td>\n",
       "      <td>49970.6</td>\n",
       "      <td>57538.1</td>\n",
       "      <td>68034.8</td>\n",
       "      <td>79762.7</td>\n",
       "      <td>86020.3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Other Income</th>\n",
       "      <td>211.6</td>\n",
       "      <td>216.1</td>\n",
       "      <td>390.2</td>\n",
       "      <td>571.4</td>\n",
       "      <td>564.6</td>\n",
       "      <td>748.7</td>\n",
       "      <td>508.8</td>\n",
       "      <td>826.8</td>\n",
       "      <td>812.4</td>\n",
       "      <td>822.9</td>\n",
       "      <td>831.6</td>\n",
       "      <td>1461</td>\n",
       "      <td>2300.1</td>\n",
       "      <td>2045.5</td>\n",
       "      <td>2561</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Total Revenue</th>\n",
       "      <td>11257.9</td>\n",
       "      <td>12414</td>\n",
       "      <td>15196.6</td>\n",
       "      <td>18638.2</td>\n",
       "      <td>21294</td>\n",
       "      <td>30066.4</td>\n",
       "      <td>37127.2</td>\n",
       "      <td>36413.9</td>\n",
       "      <td>44400.3</td>\n",
       "      <td>44523.5</td>\n",
       "      <td>50802.2</td>\n",
       "      <td>58999.1</td>\n",
       "      <td>70334.9</td>\n",
       "      <td>81808.2</td>\n",
       "      <td>88581.3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>EXPENSES</th>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Cost Of Materials Consumed</th>\n",
       "      <td>8264.6</td>\n",
       "      <td>9016.2</td>\n",
       "      <td>10344.5</td>\n",
       "      <td>13328.5</td>\n",
       "      <td>15451.2</td>\n",
       "      <td>21947.9</td>\n",
       "      <td>27141.8</td>\n",
       "      <td>26707</td>\n",
       "      <td>30349.2</td>\n",
       "      <td>28898.9</td>\n",
       "      <td>32867.8</td>\n",
       "      <td>35483.9</td>\n",
       "      <td>42629.6</td>\n",
       "      <td>44941.3</td>\n",
       "      <td>45023.9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Operating And Direct Expenses</th>\n",
       "      <td>215.7</td>\n",
       "      <td>302.4</td>\n",
       "      <td>392.4</td>\n",
       "      <td>523.3</td>\n",
       "      <td>716.1</td>\n",
       "      <td>1061.6</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Changes In Inventories Of FG,WIP And Stock-In Trade</th>\n",
       "      <td>-141.7</td>\n",
       "      <td>-199.7</td>\n",
       "      <td>200.7</td>\n",
       "      <td>-336.3</td>\n",
       "      <td>356.6</td>\n",
       "      <td>-200.9</td>\n",
       "      <td>-56</td>\n",
       "      <td>-131.2</td>\n",
       "      <td>23.4</td>\n",
       "      <td>18.5</td>\n",
       "      <td>-455.9</td>\n",
       "      <td>6.9</td>\n",
       "      <td>-380.1</td>\n",
       "      <td>40.7</td>\n",
       "      <td>210.8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Employee Benefit Expenses</th>\n",
       "      <td>196</td>\n",
       "      <td>228.7</td>\n",
       "      <td>288.4</td>\n",
       "      <td>356.2</td>\n",
       "      <td>471.1</td>\n",
       "      <td>545.6</td>\n",
       "      <td>703.6</td>\n",
       "      <td>843.8</td>\n",
       "      <td>1069.6</td>\n",
       "      <td>1368.1</td>\n",
       "      <td>1606.6</td>\n",
       "      <td>1978.8</td>\n",
       "      <td>2331</td>\n",
       "      <td>2833.8</td>\n",
       "      <td>3254.9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Finance Costs</th>\n",
       "      <td>36</td>\n",
       "      <td>20.4</td>\n",
       "      <td>37.6</td>\n",
       "      <td>59.6</td>\n",
       "      <td>51</td>\n",
       "      <td>33.5</td>\n",
       "      <td>25</td>\n",
       "      <td>55.2</td>\n",
       "      <td>189.8</td>\n",
       "      <td>175.9</td>\n",
       "      <td>206</td>\n",
       "      <td>81.5</td>\n",
       "      <td>89.4</td>\n",
       "      <td>345.7</td>\n",
       "      <td>75.8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Depreciation And Amortisation Expenses</th>\n",
       "      <td>456.8</td>\n",
       "      <td>285.4</td>\n",
       "      <td>271.4</td>\n",
       "      <td>568.2</td>\n",
       "      <td>706.5</td>\n",
       "      <td>825</td>\n",
       "      <td>1013.5</td>\n",
       "      <td>1138.4</td>\n",
       "      <td>1861.2</td>\n",
       "      <td>2084.4</td>\n",
       "      <td>2470.3</td>\n",
       "      <td>2820.2</td>\n",
       "      <td>2602.1</td>\n",
       "      <td>2757.9</td>\n",
       "      <td>3018.9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Other Expenses</th>\n",
       "      <td>521.8</td>\n",
       "      <td>551.6</td>\n",
       "      <td>811.8</td>\n",
       "      <td>944.1</td>\n",
       "      <td>1178</td>\n",
       "      <td>1407.3</td>\n",
       "      <td>3938.1</td>\n",
       "      <td>4164.7</td>\n",
       "      <td>5773.5</td>\n",
       "      <td>5922.1</td>\n",
       "      <td>6643.1</td>\n",
       "      <td>8037.7</td>\n",
       "      <td>8724.1</td>\n",
       "      <td>9991.5</td>\n",
       "      <td>11634</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Total Expenses</th>\n",
       "      <td>10009.2</td>\n",
       "      <td>10669.4</td>\n",
       "      <td>12962.7</td>\n",
       "      <td>16220.7</td>\n",
       "      <td>19656.1</td>\n",
       "      <td>26525</td>\n",
       "      <td>34018.4</td>\n",
       "      <td>34267.7</td>\n",
       "      <td>41409.3</td>\n",
       "      <td>40865</td>\n",
       "      <td>45934</td>\n",
       "      <td>51555.4</td>\n",
       "      <td>60374.6</td>\n",
       "      <td>70804.8</td>\n",
       "      <td>78115.7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Profit/Loss Before Exceptional, ExtraOrdinary Items And Tax</th>\n",
       "      <td>1248.7</td>\n",
       "      <td>1744.6</td>\n",
       "      <td>2233.9</td>\n",
       "      <td>2417.5</td>\n",
       "      <td>1637.9</td>\n",
       "      <td>3541.4</td>\n",
       "      <td>3108.8</td>\n",
       "      <td>2146.2</td>\n",
       "      <td>2991</td>\n",
       "      <td>3658.5</td>\n",
       "      <td>4868.2</td>\n",
       "      <td>7443.7</td>\n",
       "      <td>9960.3</td>\n",
       "      <td>11003.4</td>\n",
       "      <td>10465.6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Exceptional Items</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Profit/Loss Before Tax</th>\n",
       "      <td>1248.7</td>\n",
       "      <td>1744.6</td>\n",
       "      <td>2233.9</td>\n",
       "      <td>2417.5</td>\n",
       "      <td>1637.9</td>\n",
       "      <td>3541.4</td>\n",
       "      <td>3108.8</td>\n",
       "      <td>2146.2</td>\n",
       "      <td>2991</td>\n",
       "      <td>3658.5</td>\n",
       "      <td>4868.2</td>\n",
       "      <td>7443.7</td>\n",
       "      <td>9960.3</td>\n",
       "      <td>11003.4</td>\n",
       "      <td>10465.6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Tax Expenses-Continued Operations</th>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Current Tax</th>\n",
       "      <td>519.8</td>\n",
       "      <td>587.3</td>\n",
       "      <td>608.9</td>\n",
       "      <td>750.9</td>\n",
       "      <td>459.2</td>\n",
       "      <td>1123</td>\n",
       "      <td>810.1</td>\n",
       "      <td>413.8</td>\n",
       "      <td>722.8</td>\n",
       "      <td>747.9</td>\n",
       "      <td>1302.6</td>\n",
       "      <td>2041.4</td>\n",
       "      <td>2335.6</td>\n",
       "      <td>3349.5</td>\n",
       "      <td>2932.3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Less: MAT Credit Entitlement</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>90.4</td>\n",
       "      <td>0</td>\n",
       "      <td>70.4</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Deferred Tax</th>\n",
       "      <td>-73.3</td>\n",
       "      <td>-32.1</td>\n",
       "      <td>89.7</td>\n",
       "      <td>2.6</td>\n",
       "      <td>-11.8</td>\n",
       "      <td>-28.1</td>\n",
       "      <td>10.1</td>\n",
       "      <td>97.2</td>\n",
       "      <td>-33.5</td>\n",
       "      <td>127.6</td>\n",
       "      <td>-75.2</td>\n",
       "      <td>38</td>\n",
       "      <td>274.5</td>\n",
       "      <td>-67.9</td>\n",
       "      <td>32.7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Tax For Earlier Years</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Total Tax Expenses</th>\n",
       "      <td>446.5</td>\n",
       "      <td>560.9</td>\n",
       "      <td>705.3</td>\n",
       "      <td>763.3</td>\n",
       "      <td>457.1</td>\n",
       "      <td>1094.9</td>\n",
       "      <td>820.2</td>\n",
       "      <td>511</td>\n",
       "      <td>598.9</td>\n",
       "      <td>875.5</td>\n",
       "      <td>1157</td>\n",
       "      <td>2079.4</td>\n",
       "      <td>2610.1</td>\n",
       "      <td>3281.6</td>\n",
       "      <td>2965</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Profit/Loss After Tax And Before ExtraOrdinary Items</th>\n",
       "      <td>802.2</td>\n",
       "      <td>1183.7</td>\n",
       "      <td>1528.6</td>\n",
       "      <td>1654.2</td>\n",
       "      <td>1180.8</td>\n",
       "      <td>2446.5</td>\n",
       "      <td>2288.6</td>\n",
       "      <td>1635.2</td>\n",
       "      <td>2392.1</td>\n",
       "      <td>2783</td>\n",
       "      <td>3711.2</td>\n",
       "      <td>5364.3</td>\n",
       "      <td>7350.2</td>\n",
       "      <td>7721.8</td>\n",
       "      <td>7500.6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>EQUITIES AND LIABILITIES</th>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>SHAREHOLDER'S FUNDS</th>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Equity Share Capital</th>\n",
       "      <td>144.5</td>\n",
       "      <td>144.5</td>\n",
       "      <td>144.5</td>\n",
       "      <td>144.5</td>\n",
       "      <td>144.5</td>\n",
       "      <td>144.5</td>\n",
       "      <td>144.5</td>\n",
       "      <td>144.5</td>\n",
       "      <td>151</td>\n",
       "      <td>151</td>\n",
       "      <td>151</td>\n",
       "      <td>151</td>\n",
       "      <td>151</td>\n",
       "      <td>151</td>\n",
       "      <td>151</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Total Share Capital</th>\n",
       "      <td>144.5</td>\n",
       "      <td>144.5</td>\n",
       "      <td>144.5</td>\n",
       "      <td>144.5</td>\n",
       "      <td>144.5</td>\n",
       "      <td>144.5</td>\n",
       "      <td>144.5</td>\n",
       "      <td>144.5</td>\n",
       "      <td>151</td>\n",
       "      <td>151</td>\n",
       "      <td>151</td>\n",
       "      <td>151</td>\n",
       "      <td>151</td>\n",
       "      <td>151</td>\n",
       "      <td>151</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Inventories</th>\n",
       "      <td>666.6</td>\n",
       "      <td>881.2</td>\n",
       "      <td>713.2</td>\n",
       "      <td>1038</td>\n",
       "      <td>902.3</td>\n",
       "      <td>1208.8</td>\n",
       "      <td>1415</td>\n",
       "      <td>1796.5</td>\n",
       "      <td>1840.7</td>\n",
       "      <td>1705.9</td>\n",
       "      <td>2615</td>\n",
       "      <td>3132.1</td>\n",
       "      <td>3262.2</td>\n",
       "      <td>3160.8</td>\n",
       "      <td>3325.7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Trade Receivables</th>\n",
       "      <td>599.5</td>\n",
       "      <td>654.8</td>\n",
       "      <td>747.4</td>\n",
       "      <td>655.5</td>\n",
       "      <td>918.9</td>\n",
       "      <td>809.9</td>\n",
       "      <td>824.5</td>\n",
       "      <td>937.6</td>\n",
       "      <td>1469.9</td>\n",
       "      <td>1413.7</td>\n",
       "      <td>1069.8</td>\n",
       "      <td>1322.2</td>\n",
       "      <td>1199.2</td>\n",
       "      <td>1461.8</td>\n",
       "      <td>2310.4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Cash And Cash Equivalents</th>\n",
       "      <td>1029.4</td>\n",
       "      <td>1401.6</td>\n",
       "      <td>1422.8</td>\n",
       "      <td>324</td>\n",
       "      <td>1939</td>\n",
       "      <td>98.2</td>\n",
       "      <td>2508.5</td>\n",
       "      <td>2436.1</td>\n",
       "      <td>775</td>\n",
       "      <td>629.7</td>\n",
       "      <td>18.3</td>\n",
       "      <td>42.2</td>\n",
       "      <td>13.8</td>\n",
       "      <td>71.1</td>\n",
       "      <td>178.9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Short Term Loans And Advances</th>\n",
       "      <td>676.5</td>\n",
       "      <td>812</td>\n",
       "      <td>962.5</td>\n",
       "      <td>1073.4</td>\n",
       "      <td>1730.9</td>\n",
       "      <td>1655.5</td>\n",
       "      <td>683.6</td>\n",
       "      <td>778.3</td>\n",
       "      <td>1115.3</td>\n",
       "      <td>1251.1</td>\n",
       "      <td>1172.8</td>\n",
       "      <td>147.8</td>\n",
       "      <td>2.5</td>\n",
       "      <td>3</td>\n",
       "      <td>16</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>OtherCurrentAssets</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>193</td>\n",
       "      <td>376.4</td>\n",
       "      <td>540.3</td>\n",
       "      <td>358.2</td>\n",
       "      <td>325.6</td>\n",
       "      <td>2144.9</td>\n",
       "      <td>2119.7</td>\n",
       "      <td>2007.4</td>\n",
       "      <td>1485.1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Total Current Assets</th>\n",
       "      <td>2972</td>\n",
       "      <td>3749.6</td>\n",
       "      <td>3845.9</td>\n",
       "      <td>3090.9</td>\n",
       "      <td>5491.1</td>\n",
       "      <td>3772.4</td>\n",
       "      <td>9620.2</td>\n",
       "      <td>11079</td>\n",
       "      <td>10946</td>\n",
       "      <td>14171.7</td>\n",
       "      <td>8197.9</td>\n",
       "      <td>7846</td>\n",
       "      <td>8776.2</td>\n",
       "      <td>7921.4</td>\n",
       "      <td>12361.6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Total Assets</th>\n",
       "      <td>6529.8</td>\n",
       "      <td>7709.1</td>\n",
       "      <td>10263.8</td>\n",
       "      <td>12404</td>\n",
       "      <td>13675.4</td>\n",
       "      <td>16444.9</td>\n",
       "      <td>18425.1</td>\n",
       "      <td>22302.2</td>\n",
       "      <td>26734.2</td>\n",
       "      <td>30535.7</td>\n",
       "      <td>33551</td>\n",
       "      <td>41940</td>\n",
       "      <td>51250.6</td>\n",
       "      <td>59370.1</td>\n",
       "      <td>62931.8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>OTHER ADDITIONAL INFORMATION</th>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>CONTINGENT LIABILITIES, COMMITMENTS</th>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Contingent Liabilities</th>\n",
       "      <td>893.6</td>\n",
       "      <td>1289.7</td>\n",
       "      <td>2094.6</td>\n",
       "      <td>2734.2</td>\n",
       "      <td>1901.7</td>\n",
       "      <td>3657.2</td>\n",
       "      <td>6384.8</td>\n",
       "      <td>6108</td>\n",
       "      <td>8193.3</td>\n",
       "      <td>7210.2</td>\n",
       "      <td>9228.6</td>\n",
       "      <td>9368.7</td>\n",
       "      <td>6744.9</td>\n",
       "      <td>6696.8</td>\n",
       "      <td>11614.9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>CIF VALUE OF IMPORTS</th>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Raw Materials</th>\n",
       "      <td>1635.5</td>\n",
       "      <td>1574.3</td>\n",
       "      <td>1355</td>\n",
       "      <td>1385.8</td>\n",
       "      <td>1786.7</td>\n",
       "      <td>2613.3</td>\n",
       "      <td>2969.1</td>\n",
       "      <td>3045.1</td>\n",
       "      <td>4234.4</td>\n",
       "      <td>3095.5</td>\n",
       "      <td>3181.8</td>\n",
       "      <td>3363.2</td>\n",
       "      <td>3725.4</td>\n",
       "      <td>3887.9</td>\n",
       "      <td>4396.9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Stores, Spares And Loose Tools</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>85.7</td>\n",
       "      <td>86.7</td>\n",
       "      <td>12.8</td>\n",
       "      <td>41.6</td>\n",
       "      <td>23.1</td>\n",
       "      <td>62.9</td>\n",
       "      <td>20.1</td>\n",
       "      <td>66.1</td>\n",
       "      <td>58.5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Trade/Other Goods</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>85.7</td>\n",
       "      <td>86.7</td>\n",
       "      <td>12.8</td>\n",
       "      <td>41.6</td>\n",
       "      <td>23.1</td>\n",
       "      <td>62.9</td>\n",
       "      <td>20.1</td>\n",
       "      <td>66.1</td>\n",
       "      <td>58.5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Capital Goods</th>\n",
       "      <td>86</td>\n",
       "      <td>51.7</td>\n",
       "      <td>68</td>\n",
       "      <td>875.3</td>\n",
       "      <td>1209.5</td>\n",
       "      <td>396.8</td>\n",
       "      <td>825</td>\n",
       "      <td>1162.5</td>\n",
       "      <td>1476.2</td>\n",
       "      <td>1731.2</td>\n",
       "      <td>1011.2</td>\n",
       "      <td>738.3</td>\n",
       "      <td>1481.8</td>\n",
       "      <td>648.3</td>\n",
       "      <td>1331.2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>EXPENDITURE IN FOREIGN EXCHANGE</th>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Expenditure In Foreign Currency</th>\n",
       "      <td>180.3</td>\n",
       "      <td>207.9</td>\n",
       "      <td>331.7</td>\n",
       "      <td>490.5</td>\n",
       "      <td>782.1</td>\n",
       "      <td>991.8</td>\n",
       "      <td>2338.3</td>\n",
       "      <td>2438.9</td>\n",
       "      <td>3102</td>\n",
       "      <td>3087.4</td>\n",
       "      <td>3300.3</td>\n",
       "      <td>3792.6</td>\n",
       "      <td>0</td>\n",
       "      <td>9328.4</td>\n",
       "      <td>12802.7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>REMITTANCES IN FOREIGN CURRENCIES FOR DIVIDENDS</th>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Dividend Remittance In Foreign Currency</th>\n",
       "      <td>30.7</td>\n",
       "      <td>31.3</td>\n",
       "      <td>54.8</td>\n",
       "      <td>70.5</td>\n",
       "      <td>78.3</td>\n",
       "      <td>54.8</td>\n",
       "      <td>94</td>\n",
       "      <td>117.5</td>\n",
       "      <td>117.5</td>\n",
       "      <td>135.8</td>\n",
       "      <td>203.7</td>\n",
       "      <td>424.5</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>EARNINGS IN FOREIGN EXCHANGE</th>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>FOB Value Of Goods</th>\n",
       "      <td>982.3</td>\n",
       "      <td>583.9</td>\n",
       "      <td>578.1</td>\n",
       "      <td>741.3</td>\n",
       "      <td>1502.2</td>\n",
       "      <td>4543.7</td>\n",
       "      <td>3498.8</td>\n",
       "      <td>3691.8</td>\n",
       "      <td>4560.1</td>\n",
       "      <td>4141.7</td>\n",
       "      <td>4633.2</td>\n",
       "      <td>4735.3</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Other Earnings</th>\n",
       "      <td>0.7</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>57</td>\n",
       "      <td></td>\n",
       "      <td>5455.9</td>\n",
       "      <td>5218.6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>BONUS DETAILS</th>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Bonus Equity Share Capital</th>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>NON-CURRENT INVESTMENTS</th>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Non-Current Investments Quoted Market Value</th>\n",
       "      <td>200.1</td>\n",
       "      <td>289.8</td>\n",
       "      <td>270.4</td>\n",
       "      <td>219.5</td>\n",
       "      <td>108.7</td>\n",
       "      <td>215.1</td>\n",
       "      <td>264</td>\n",
       "      <td>172.3</td>\n",
       "      <td>147.4</td>\n",
       "      <td>237.7</td>\n",
       "      <td>560.5</td>\n",
       "      <td>583.9</td>\n",
       "      <td>1027.4</td>\n",
       "      <td>1371</td>\n",
       "      <td>1077.3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Non-Current Investments Unquoted Book Value</th>\n",
       "      <td>1505.5</td>\n",
       "      <td>2040.1</td>\n",
       "      <td>3398.1</td>\n",
       "      <td>5169.6</td>\n",
       "      <td>3162.2</td>\n",
       "      <td>11.1</td>\n",
       "      <td>419.8</td>\n",
       "      <td>1387.2</td>\n",
       "      <td>1867.4</td>\n",
       "      <td>1278.3</td>\n",
       "      <td>9791.1</td>\n",
       "      <td>18404.6</td>\n",
       "      <td>25606.2</td>\n",
       "      <td>33041.9</td>\n",
       "      <td>30609.1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>CURRENT INVESTMENTS</th>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Current Investments Quoted Market Value</th>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Current Investments Unquoted Book Value</th>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>3995.6</td>\n",
       "      <td>4754.1</td>\n",
       "      <td>5229.8</td>\n",
       "      <td>8813.1</td>\n",
       "      <td>2996.4</td>\n",
       "      <td>1056.8</td>\n",
       "      <td>2178.8</td>\n",
       "      <td>1217.3</td>\n",
       "      <td>5045.5</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>90 rows × 15 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                                                     Mar 05   Mar 06   Mar 07  \\\n",
       "INCOME                                                                          \n",
       "Revenue From Operations [Gross]                     13458.2  14898.8  17358.4   \n",
       "Less: Excise/Sevice Tax/Other Levies                 2411.9   2700.9     2552   \n",
       "Revenue From Operations [Net]                       11046.3  12197.9  14806.4   \n",
       "Total Operating Revenues                            11046.3  12197.9  14806.4   \n",
       "Other Income                                          211.6    216.1    390.2   \n",
       "Total Revenue                                       11257.9    12414  15196.6   \n",
       "EXPENSES                                                                        \n",
       "Cost Of Materials Consumed                           8264.6   9016.2  10344.5   \n",
       "Operating And Direct Expenses                         215.7    302.4    392.4   \n",
       "Changes In Inventories Of FG,WIP And Stock-In T...   -141.7   -199.7    200.7   \n",
       "Employee Benefit Expenses                               196    228.7    288.4   \n",
       "Finance Costs                                            36     20.4     37.6   \n",
       "Depreciation And Amortisation Expenses                456.8    285.4    271.4   \n",
       "Other Expenses                                        521.8    551.6    811.8   \n",
       "Total Expenses                                      10009.2  10669.4  12962.7   \n",
       "Profit/Loss Before Exceptional, ExtraOrdinary I...   1248.7   1744.6   2233.9   \n",
       "Exceptional Items                                         0        0        0   \n",
       "Profit/Loss Before Tax                               1248.7   1744.6   2233.9   \n",
       "Tax Expenses-Continued Operations                                               \n",
       "Current Tax                                           519.8    587.3    608.9   \n",
       "Less: MAT Credit Entitlement                              0        0        0   \n",
       "Deferred Tax                                          -73.3    -32.1     89.7   \n",
       "Tax For Earlier Years                                     0        0        0   \n",
       "Total Tax Expenses                                    446.5    560.9    705.3   \n",
       "Profit/Loss After Tax And Before ExtraOrdinary ...    802.2   1183.7   1528.6   \n",
       "EQUITIES AND LIABILITIES                                                        \n",
       "SHAREHOLDER'S FUNDS                                                             \n",
       "Equity Share Capital                                  144.5    144.5    144.5   \n",
       "Total Share Capital                                   144.5    144.5    144.5   \n",
       "...                                                     ...      ...      ...   \n",
       "Inventories                                           666.6    881.2    713.2   \n",
       "Trade Receivables                                     599.5    654.8    747.4   \n",
       "Cash And Cash Equivalents                            1029.4   1401.6   1422.8   \n",
       "Short Term Loans And Advances                         676.5      812    962.5   \n",
       "OtherCurrentAssets                                        0        0        0   \n",
       "Total Current Assets                                   2972   3749.6   3845.9   \n",
       "Total Assets                                         6529.8   7709.1  10263.8   \n",
       "OTHER ADDITIONAL INFORMATION                                                    \n",
       "CONTINGENT LIABILITIES, COMMITMENTS                                             \n",
       "Contingent Liabilities                                893.6   1289.7   2094.6   \n",
       "CIF VALUE OF IMPORTS                                                            \n",
       "Raw Materials                                        1635.5   1574.3     1355   \n",
       "Stores, Spares And Loose Tools                            0        0        0   \n",
       "Trade/Other Goods                                         0        0        0   \n",
       "Capital Goods                                            86     51.7       68   \n",
       "EXPENDITURE IN FOREIGN EXCHANGE                                                 \n",
       "Expenditure In Foreign Currency                       180.3    207.9    331.7   \n",
       "REMITTANCES IN FOREIGN CURRENCIES FOR DIVIDENDS                                 \n",
       "Dividend Remittance In Foreign Currency                30.7     31.3     54.8   \n",
       "EARNINGS IN FOREIGN EXCHANGE                                                    \n",
       "FOB Value Of Goods                                    982.3    583.9    578.1   \n",
       "Other Earnings                                          0.7                     \n",
       "BONUS DETAILS                                                                   \n",
       "Bonus Equity Share Capital                                                      \n",
       "NON-CURRENT INVESTMENTS                                                         \n",
       "Non-Current Investments Quoted Market Value           200.1    289.8    270.4   \n",
       "Non-Current Investments Unquoted Book Value          1505.5   2040.1   3398.1   \n",
       "CURRENT INVESTMENTS                                                             \n",
       "Current Investments Quoted Market Value                                         \n",
       "Current Investments Unquoted Book Value                                         \n",
       "\n",
       "                                                     Mar 08   Mar 09   Mar 10  \\\n",
       "INCOME                                                                          \n",
       "Revenue From Operations [Gross]                     21200.4  23381.5  32174.1   \n",
       "Less: Excise/Sevice Tax/Other Levies                 3133.6   2652.1   2856.4   \n",
       "Revenue From Operations [Net]                       18066.8  20729.4  29317.7   \n",
       "Total Operating Revenues                            18066.8  20729.4  29317.7   \n",
       "Other Income                                          571.4    564.6    748.7   \n",
       "Total Revenue                                       18638.2    21294  30066.4   \n",
       "EXPENSES                                                                        \n",
       "Cost Of Materials Consumed                          13328.5  15451.2  21947.9   \n",
       "Operating And Direct Expenses                         523.3    716.1   1061.6   \n",
       "Changes In Inventories Of FG,WIP And Stock-In T...   -336.3    356.6   -200.9   \n",
       "Employee Benefit Expenses                             356.2    471.1    545.6   \n",
       "Finance Costs                                          59.6       51     33.5   \n",
       "Depreciation And Amortisation Expenses                568.2    706.5      825   \n",
       "Other Expenses                                        944.1     1178   1407.3   \n",
       "Total Expenses                                      16220.7  19656.1    26525   \n",
       "Profit/Loss Before Exceptional, ExtraOrdinary I...   2417.5   1637.9   3541.4   \n",
       "Exceptional Items                                         0        0        0   \n",
       "Profit/Loss Before Tax                               2417.5   1637.9   3541.4   \n",
       "Tax Expenses-Continued Operations                                               \n",
       "Current Tax                                           750.9    459.2     1123   \n",
       "Less: MAT Credit Entitlement                              0        0        0   \n",
       "Deferred Tax                                            2.6    -11.8    -28.1   \n",
       "Tax For Earlier Years                                     0        0        0   \n",
       "Total Tax Expenses                                    763.3    457.1   1094.9   \n",
       "Profit/Loss After Tax And Before ExtraOrdinary ...   1654.2   1180.8   2446.5   \n",
       "EQUITIES AND LIABILITIES                                                        \n",
       "SHAREHOLDER'S FUNDS                                                             \n",
       "Equity Share Capital                                  144.5    144.5    144.5   \n",
       "Total Share Capital                                   144.5    144.5    144.5   \n",
       "...                                                     ...      ...      ...   \n",
       "Inventories                                            1038    902.3   1208.8   \n",
       "Trade Receivables                                     655.5    918.9    809.9   \n",
       "Cash And Cash Equivalents                               324     1939     98.2   \n",
       "Short Term Loans And Advances                        1073.4   1730.9   1655.5   \n",
       "OtherCurrentAssets                                        0        0        0   \n",
       "Total Current Assets                                 3090.9   5491.1   3772.4   \n",
       "Total Assets                                          12404  13675.4  16444.9   \n",
       "OTHER ADDITIONAL INFORMATION                                                    \n",
       "CONTINGENT LIABILITIES, COMMITMENTS                                             \n",
       "Contingent Liabilities                               2734.2   1901.7   3657.2   \n",
       "CIF VALUE OF IMPORTS                                                            \n",
       "Raw Materials                                        1385.8   1786.7   2613.3   \n",
       "Stores, Spares And Loose Tools                            0        0        0   \n",
       "Trade/Other Goods                                         0        0        0   \n",
       "Capital Goods                                         875.3   1209.5    396.8   \n",
       "EXPENDITURE IN FOREIGN EXCHANGE                                                 \n",
       "Expenditure In Foreign Currency                       490.5    782.1    991.8   \n",
       "REMITTANCES IN FOREIGN CURRENCIES FOR DIVIDENDS                                 \n",
       "Dividend Remittance In Foreign Currency                70.5     78.3     54.8   \n",
       "EARNINGS IN FOREIGN EXCHANGE                                                    \n",
       "FOB Value Of Goods                                    741.3   1502.2   4543.7   \n",
       "Other Earnings                                                                  \n",
       "BONUS DETAILS                                                                   \n",
       "Bonus Equity Share Capital                                                      \n",
       "NON-CURRENT INVESTMENTS                                                         \n",
       "Non-Current Investments Quoted Market Value           219.5    108.7    215.1   \n",
       "Non-Current Investments Unquoted Book Value          5169.6   3162.2     11.1   \n",
       "CURRENT INVESTMENTS                                                             \n",
       "Current Investments Quoted Market Value                                         \n",
       "Current Investments Unquoted Book Value                                         \n",
       "\n",
       "                                                     Mar 11   Mar 12   Mar 13  \\\n",
       "INCOME                                                                          \n",
       "Revenue From Operations [Gross]                     40102.1  38614.1  48114.7   \n",
       "Less: Excise/Sevice Tax/Other Levies                 4253.1   3908.2   5502.1   \n",
       "Revenue From Operations [Net]                         35849  34705.9  42612.6   \n",
       "Total Operating Revenues                            36618.4  35587.1  43587.9   \n",
       "Other Income                                          508.8    826.8    812.4   \n",
       "Total Revenue                                       37127.2  36413.9  44400.3   \n",
       "EXPENSES                                                                        \n",
       "Cost Of Materials Consumed                          27141.8    26707  30349.2   \n",
       "Operating And Direct Expenses                             0        0        0   \n",
       "Changes In Inventories Of FG,WIP And Stock-In T...      -56   -131.2     23.4   \n",
       "Employee Benefit Expenses                             703.6    843.8   1069.6   \n",
       "Finance Costs                                            25     55.2    189.8   \n",
       "Depreciation And Amortisation Expenses               1013.5   1138.4   1861.2   \n",
       "Other Expenses                                       3938.1   4164.7   5773.5   \n",
       "Total Expenses                                      34018.4  34267.7  41409.3   \n",
       "Profit/Loss Before Exceptional, ExtraOrdinary I...   3108.8   2146.2     2991   \n",
       "Exceptional Items                                         0        0        0   \n",
       "Profit/Loss Before Tax                               3108.8   2146.2     2991   \n",
       "Tax Expenses-Continued Operations                                               \n",
       "Current Tax                                           810.1    413.8    722.8   \n",
       "Less: MAT Credit Entitlement                              0        0     90.4   \n",
       "Deferred Tax                                           10.1     97.2    -33.5   \n",
       "Tax For Earlier Years                                     0        0        0   \n",
       "Total Tax Expenses                                    820.2      511    598.9   \n",
       "Profit/Loss After Tax And Before ExtraOrdinary ...   2288.6   1635.2   2392.1   \n",
       "EQUITIES AND LIABILITIES                                                        \n",
       "SHAREHOLDER'S FUNDS                                                             \n",
       "Equity Share Capital                                  144.5    144.5      151   \n",
       "Total Share Capital                                   144.5    144.5      151   \n",
       "...                                                     ...      ...      ...   \n",
       "Inventories                                            1415   1796.5   1840.7   \n",
       "Trade Receivables                                     824.5    937.6   1469.9   \n",
       "Cash And Cash Equivalents                            2508.5   2436.1      775   \n",
       "Short Term Loans And Advances                         683.6    778.3   1115.3   \n",
       "OtherCurrentAssets                                      193    376.4    540.3   \n",
       "Total Current Assets                                 9620.2    11079    10946   \n",
       "Total Assets                                        18425.1  22302.2  26734.2   \n",
       "OTHER ADDITIONAL INFORMATION                                                    \n",
       "CONTINGENT LIABILITIES, COMMITMENTS                                             \n",
       "Contingent Liabilities                               6384.8     6108   8193.3   \n",
       "CIF VALUE OF IMPORTS                                                            \n",
       "Raw Materials                                        2969.1   3045.1   4234.4   \n",
       "Stores, Spares And Loose Tools                         85.7     86.7     12.8   \n",
       "Trade/Other Goods                                      85.7     86.7     12.8   \n",
       "Capital Goods                                           825   1162.5   1476.2   \n",
       "EXPENDITURE IN FOREIGN EXCHANGE                                                 \n",
       "Expenditure In Foreign Currency                      2338.3   2438.9     3102   \n",
       "REMITTANCES IN FOREIGN CURRENCIES FOR DIVIDENDS                                 \n",
       "Dividend Remittance In Foreign Currency                  94    117.5    117.5   \n",
       "EARNINGS IN FOREIGN EXCHANGE                                                    \n",
       "FOB Value Of Goods                                   3498.8   3691.8   4560.1   \n",
       "Other Earnings                                                                  \n",
       "BONUS DETAILS                                                                   \n",
       "Bonus Equity Share Capital                                                      \n",
       "NON-CURRENT INVESTMENTS                                                         \n",
       "Non-Current Investments Quoted Market Value             264    172.3    147.4   \n",
       "Non-Current Investments Unquoted Book Value           419.8   1387.2   1867.4   \n",
       "CURRENT INVESTMENTS                                                             \n",
       "Current Investments Quoted Market Value                                         \n",
       "Current Investments Unquoted Book Value              3995.6   4754.1   5229.8   \n",
       "\n",
       "                                                     Mar 14   Mar 15   Mar 16  \\\n",
       "INCOME                                                                          \n",
       "Revenue From Operations [Gross]                     47822.8  53768.5  63957.7   \n",
       "Less: Excise/Sevice Tax/Other Levies                   5178     5163   7516.5   \n",
       "Revenue From Operations [Net]                       42644.8  48605.5  56441.2   \n",
       "Total Operating Revenues                            43700.6  49970.6  57538.1   \n",
       "Other Income                                          822.9    831.6     1461   \n",
       "Total Revenue                                       44523.5  50802.2  58999.1   \n",
       "EXPENSES                                                                        \n",
       "Cost Of Materials Consumed                          28898.9  32867.8  35483.9   \n",
       "Operating And Direct Expenses                             0        0        0   \n",
       "Changes In Inventories Of FG,WIP And Stock-In T...     18.5   -455.9      6.9   \n",
       "Employee Benefit Expenses                            1368.1   1606.6   1978.8   \n",
       "Finance Costs                                         175.9      206     81.5   \n",
       "Depreciation And Amortisation Expenses               2084.4   2470.3   2820.2   \n",
       "Other Expenses                                       5922.1   6643.1   8037.7   \n",
       "Total Expenses                                        40865    45934  51555.4   \n",
       "Profit/Loss Before Exceptional, ExtraOrdinary I...   3658.5   4868.2   7443.7   \n",
       "Exceptional Items                                         0        0        0   \n",
       "Profit/Loss Before Tax                               3658.5   4868.2   7443.7   \n",
       "Tax Expenses-Continued Operations                                               \n",
       "Current Tax                                           747.9   1302.6   2041.4   \n",
       "Less: MAT Credit Entitlement                              0     70.4        0   \n",
       "Deferred Tax                                          127.6    -75.2       38   \n",
       "Tax For Earlier Years                                     0        0        0   \n",
       "Total Tax Expenses                                    875.5     1157   2079.4   \n",
       "Profit/Loss After Tax And Before ExtraOrdinary ...     2783   3711.2   5364.3   \n",
       "EQUITIES AND LIABILITIES                                                        \n",
       "SHAREHOLDER'S FUNDS                                                             \n",
       "Equity Share Capital                                    151      151      151   \n",
       "Total Share Capital                                     151      151      151   \n",
       "...                                                     ...      ...      ...   \n",
       "Inventories                                          1705.9     2615   3132.1   \n",
       "Trade Receivables                                    1413.7   1069.8   1322.2   \n",
       "Cash And Cash Equivalents                             629.7     18.3     42.2   \n",
       "Short Term Loans And Advances                        1251.1   1172.8    147.8   \n",
       "OtherCurrentAssets                                    358.2    325.6   2144.9   \n",
       "Total Current Assets                                14171.7   8197.9     7846   \n",
       "Total Assets                                        30535.7    33551    41940   \n",
       "OTHER ADDITIONAL INFORMATION                                                    \n",
       "CONTINGENT LIABILITIES, COMMITMENTS                                             \n",
       "Contingent Liabilities                               7210.2   9228.6   9368.7   \n",
       "CIF VALUE OF IMPORTS                                                            \n",
       "Raw Materials                                        3095.5   3181.8   3363.2   \n",
       "Stores, Spares And Loose Tools                         41.6     23.1     62.9   \n",
       "Trade/Other Goods                                      41.6     23.1     62.9   \n",
       "Capital Goods                                        1731.2   1011.2    738.3   \n",
       "EXPENDITURE IN FOREIGN EXCHANGE                                                 \n",
       "Expenditure In Foreign Currency                      3087.4   3300.3   3792.6   \n",
       "REMITTANCES IN FOREIGN CURRENCIES FOR DIVIDENDS                                 \n",
       "Dividend Remittance In Foreign Currency               135.8    203.7    424.5   \n",
       "EARNINGS IN FOREIGN EXCHANGE                                                    \n",
       "FOB Value Of Goods                                   4141.7   4633.2   4735.3   \n",
       "Other Earnings                                                             57   \n",
       "BONUS DETAILS                                                                   \n",
       "Bonus Equity Share Capital                                                      \n",
       "NON-CURRENT INVESTMENTS                                                         \n",
       "Non-Current Investments Quoted Market Value           237.7    560.5    583.9   \n",
       "Non-Current Investments Unquoted Book Value          1278.3   9791.1  18404.6   \n",
       "CURRENT INVESTMENTS                                                             \n",
       "Current Investments Quoted Market Value                                         \n",
       "Current Investments Unquoted Book Value              8813.1   2996.4   1056.8   \n",
       "\n",
       "                                                     Mar 17   Mar 18   Mar 19  \n",
       "INCOME                                                                         \n",
       "Revenue From Operations [Gross]                     76140.8  80336.5  83026.5  \n",
       "Less: Excise/Sevice Tax/Other Levies                 9231.4   2231.7        0  \n",
       "Revenue From Operations [Net]                       66909.4  78104.8  83026.5  \n",
       "Total Operating Revenues                            68034.8  79762.7  86020.3  \n",
       "Other Income                                         2300.1   2045.5     2561  \n",
       "Total Revenue                                       70334.9  81808.2  88581.3  \n",
       "EXPENSES                                                                       \n",
       "Cost Of Materials Consumed                          42629.6  44941.3  45023.9  \n",
       "Operating And Direct Expenses                             0        0        0  \n",
       "Changes In Inventories Of FG,WIP And Stock-In T...   -380.1     40.7    210.8  \n",
       "Employee Benefit Expenses                              2331   2833.8   3254.9  \n",
       "Finance Costs                                          89.4    345.7     75.8  \n",
       "Depreciation And Amortisation Expenses               2602.1   2757.9   3018.9  \n",
       "Other Expenses                                       8724.1   9991.5    11634  \n",
       "Total Expenses                                      60374.6  70804.8  78115.7  \n",
       "Profit/Loss Before Exceptional, ExtraOrdinary I...   9960.3  11003.4  10465.6  \n",
       "Exceptional Items                                         0        0        0  \n",
       "Profit/Loss Before Tax                               9960.3  11003.4  10465.6  \n",
       "Tax Expenses-Continued Operations                                              \n",
       "Current Tax                                          2335.6   3349.5   2932.3  \n",
       "Less: MAT Credit Entitlement                              0        0        0  \n",
       "Deferred Tax                                          274.5    -67.9     32.7  \n",
       "Tax For Earlier Years                                     0        0        0  \n",
       "Total Tax Expenses                                   2610.1   3281.6     2965  \n",
       "Profit/Loss After Tax And Before ExtraOrdinary ...   7350.2   7721.8   7500.6  \n",
       "EQUITIES AND LIABILITIES                                                       \n",
       "SHAREHOLDER'S FUNDS                                                            \n",
       "Equity Share Capital                                    151      151      151  \n",
       "Total Share Capital                                     151      151      151  \n",
       "...                                                     ...      ...      ...  \n",
       "Inventories                                          3262.2   3160.8   3325.7  \n",
       "Trade Receivables                                    1199.2   1461.8   2310.4  \n",
       "Cash And Cash Equivalents                              13.8     71.1    178.9  \n",
       "Short Term Loans And Advances                           2.5        3       16  \n",
       "OtherCurrentAssets                                   2119.7   2007.4   1485.1  \n",
       "Total Current Assets                                 8776.2   7921.4  12361.6  \n",
       "Total Assets                                        51250.6  59370.1  62931.8  \n",
       "OTHER ADDITIONAL INFORMATION                                                   \n",
       "CONTINGENT LIABILITIES, COMMITMENTS                                            \n",
       "Contingent Liabilities                               6744.9   6696.8  11614.9  \n",
       "CIF VALUE OF IMPORTS                                                           \n",
       "Raw Materials                                        3725.4   3887.9   4396.9  \n",
       "Stores, Spares And Loose Tools                         20.1     66.1     58.5  \n",
       "Trade/Other Goods                                      20.1     66.1     58.5  \n",
       "Capital Goods                                        1481.8    648.3   1331.2  \n",
       "EXPENDITURE IN FOREIGN EXCHANGE                                                \n",
       "Expenditure In Foreign Currency                           0   9328.4  12802.7  \n",
       "REMITTANCES IN FOREIGN CURRENCIES FOR DIVIDENDS                                \n",
       "Dividend Remittance In Foreign Currency                                        \n",
       "EARNINGS IN FOREIGN EXCHANGE                                                   \n",
       "FOB Value Of Goods                                                             \n",
       "Other Earnings                                                5455.9   5218.6  \n",
       "BONUS DETAILS                                                                  \n",
       "Bonus Equity Share Capital                                                     \n",
       "NON-CURRENT INVESTMENTS                                                        \n",
       "Non-Current Investments Quoted Market Value          1027.4     1371   1077.3  \n",
       "Non-Current Investments Unquoted Book Value         25606.2  33041.9  30609.1  \n",
       "CURRENT INVESTMENTS                                                            \n",
       "Current Investments Quoted Market Value                                        \n",
       "Current Investments Unquoted Book Value              2178.8   1217.3   5045.5  \n",
       "\n",
       "[90 rows x 15 columns]"
      ]
     },
     "execution_count": 9,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "f"
   ]
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.7.0"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}