Do your personal finance maths online on Zoho

If you want to manage something, you must be able to measure it. In other words, if you can't measure it, you really can't manage it well.

Your personal finances also falls within the above concept. How do you know whether you are doing well with your personal finances or not?

So there are tools and calculators available which can help you with a self analysis and provide a road map for your finance decisions.

The following spreadsheets which I have done on Zoho , which has a suite of online web applications offering easy collaboration.

• Monthly Budgeting Worksheet
• Financial Freedom Calculator
• Networth Template
• Benefit of starting early

Zoho is really amazing and I found this excerpt about them:

This is the only real “little guy” on the list. I’ve written about the fact that Zoho already has an online office suite that is better than anything from Microsoft or Google. While the product is really good, what has been equally important for Zoho is that it has proven that it knows how to execute. Microsoft got to where it is today because it was faster and more effective at executing than any of its competitors

The advantage of these sheets is that while you can toggle with your own case figures in the sheet online and they will return with the figures for your case in a jiffy. And you can also download them for free if you really like them! We'll be happier if you spread the word to your friends.

Power and Magic of Compounding

Simple maths tell us more about the power of starting early and investing regularly rather than any rants. Check out this simple calculator by Hugh where he gives an option to compare two savings/investing options.

Case 1: You start now with a yearly investment of Rs 1000 and stay invested for 40 years.

Case 2: You start after 20 years from now but invest Rs 2000 instead for 20 years.

In both the case, the amount invested is Rs 40,000. Assuming a common growth rate of 10% in both the cases, in case 1 , the accrued balance works out to Rs 442,593 . The accrued balance in case 2 is Rs 114,550.

Why don't you work it yourself and take away your learnings.

Do It Yourself Tools for Personal Finance

Personal Finance is a thing which we keep on postponing. I’m already feeling like a poet out catching people to hear my poem. And being a person who hardly understands poems, I can understand the yawning souynds people make when I try to tell about personal finance.

I’m persistent. But this time I’ll not rant on any theory and give you a download option where you can do all your personal finance yourself.
So you are about to make a poem yourself. :)

The worksheet has the following sheets. Download it here.
1. Networth
2. Budgeting
3. Planning for Child's education
4. Advantage of starting early
5. Tax Calculator
6. Retirement Planning
7. Mutual Fund Portfolio
8. Insurance details
9. Other Portfolio
10. When you will be a crorepati
11. Calendar2007

.

.

Reviews, Tips, Calculators with an Indian perspective.

Simple Calculators for Simplifying your Finances

Look at some tools and calculators for your personal finance decisions

1. Worksheets


2. Retirement Benefit Planner


3. MF Portfolio


4. Excel Sheets


5. Magic of compounding

I'll come back with more!

Reviews, Tips, Calculators with an Indian perspective.

Carnival of Personal Finance

2Million hosted the 87th edition of the carnival of personal finance and my post was featured on it. My post lets you download ten excel sheets where you can budget, plan and control your finances. The carnival itself is a rich source of information on Personal Finance.

Btw, I forgot linking back on another Carnival I participated some time back. I'm sorry, Cecilia Green, who has the carnival hosted here

Go, take a look. And yes, I'm hosting a carnival on Money and Finance. Waiting to see your posts.


Reviews, Tips, Calculators with an Indian perspective.

WorkSheets on Budgeting, Planning and Control

I'm amazed at myself. My 200th post and it's hardly four months since I've fallen(err..or risen to) for this blog thing!!

I have been writing a lot of theory(crap;?) on going about your financial decisions. Sounds fine but how do you actually do it? Have been working a while on some worksheets and here is the result of my efforts. Download this Worksheet on Excel

The entire worksheet has eleven spreadsheets and they are:

1. Networth Statement: Start with calculating your Networth. The sheet also gives you an idea of the weightage of each asset and liability.

2. Budgeting: The sheet gives you an idea of planning your expenses vis a vis your income. The idea is that when you start measuring it, you can manage or control it and then improve upon.

3. Children Education Planner: Gives you an idea of what amount you need to invest and for how long so that the desired level of money is available for your children.

4. Starting Early: The worksheet compares between two scenarios where in one you start early and in the other where you start late. See the difference.

5. Tax Calculator: You can enter your monthly income and the total tax can be seen. Well this is according to Indian Tax laws. If any of you want the template for the Tax returns, do let me know.

6. Retirement Planner: This sheet will help you in arriving at the amount to be invested monthly for desired retirement pool. Toggle around with the figures.

7,8,9. Gives you a sheet where you can enter your Mutual Funds portfolio, Insurance and Other Investments.

10. Crorepati?: It calculates the Future Value of your investments and tells you when will you be able to become a crorepati!!

11. Calendar 2007 : A desktop and soft copy of Caledar on Excel.

I'm proud of my effort. But this should not stop you from telling me what improvements I can make. Infact that will be hugely appreciated. I'm also looking for somebody who can make it better. Also guys who can convert this into some other platform like odp or anything better.


Reviews, Tips, Calculators, Sensex, Insurance, Real Estate, Mutual Funds with an Indian perspective.

Advantage of Starting Early

I spent an hour working in calculating the future values of my investments and worked on MS Excel for that. I found out the "Power of Compounding" and the benefit of "Starting Early".

If I started at age 20 and invested Rs 2000 every month (Rs 24000 annually), my corpus at age 55 would have amounted to Rs 65 lacs. With similar amount and rate of return, if I started at 40, the corpus would be a miserly Rs 7.62 lacs. I invest less by Rs 4.80 lacs and the corpus difference is Rs 57.42 lacs (1196%)!

To match the returns I would have to invest more. How much? Instead of Rs 24000 every year, I will have to invest Rs 205000!! Rs 1.80 lacs more!

Confounded? Want to see the calculations. Download it here You can toggle around with the age, rate of return, retirement age and the amount to be invested. The parts highlighted by blue color are formulas and should not be changed. As you can see, it is nothing of a rocket science. Simple functions on Excel help you in this analysis.

Any questions, Ask!