QUOTE(wongmunkeong @ Apr 24 2012, 12:01 PM)
Koniciwa fellow forumers.
Since most of the postings here are in the vein of:
1. How am i doing (savings vs expenses based on net income)?
2. Will i have enough in X years time for a $YYYK home/car/imported spouse
/etc.?
3. How much death insurance should i have?
4. How much will my EPF be?
5. How much will my mortgage be if the loan is $xxxK, interest is y%pa and term zz years?
6. What is my Asset Allocation and Net Worth based on.....?
"To help those who help themselves", attached is the "cleaned up" (another version) of my older ZIP postings with a bunch of Excel files.
Instructions:
a. Please install Excel's Analysis Toolpak (google it or search about it here or Fund Management topic please if you're unsure how to install)
b. For Excel beginners: Play with the variables in YELLOW cells - i worry about U fiddling with formulas, thus, yellow cells are non-formulas
c. For Excel intermediate/advance: Go ahead and play with all cells
Hope these help and as usual - USE AT YOUR OWN RISK.
These are just simulations and calculations not gospel truths and, in addition, i'm only human, prone to make mistakes
Bro, got no idea why I can't download the spreadsheet that you are sharing over here. No idea why it can't be opened. Since most of the postings here are in the vein of:
1. How am i doing (savings vs expenses based on net income)?
2. Will i have enough in X years time for a $YYYK home/car/imported spouse
3. How much death insurance should i have?
4. How much will my EPF be?
5. How much will my mortgage be if the loan is $xxxK, interest is y%pa and term zz years?
6. What is my Asset Allocation and Net Worth based on.....?
"To help those who help themselves", attached is the "cleaned up" (another version) of my older ZIP postings with a bunch of Excel files.
Instructions:
a. Please install Excel's Analysis Toolpak (google it or search about it here or Fund Management topic please if you're unsure how to install)
b. For Excel beginners: Play with the variables in YELLOW cells - i worry about U fiddling with formulas, thus, yellow cells are non-formulas
c. For Excel intermediate/advance: Go ahead and play with all cells
Hope these help and as usual - USE AT YOUR OWN RISK.
These are just simulations and calculations not gospel truths and, in addition, i'm only human, prone to make mistakes
May 2 2012, 12:44 PM

Quote
0.0192sec
0.77
6 queries
GZIP Disabled