Skip to content

Instantly share code, notes, and snippets.

@haldarmahesh
Created August 7, 2016 17:41
Show Gist options
  • Save haldarmahesh/d7c465547b2017cd43fdc849c007b29c to your computer and use it in GitHub Desktop.
Save haldarmahesh/d7c465547b2017cd43fdc849c007b29c to your computer and use it in GitHub Desktop.
{
"prime": "con",
"number_set": {
"balancesheet": [
[
"Share Capital",
{
"2008-03-31": 286,
"2009-03-31": 286,
"2014-03-31": 286,
"2011-03-31": 286,
"2015-03-31": 572,
"2013-03-31": 286,
"2006-03-31": 138,
"2012-03-31": 286,
"2010-03-31": 286,
"2016-03-31": 1144,
"2007-03-31": 286
}
],
[
"Reserves",
{
"2008-03-31": 13509,
"2009-03-31": 17968,
"2014-03-31": 44244,
"2011-03-31": 25690,
"2015-03-31": 50164,
"2013-03-31": 37708,
"2006-03-31": 6828,
"2012-03-31": 31046,
"2010-03-31": 22763,
"2016-03-31": 56682,
"2007-03-31": 10969
}
],
[
"Borrowings",
{
"2008-03-31": 0,
"2009-03-31": 0,
"2014-03-31": 0,
"2011-03-31": 0,
"2015-03-31": 0,
"2013-03-31": 0,
"2006-03-31": 0,
"2012-03-31": 0,
"2010-03-31": 0,
"2016-03-31": 0,
"2007-03-31": 0
}
],
[
"Other Liabilities",
{
"2008-03-31": 4191,
"2009-03-31": 3909,
"2014-03-31": 12744,
"2011-03-31": 5493,
"2015-03-31": 15871,
"2013-03-31": 8599,
"2006-03-31": 2414,
"2012-03-31": 7295,
"2010-03-31": 4687,
"2016-03-31": 17688,
"2007-03-31": 2154
}
],
[
"Total Liabilities",
{
"2008-03-31": 17986,
"2009-03-31": 22163,
"2014-03-31": 57274,
"2011-03-31": 31469,
"2015-03-31": 66607,
"2013-03-31": 46593,
"2006-03-31": 9380,
"2012-03-31": 38627,
"2010-03-31": 27736,
"2016-03-31": 75514,
"2007-03-31": 13409
}
],
[
"Fixed Assets",
{
"2008-03-31": 3453,
"2009-03-31": 4677,
"2014-03-31": 8378,
"2011-03-31": 5235,
"2015-03-31": 11346,
"2013-03-31": 7139,
"2006-03-31": 1655,
"2012-03-31": 5555,
"2010-03-31": 4946,
"2016-03-31": 13180,
"2007-03-31": 2806
}
],
[
"CWIP",
{
"2008-03-31": 1324,
"2009-03-31": 677,
"2014-03-31": 961,
"2011-03-31": 264,
"2015-03-31": 776,
"2013-03-31": 1140,
"2006-03-31": 571,
"2012-03-31": 590,
"2010-03-31": 409,
"2016-03-31": 960,
"2007-03-31": 965
}
],
[
"Investments",
{
"2008-03-31": 72,
"2009-03-31": 0,
"2014-03-31": 4331,
"2011-03-31": 144,
"2015-03-31": 2270,
"2013-03-31": 2116,
"2006-03-31": 755,
"2012-03-31": 372,
"2010-03-31": 3702,
"2016-03-31": 1892,
"2007-03-31": 25
}
],
[
"Other Assets",
{
"2008-03-31": 13137,
"2009-03-31": 16809,
"2014-03-31": 43604,
"2011-03-31": 25826,
"2015-03-31": 52215,
"2013-03-31": 36198,
"2006-03-31": 6399,
"2012-03-31": 32110,
"2010-03-31": 18679,
"2016-03-31": 59482,
"2007-03-31": 9613
}
],
[
"Total Assets",
{
"2008-03-31": 17986,
"2009-03-31": 22163,
"2014-03-31": 57274,
"2011-03-31": 31469,
"2015-03-31": 66607,
"2013-03-31": 46593,
"2006-03-31": 9380,
"2012-03-31": 38627,
"2010-03-31": 27736,
"2016-03-31": 75514,
"2007-03-31": 13409
}
]
],
"annual": [
[
"Sales",
{
"2008-03-31": 16692,
"2009-03-31": 21693,
"2014-03-31": 50133,
"2011-03-31": 27501,
"2015-03-31": 53319,
"2013-03-31": 40352,
"2006-03-31": 9521,
"2012-03-31": 33734,
"2010-03-31": 22742,
"2016-03-31": 62441,
"2007-03-31": 13893
}
],
[
"Expenses",
{
"2008-03-31": 11432,
"2009-03-31": 14934,
"2014-03-31": 36743,
"2011-03-31": 18531,
"2015-03-31": 38436,
"2013-03-31": 28814,
"2006-03-31": 6508,
"2012-03-31": 23007,
"2010-03-31": 14879,
"2016-03-31": 45312,
"2007-03-31": 9483
}
],
[
"Operating Profit",
{
"2008-03-31": 5260,
"2009-03-31": 6759,
"2014-03-31": 13390,
"2011-03-31": 8970,
"2015-03-31": 14883,
"2013-03-31": 11538,
"2006-03-31": 3013,
"2012-03-31": 10727,
"2010-03-31": 7863,
"2016-03-31": 17129,
"2007-03-31": 4410
}
],
[
"OPM",
{
"2008-03-31": 31.51,
"2009-03-31": 31.16,
"2014-03-31": 26.71,
"2011-03-31": 32.62,
"2015-03-31": 27.91,
"2013-03-31": 28.59,
"2006-03-31": 31.65,
"2012-03-31": 31.8,
"2010-03-31": 34.57,
"2016-03-31": 27.43,
"2007-03-31": 31.74
}
],
[
"Other Income",
{
"2008-03-31": 704,
"2009-03-31": 912,
"2014-03-31": 2664,
"2011-03-31": 1211,
"2015-03-31": 3430,
"2013-03-31": 2365,
"2006-03-31": 232,
"2012-03-31": 1904,
"2010-03-31": 991,
"2016-03-31": 3128,
"2007-03-31": 378
}
],
[
"Interest",
{
"2008-03-31": 1,
"2009-03-31": 3,
"2014-03-31": 9,
"2011-03-31": 2,
"2015-03-31": 12,
"2013-03-31": 5,
"2006-03-31": 1,
"2012-03-31": 4,
"2010-03-31": 2,
"2016-03-31": 9,
"2007-03-31": 1
}
],
[
"Depreciation",
{
"2008-03-31": 598,
"2009-03-31": 761,
"2014-03-31": 1317,
"2011-03-31": 854,
"2015-03-31": 1017,
"2013-03-31": 1099,
"2006-03-31": 437,
"2012-03-31": 928,
"2010-03-31": 905,
"2016-03-31": 1266,
"2007-03-31": 514
}
],
[
"Profit before tax",
{
"2008-03-31": 5365,
"2009-03-31": 6907,
"2014-03-31": 14728,
"2011-03-31": 9325,
"2015-03-31": 17284,
"2013-03-31": 12799,
"2006-03-31": 2807,
"2012-03-31": 11699,
"2010-03-31": 7947,
"2016-03-31": 18982,
"2007-03-31": 4273
}
],
[
"Tax",
{
"2008-03-31": 706,
"2009-03-31": 919,
"2014-03-31": 4072,
"2011-03-31": 2490,
"2015-03-31": 4911,
"2013-03-31": 3370,
"2006-03-31": 328,
"2012-03-31": 3367,
"2010-03-31": 1681,
"2016-03-31": 5301,
"2007-03-31": 406
}
],
[
"Net Profit",
{
"2008-03-31": 4659,
"2009-03-31": 5988,
"2014-03-31": 10656,
"2011-03-31": 6835,
"2015-03-31": 12372,
"2013-03-31": 9429,
"2006-03-31": 2458,
"2012-03-31": 8332,
"2010-03-31": 6266,
"2016-03-31": 13678,
"2007-03-31": 3856
}
],
[
"EPS (unadj)",
{
"2008-03-31": 75.8,
"2009-03-31": 100.7,
"2014-03-31": 175.54,
"2011-03-31": 109.56,
"2015-03-31": 99.11,
"2013-03-31": 157.8,
"2006-03-31": 82.75,
"2012-03-31": 138.01,
"2010-03-31": 105.35,
"2016-03-31": 54.83,
"2007-03-31": 65.63
}
],
[
"Dividend Payout",
{
"2008-03-31": 40.82,
"2009-03-31": 22.46,
"2014-03-31": 33.95,
"2011-03-31": 50.4,
"2015-03-31": 41.31,
"2013-03-31": 25.58,
"2006-03-31": 50.37,
"2012-03-31": 32.39,
"2010-03-31": 22.89,
"2016-03-31": 40.72,
"2007-03-31": 16.83
}
]
],
"cashflow": [
[
"Cash from Operating Activity",
{
"2008-03-31": 4124,
"2009-03-31": 5401,
"2014-03-31": 9825,
"2011-03-31": 4797,
"2015-03-31": 8353,
"2013-03-31": 7373,
"2006-03-31": 2419,
"2012-03-31": 6394,
"2010-03-31": 6187,
"2016-03-31": 9863,
"2007-03-31": 3514
}
],
[
"Cash from Investing Activity",
{
"2008-03-31": -1120,
"2009-03-31": -213,
"2014-03-31": -2563,
"2011-03-31": 3398,
"2015-03-31": 999,
"2013-03-31": -2922,
"2006-03-31": -423,
"2012-03-31": -147,
"2010-03-31": -3634,
"2016-03-31": -720,
"2007-03-31": -1121
}
],
[
"Cash from Financing Activity",
{
"2008-03-31": -777,
"2009-03-31": -2430,
"2014-03-31": -3144,
"2011-03-31": -3640,
"2015-03-31": -4935,
"2013-03-31": -3210,
"2006-03-31": 171,
"2012-03-31": -2322,
"2010-03-31": -1485,
"2016-03-31": -6813,
"2007-03-31": -316
}
],
[
"Net Cash Flow",
{
"2008-03-31": 2227,
"2009-03-31": 2758,
"2014-03-31": 4118,
"2011-03-31": 4555,
"2015-03-31": 4417,
"2013-03-31": 1241,
"2006-03-31": 2167,
"2012-03-31": 3925,
"2010-03-31": 1068,
"2016-03-31": 2330,
"2007-03-31": 2077
}
]
],
"quarters": [
[
"Sales",
{
"2016-06-30": 16782,
"2014-12-31": 13796,
"2014-09-30": 13342,
"2014-03-31": 12875,
"2015-06-30": 14354,
"2014-06-30": 12770,
"2015-03-31": 13411,
"2015-12-31": 15902,
"2013-12-31": 13026,
"2016-03-31": 16550,
"2013-09-30": 12965,
"2015-09-30": 15635
}
],
[
"Expenses",
{
"2016-06-30": 12335,
"2014-12-31": 10107,
"2014-09-30": 9859,
"2014-03-31": 9594,
"2015-06-30": 10594,
"2014-06-30": 9559,
"2015-03-31": 9679,
"2015-12-31": 11574,
"2013-12-31": 9767,
"2016-03-31": 11911,
"2013-09-30": 10128,
"2015-09-30": 11642
}
],
[
"Operating Profit",
{
"2016-06-30": 4447,
"2014-12-31": 3689,
"2014-09-30": 3483,
"2014-03-31": 3281,
"2015-06-30": 3760,
"2014-06-30": 3211,
"2015-03-31": 3732,
"2015-12-31": 4328,
"2013-12-31": 3259,
"2016-03-31": 4639,
"2013-09-30": 2837,
"2015-09-30": 3993
}
],
[
"OPM",
{
"2016-06-30": 26.5,
"2014-12-31": 26.74,
"2014-09-30": 26.11,
"2014-03-31": 25.48,
"2015-06-30": 26.19,
"2014-06-30": 25.14,
"2015-03-31": 27.83,
"2015-12-31": 27.22,
"2013-12-31": 25.02,
"2016-03-31": 28.03,
"2013-09-30": 21.88,
"2015-09-30": 25.54
}
],
[
"Other Income",
{
"2016-06-30": 753,
"2014-12-31": 840,
"2014-09-30": 877,
"2014-03-31": 851,
"2015-06-30": 756,
"2014-06-30": 829,
"2015-03-31": 881,
"2015-12-31": 802,
"2013-12-31": 731,
"2016-03-31": 772,
"2013-09-30": 510,
"2015-09-30": 793
}
],
[
"Depreciation",
{
"2016-06-30": 400,
"2014-12-31": 0,
"2014-09-30": 0,
"2014-03-31": 0,
"2015-06-30": 313,
"2014-06-30": 0,
"2015-03-31": 283,
"2015-12-31": 369,
"2013-12-31": 0,
"2016-03-31": 419,
"2013-09-30": 0,
"2015-09-30": 0
}
],
[
"Interest",
{
"2016-06-30": 0,
"2014-12-31": 0,
"2014-09-30": 0,
"2014-03-31": 0,
"2015-06-30": 0,
"2014-06-30": 0,
"2015-03-31": 0,
"2015-12-31": 0,
"2013-12-31": 0,
"2016-03-31": 0,
"2013-09-30": 0,
"2015-09-30": 0
}
],
[
"Profit before tax",
{
"2016-06-30": 4800,
"2014-12-31": 4529,
"2014-09-30": 4360,
"2014-03-31": 4132,
"2015-06-30": 4203,
"2014-06-30": 4040,
"2015-03-31": 4330,
"2015-12-31": 4761,
"2013-12-31": 3990,
"2016-03-31": 4992,
"2013-09-30": 3347,
"2015-09-30": 4786
}
],
[
"Tax",
{
"2016-06-30": 1362,
"2014-12-31": 1279,
"2014-09-30": 1264,
"2014-03-31": 1140,
"2015-06-30": 1175,
"2014-06-30": 1154,
"2015-03-31": 1232,
"2015-12-31": 1296,
"2013-12-31": 1115,
"2016-03-31": 1394,
"2013-09-30": 940,
"2015-09-30": 1387
}
],
[
"Net Profit",
{
"2016-06-30": 3436,
"2014-12-31": 3250,
"2014-09-30": 3096,
"2014-03-31": 2992,
"2015-06-30": 3028,
"2014-06-30": 2886,
"2015-03-31": 3097,
"2015-12-31": 3465,
"2013-12-31": 2875,
"2016-03-31": 3597,
"2013-09-30": 2407,
"2015-09-30": 3398
}
]
]
},
"bse_code": "500209",
"short_name": "Infosys",
"nse_code": "INFY",
"companyrating_set": [
{
"rating__rating": "CRISIL A1+",
"instrument": "Commercial Paper",
"rating__source": "crisil",
"link": "http://www.crisil.com/ratings/company-wise-ratings.jsp?txtSearch=Infosys Ltd"
},
{
"rating__rating": "CGR1",
"instrument": "Corporate Governance Rating-CGR",
"rating__source": "icra",
"link": "http://icra.in/search.aspx?word=Infosys Ltd"
},
{
"rating__rating": "CRISIL GVC Level 1",
"instrument": "Governance and Value Creation Rating",
"rating__source": "crisil",
"link": "http://www.crisil.com/ratings/company-wise-ratings.jsp?txtSearch=Infosys Ltd"
},
{
"rating__rating": "CRISIL AAA(Stable)",
"instrument": "Long Term Debt",
"rating__source": "crisil",
"link": "http://www.crisil.com/ratings/company-wise-ratings.jsp?txtSearch=Infosys Ltd"
}
],
"annualreport_set": [
{
"source": "bse",
"report_date": 2016,
"link": "http://www.bseindia.com/bseplus/AnnualReport/500209/5002090316.pdf"
},
{
"source": "bse",
"report_date": 2015,
"link": "http://www.bseindia.com/bseplus/AnnualReport/500209/5002090315.pdf"
},
{
"source": "bse",
"report_date": 2014,
"link": "http://www.bseindia.com/bseplus/AnnualReport/500209/5002090314.pdf"
},
{
"source": "bse",
"report_date": 2013,
"link": "http://www.bseindia.com/bseplus/annualreport/500209/5002090313.pdf"
},
{
"source": "bse",
"report_date": 2012,
"link": "http://www.bseindia.com/bseplus/annualreport/500209/5002090312.pdf"
},
{
"source": "bse",
"report_date": 2011,
"link": "http://www.bseindia.com/bseplus/annualreport/500209/5002090311.pdf"
},
{
"source": "bse",
"report_date": 2010,
"link": "http://www.bseindia.com/bseplus/annualreport/500209/500209_2009-10.pdf"
},
{
"source": "nse",
"report_date": 2010,
"link": "http://nseindia.com/annual_reports/AR_INFOSYSTCH_2009_2010_18082010121500.zip"
}
],
"announcement_set": [
{
"ann_date": "03 Aug 2016",
"announcement": "Infosys Invests in Cloudyn",
"link": "http://www.bseindia.com/corporates/anndet_new.aspx?newsid=465b41b3-4da2-4a65-96f0-a9274beff41a"
},
{
"ann_date": "16 Jul 2016",
"announcement": "Statement of Investor Complaint under Reg. 13(3) of SEBI (LODR) Regulations, 2015 for Quarter ended June 30, 2016",
"link": "http://www.bseindia.com/corporates/anndet_new.aspx?newsid=b26e663f-fc1f-48ad-bed1-585bf041a9b4"
},
{
"ann_date": "15 Jul 2016",
"announcement": "Fact Sheet, IFRS - INR Press Release & IFRS - USD Press Release",
"link": "http://www.bseindia.com/corporates/anndet_new.aspx?newsid=6ef722c1-3cb7-4d12-8a7d-7fc3bfe96ff2"
},
{
"ann_date": "15 Jul 2016",
"announcement": "Auditors' Report for the Quarter ended June 30, 2016",
"link": "http://www.bseindia.com/corporates/anndet_new.aspx?newsid=636c7884-7664-43fc-86cc-48da9b725346"
},
{
"ann_date": "15 Jul 2016",
"announcement": "Outcome of Board Meeting",
"link": "http://www.bseindia.com/corporates/anndet_new.aspx?newsid=7f40f89a-7107-4674-a1de-867e022039cc"
}
],
"warehouse_set": {
"high_price": 1279.3,
"low_price": 1011.25,
"sales_growth": 18.15,
"current_price": 1068,
"dividend_yield": 2.27,
"face_value": 5,
"id": 6596470,
"sales_growth_3years": 15.66,
"profit_growth_5years": 14.88,
"average_return_on_equity_3years": 25.63,
"book_value": 266.71,
"status": "Active",
"pair_url": "/company/INFY/",
"sales_growth_10years": 18.17,
"average_return_on_equity_10years": 27.96,
"profit_growth": 11.43,
"market_capitalization": 245313.69,
"profit_growth_10years": 15.12,
"price_to_earning": 17.65,
"industry": "IT Consulting & Software",
"analysis": {
"remarks": [],
"bad": [
"Promoter's stake has decreased",
"Promoter holding is low: 12.75%"
],
"good": [
"Company is virtually debt free.",
"Company has a good return on equity (ROE) track record: 3 Years ROE 25.63%",
"Company has been maintaining a healthy dividend payout of 38.96%"
]
},
"result_type": "con",
"profit_growth_3years": 13.19,
"sales_growth_5years": 17.82,
"return_on_equity": 25.19,
"average_return_on_equity_5years": 26.38
},
"id": 1489,
"name": "Infosys Ltd"
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment