Allotted Companies

[Ujjwal Chadha]

Hey Guys

You are supposed to research for the companies on basis of the following list:

1. Yash - Airtel (Telecom)
   
2. Prasham - Nestle (FMCG)
3. Manu - ITC (FMCG)
4. Anurag - IOCL (Oil and Gas)
5. Radhika - Unitech (Realty)
6. Shuchi - HDFC (Banking)
7. Isha - Reliance Industries Ltd 
8. Rohan - Infosys (IT)
9. Pratibha - Moser Baer (IT)
10. Sugandha -ONGC (Oil and Gas)
11. Diksha - Omaxe Ltd (Realty)
12. Shruti - Maruti Suzuki (Auto)
13. Shrishti - TCS (IT)
14. Akriti - DLF (Realty)
15. Sameer - State Bank Of India (Banking)
16. Aradhya - Reliance Communications (Telecom), TATA Motors (Auto)
17. Armaan - Hindustan Unilever (FMCG), GAIL (Oil and Gas)
18. Divya - Idea Cellular (Telecom), Mahindra and Mahindra Ltd (Auto)
19. Rohit - Larsen and Toubro (Capital Goods), Reliance Petroleum (Oil and Gas), Punj Llyod (Capital Goods)
20. Ujjwal - Reliance Power (Reliance), Wipro (IT), BHEL (Capital Goods)

Deadline for submission of information is Sunday, 6 PM

Kindly inform each other, as I am guessing that everyone is not checking mails regularly.

As for the research part,
Make it as simple as you can. You need to give

• avg price trend over the last 6 months only, say fr eg, let me know only this - May - around 540, June - around 580, July - dropped to 490 levels, and so on

• Give me only major news relating to the company. That means give me only the news which can/may have caused large fluctuations in company share prices.

• The news about your company's industry should be also on similar lines
  

• Also, post some relevant scenarios, hypothetical situations, etc that we should put in the game. Remember this is where I want you to run your imagination and give interesting scenarios, news, etc. It can be based on news about company, political scenarios, new norms or laws in the industry, etc. For e.g. - Idea Cellular faces severe technical issues and system goes down for a week with rumors of company willing to pack up; A bank fails to recover loans and other lendings leading to severe liquidity crunch forcing it to wind up; Govt passes the law that major national infrastructure projects to be handled by only a particular company in north india, or only govt agencies can do such projects, etc.....

• Also, post information about companies annual and quarterly results. Again make it simple as Q1 2009: profit - 105 Crore (up by 3.2%), Q2 2009: losses of 40 Crore (down by 2.8%), etc. Also give any major news relating to profits and dividends distributed (if you may find any)

Just try and cover all the info required above while making it as short as possible. I do not want long emails or documents about the company's performance. Only relevant data good enough to design the game is good enough.

Here are some pages that you just might find helpful: (though they are a bit complicated and I would recommend not to depend on them for all the info. Try and google most of the info)


http://www.bseindia.com/Stockreach_Gloss.htm

http://www.bseindia.com/mktlive/mktwatch.asp

http://www.bseindia.com/mktlive/indiceswatch_scrip.asp?iname=BSE30&sensid=30&type=sens&mktcapteck=1263949.04&total=2540674.25&dateheader=Friday%2C+November+13%2C+2009

http://www.bseindia.com/scripsearch/scrips_2.aspx?checkmore=1&myScrip=reliance&flag=re

Enter your company name to see their price charts:
http://charting.bseindia.com/charting/index.asp

For any help or information, either mail me or call me.




--
Warm regards

Ujjwal Chadha
Vice President
Corporate Relations,
AIESEC in Delhi University,
India

Phone: (Delhi) +91 9868 420 406
     
Email: ujjwal...@gmail.com
    IM: ujjwal...@hotmail.com  
Skype: ujjwal.chadha

SEARCHTOOL FOR AIESEC DELHI UNIVERSITY
http://spreadsheets.google.com/ccc?key=pje8BW54NZ4VsxkgVXGnsFQ

LOCAL PARTNERS:

Ernst & Young
Visnova Solutions Ltd.
NASSCOM
Cybermedia
Genpact

NATIONAL PARTNERS:

Tata Consultancy Services
Coca Cola India
Godrej
HSBC
ABN AMRO
BMR Associates
HDFC
General Atlantic
Mayfield Fund

NATIONAL AWARDS:

Best Corporate Relations, ICX, AIESEC India 2007

Best Corporate Relations, ICX, AIESEC India 2008

Most Progressive Financial Management, AIESEC India 2008

Best Local Committee, AIESEC India 2007

[Yash Agarwal]

This is my research on Airtel.

--
Y@$#

[Manu Abbi]

2009/11/15 Yash Agarwal <yash...@gmail.com>

ITC Limited .
--
Cheers ,
Manu

[anurag kakkar]

IOCL,

--
cheers,
Anurag

[akriti sobti]

Reddy

Here's DLF.

Akriti

[Shruti Sharma]

Here's the Maruti Suzuki profile...

On Sat, Nov 14, 2009 at 12:41 AM, Ujjwal Chadha <ujjwal...@gmail.com> wrote:

[Sameer Varma]

STATE BANK OF INDIA

 

STOCK PRICES JAN-NOV

Month	Open Price	High Price	Low Price	Close Price	No. of  Shares	No. of  Trades	Total Turnover(Rs.)	* Spread (Rs.)
								H - L	C - O
January 2009	1,294.45	1,376.40	1,031.05	1,152.20	20974521	699600	24,617,166,571.00	345.35	-142.25
February 2009	1,141.10	1,205.90	1,008.30	1,027.10	15339661	555742	16,779,684,851.00	197.60	-114.00
March 2009	1,010.00	1,132.25	894.00	1,066.55	22660043	756093	22,521,165,313.00	238.25	56.55
April 2009	1,079.70	1,355.00	980.00	1,277.70	18094364	630772	22,151,321,901.00	375.00	198.00
May 2009	1,300.00	1,891.00	1,225.00	1,869.10	17712287	595474	27,117,854,847.00	666.00	569.10
June 2009	1,875.00	1,935.00	1,612.00	1,742.05	13840435	514536	24,223,393,629.00	323.00	-132.95
July 2009	1,737.90	1,840.00	1,512.00	1,814.00	14493518	523061	24,320,956,777.00	328.00	76.10
August 2009	1,825.00	1,886.90	1,670.00	1,743.05	8715987	353242	15,408,461,400.00	216.90	-81.95
September 2009	1,760.00	2,235.00	1,710.10	2,195.70	9537712	360023	19,081,059,274.00	524.90	435.70
October 2009	2,180.10	2,500.00	2,048.20	2,191.00	15641731	536543	35,258,872,274.00	451.80	10.90
November 2009	2,190.00	2,394.00	2,059.10	2,298.05	7132892	276858	15,935,941,085.00	334.90	108.05
* Spread  H - L -> High - Low C - 0 -> Close – Open    Interest Earned/Net Income from sales/services 250,179.10       Interest / discount on Advances / bills 180,712.90       Income on Investments 62,161.60       Interest on Balances with RBI & other inter bank funds 5,053.10       Others 2,251.50    Other Income 80,837.40   Total Income 331,016.50   Interest Expended -171,461.80    Operating Expenses -98,911.00       Employee Cost -37,522.60       Other operating expenses -61,388.40   Total Expenditure for Banks -270,372.80   Operating Profit Before Provisions and Contingencies 60,643.70    Provisions (other than tax) and Contingencies -12,017.30    Exceptional Items 0.00   Profit (+)/ Loss (-) from Ordinary Activities before Tax 48,626.40    Tax -17,294.80   Net Profit (+)/ Loss (-) from Ordinary Activities after Tax 31,331.60    Extraordinary Items 0.00   Net Profit 31,331.60   Minority Interest -821.70   Share of Profit & Loss of Asso 0.00   Net Profit after Mino Inter & Share of P & L 30,509.90   Any Other 0.00   Income Attributable to Consolidated Group 30,509.90   Cost of Investment In Sub 0.00   Equity Capital 6,348.80   Face Value (in Rs) 10.00   Reserves 717,555.10   Percentage of Share held by Govt

 

	Sep '08	Dec '08	Mar '09	Jun '09	Sep '09
Sales Turnover	15,566.50	18,030.34	17,342.39	17,472.76	17,775.88
Other Income	2,343.14	3,225.56	4,718.22	3,568.75	3,525.16
Total Income	17,909.64	21,255.90	22,060.61	21,041.51	21,301.04
Total Expenses	4,215.89	4,697.96	5,660.77	5,092.49	5,315.03
Operating Profit	11,350.61	13,332.38	11,681.62	12,380.27	12,460.85
Profit On Sale Of Assets	--	--	--	--	--
Profit On Sale Of Investments	--	--	--	--	--
Gain/Loss On Foreign Exchange	--	--	--	--	--
VRS Adjustment	--	--	--	--	--
Other Extraordinary Income/Expenses	--	--	--	--	--
Total Extraordinary Income/Expenses	--	--	--	--	--
Tax On Extraordinary Items	--	--	--	--	--
Net Extra Ordinary Income/Expenses	--	--	--	--	--
Gross Profit	13,693.75	16,557.94	16,399.84	15,949.02	15,986.01
Interest	10,111.15	12,272.15	12,500.45	12,447.88	12,167.06
PBDT	3,582.60	4,285.79	3,899.39	3,501.14	3,818.95
Depreciation	--	--	--	--	--
Depreciation On Revaluation Of Assets	--	--	--	--	--
PBT	3,582.60	4,285.79	3,899.39	3,501.14	3,818.95
Tax	1,322.88	1,807.37	1,157.08	1,170.77	1,328.91
Net Profit	2,259.72	2,478.42	2,742.31	2,330.37	2,490.04
Prior Years Income/Expenses	--	--	--	--	--
Depreciation for Previous Years Written Back/ Provided	--	--	--	--	--
Dividend	--	--	--	--	--
Dividend Tax	--	--	--	--	--
Dividend (%)	--	--	--	--	--
Earnings Per Share	35.59	39.04	43.19	36.71	39.22
Book Value	--	--	--	--	--
Equity	634.88	634.88	634.88	634.88	634.88
Reserves	48,401.19	48,401.19	57,312.81	57,312.81	57,312.81
Face Value	10.00	10.00	10.00	10.00	10.00

NEWS

1. state bank of indore to merge with sbi by march

2. sbi deposit rates cut 25-50 bps

3. sbi cuts deposit rates on slow credit, liquidity glut

4. banks cut credit growht targets but sbi ahead of the pack

 

hypothetical situations

1. sbi earnings climb by 10%

2. sbi fails to recover loans, hence liquidity crunch

[Rohan Sangari]

My company: INFOSYS

Check it out.

 

Rohan Sangari

[aradhya]

Tata Motors Limited : 637.5
<<
Price Information
Open 647
High 656.9
Low 632.1
Previous Close 646.45
Average Price 646.3
Total Traded Quantity 3461992
Turnover in Rs.Lakhs 22374.8
52 week high price 656.9
52 week low price 124.8
Face Value 10

Open Price 644.10 Average Price 643.08 Open Interest 12,336,900
High Price 654.90 No. of Contracts Traded 9,139 Open Int. Chg
-319,600
Low Price 629.95 Turnover (Rs. in lakhs) 49,955.42 Open Int. Chg %
-2.53
Prev. Close 644.70



Tata Motors Second Quarter Stand-alone net revenue g row s to R s.7 9
7 8 .8 2 crores,
P A T g row s to R s.7 2 9 .1 4 crores
Mum b ai, Oct 2 6 , 2 0 0 9 : Tata Motors today reported revenues (net
of excise) of
R s.7 9 7 8 .8 2 crores on a stand-alone basis for the q uarter ended
S eptem ber 3 0 , 2 0 0 9 , of
the financial year 2 0 0 9 -10 , com pared to R s.7 0 7 8 .8 5 crores
in the corresponding q uarter
last year, a g row th of 12 .7 % .
F or the second q uarter in a row , the com pany im proved its
operating m arg in to 13 .4 % ,
an im provem ent of 5 8 0 basis points com pared w ith the
corresponding q uarter of the
previous year. V olum e recovery com bined w ith im proved
realisations contributed to
g row th in revenues w hilst stable m aterial prices and accelerated
cost reduction efforts
continued to yield beneficial im pact on m arg ins.
P rofit before Tax for the q uarter g rew by 15 3 .3 % to R s.9 0 6 .8
5 crores (Q2 2 0 0 8 -0 9 :
R s.3 5 8 .0 1 crores) and P rofit after Tax w as R s.7 2 9 .14 crores
(Q2 2 0 0 8 -0 9 : R s.3 4 6 .9 9
crores), an increase of 110 .1% . The P rofit before Tax for
corresponding q uarter of 2 0 0 8 -
0 9 , w as after considering notional foreig n exchang e loss (net) of
R s. 2 4 5 .2 3 crores. H ad
the exchang e differences for the q uarter ended S eptem ber 3 0 , 2 0
0 8 , been accounted for
as per the current policy, the increase in P rofit before Tax w ould
be 4 9 .7 % .
The sales volum e for the q uarter (including exports) w as 15 8 ,5 7
5 vehicles (Q2 2 0 0 8 -0 9 :
13 5 ,0 3 7 ), a g row th of 17 .4 % . R evival of industrial activity
and im provem ent in liq uidity
coupled w ith introduction of new products and variants im proved the
com pany s sales in
the dom estic m ark et. H ow ever, continued slow dow n in prim e m
ark ets and volatility of
exchang e rates persist in im pacting com pany s exports of com m
ercial vehicles and
passeng er vehicles.
In the dom estic m ark et, the com pany g ained m ark et share in com
m ercial vehicles to
6 5 .5 % during the q uarter com pared w ith 6 2 .0 % in the
corresponding q uarter of last year
on the back of a 2 0 .7 % g row th in dom estic sales to 8 9 ,6 5 5
units. F or the first tim e in the
last four q uarters, the com pany s sales in the m edium and heavy com
m ercial vehicle
seg m ent w itnessed a year-on-year g row th during the current q
uarter of J uly-S eptem ber
2 0 0 9 , w hile the industry sales in the seg m ent w as alm ost
flat. Lig ht com m ercial vehicles,
led by the continued strong perform ance of the A ce and the Mag ic,
also m aintained
sig nificant g row th at 3 3 .1% .
P asseng er vehicles, including F iat and J ag uar and Land R over
vehicles, g rew by 2 7 .3 %
in the dom estic m ark et to 6 0 ,9 17 units. The m ark et share for
Tata passeng er vehicles for
the period stood at 11.6 % . The com pany com m enced the delivery of
Tata N ano this
q uarter and has delivered 7 ,5 0 6 units m anufactured from its plant
at U ttarak hand. A long
w ith F iat, the com pany has a joint m ark et share of 13 .4 % in the
industry. The com pany
commenced deliveries of Jaguar and Land Rover vehicles which have
received
encouraging response from the market.
Half Y ear
The company s revenues (net of excise) were Rs.14383.45 crores in the
first half,
compared to Rs.14007.29 crores in the first half last year, a growth
of 2.7%. Profit before
Tax (before notional loss on foreign exchange valuation) was Rs.
1475.74 crores,
compared to Rs.1109.92 crores in the first half last year, an increase
of 33.0%. After
considering notional exchange valuation loss of Rs. 20.85 crores (Q2
2008-09: Rs.
406.82 crores) reflecting the volatility in foreign exchange rates on
revaluation of foreign
currency borrowings, deposits and loans given, Profit before Tax was
Rs.1454.89 crores,
compared to Rs. 703.10 crores in the first half last year, a growth of
106.9%, while Profit
after Tax (after notional loss on foreign exchange valuation) was Rs.
1242.90 crores
compared to Rs.673.10 crores in the first half last year, a growth of
84.7%.
The audited financial results of the company for the quarter and half
year ended
September 30, 2009, are enclosed.


RELIANCE COMM
Price Information
Open 177
High 177.6
Low 172
Previous Close 176.95
Average Price 174.38
Total Traded Quantity 4013833
Turnover in Rs.Lakhs 6999.32
52 week high price 362
52 week low price 131.1
Face Value 5

Open Price 177.05 Average Price 174.23 Open Interest 20,996,500
High Price 177.50 No. of Contracts Traded 7,376 Open Int. Chg
-928,900
Low Price 171.55 Turnover (Rs. in lakhs) 8,995.84 Open Int. Chg %
-4.24
Prev. Close 177.00

Reliance Communications, the nation's second largest wireless
telephony company, on Saturday announced 51% decline in quarterly
profit due to forex loss
RCOM, part of the Reliance Anil Dhirubhai Ambani group, has posted net
profit of Rs 740 crore in the September quarter, compared to Rs 1,531
crore in the year-ago period. The forex loss of Rs 283 crore forced
the company, which posted a marginal 1% rise in revenue to Rs 5,703
crore, to post a sharp decline in profit.

The results were worse than the expectation. A survey of ETIG and four
brokerage houses estimated RCOM's net sales at Rs 6,356 crore and net
profit at Rs 1,171 crore. However, the company would have posted a net
profit of Rs 1023 crore, had there been no forex loss.

Bharti Airtel, the nation's largest, on Friday posted a 13% rise in
net profit and 9% revenue growth.

RCOM chairman Anil Ambani said: " In the near term, the wireless
sector in India is undergoing a challenging phase, with increased
competitive intensity and continuing aggressive rebalancing of mobile
tariffs by all leading players."

The wireless revenues, main money spinner for the telco, dropped 7.5%
to Rs 4010 crore while EBIDTA margin fell 540 basis points to 35.4%.
In a statement, the company said higher competitive intensity,
aggressive tariff restructuring by the telecom operators and higher
network and operational costs owing to a nationwide GSM rollout have
impacted wireless segment and EBIDTA margin.