Posts

Showing posts from September, 2008

EMI & Loan amortization Formula

I realised that most who are searching for a EMI formula will not read a long blog - To download the EMI / Loan Amortization Template and the formulae - click here To read the descriptive blog about EMI / Loan Amortization - click here .

Loan amortization schedule

I walk into my home today to find a mail from my Banker - there is an increase of 150 Basis Points in the Home Loan interest rate - meaning, my house loan has increased by 1.5% - What stumped my the most is this - My House loan tenure is increased to 425 months from 240 months, keeping the EMI (Equated Monthly Installment / Amortization Money) constant. It took about 2-3 minutes to understand that a 1.5% increase in house loan can actually almost double my repayment period - and needless to say, you would almost pay 80% than what you actually would have paid at the end of the agreed period - in my case 24 months. There was no mathematical error - and the easier way to decrease my 80% additional payout is to increase my EMI by just about 8% a month. At first, I took the easy way out asking uncle "Google" for the formula for amortization / calculate payout months with EMI constant, and for a surprise - I did not get any simple answers - There were some good Excel Templates on M

Random tidbits about my workplaces

Wipro had the fastest IT response time – under 2 mins – every time, all the time :) - Amazing All most every single Finance / HR head across all the companies have been sacked / tried for either financial fraud or sexual abuse!!! – And all these companies have the longest essays on everything ‘ethical’ All but at one company (SumTotal) – I have seen people make-out or watch porn in the conference room A comment that’s blog worthy Working with XXXX is like reliving the dream of high school - except that....in high school it was fun, but a few years down the lane, you see it as being stupid and occasionally laugh at yourself....but it gets even more frustrating when you have to hear self appointed pompous asses who make a big deal of it - grow up guys!!!! Unfortunately... I am living that for now - just can't wait to get out of high school No company ever gave a financial bonus to any employees, while each maintained at least 40% profit Y-O-Y Across all companies – ‘hikes ‘ came bef