{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Introduction","Balance Sheet","Income Statement"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":56,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Introduction","index":0,"n_rows":21,"n_cols":6,"rows_kept":21,"cut":false,"hidden":false,"merged":[[2,1,18,9]]}
[null,null,null,null,null,"www.Tricks12345.com"]
[]
[null,"Import \nFinancial Data from\nMoney Control"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Pavan Kumar Gundlapalli"]

{"sheet":"Balance Sheet","index":1,"n_rows":70,"n_cols":6,"rows_kept":70,"cut":false,"hidden":false,"merged":[]}
[]
[null,"2018-03-17","2018-03-16","2018-03-15","2018-03-14","2018-03-13"]
[]
[null,"12 mths","12 mths","12 mths","12 mths","12 mths"]
[]
["EQUITIES AND LIABILITIES"]
["SHAREHOLDER'S FUNDS"]
["Equity Share Capital",160.9,160.68,160.59,160.58000000000001,160.58000000000001]
["Total Share Capital",160.9,160.68,160.59,160.58000000000001,160.58000000000001]
["Revaluation Reserves",0,0,8.9700000000000006,8.9700000000000006,8.9700000000000006]
["Reserves and Surplus",12639.61,11825.2,10920.59,9922.09,8699.9699999999993]
["Total Reserves and Surplus",12639.61,11825.2,10929.56,9931.06,8708.94]
["Total Shareholders Funds",12800.51,11985.88,11090.15,10091.64,8869.52]
["NON-CURRENT LIABILITIES"]
["Long Term Borrowings",7.0000000000000007E-2,0.13,0.41,0.43,0.55000000000000004]
["Deferred Tax Liabilities [Net]",0,35.85,330.59,311.2,281.2]
["Other Long Term Liabilities",125.2,130.72,40,30,30]
["Long Term Provisions",125.61,132,151.93,73.989999999999995,47.34]
["Total Non-Current Liabilities",250.88,298.7,522.92999999999995,415.62,359.09]
["CURRENT LIABILITIES"]
["Short Term Borrowings",324.26,1131.68,1380.2,876.91,965.26]
["Trade Payables",1298.21,990.84,1496.6,962.56,827.09]
["Other Current Liabilities",685.43,582.73,352.42,333.2,242.62]
["Short Term Provisions",247.93,249.22,349.52,244.07,229.63]
["Total Current Liabilities",2555.83,2954.47,3578.74,2416.7399999999998,2264.6]
["Total Capital And Liabilities",15607.22,15239.05,15191.82,12924,11493.21]
["ASSETS"]
["NON-CURRENT ASSETS"]
["Tangible Assets",4095.16,3702.28,3468.33,3519.59,3418.29]
["Intangible Assets",140.1,123.83,125.29,4.5999999999999996,0]
["Capital Work-In-Progress",540.52,512.80999999999995,339,319.64,339.99]
["Intangible Assets Under Development",15.25,37.909999999999997,21.71,57.05,10.35]
["Other Assets",0.32,0.33,0,0,0]
["Fixed Assets",4791.3500000000004,4377.16,3954.33,3900.88,3768.63]
["Non-Current Investments",3647.71,3716.26,4036.99,3328.28,514.36]
["Deferred Tax Assets [Net]",59.54,0,0,0,0]
["Long Term Loans And Advances",215.75,219.37,576.71,535.29999999999995,373.72]
["Other Non-Current Assets",547.53,458.89,65.13,61.57,0.31]
["Total Non-Current Assets",9261.8799999999992,8771.68,8633.16,7826.03,4657.0200000000004]
["CURRENT ASSETS"]
["Current Investments",638.17999999999995,539.52,384.11,258.85000000000002,2087.46]
["Inventories",2653.5,2918.47,3289.2,2511.16,2343.37]
["Trade Receivables",1938.79,1896.41,2058.91,1728.1,1645.22]
["Cash And Cash Equivalents",58.46,53.01,82.76,46.04,105.07]
["Short Term Loans And Advances",9.5299999999999994,10.92,589.96,515.55999999999995,652.79]
["OtherCurrentAssets",1046.8800000000001,1049.04,153.72,38.26,2.2799999999999998]
["Total Current Assets",6345.34,6467.37,6558.66,5097.97,6836.19]
["Total Assets",15607.22,15239.05,15191.82,12924,11493.21]
["OTHER ADDITIONAL INFORMATION"]
["CONTINGENT LIABILITIES, COMMITMENTS"]
["Contingent Liabilities",4922.74,4735.0200000000004,1760.36,1201.3599999999999,3993.66]
["CIF VALUE OF IMPORTS"]
["Raw Materials",938.94,1453.01,1515.43,1330.64,1206.78]
["Stores, Spares And Loose Tools",22.67,27,23.73,30.7,26.23]
["Capital Goods",258.67,247,123.75,64.709999999999994,83.21]
["EXPENDITURE IN FOREIGN EXCHANGE"]
["Expenditure In Foreign Currency",1767.8,745.86,585.42999999999995,468.25,274.33999999999997]
["REMITTANCES IN FOREIGN CURRENCIES FOR DIVIDENDS"]
["Dividend Remittance In Foreign Currency","-","-","-","-","-"]
["EARNINGS IN FOREIGN EXCHANGE"]
["FOB Value Of Goods",5004.97,6683.67,4736.33,4947.96,4426.16]
["Other Earnings",101.66,62.46,174.07,201.92,68.56]
["BONUS DETAILS"]
["Bonus Equity Share Capital",151.66,151.66,151.66,151.66,151.66]
["NON-CURRENT INVESTMENTS"]
["Non-Current Investments Quoted Market Value","-","-","-","-","-"]
["Non-Current Investments Unquoted Book Value",3647.71,3716.26,4036.66,3327.94,514.01]
["CURRENT INVESTMENTS"]
["Current Investments Quoted Market Value","-","-","-","-","-"]
["Current Investments Unquoted Book Value",638.17999999999995,539.52,384.11,258.85000000000002,2087.46]

{"sheet":"Income Statement","index":2,"n_rows":52,"n_cols":6,"rows_kept":52,"cut":false,"hidden":false,"merged":[]}
[]
[null,"2018-03-17","2018-03-16","2018-03-15","2018-03-14","2018-03-13"]
[]
[null,"12 mths","12 mths","12 mths","12 mths","12 mths"]
[]
["INCOME"]
["Revenue From Operations [Gross]",10673.52,11873.46,9831.8799999999992,9174.9599999999991,8134.56]
["Less: Excise/Sevice Tax/Other Levies",0,0,92.94,99.12,92.16]
["Revenue From Operations [Net]",10673.52,11873.46,9738.94,9075.84,8042.4]
["Other Operating Revenues",301.06,244.26,392.84,304.45,160.02000000000001]
["Total Operating Revenues",10974.58,12117.72,10131.780000000001,9380.2900000000009,8202.42]
["Other Income",129.85,280.3,147.91,280.27999999999997,229.13]
["Total Revenue",11104.43,12398.02,10279.69,9660.57,8431.5499999999993]
["EXPENSES"]
["Cost Of Materials Consumed",2956.04,3633.34,3426.74,3145.34,2646.83]
["Purchase Of Stock-In Trade",1128.99,1037.56,903.41,773.4,706.89]
["Changes In Inventories Of FG,WIP And Stock-In Trade",56.27,228.35,-349.05,-158.12,-290.75]
["Employee Benefit Expenses",1728.97,1778.56,1505.58,1284.75,969.28]
["Finance Costs",39.200000000000003,147.07,136.05000000000001,127.86,33.380000000000003]
["Depreciation And Amortisation Expenses",499.97,442.69,433.2,323.61,303.02999999999997]
["Other Expenses",3508.05,3386.48,2683.79,2345.39,2051.0300000000002]
["Total Expenses",9917.49,10654.05,8739.7199999999993,7842.23,6419.69]
[null,"2018-03-17","2018-03-16","2018-03-15","2018-03-14","2018-03-13"]
[]
[null,"12 mths","12 mths","12 mths","12 mths","12 mths"]
[]
["Profit/Loss Before Exceptional, ExtraOrdinary Items And Tax",1186.94,1743.97,1539.97,1818.34,2011.86]
["Profit/Loss Before Tax",1186.94,1743.97,1539.97,1818.34,2011.86]
["Tax Expenses-Continued Operations"]
["Current Tax",311.06,356.64,318.77999999999997,400,386]
["Less: MAT Credit Entitlement",0,0,0,0,-70]
["Deferred Tax",-99.06,-74.97,40.1,30,48.75]
["Total Tax Expenses",212,281.67,358.88,430,504.75]
["Profit/Loss After Tax And Before ExtraOrdinary Items",974.94,1462.3,1181.0899999999999,1388.34,1507.11]
["Profit/Loss From Continuing Operations",974.94,1462.3,1181.0899999999999,1388.34,1507.11]
["Profit/Loss For The Period",974.94,1462.3,1181.0899999999999,1388.34,1507.11]
[null,"2018-03-17","2018-03-16","2018-03-15","2018-03-14","2018-03-13"]
[]
[null,"12 mths","12 mths","12 mths","12 mths","12 mths"]
[]
["OTHER ADDITIONAL INFORMATION"]
["EARNINGS PER SHARE"]
["Basic EPS (Rs.)",12.13,18.21,14.71,17.29,18.77]
["Diluted EPS (Rs.)",12.11,18.16,14.66,17.29,18.77]
["VALUE OF IMPORTED AND INDIGENIOUS RAW MATERIALS"]
["Imported Raw Materials",0,0,1523.87,1745.19,1097.17]
["Indigenous Raw Materials",0,0,2004.38,1537.46,1665.58]
["STORES, SPARES AND LOOSE TOOLS"]
["DIVIDEND AND DIVIDEND PERCENTAGE"]
["Equity Share Dividend",193.58,180.92,160.59,160.58000000000001,160.58000000000001]
["Tax On Dividend",0,0,32.69,27.29,27.29]
["Equity Dividend Rate (%)",100,100,100,100,100]