Welcome Guest ( Log In | Register )

Bump Topic Topic Closed RSS Feed
151 Pages « < 64 65 66 67 68 > » Bottom

Outline · [ Standard ] · Linear+

 Personal financial management, V2

views
     
HughieRmX
post May 2 2012, 12:44 PM

::.. ♬|♪ HaRdC0Re TrAnCE AddiCT ♬|♪..::
*******
Senior Member
3,394 posts

Joined: Jan 2003
From: Kuala Lumpur



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 tongue.gif/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  sweat.gif
c. For Excel intermediate/advance: Go ahead and play with all cells biggrin.gif

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  notworthy.gif
*
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. sweat.gif
wongmunkeong
post May 2 2012, 12:54 PM

Barista FIRE
Group Icon
Elite
5,608 posts

Joined: May 2011
From: Here, There, Everywhere


QUOTE(HughieRmX @ May 2 2012, 12:44 PM)
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. sweat.gif
*
a. er.. U can't download
OR
b. U downloaded to yr PC
but U can't open / unzip the ZIP file to a folder
OR
c. U downloaded to yr PC
U can open / unzip the ZIP file to a folder
but U can't open the Excel file?

Better PM me since other forumers seem to be able to download and open with no issue.


Added on May 2, 2012, 12:55 pm
QUOTE(NoTea @ May 2 2012, 12:17 AM)
hey wongmunkeong
just wanted to say thank you for the revamped excel files
these are very helpful with my numbers
biggrin.gif biggrin.gif biggrin.gif
*
You're welcome NoTea - glad to be of help.
Any ideas for improvement and feedback on bugs (if any) is welcome notworthy.gif

This post has been edited by wongmunkeong: May 2 2012, 12:55 PM
va1kyr13
post May 2 2012, 01:01 PM

New Member
*
Junior Member
18 posts

Joined: Dec 2011
Just want an opinion from you guyz up here.

If we invest in land, did you think it worth it?
i not meant by a condo/property or whatsover.
I meant a RAW land that are reserve for the future development.
What do you think?

HughieRmX
post May 2 2012, 01:31 PM

::.. ♬|♪ HaRdC0Re TrAnCE AddiCT ♬|♪..::
*******
Senior Member
3,394 posts

Joined: Jan 2003
From: Kuala Lumpur



QUOTE(wongmunkeong @ May 2 2012, 12:54 PM)
a. er.. U can't download
OR
b. U downloaded to yr PC
  but U can't  open / unzip the ZIP file to a folder
OR
c. U downloaded to yr PC
U can open / unzip the ZIP file to a folder
  but U can't open the Excel file?

Better PM me since other forumers seem to be able to download and open with no issue.


Added on May 2, 2012, 12:55 pm
You're welcome NoTea - glad to be of help.
Any ideas for improvement and feedback on bugs (if any) is welcome  notworthy.gif
*
Got it .. I will PM you in a short while .. biggrin.gif
loanneeded
post May 3 2012, 12:51 PM

Getting Started
**
Junior Member
78 posts

Joined: Mar 2010
hi guys, i'm not sure whether this is the right place to ask. but i think it's about money management too.

basically, i'm going to be sent to work in china by my current company. So, i want to ask how and where should i declare my income TAX? i'm wondering should i ask my company to pay me in RMB or RM. whichever that can enable me to pay less tax sad.gif

i heard that if i'm going to work oversea, i would consider expat and need to pay 26% flat rate! sad.gif is that true?

it's welcome too if anyone can advise me about China income tax rate. i've searched google and come back with many different result.
SUSfuzzy
post May 3 2012, 02:42 PM

*pew pew pew*
*******
Senior Member
7,106 posts

Joined: Jan 2003


QUOTE(loanneeded @ May 3 2012, 12:51 PM)
hi guys, i'm not sure whether this is the right place to ask. but i think it's about money management too.

basically, i'm going to be sent to work in china by my current company. So, i want to ask how and where should i declare my income TAX? i'm wondering should i ask my company to pay me in RMB or RM. whichever that can enable me to pay less tax sad.gif

i heard that if i'm going to work oversea, i would consider expat and need to pay 26% flat rate! sad.gif is that true?

it's welcome too if anyone can advise me about China income tax rate. i've searched google and come back with many different result.
*
Normally it depends on which end are you getting paid, so if the 'earning' is in China, you will be taxed in China and vice versa. Honestly, this issue should be taken up and handled by your company rather than individual.
johniewalkers
post May 3 2012, 03:52 PM

New Member
*
Newbie
1 posts

Joined: May 2012
i think we should have a good business plan, and there is, certainly want the plan to reflect purpose and use it to actually run your business. Still we often don't have a clue how. That's where educating yourself comes in. Take time to understand how to do the math, read market analysis and adopt good business strategies that work. It helps to study business plans that have actually been used to start successful businesses.
avengers88
post May 5 2012, 09:10 PM

Whatever man
******
Senior Member
1,615 posts

Joined: May 2005



Hey guys, just want to enquire. If I have about RM1k to spare after all deductions per month, what should I do with the cash? I am pretty new in investment and all. Current savings that I have is RM10k. Should I start putting money into FD or is there a better to to ensure that my monthly expenses does not cross the line. Please know that I do not have any medical card or insurance and I dun think the time is there to get it yet. I am currently 24 and just started working.
wongmunkeong
post May 5 2012, 09:49 PM

Barista FIRE
Group Icon
Elite
5,608 posts

Joined: May 2011
From: Here, There, Everywhere


QUOTE(avengers88 @ May 5 2012, 09:10 PM)
Hey guys, just want to enquire. If I have about RM1k to spare after all deductions per month, what should I do with the cash? I am pretty new in investment and all. Current savings that I have is RM10k. Should I start putting money into FD or is there a better to to ensure that my monthly expenses does not cross the line. Please know that I do not have any medical card or insurance and I dun think the time is there to get it yet. I am currently 24 and just started working.
*
Hi Avengers88,

Just started working? Welcome to slog-athon land biggrin.gif
Jokes aside, just to bounce some ideas with U yar for your $1K spare pm:
1. Life insurance with 36 critical illness and disability coverage
U may want to consider this IF:
a. U've loved ones economically dependent on U
b. U want to try and save your life if diagnosed with any of the 36 critical illness (choy choy but...)
c. U need to be able to fend for yourself should disability happen (choy choy again but...)

2. Hospitalization insurance
U may want to consider this IF:
a. Your employer doesn't cover at least $30Kpa hospitalization
b. Your parents, family or U can't cough-up at least $30K hospitalization if U are hospitalized (choy...)
These days, even a simple / minor operation cost about $10K+/- in total.
If it's something more involved, then it starts ratcheting up.

3. Emergency buffer fund
Do U have at least 3 months' average expenses set aside in FD, savings, etc (easy to get to and easy to liquidate/is liquid)?
Before investing in anything, best to have some $ put aside for emergencies coz once invested, costs and market timing comes into play
eg. U invest $1K but in reality U get only $990+ "value" of stocks/bonds/unit trusts/etc. coz of service charges/commissions/brokerage/stamp duties/etc.
Thus, U lose straight off the bat.
Next, if U were FORCED to liquidate your investment prematurely coz U need the $ to cover some emergencies AND the market is bad... double-whammy

Once the above are covered, then only start thinking about investments.
If U noticed, all of the above is about risk management and risk transference. If one can't even "see" these risks, imagine how well one would do in the risky investment world sweat.gif.
Use the time to learn about investments while the above are being covered.

Just a thought yar - no right/wrong notworthy.gif
avengers88
post May 5 2012, 10:01 PM

Whatever man
******
Senior Member
1,615 posts

Joined: May 2005



Yes bro, I currently have 10k saved up ( which is my emergency fund I guess ) in my savings account. So my question is :

1) Should I put the 10k into FD ? Or ASN ?

2) I will be saving 1k per month, do i add the 1k to FD account ?


wongmunkeong
post May 5 2012, 10:26 PM

Barista FIRE
Group Icon
Elite
5,608 posts

Joined: May 2011
From: Here, There, Everywhere


QUOTE(avengers88 @ May 5 2012, 10:01 PM)
Yes bro, I currently have 10k saved up ( which is my emergency fund I guess ) in my savings account. So my question is :

1) Should I put the 10k into FD ? Or ASN ?

2) I will be saving 1k per month, do i add the 1k to FD account ?
*
doh.gif my bad.
Only the "$1K per month" registered in my brains hehe - what to do, multi-tasking on Johnny English 2 and Internet laugh.gif

In my humble opinion:
1) Should I put the 10k into FD ? Or ASN ?
Assuming you do not have a flexi-mortgage account:
a. Put aside about 1 to 2 months' average expenses in savings account - the fastest and easiest access for emergencies
b. The rest, split them into a staggered / laddered FD + ASN/bond fund
Personally, i've my emergency buffer stored thus:
3+/- months' average expenses in my flexi mortgage account (as flexi as savings a/c + better than FD rates)
9+/- months' average expenses in bond funds (i'm way too lazy to queue up to buy ASN tongue.gif)

2) I will be saving 1k per month, do i add the 1k to FD account ?
Ah.. for this, i'd suggest thinking about the Qs i posted earlier, the first 2 Qs on insurances - to manage or transfer risks.
IF these are "cow tim" already, then i'd suggest:
a. Plonk your $1K into FD account or ASN (assuming the ASN U are getting into are "fixed price" ie. doesn't move from $1)
b. WHILE
+ learning about types of investment vehicles, asset allocation and asset classes, methods (eg. value investing, dollar cost averaging, value cost averaging, etc.)
+ drawing up your investment plans (what and how much to invest in, how/when/why to invest, how/when/why to divest, etc.)
c. then execute

Just a thought notworthy.gif

This post has been edited by wongmunkeong: May 5 2012, 10:26 PM
avengers88
post May 5 2012, 10:43 PM

Whatever man
******
Senior Member
1,615 posts

Joined: May 2005



Bro, I dun understand what is the flexi mortgage account for. Mind explaining on it? Does every bank provide this flexi mortgage account? Because my main bank currently is Maybank.
wongmunkeong
post May 5 2012, 10:53 PM

Barista FIRE
Group Icon
Elite
5,608 posts

Joined: May 2011
From: Here, There, Everywhere


QUOTE(avengers88 @ May 5 2012, 10:43 PM)
Bro, I dun understand what is the flexi mortgage account for. Mind explaining on it? Does every bank provide this flexi mortgage account? Because my main bank currently is Maybank.
*
Flexi mortgage is a type of mortgage.
er.. please don't ask me to explain what a mortgage yar tongue.gif

Copied & re-posted from previous - google/search functions are your friend, leverage on them
...instead of plonking my cash in any savings or FDs, better to plonk into my Flexi Mortgage as my mortgage is 4.4%pa daily rest - ie. whatever amount of extra $ i have placed in my Flexi Mortgage is considered capital repayment, thus i dont get charged 4.4%pa for that additional capital repaid amount, thus in effect "saving me" 4.4%pa. No FD gives me that % and also flexibility to take out (re-draw).

....Flexi mortgages - U can knock down the principal amount any time/any amount AND re-draw the extra payments any time / any amount via cheques/ATM/online.
When U pay extra / knock down the principal amount, say $100K, U dont pay interest on that $100K UNTIL U re-draw it
eg (simple example only, not spot-on actual mathematically same with banks).
On top of the monthly payment, i plonk in $50K additional on Jan 1
Then later, I took out $20K to buy stocks on Jan 31
a. My mortgage interest calculated from Jan 2 to Jan 30th would be less $50K *x.xx%/364.25 days (mortgage interest charged) *28 days
b. From Jan31 onwards, my mortgage interest calculated would be additional $20K *x.xx%/364.25 days (mortgage interest charged) *xx days

This post has been edited by wongmunkeong: May 5 2012, 10:53 PM
avengers88
post May 5 2012, 11:56 PM

Whatever man
******
Senior Member
1,615 posts

Joined: May 2005



Does flexi mortgage means that I need to have a property ?
Does that mean that I am applying a loan ?
wongmunkeong
post May 6 2012, 08:27 AM

Barista FIRE
Group Icon
Elite
5,608 posts

Joined: May 2011
From: Here, There, Everywhere


QUOTE(avengers88 @ May 5 2012, 11:56 PM)
Does flexi mortgage means that I need to have a property ?
Does that mean that I am applying a loan ?
*
Yes to both Qs, it is a mortgage.
avengers88
post May 6 2012, 08:38 AM

Whatever man
******
Senior Member
1,615 posts

Joined: May 2005



Alright thanks bro I understand now. Too bad I dun own any property, think I cant use that LOL!
wongmunkeong
post May 6 2012, 08:42 AM

Barista FIRE
Group Icon
Elite
5,608 posts

Joined: May 2011
From: Here, There, Everywhere


QUOTE(avengers88 @ May 6 2012, 08:38 AM)
Alright thanks bro I understand now. Too bad I dun own any property, think I cant use that LOL!
*
No probs mar - knowing your options, now and future, is a way to win with higher probability biggrin.gif
techie.opinion
post May 6 2012, 01:44 PM

On my way
****
Senior Member
661 posts

Joined: Feb 2007
QUOTE(wongmunkeong @ May 5 2012, 10:53 PM)
Flexi mortgage is a type of mortgage.
er.. please don't ask me to explain what a mortgage yar  tongue.gif

Copied & re-posted from previous - google/search functions are your friend, leverage on them
...instead of plonking my cash in any savings or FDs, better to plonk into my Flexi Mortgage as my mortgage is 4.4%pa daily rest - ie. whatever amount of extra $ i have placed in my Flexi Mortgage is considered capital repayment, thus i dont get charged 4.4%pa for that additional capital repaid amount, thus in effect "saving me" 4.4%pa. No FD gives me that % and also flexibility to take out (re-draw).

....Flexi mortgages - U can knock down the principal amount any time/any amount AND re-draw the extra payments any time / any amount via cheques/ATM/online.
When U pay extra / knock down the principal amount, say $100K, U dont pay interest on that $100K UNTIL U re-draw it
eg (simple example only, not spot-on actual mathematically same with banks).
On top of the monthly payment, i plonk in $50K additional on Jan 1
Then later, I took out $20K to buy stocks on Jan 31
a. My mortgage interest calculated from Jan 2 to Jan 30th would be less $50K *x.xx%/364.25 days (mortgage interest charged) *28 days
b. From Jan31 onwards, my mortgage interest calculated would be additional $20K *x.xx%/364.25 days (mortgage interest charged) *xx days
*
Bro... The action taken is great, what if you have other option where the extra money you paid to flexi housing loan... able to generate more profits than the amount of interest cut?
wongmunkeong
post May 6 2012, 02:16 PM

Barista FIRE
Group Icon
Elite
5,608 posts

Joined: May 2011
From: Here, There, Everywhere


QUOTE(techie.opinion @ May 6 2012, 01:44 PM)
Bro... The action taken is great, what if you have other option where the extra money you paid to flexi housing loan... able to generate more profits than the amount of interest cut?
*
That is of course your personal choice bro.
I plonk in "unused" extras and stuff into my flexi mortgage while accumulating / awaiting usage OR when no opportunities as yet.
Please do read the entire ding-dong with Avengers88 - he's asking about where to plonk his emergency buffer and stuff.
Malformed
post May 8 2012, 09:56 AM

Getting Started
**
Junior Member
270 posts

Joined: Jan 2012
Think I might need some help to budget my coming months due to new hobby rclxub.gif

This post has been edited by Malformed: May 8 2012, 09:56 AM

151 Pages « < 64 65 66 67 68 > » Top
Topic ClosedOptions
 

Change to:
| Lo-Fi Version
0.0192sec    0.77    6 queries    GZIP Disabled
Time is now: 8th December 2025 - 09:02 PM