Monday, March 15, 2010

EMI Calculator with yearwise projections of interest / principle components



I have updated the previous version with some additional options.

With this version, you can see the projection of interest component or the principle component year over year for the entire duration of the Loan. This data is available both as a table and as a graph.

What is better, just enter the loan starting date and the complete info available for you to analyze further. This is specifically made for planning your tax exemptions for the duration of the loan.








you can download the file from the below link...



Friday, February 26, 2010

New Tax Proposal in the Union Budget - Feb, 2010

The Budget has proposed a new tax Slab. Taxes will be slashed again


on income up to Rs 1.6 lakh, Tax would be nil,
above Rs 1.6 lakh upto Rs 5 lakh, Tax would be 10%,
above Rs 5 lakh upto 8 lakh, Tax would be 20% and
above Rs 8 lakh, Tax would be 30%.


Also, over and above the existing Rs 1 lakh deduction on tax savings, an additional deduction of Rs 20% for investment in long-term infrastructure bonds would be allowed.

Sunday, October 04, 2009

Updated version of EMI Rlated Calcultions



Here is a new version of the Original EMI Calculator.



You calculate anything using this. Calculate Loan Eligibility, EMI, Interest or Term.

You can get a loan distribution also.


.

Wednesday, May 13, 2009

2009 Indian LokSabha Election, General Election, exit polls results

There are various versions of exit polls predicting who will get how much. How much NDA, UPA, Left, third front, fourth front etc.




1) NDTV Results.

NDA = 160-170
UPA = 205-215
3rd Front = 120-130
Others = 36-45

Click here for Link

2) Times of india

NDA = 195
UPA = 201
3rd Front = 82
4th Front = 65

Click here for Link


Thursday, September 18, 2008

Updated EMI Calculator with enhanced features




I have been using an EMI Calculator that I had made few years back. Now I have updated that and is available for download.

Please see the right side of this post and you would find a section "MY FILES". The "EMI Calculator Plus V3.01.xls" will be available there and you can download it from there.

Features:

1. Calculate EMI (Equated Monthly Installments), if you know the Loan Amount, Interest rate per year and no of installments.

2. Calculate the Interest rate if you know the EMI. (This is useful because sometimes the bank will only say the EMI).

3. Calculate the Loan amount. You know how much you can pay per month. Then you can find the Loan amount for a given interest rate and tenure.


For all these, there would be additional information like - How much I pay in full, How much I pay extra per month etc..

Also, you can see the breakdown of the Loan for each month. How much is the Interest Component? and How much is the Reduction In Principle? etc.. This is very useful when you have tax exemption on a housing loan.


a snapshot.


Check out.. Im sure that you will find it useful..
Let me know, if you have any comments, suggestion, problems...




Sunday, September 14, 2008

India is the 4th largest country in terms of the GDP (PPP)



You must be thinking that I'm joking or I'm talking about 2025. No Im not. These are figures of the year 2007 given by IMF and World Bank. I will come to that in a while. Lets forget that for a moment.

I was just browsing to get some comparative index of the living standard of people across different countries in the world and their purchasing power. How do you do that?

For a long time, GDP (Gross domestic product) and GDP per capita used to be the benchmark for that.

In simple terms, wiki says:
GDP = consumption + gross investment + government spending + (exports − imports).

Next came the Human Development Index.

Wiki says:
This index is a normalized measures of life expectancy, literacy, educational attainment, and GDP per capita for countries worldwide.

But if I understood these correctly, it does not take into account the purchasing power of an individual.. Lets take two countries - India and Germany. Their respective currencies are Euro and Rupee. The exchange ratio between these two currencies is 1Euro = 65Rs approximately. So lets compare a service in both countries.. I take the haircut. In Germany, it costs 10Euro minimum in general. In India, It may cost 100Rs max in big cities for an above average one. (Although you can avail that service at much cheaper rate, I kept the Indian one slightly on the higher side to have a correction factor for quality of service.) Now, simple maths says that the cost of the haircut is 6.5 times cheaper in India. So if we take the haircut as a benchmark, the German need to earn 6.5 times the Indian to have the same living standard. Obviously, the values are way of target, but my point is that, just because an Indian may earn less doesn't necessarily mean that he may have a lower living standard. Thankfully, people who know these things have made another index to make necessary correction to account for the difference in living cost.

That is PPP (Purchasing power parity)

Wiki says:
The purchasing power parity (PPP) theory uses the long-term equilibrium exchange rate of two currencies to equalize their purchasing power.

India ranks 12th by GDP but 4th by PPP.


Fig Courtesy Wikipedia.


See the following link to get the ranks based on PPP.
http://en.wikipedia.org/wiki/List_of_countries_by_GDP_(PPP)


Thus you can see that India is the 4th largest economy in the world today, bigger than Germany and UK.
(based on GDP-PPP).

As you would read in those pages, this, by no means, cannot be considered as the absolute index for comparison. But this will give you a perspective of the purchasing ability of the people, which is missing in other indexes.



Footnote:

Even PPP is a Gross Income. It means that the bigger the population, the bigger the GDP (in general, of course with exceptions). India, due to its size would have come that high in the list.

I think, more than PPP, the PPP/person (PPP per capita) would be a more interesting figure. But here also, the figures would be distorted if the wealth is concentrated among few.

So I think, an even more interesting figure would be the average PPP of the middle 70% of the population. What I meant is this. Remove the top 15% and bottom 15%. Calculate the PPP of the remaining 70%. Divide that value with the no of people that fall into those 70%. Thus you would get the average purchasing ability of the common man in that country.

This is the "Joe's 70% average PPP".


Links:

Gross domestic product

Human Development Index

Purchasing power parity

List of countries by GDP (nominal)

List of countries by GDP per capita

List of countries by Human Development Index

List of countries by GDP-PPP

List of countries by PPP per capita

Tuesday, September 02, 2008

Hidden Radio






What you see is a camouflaged Radio design by John Van Den.

You can lift and rotate. Lifting increases the volume. Rotating will tune the radio. The light will give a you a feedback on tuning with varied brightness.

Have a look

Sunday, August 24, 2008

the performance enhancement methods of today and tomorrow.. the doping direction.



Today the Beijing Olympics 2008 came to a close. I was not following it very closely, but from the few impression that I get, it was a wonderful event. China can take pride in the way it has organised it. There would always be criticism, but I think the World has seen another dimension of the Dragon Empire. China also would also have learnt a few things out of this. Congratulations China!

I was just browsing for the Doping Counter Hits of Beijing 2008. I didn't get there but I reached some interesting sites.. thought I will share with you.

Today its the age of Performance Enhancement Drugs.
Tomorrow it will be the Gene Doping. Although cant really be sure if its so futuristic because it might be here already.


A German television report on the availability of gene doping in China, which aired just a few days before the Olympics, stunned anti-doping experts. In the documentary by ARD television, a reporter posing as an American swimming coach met with a doctor who is the head of the gene-therapy department of an unnamed Chinese hospital. The hidden-camera report shows the Chinese doctor, with his face blurred, offering gene-therapy treatment to the undercover reporter in return for $24,000.

Quote from newsweek.com. the full link is given below


Interesting links..

Is 'gene doping' the next Olympic threat?

an unofficial list of banned athletes..

The nonsense of Olympic doping rules.

footnote:
couple of years back, I had a posting on Marion Jones (click here to see the post). I am no expert in sports drugs, but I had felt at that time that something is smelling bad. An year later (Oct 2007), she admitted that she Doped and all medals of Olympics 2000 and subsequent medals were stripped off her.

So what you see is not always what it is, more so in this case.


Monday, August 18, 2008

what defines you and me.



I came across this movie on YouTube the other day. Its not only very touching, but make you introspective and indeed very thankful what all we have.



It was a very beautiful day for him until that small accident happened. But the consequences were not so small. Its amazing that he could survive in spite of all these, because most often the mental damage (of lost abilities) would be more devastating than the physical one. It is not easy to recover from that.

I was watching the movie FELON, where the life of this guy turns upside down by an event. His fellow prisoner has this Quote for him.. "when your life is defined by a single action, it change the concept of time."

If you have watched the above movie full, at the end he says this to all. Can you define yourself, beyond the physical abilities that you have?

Probably another reason why he was able recover is that he could accept himself being not good in certain things.. Things which he was good at and had taken pride in.. He was able to redefine himself.. he was able to find joy when he could do simple things.. that was an achievement for his at his level.. I think there is an underlying lesson in that. We often compare ourself with the best and gets disappointed that we are not as good as they are.. May be we need to set the benchmarks for ourself and not by comparing with others.. Be happy at what you have achieved, however small that may be when comparing with others.. But, for you, you had to put the 100% to get there and that's what all you can ask for.. Take pride in that..

We, most often gets concerned at what all we missed, could have, would have etc etc.. But probably, once in a while we have to sit back and think what all went right for me. There could be so many instances where we miss the worst by a whisker.. But we soon forget that. Things that we don't forget are on the other side of the spectrum. I guess its human.

So define yourself beyond the physical abilities.. Can we?

what do you think ?


Sunday, August 17, 2008

Beijing Olympics 2008. Is it the Phelps-Bolt Olympics


Some more superstars !!! Rather they are a phenomenon in themselves..

Usain Bolt
Michael Phelps






When the competition gets tough, you normally expect the winning margins to be very small.. But here are two guys who are just miles ahead of others (one over land and the other in the water).

There are obviously speculations that these are backed by illegal substances. But I like to believe otherwise. May be they are not cheating and if they are not, then I think its the biggest crime not to give it to them. I mean, there are ways and means to keep a check on those. And so long as they are proved otherwise, I think its not fair to doubt their ability and efforts they might have put in.


On the one hand you have the (Thunder) Bolt, who didn't compete in the 100m until one year ago, suddenly emerges from the cloud and in the BIGGEST stage, takes the glory with ease. He was posing for the cameras even before he finished and even then won it with a margin that is the biggest in last 40 years and of course broke the world record by a big margin. "We've never seen anything like that before" was the verdict of the great Olympian Michael Johnson after a breathtaking 100 metres final.



On the other hand, you have a superhuman in Phelps. The way he strokes past others will mislead you to think that he is competing with armatures. And he does that event after event. There is no stopping him. The term - Fatigue - might have to be redefined now, because he seems to have not heard about that at all. I heard a comment about him "He is just another guy, but from a different planet". One can't help thinking in those lines. Interestingly enough, if you read through his physical specialities (c/o wiki), then one might wonder, if this is a small evolutionary change!


Further reading
Olympics: Bolt saunters into history in 9.69 sec
9.69 - and Usain Bolt didn't even try
The Michael Phelps diet: don't try this at home

Bio of Usain Bolt
Bio of Michael Phelps

youtube channel of Usain Bolt