Sunday, February 14, 2016

R2I Budget Spreadsheet ...

In the previous blog entry, I mentioned about doing a budget when you are evaluating R2I to see how much funds you have, how much you will earn over the years and save, how much you will need over the years. 

If you are planning to return after doing few years of R2I, it is critical that you need this evaluation to see whether you will have enough $$ when you return overseas again. Without doing this exercise, you might get caught off guard only to realize that you don't have enough funds to get back - staying in a country like US can be expensive unless you have enough funds to support you.

Following is a spreadsheet that I am providing as a sample for you do such calculation. Please try and provide any feedback to improve this sheet for others.

https://docs.google.com/spreadsheets/d/1qGAhSa8VcetBa9I3cH9b-_9vvubMTr1mH30-nWHueIc/edit?usp=sharing

First sheet tracks US funds in $
Second sheet tracks India funds in Rs.
Third sheet tracks any real estate investment you have, in Rs.
Fourth sheet shows your overall long term/short term positions.

Fifth sheet is the key sheet - which calculates your needs over years + earnings. You will have total needs at a certain point of time using this method.