Welcome Guest ( Log In | Register )

Outline · [ Standard ] · Linear+

 Personal Financial Management V3, It's all about managing your $$$

views
     
SUSic no 851025071234
post Aug 4 2016, 08:45 AM

Regular
******
Senior Member
1,231 posts

Joined: Mar 2015
QUOTE(wongmunkeong @ Jul 31 2016, 05:35 PM)
Excel worksheets & visualization for Standard Mortgage VS Flexi Mortgage - if all else being equal

Since an old friend of mine poked me on this and she couldn't visualize it until we went DAY BY DAY interest accumulation in the mortgage account - i created these worksheets, thus thought it would also be useful for fellow forumers to use.

Note - the worksheet protection is for newbies only
If U are an Excel wielder & want to change the Flexi or Normal rate higher/lower and other stuff, just unprotect the relevant worksheet - NO PASSWORD tongue.gif
*
Hi mr Wong , I dont understand your excel sheet. Do you mean we should put our savings in mortgage loan for best return?

Currently I am able to save rm1k per month and I'm putting in fd. My target is to clear my house loan in 10 yrs with the extra savings. Do you have any advice where I should park the money? I am looking for stable return instead of high risk high gain as my purpose is for loan clearance. I'm not sure if my loan is flexi or standard as it did not state in the loan agreement. I think is standard. But according to your excel it doesn't matter?
SUSic no 851025071234
post Aug 4 2016, 10:01 AM

Regular
******
Senior Member
1,231 posts

Joined: Mar 2015
QUOTE(wongmunkeong @ Aug 4 2016, 09:56 AM)
A. The Excel
er.. boss, the Excel sheet i shared is for people:
1. who knows about traditional VS flexi mortgage
2. wants to have concrete numbers to know pros/cons in quantifiable terms

thus, for your case - i don't think that Excel is for U
B. Clearing your housing loan with extra savings/parking $.
1. If U are totally risk adverse - stick with FD
Perhaps have at least 6 months to 12 months of emergency funds stashed in FD
Then the rest just knockdown your mortgage's capital (ie make sure your financier knows those extra payment are for capital repayment).
NOTE - best to check your contract / with your financier if there are any specific processes / extra costs involved - some can be really convoluted.

2. If U are an investor, after building your emergency funds, do your asset allocations & plan out your investments & execute, track, adjust - simple, not easy
*
Ok thanks. I'm not investor. The most I have is UT and some gold account. Any low risk investment to recommend?
SUSic no 851025071234
post Aug 4 2016, 11:03 AM

Regular
******
Senior Member
1,231 posts

Joined: Mar 2015
QUOTE(wongmunkeong @ Aug 4 2016, 10:32 AM)
heheh - serious ka?
U are totally risk adverse AND U have a GIA (gold investment account)?  sweat.gif
to me, that is risky - straight away lose 4% and HOPE gold prices go up + gold a/c doesn't generate any dividends/rental + can't be used like a house/land

different stroke for different folks i guess - even categorizing "risky"
*
No the gold I have is very little only. I invest few yes back and have cash out some remaining the min balance. It is not very good investment I know. Also is in uob so spread not that wide.

Is there any investment have more than 4% profit? Otherwise just put fd hehe
SUSic no 851025071234
post Aug 4 2016, 12:08 PM

Regular
******
Senior Member
1,231 posts

Joined: Mar 2015
QUOTE(wongmunkeong @ Aug 4 2016, 11:23 AM)
if i was totally risk adverse (vs current risk managed), yup FD lor
AND
max FD in 1 bank <=$250K due to PIDM insurance coverage
http://www.pidm.gov.my/For-Public/About-De...urance/Coverage
eg
if i have $550K & no morgage, i'd put:
a. 200K in MBB FD
b. 200K in PB FD
c. 150K in OCBC FD

even if multiple accounts in same bank entity, coverage is only up to $250K
*
What about unit trust? Will it give better return? I mean my investment is for 10 years so should something better than fd right?
SUSic no 851025071234
post Aug 4 2016, 10:08 PM

Regular
******
Senior Member
1,231 posts

Joined: Mar 2015
QUOTE(Ramjade @ Aug 4 2016, 09:52 PM)
There is. EPF and amanah saham fixed price. EPF cannot touch the money. Amanah saham need to camp at bank, try luck. Sometimes empty handed. So the choice is yours. tongue.gif
Epic sentence.thumbup.gif
*
I have put about 20 k in amanah saham gemilang. Is it good investment for 10 years compare fd?
SUSic no 851025071234
post Aug 5 2016, 08:16 AM

Regular
******
Senior Member
1,231 posts

Joined: Mar 2015
QUOTE(Ramjade @ Aug 4 2016, 10:16 PM)
Amanah saham gemilang can get worse result than FD. I am not talking about that. Therr are better options available on FSM which can outperform ASG. You want >4% right? Only the following amanah saham sure will give you >4% without fail every year: ASM, ASW2020, AS1M
*
I am not bumi. I see the asg so far every year about 6% return. Not bad right?
SUSic no 851025071234
post Aug 5 2016, 12:31 PM

Regular
******
Senior Member
1,231 posts

Joined: Mar 2015
QUOTE(Ramjade @ Aug 5 2016, 10:10 AM)
ASG is a pure UT. Dividend does not matter in UT. Like I said there are better option than ASG at FSM. Now, if you are talking about the fixed price fund, dividend is important. drool.gif
You don't need to be a bumi to buy the 3 fund I mention ASW2020, ASM, AS1M. I can assure you that those 3 funds give better returns than any FD. I am not a bumi too.
*
Is it can buy anytime or need wait opening?

QUOTE(cybermaster98 @ Aug 5 2016, 11:20 AM)
Got. FX United and JJ.  biggrin.gif
*
What is that? Never hear before.
SUSic no 851025071234
post Jan 13 2017, 07:48 PM

Regular
******
Senior Member
1,231 posts

Joined: Mar 2015
Anyone calculate before how much need to save to retire?
SUSic no 851025071234
post Jan 13 2017, 10:14 PM

Regular
******
Senior Member
1,231 posts

Joined: Mar 2015
QUOTE(T231H @ Jan 13 2017, 09:30 PM)
while waiting for responses, you may try read this...
Retirement Planning: Calculate How Much You Need in 5 Simple Steps
https://www.imoney.my/articles/retirement-planning

or more in google
https://www.google.com/?gws_rd=ssl#q=how+mu...ire+in+malaysia
*
Thnx. Cos I calculate I will have roughly 1 mil when retire not sure if enough and what is equivalent to today value
SUSic no 851025071234
post Jan 13 2017, 10:19 PM

Regular
******
Senior Member
1,231 posts

Joined: Mar 2015
QUOTE(T231H @ Jan 13 2017, 09:30 PM)
while waiting for responses, you may try read this...
Retirement Planning: Calculate How Much You Need in 5 Simple Steps
https://www.imoney.my/articles/retirement-planning

or more in google
https://www.google.com/?gws_rd=ssl#q=how+mu...ire+in+malaysia
*
QUOTE(ic no 851025071234 @ Jan 13 2017, 10:14 PM)
Thnx. Cos I calculate I will have roughly 1 mil when retire not sure if enough and what is equivalent to today value
*
From the imoney calculation it says I will have enough. Cool. I'm set for the future.

 

Change to:
| Lo-Fi Version
0.0948sec    0.59    7 queries    GZIP Disabled
Time is now: 9th December 2025 - 04:08 PM