Wednesday, October 29, 2014

Just created this on Google Sheets for my team member to "see" and play-with, for visualizing & planning her future cash flow.

https://docs.google.com/spreadsheets/d/13lkpnpvDajVJ__b62aZSMcHP4MD8bxMTZbOYH6_32bQ/edit?usp=sharing

Thus - thought it'd be useful to others too.
Please note:
1. Please make a copy to your own Google sheets in order to edit at your own private pleasure.
U won't be able to edit the version i shared.
To make a copy: File >> Make a copy

2. EPF variables - specifically tailored to Malaysia
If U do not have any such items (it's like 401K, CPF, etc), just zero-rise the variables.

3. Goals 2 to 7:
If U do not have them, zero-rise them.

4. Does NOT calculate taxes on investment or trading returns.
Please factor taxes in to get the net returns pa % expected.

5. Focus on Column D, Row 14 onwards - this is the cash-related investments that will be funding your retirement and goals.
If the row's cell is NOT red, U should be ok.
Red = no more investments to fund anything from that year/row onwards

6. Anything else?
drop me a line here and i'll see if i can incorporate the idea OR clarify usage of existing.

https://docs.google.com/spreadsheets/d/13lkpnpvDajVJ__b62aZSMcHP4MD8bxMTZbOYH6_32bQ/edit?usp=sharing

No comments:

Post a Comment