Future Value : The future value of an asset or investment is the value of asset or investment on a specific date in future. Most of the people who use excel for financial analysis or accounting purpose rely heavily on the excel’s inbuilt function for deriving the future value.

FV = (rate, nper, pmt, [pv], [type])

Example: You just opened a bank account with Rs. 20000 and you have decided to deposit Rs. 4000 at the end of every month for next 10 years. The bank offers 9 per cent annual interest on the savings account. Now, you want to know how much money you will have in your account at the end of 10 years. Here you can use excel’s future value function to calculate the total amount that you will get at the end of 10 years.
Lets break this problem in key variables that will be required by the FV() of Excel.
Rate: 9 per cent per annum. But we need to calculate the monthly rate of interest as the period of payment is monthly. So Rate = 9%/12% = 0.75% or 0.0075 (Take note of the percentage sign).

Periods (nper): 120 months (10 years X 12 Months)

Payment (pmt) : -4000 (since its going out from your pocket, hence the minus sign)

Present Value (pv): – 20000 (same logic as above)

Type : 0 (if payment is deposited at the end of the period), 1 (if payment is deposited at the beginning of the period)

http://pagead2.googlesyndication.com/pagead/show_ads.js

The function now becomes:

FV=(0.75%, 120, -4000, -20000,0)

You will get Rs. 823,084.25 as the result. This is the money you will receive at the end of the 10 years.

Day One is really very handy app for anyone  interested in writing daily journals. It syncs beautifully to all your devices using either Dropbox or iCloud. You can use a password to protect your journal from prying eyes and  it works perfectly. However, if you forget the password, reseting the password is not easy. You have to go through a number of steps, depending on whether you are keeping your content synced through Dropbox or iCloud. The detailed procedure is given here. But, the procedure given at the official support webpage does not apply for those users who are using iCloud for syncing on Mountain Lion. The reason, there is no ‘Mobile Document’ folder that you can access on Mountain Lion. But you can do it by deleting the ‘security.plist’.

http://pagead2.googlesyndication.com/pagead/show_ads.js

‘Go to System Preferences’ -> ‘iCloud’

Click on Manage and Choose ‘Day One’  and then find ‘security.plist’ and delete it.

 

I really loved my Kindle classic, probably the best book reader around, but just las week it developed a snag with its displace and it made it completely unusable. There is a one ad that is stuck 3/4 of my display and only 1/4 of the screen is working properly. That means that you cannot use it for anything. I tried resetting many times but nothing seem to work.
//
http://pagead2.googlesyndication.com/pagead/show_ads.js

I am wondering if there is any way to get it repaired in India. We got it from US and I think it is still under warranty. But the warranty is not available in India and I am not aware of any agency that does repair officially or unofficially. Did anyone face the same problem and more importantly did you get the kindle to work again?

I have been searching for a good blog-editor for MacOS and experimented with a number of them (Sadly there are not many available). Most of the professional bloggers on MacOS use either Ecto or MarsEdit and while these are decent options, these are not free and I would not say the best options for amateurs bloggers for two reasons. One, they are still have some bugs, and second, they are not free. There is another option Qumana, which is available all the platforms, but I find it rather slow and buggy.

Finally I settled down to Scribefire, a very powerful browser extension that is available for Firefox, Opera and Chrome and available for all platforms. It offeres all the features of a normal desktop blog-editor and very light on resources. It supports all the major blogging platforms (Blogger, WordPress, Liverjournal) and if you are using any of the free blogging platforms the installation is breeze. You just need to fill in the blog url and it automatically detects the settings.Scribefire-the blog editor

Though configuring self-hosted blogs is a bit problematic. I did not detect the settings for my this (http://santoshsing.net) wordpress blog automatically and I had to provide the settings manually. But it is not that difficult. Here is how you can easily configure it.

http://pagead2.googlesyndication.com/pagead/show_ads.js

1. First, login to your blog admin (htttp://blogurl/wp-admin)

2. Go to Dashboard–>Setting–>Writing and enable remote publising xml-rpc (tick it on if it is not already ticked)

3. Now install the ScribeFire extension in your browser, open it and click on Add a new blog.

4.  Fill in the blog url, Select blogtype -Wordpress, and put your api url (http://yourblogurl/xml-rpc/php)

5. Provide your blog admin username and password.

You are all set to blog now.

 

 

Last week, Apple released beta version of the new chat/message client Message and I liked its interface and design. It is a great gift for users with multiple iOS/MacOS devices, you can start the conversation on one device and continue it on any of the iOS/MacOS device. It officially supports almost all the popular chat services such as Yahoo, gTalk, AIM etc.. but it does not support Facebook chat but there is a way around that:

http://pagead2.googlesyndication.com/pagead/show_ads.js

Step 1: Login to your facebook account and see the url in browser address bar and note down the part after http://facebook.com/.. for example: if you see http://facebook.com/smsmt .. you note down the ‘smsmt’. This is your user name for facebook chat account. 

Step 2: Go to Messages (if you have not downloaded and installed it.. check it on apple website) and go to preferences.

Step 3: Click on ‘Accounts’ and when the ‘Account’s’ window opens click on the ‘+’ sign on the bottom left corner.

Step 4: Select account type as ‘Jabber’ and in username field put yourusername@chat.facebook.com and enter your facebook password.

Now you can use Message with your facebook chat account.

I have been using Fast Track Chennai for almost a couple of years now, and I realized that I really need a better alternative in Chennai. I have missed my flight twice, reached late at least ten times and lost my temper almost every second time I call them to order for a cab. I can cite numerous reasons (yes, my list is surprisingly long!) but here are three major ones:

1. Their drivers are ill-trained and they never understand their responsibility of informing the customer in case their vehicle is broken or they are running late (which they almost always do if you need them on time.).

2. The call-center employees never understand your requirements and your timing and pick-up address are prone to be goofed up most of the time. Often then tend to attend more than one customer at the same time. Yes, you can easily make this thing from the phone call.

http://pagead2.googlesyndication.com/pagead/show_ads.js

3. I know that it is my stupidity/lethargy/idleness that I did not learn Tamil and I understand that the drivers are not supposed to be fluent in Hindi or English (though most of the time Fast Track people assure me that they are sending driver who understands English), but I do expect the drivers to know the routes in the city. I am not able to count how many times I have got delayed or paid twice the normal fare due this reason.

There are a number of other operators whom I have started trying instead of Fast Track. Anyone knows a better option in Chennai?

After three days of initial outage, I finally got my iCloud mail id working. It was really strange the way iCloud smtp server behaved. But anyway, I think this problem is over. After configuring iCloud email on my mac and windows, I really needed it on my android phones so that I can check my mails on the go. Here is a step by step tutorial for configuring your email client on Android phones (the setting works almost on all the devices).

1. Go to the native email client application and go to new account setup.

2. Fill your email address “xxxx@me.com or xxxx@mac.com” and password and click on the Manual Setup.

3. Choose IMAP and fill “p07-imap.mail.me.com” (or p01-imap.mail.me.com etc..)port: 993 and Security type : SSL.

http://pagead2.googlesyndication.com/pagead/show_ads.js

4. On the following screen configure smtp server by entering these values SMTP Server: smtp.me.com Port: 587 Security type: TLS You need to check “Require Sign In” and provide your username and password. Keep in mind that your username should not be your full email id but just the part before @sign e.g enter sa123 for email id sa123@me.com.

5. Enter the values in option fields and enjoy your icloud mail on android. Note: You need to check your imap server as iCloud has assigned the different servers (p01-imap to p09-imap) to different email ids so check which one of the these works for you. You can also see this in your iOS device mail setting, use the same imap server for android.

Update: Please do let me know if this setting work for you… I would like to know whether this is working universally or just for a few. Update  2: Try changing your password of iCloud account if above settings are not working. For some servers this has solved the problem. Look at the comments sections, you can see what has worked for some other people. The best blog-editor for Mac (Do you agree with my choice…share your views here) 

// http://www.assoc-amazon.com/s/ads.js

For someone who works on ‘understanding markets’ and is familiar with previous works of Michael Shermer, picking “The Mind of the Market” from the bookshelf was an impulsive decision. And, the blurb made it clear that I have an interesting read for my weekend.

Shermer, drawing extensively from behavioral economics, neuroscience, psychology and evolutionary biology, offers his explanation of our seemingly irrational and often unpredictable economic behavior. Shermer, en route to his explanations, builds an excellent repository of cutting edge research in several disciplines and provides his readers a plethora of interesting examples and theories which have been part of great debate among academics; this itself makes his book immensely valuable and enriching. He starts with drawing parallels between Charles Darwin’s theory of natural selection and Adam Smith’s invisible hand makes a cogent argument about interconnectedness of these two seminal works and how they affect behavior. His rebuttal of ‘Homo Economicus’ might not be very convincing to some but it does provide some good insights nonetheless. 

http://pagead2.googlesyndication.com/pagead/show_ads.js

“Morality of the market” and “morality and market” are the two themes you will come across in many chapters.
While Shermer confesses the limitation of research findings when applied to real life settings, yet he does resort often to the same for his arguments. Shermer cherry-picks cases and examples to establish the creativity and efficacy of markets and its self correcting mechanism; and this has invited a fair amount of criticism to this book. This was almost expected if you consider that Shermer is also known as skeptic and wrote a scathing criticism for Ayn Rand’s philosophy in his essay “The unlikeliest cult in history” , in this book Shermer the skeptics takes the back seat and Shermer the libertarian emerges very strongly.

Fiction
1. Never Let Me Go by Ishiguro Kazuo
Highly recommended if you are looking for a good thought provoking science fiction.  A mushy story about the lives of clones who were raised to be ‘donors’ for human beings. Was shortlisted for Booker in 2005.

2. 1984 by George Orwell
I read a couple of dystopian novels recently. This was surely one genre defining novel. Does not need any recommendation.

3. Things Fall Apart by Chinua Achebe
Probably the most widely read novel by an African author. Loved this book, reading this book was a pleasure. Simple story, simple writing, great impact.

4. The Idiot by Fyodor Dostoevesky
One of the greatest Russian novels. You will love the struggle of ‘the original’ protogonist  with the materialistic society. The tragic love story of Prince and Nastasya adds a number of new dimensions to relationship and love.

5. Fahrenheit 451 by Ray Bradbury
The second dystopian novel that I read this year.

6. The Postman Always Rings Twice by James M Cain
A very highly rated crime novel. Some people put this novel in top 100 novels of last century. Did not impress me that much, story seems too familiar.. probably I read too many adaptation or saw different versions of the story in some movies.

7. Full Dark, No Stars by Stephen King
Somehow finished it. I am not a big fan of horror stories, Stephan King’s writing and story telling skills made me tolerate this one.

8. Along came a Spider by James Patterson
Wanted to read some light fiction and picked the Alex Cross series for time pass. Nothing much to write about here. A time pass.

9. Max: Maximum Ride by James Patterson
Juvenile fiction. Well just picked it out of curiosity and lack of other options.

10. Siddhartha by Herman Hesse
I read this 15 years ago, could not get much of this book at that time. Re-read it.

11. 2666 by Roberta Bolano
A slow and very lengthy novel. Over 1000 pages. It was an ordeal in patience and test of my passion for reading as the story did not move much in first few hundred pages.

Non-Fiction
12.I hope they Serve Beer in Hell by Tucker Max
Curiosity. Yes, that’s why I picked the book.

13. May I hebb Your Attention Pliss by Arnab Ray
By One of my favorite bloggers who turned author. A great satire on our life in eighties and nineties.

http://pagead2.googlesyndication.com/pagead/show_ads.js

On my last trip to US, I wanted to buy a Kindle book reader, but the pain of ordering it online forced me to by Barnes and Nobles’ Nook. There is not much difference in Nook and Kindle if you consider the book reading experience but Nook does not have a physical keyboard as Kindle does. I looked at other options such as Sony Reader and Kobo. Nook is a great choice if you want to use this book reader in US as it offers some good freebies but if you want to use Nook in India and do not have a US credit card then it is a pain. Barnes and Nobles online bookshop does not allow you to buy books using Indian crdit cards! I bought it despite knowing this fact as I was not relying on doing a lot of online shopping from Barnes and Nobles. I just wanted to transfer my collection of ebooks which I can transfer to Nook and read.

http://pagead2.googlesyndication.com/pagead/show_ads.js

Recently I got my hands on a friends’ Infibeam Pi2  and this seems to be the best ebook reader for Indian market. It has more features than Nook and uses the same e-ink technology; the best thing you can buy books from Infibeam bookstore at Indian bookprices (lower than what you pay at Amazon or B&N). The new version has touch screen, so for those pampered by the touch screens of their smartphones and iPads it does gives you a better experience than any Nook or Kindle.