QUOTE(kuhfayLover @ Jul 11 2011, 10:46 PM)
40 years.. i will prefer drag the longest.. then if got $$ then put more inside since its semi flexi loanduwan 30 years then every month have to pay alot.. end up kenot pay.. kena penalty~
Sutera Maya, New project, J.Puchong/OKR
|
|
Jul 11 2011, 10:57 PM
|
![]() ![]() ![]() ![]() ![]() ![]()
Senior Member
1,380 posts Joined: May 2009 From: Petaling Jaya |
|
|
|
|
|
|
Jul 11 2011, 11:00 PM
|
![]() ![]() ![]() ![]() ![]() ![]() ![]()
Senior Member
4,790 posts Joined: Dec 2008 |
|
|
|
Jul 11 2011, 11:05 PM
|
![]() ![]() ![]()
Junior Member
381 posts Joined: May 2011 |
QUOTE(CKHong @ Jul 11 2011, 10:57 PM) 40 years.. i will prefer drag the longest.. then if got $$ then put more inside since its semi flexi loan pbb allow 40 yrs? duwan 30 years then every month have to pay alot.. end up kenot pay.. kena penalty~ Yes, who knows kena lottery, then can settle this loan and get 2nd property tomorrow. |
|
|
Jul 11 2011, 11:50 PM
|
![]() ![]() ![]() ![]() ![]() ![]()
Senior Member
1,285 posts Joined: Sep 2009 |
QUOTE(kuhfayLover @ Jul 11 2011, 10:46 PM) WAU!! Thanks joeekh! 1. yes..the formula will calculate ur monthly repayment for the whole tenure of your loanNo worries, i like maths! Still, i have questions: 1) PMT(interestrate/12,loantenure*12,loanamt,0,0) => so this formula actually already cater for recalculate based on outstanding balance ar? 2) I have a clearer picture now after seeing ur attachment, so good of u! But, i thought the interest is already include in RM1956.07, why do we still need to pay the extra daily interest(in ur example, column F) ? meaning u need to pay rm1956.07 every month for the whole of 30 years loan (max)...unless ur flexi loan savings kick in n reduce the interest.. 2. column f calculate ur daily interest rate..at end of 1st month, ur monthly interest is rm1400++, but u paying rm1956.07 that mean rm1400++ goes to pay interest and remaining rm500 goes pay ur principal (rm400k)... if u wan to have the excel sheet, u can pm me ur email if u dont mind de... if u ok, can also gimme ur msn / hp # wahahaha Added on July 11, 2011, 11:51 pm QUOTE(cutealex @ Jul 11 2011, 11:00 PM) the strategy is...maximize ur loan tenure...increase ur cash flow...this u teach me de... This post has been edited by joeekh: Jul 11 2011, 11:51 PM |
|
|
Jul 12 2011, 12:00 AM
|
![]() ![]() ![]()
Junior Member
381 posts Joined: May 2011 |
QUOTE(joeekh @ Jul 11 2011, 11:50 PM) 1. yes..the formula will calculate ur monthly repayment for the whole tenure of your loan 2. rm1400++ for interest? rm500 for principal? so much diff? so exp of the interest been charged? meaning u need to pay rm1956.07 every month for the whole of 30 years loan (max)...unless ur flexi loan savings kick in n reduce the interest.. 2. column f calculate ur daily interest rate..at end of 1st month, ur monthly interest is rm1400++, but u paying rm1956.07 that mean rm1400++ goes to pay interest and remaining rm500 goes pay ur principal (rm400k)... if u wan to have the excel sheet, u can pm me ur email if u dont mind de... if u ok, can also gimme ur msn / hp # wahahaha hey boy, u think u gonna explain to me on phone on this complicated maths calculation ar? I will |
|
|
Jul 12 2011, 12:04 AM
|
![]() ![]() ![]() ![]() ![]() ![]()
Senior Member
1,285 posts Joined: Sep 2009 |
QUOTE(kuhfayLover @ Jul 12 2011, 12:00 AM) 2. rm1400++ for interest? rm500 for principal? so much diff? so exp of the interest been charged? yes..during initial stage..u will pay more for interest...less for principal..hey boy, u think u gonna explain to me on phone on this complicated maths calculation ar? I will the longer the time, u will pay lesser for interest...more for principal... in a short..the monthly repayment u pay is same...rm1956.07... but monthly accumulated interest will be lesser.. once u do the math, u will understand... ah girl...me jz finding an excuse to ask for ur hp#... |
|
|
|
|
|
Jul 12 2011, 12:08 AM
|
![]() ![]() ![]()
Junior Member
381 posts Joined: May 2011 |
QUOTE(joeekh @ Jul 12 2011, 12:04 AM) yes..during initial stage..u will pay more for interest...less for principal.. That's sound interesting, will get one portfolio done for myself. the longer the time, u will pay lesser for interest...more for principal... in a short..the monthly repayment u pay is same...rm1956.07... but monthly accumulated interest will be lesser.. once u do the math, u will understand... ah girl...me jz finding an excuse to ask for ur hp#... hey boy, that's need to ask my kids's permission |
|
|
Jul 12 2011, 12:12 AM
|
![]() ![]() ![]() ![]() ![]() ![]()
Senior Member
1,285 posts Joined: Sep 2009 |
|
|
|
Jul 12 2011, 12:16 AM
|
![]() ![]() ![]()
Junior Member
381 posts Joined: May 2011 |
|
|
|
Jul 12 2011, 12:18 AM
|
![]() ![]() ![]() ![]() ![]() ![]()
Senior Member
1,380 posts Joined: May 2009 From: Petaling Jaya |
QUOTE(cutealex @ Jul 11 2011, 11:00 PM) haha.. i won't stick to the loan repayment schedule geh.. once i got extra i will dump in Added on July 12, 2011, 12:19 am QUOTE(kuhfayLover @ Jul 11 2011, 11:05 PM) pbb allow 40 yrs? pbb allow ah.. Yes, who knows kena lottery, then can settle this loan and get 2nd property tomorrow. i fong hei lottery liao i bought so many times satu pun tarak kena This post has been edited by CKHong: Jul 12 2011, 12:19 AM |
|
|
Jul 12 2011, 12:23 AM
|
![]() ![]() ![]() ![]() ![]() ![]()
Senior Member
1,285 posts Joined: Sep 2009 |
QUOTE(kuhfayLover @ Jul 12 2011, 12:16 AM) When ur turn into color wolf like cutealex ar?! oh....Even though i'm not a little girl anymore, still, will frighten me away one. good ah... ppl help u..u say me like that... Added on July 12, 2011, 12:24 am QUOTE(CKHong @ Jul 12 2011, 12:18 AM) pbb allow ah.. pbb no good....then only loan me 90% of discounted price.. This post has been edited by joeekh: Jul 12 2011, 12:24 AM |
|
|
Jul 12 2011, 12:27 AM
|
![]() ![]() ![]()
Junior Member
381 posts Joined: May 2011 |
QUOTE(joeekh @ Jul 12 2011, 12:23 AM) oh.... haha, this no use on me lo. good ah... ppl help u..u say me like that... Anyway, u r a good one, helpful one! Thx a lot. |
|
|
Jul 12 2011, 12:30 AM
|
![]()
Junior Member
12 posts Joined: Jul 2010 |
No roof garden then its like a flat
|
|
|
|
|
|
Jul 12 2011, 12:30 AM
|
![]() ![]() ![]() ![]() ![]() ![]()
Senior Member
1,285 posts Joined: Sep 2009 |
QUOTE(kuhfayLover @ Jul 12 2011, 12:27 AM) hahaha..seriously..pm me if u want the excel sheet... Added on July 12, 2011, 12:31 am QUOTE(miruvaaccessories @ Jul 12 2011, 12:30 AM) nt neccessary de..flat dont have swimmng pool n all the facilities.... This post has been edited by joeekh: Jul 12 2011, 12:31 AM |
|
|
Jul 12 2011, 12:36 AM
|
![]() ![]() ![]() ![]() ![]() ![]()
Senior Member
1,380 posts Joined: May 2009 From: Petaling Jaya |
QUOTE(miruvaaccessories @ Jul 12 2011, 12:30 AM) oh oh.. is it every condo.. will have roof garden ? sorry.. noob here.. doesn't know the definition of condo Added on July 12, 2011, 12:37 am QUOTE(joeekh @ Jul 12 2011, 12:30 AM) hear u say say har.. u correct alsoif no roof garden means flat.. then in malaysia.. alot condo have to change name to flat lur ~ This post has been edited by CKHong: Jul 12 2011, 12:37 AM |
|
|
Jul 12 2011, 12:38 AM
|
![]() ![]() ![]()
Junior Member
381 posts Joined: May 2011 |
QUOTE(joeekh @ Jul 12 2011, 12:30 AM) hahaha.. Thx first, will pm u soon then seriously..pm me if u want the excel sheet... |
|
|
Jul 12 2011, 01:03 AM
|
![]() ![]() ![]() ![]() ![]() ![]()
Senior Member
1,285 posts Joined: Sep 2009 |
QUOTE(CKHong @ Jul 12 2011, 12:36 AM) oh oh.. is it every condo.. will have roof garden ? yalar...sorry.. noob here.. doesn't know the definition of condo Added on July 12, 2011, 12:37 am hear u say say har.. u correct also if no roof garden means flat.. then in malaysia.. alot condo have to change name to flat lur ~ garden thus concept only 'hit; these few years nia.. last time condo dont hv garden also mah... Added on July 12, 2011, 1:03 am QUOTE(kuhfayLover @ Jul 12 2011, 12:38 AM) ok..i wait for ur pm then...This post has been edited by joeekh: Jul 12 2011, 01:03 AM |
|
|
Jul 12 2011, 01:08 AM
|
![]() ![]() ![]()
Junior Member
381 posts Joined: May 2011 |
Joeekh, u think does leasehold or freehold matter?
( pulling the topic back) |
|
|
Jul 12 2011, 01:19 AM
|
![]() ![]() ![]() ![]() ![]() ![]()
Senior Member
1,285 posts Joined: Sep 2009 |
QUOTE(kuhfayLover @ Jul 12 2011, 01:08 AM) if u plan for own stay n stay long long time..then shud nt be issuebt make sue lease period is > 90yrs.. bt then again most ppl after stay 1 place long time, they will think of changing environment.. when u move to new house..u will want to sell old hse.. bt old hse + leasehold = small market value.. bt can be offset by rent out old hse.... sorry..too open ended liao.. in a short...i wont too mind... This post has been edited by joeekh: Jul 12 2011, 01:20 AM |
|
|
Jul 12 2011, 09:15 AM
|
![]() ![]() ![]() ![]() ![]() ![]()
Senior Member
1,380 posts Joined: May 2009 From: Petaling Jaya |
QUOTE(kuhfayLover @ Jul 12 2011, 01:08 AM) but if can choose.. go for freehold lur ~ easier to sell.. or if u plan to rent it for next time[not selling] save your child $$ as they don't have to fork out money to extend the period |
| Change to: | 0.0286sec
0.46
6 queries
GZIP Disabled
Time is now: 24th December 2025 - 10:34 AM |