The personal fincance calculator has several userful sheets like
- Finance calculators for PPF, EMIs and general returns
- Income Tax Calculators for personal use
- Expense Tracking sheets
- Retirement calcuators
How to use the sheet
- The PPF calculator is for the “Public Provident Fund” scheme of the Indian Government. You contribute every year for 15 years and get reasonably good rates (Better than FDs at least) for the money. The interest is also tax free (till 2022 at least). So you can enter how much you plan to save each year and because the interest keeps changing each year you have to enter it in the yellow cell for each year or just use something appox.
- The EMI calculators come in 2 flavors, enter loan amount and the years to repay with interest and get EMI or enter what EMI you can pay with years and interest to get what loan you are bound to get.
- To evaluate any investment the “Common Returns” calculator is useful. Just enter annual amount, interest and years and it will show how much you can get by the end. Useful to quickly check any investment including FDs, Stock or anything else for that matter.
- The “Future value” is like Inflation calculator. So if you want to find how much your costs will become in future, you can check here by giving the current cost, inflation rate and years to find what it will become later. Useful for things like checking future college fees for your kids 🙂
- Making a crore is just a fun way to check how long and how much in each investment will take you to a Crore. Your age helps the tool to try and distribute the risks accordingly.
- Retirement Calculatore is to estimate your total amount needed with current annual spending as input. The multiplier is to choose a degree of confidence. Like 25x is what is accepted as minimum required. 35x is more of an ideal figure and if you very worried that even 50x will not keep you at peace 🙂
- The expenses sheet is to just have a plan for your monthly salary and to quickly check if there are pending payments. There is also an annual section to track various random expenses that happens over the year and to ensure if you pay them on time and to plan for it. There is a section for monthly investments which tells you how much your savings rate or investment percentage is.
- The income tax calculator may be a bit tricky if you have never actually paid attention to your salary slip and taxes but try it. Take you salary slip and try to map things such that the net salary matches for a month. You can change the sections like DA, HRA or ESPP to match your own salary slip headings. This is just a rough guidance. Please don’t blame me for not paying taxes 🙂
- The last sheet is probably the most impactful as it shows how long you have got to work because of your current money habits. If your savings rate (from the expenses sheet in case you are using that) is less, you have to work several more years to attain a state of point where you don’t have to work for money (You can retire if you want to). For example if you save half your salary, then you probably just need to work 15 years on an average. Again this is very rough guidance and does not consider every eventuality.
Please note, this is a shared google sheet that you should make a copy of and use. It is made and shared as a fun guidance project. If you end up not paying taxes or not accumulating enough due to any bug in this sheet don’t blame me. You have been warned. With very little effort you can even edit it to match your needs perfectly. Feel free to use / share with anyone. It it totally free and devoid of any copyrights.