Sunday, November 28, 2010

India - A super power soon

Indians speak a lot saying “Is desh ka kuch nehi ho sakta (Nothing can happen about the nation)”. But, I think it just requires three simple steps to develop the nation. A developing nation can be a developed nation in less than a month. All Indians will be happy and it would be the most developed nation on its own. “A SUPER POWER” to be specific. The three steps are as follows:

1. Get Rs. 3,000 trillion (Approx.) back to India

The corrupted money in different parts of the world can be brought back to India. Leave about a comman man like us. Even most of the politicians don’t even know how many zeros are there in 3,000 trillion. This money can make India a super power. Today a dollar costs around Rs.45. Later a Rupee would cost $45. An unimaginable infrastructure, rich people, No divestment, Great technology, Best research and education, Tax free income, etc can be seen in India.

2. Remove Rs. 100, 500 and 1000 notes from the market (remove corruption)

The bigger notes are responsible for the corruption in India. If I have 1crore rupees as black money with me, a bag of Rs.1000 notes could do. But If I have to store the same Rs. 1crore in denominations of Rs.10 at home, A room would not be sufficient. Carrying the same would itself be a problem. So, the only option that would be left to me would be to keep it in bank. It is really difficult to put a lot of black money into the bank. A traffic police could ask for Rs.100 from 200 people, it would be 2000 notes of Rs.10 each. So, his pocket might not be sufficient.

3. Replace the existing currency notes by new one. All bank transactions are free of cost

The best way of removing the duplicate notes would be to use new technology and develop the new notes. Replace the existing currency from the market. The proper money would be in the market. The existing duplicate notes can be removed. To avoid the printing of the new notes, Govt. can take serious legal actions. Also, printing Rs.10 notes would cost them more than Rs.10.

The implementation of these three steps could develop the nation in no time making it the world’s super power. It will be done by some or the other political party one day and we hope the day is not far.

Company’s failure can’t make you poor.

People invest a lot in products like life insurance, medical insurance, equity of the company that he/she is working, etc. But leading a life without a job is the most difficult part of it. Your job depends on the company. If company is closed or is not performing, you get unemployed. In both the cases, its stock price falls to its all time low price. So, buying deep out of the money long term put option is always better. Let us assume the income of an employee is Rs.5lac per annum. If he invests Rs.5000 and buy a Rs. 0.05 worth 100,000 put options, the day the company closes, the price of the stock would become negligible. The profit that we get is much higher and the unemployment makes us rich.

Thursday, November 11, 2010

Who says markets are efficient: Lots of free lunch in the market

Efficient market hypothesis states that markets are efficient. Market price reflects the true price of a share. There is no information asymmetry and there is no free lunch available for any investor in the market. But it is not true. You always find a free lunch in markets. Just need to understand and grab it.

Indian Govt. is continuously coming out with several IPOs and FPOs with a 5% discount for the retail investors. We have the free lunch in it being a retail investor.

FPOs: All the companies come out with an FPO at a discount compared to the current market price. Otherwise people would prefer buying from the market than from the FPO. So, to raise money, the company has to give discount on current market price. Govt. FPOs also give a discount of 5% for the retail investors. The best strategy to grab the free lunch is to buy an ATM put options that costs approx. 3-5% of the market price. Apply for an FPO that is priced at a discount of more than 5%. The minimum profit that we get at any cost is (Market price – FPO price – Put option premium – all transactions costs). If the price on the day of listing is more than the strike price of the FPO, you earn more and if it is less, you get your minimum profit.

Eg: Power grid FPO with price band of 85 to 90 and trading at 100 with ATM (strike = 100) put costing 3 to 5 rupees and 5% discount for retail investor. So, if we pay Rs.4 as premium for 100 – Put option, minimum profit for retail investor = 100 – (90-4.5) – 4 – transaction cost = approx. Rs.10/share (Free lunch in efficient market). If, on the day of listing, price is above 100, we have lot more than Rs.10/share. It is clearly an arbitrage opportunity.

IPOs: Govt. sells the shares at a discount than its valuation for an IPO so as to attract the investor for the IPO. Retailers also get a discount of 5% in the IPO. So, the obvious thing that can happen is to get a min. of 5% benefit in an IPO for an investor. The best example is the latest IPO by Coal India. But efficient market hypothesis may work here.

Tuesday, November 9, 2010

India still a golden eagle (sone ki chidiya)

India has been ruled by several kings followed by East India Company and now the famous Indian politicians who took/stole a lot of wealth from the nation. A nation called to be an independent nation after 1947 is independent for its name and now it is ruled by the famous Gandhi family. After stealing so much of wealth by several kings and kingdoms, India is rich and has a lot more to feed its people (a common man). What does it mean? It clearly depicts how rich India is in terms of its wealth. After a loss of so much of wealth, India is capable of feeding its 1.1 billion citizens.

Sunday, October 24, 2010

What should we know to be an expert in MS Excel??

Many people appreciate my excel skills. But if someone asks me what do I know, i don't have an answer since I know few basic excel skills and I know how to make perfect utilization of it to develop any model through it. The following are a few skills that I have.

1. Count and Sum:

Some of the formulas that are highly useful in this category are: sum, sumif, sumifs, sumproduct, sumsq, sumx2my2(sum of x square - y square), sumx2py2(sum of x square + y square), sumxmy2(sum of (x - y) square), count, countif, countifs, average, etc

2. Key board shortcuts:

There are a list of excel shortcuts that are highly useful and that makes the work faster. All the shortcuts can be seen in the following link by microsoft.

In this, the most important that cannot be ignored are: F2, F4, Ctrl + c, Ctrl + v, Ctrl + directional arrows, home, end, etc

3. Logical and Conditional formulas:

A few but most important formulas are: if, iferror, and, or, not, etc

4. Filters:

Data can be filtered as per our requirement by using the concept of filters. There is also an advanced filter which is an added advantage over the normal filter.


5. Lookups:

Hlookup and Vlookup are the major requirement while dealing with a major set of data. To develop a dynamic model in excel including filtering gets easier using lookups

6. Security and Protection:

For keeping your data unmodifiable in a particular cell or worksheet or file, you can protect it. It is available in Home/Cells/Protection.

7. Charts and Pivot Table:

Pivot table is highly useful in organizing, calculating sum, count, average, etc and summarizing the data based on requirement. A chart also helps presenting the data in an easier pictorial format.

8. Others:

There are certain other concepts which are most important in excel. Some of the most important are Solver, Goal Seek, data table, scenario analysis, data analysis, conditional formating, macros, etc.

Wednesday, September 15, 2010

Greeks in Education

Indian education is full of Greek letters like alpha, beta, gamma, theta, Vega, etc. These similar words are used in almost every field. If I ask theta in a summit with audience from diversified fields, they understand it differently. For example, theta is used in different fields as follows:
  • Derivatives in finance.
  • A plane angle in geometry.
  • A special function of several complex variables.
  • The voiceless dental fricative in the International Phonetic Alphabet, such as in the words thick or thin (but not as in the, which is the voiced dental fricative).
  • The Potential temperature in meteorology.
  • The score of a test taker in item response theory.
  • Theta Type Replication: a type of bacterial DNA replication specific to circular chromosomes.
  • Threshold value of an artificial neuron.
  • A Bayer designation letter applied to a star in a constellation; usually the eighth star so labelled but not necessarily the eighth brightest as viewed from Earth.
  • The parameter frequently used in writing the likelihood function (Bayes theorem).
  • Along with μ (Mu), population parameters in the Normal/Gaussian/Bell curve distribution, usually designated N(μ,θ).
  • The Watterson estimator for the population mutation rate in population genetics.
  • In Christian theological writings it is often used as a short hand for God.
If this single Greek letter is used in such diversified fields, I wonder how people interpret it. Being an Indian, we can say that we don't understand Greek. But what do Greeks say if they don't understand Greek??

Tuesday, August 10, 2010

Todays education gets us an ability to read but not the ability to distinguish what is worth reading

In schools, the education system in India has been designed so as to match the requirements of the parents and organizations. It educates a man on how to handle pressure of studies and related homework, etc rather than teaching how to enjoy the learning. The hobby or hidden talent of the child is killed in the system. By the time he completes his education (graduation/post graduation), he looses his hidden talent and try to create a new hobby or talent which results in nothing more than a failure. Ultimately, he himself is made responsible for the loss. Every parent wants a child to be a sachin tendulkar or lata mangeshkar but no one makes it happen by recognizing, appreciating and encouraging them to enjoy his talent. If sachin tendulkar or lata mangeshkar could not have not been allowed to play cricket or music in there childhood, we could not have had them as a great appreciatable talent.

If a student is physically and mentally capable of handling the pressure, he is appreciated. But he doesn't really deserve it as he has done it based on his ability rather than performance. A ranker is elected as a leader/representative in the class rather than the one who has shown a much better performance than the last time (The previous exam). In stock market, we feel that "A small performing company is much better than the biggest company which is not performing"

The education system today has got us an ability to read and write but not the ability to distinguish what is worth reading. So, we get attracted by an attractive story rather than a real time good story.