Showing posts with label housing loan. Show all posts
Showing posts with label housing loan. Show all posts

Friday, January 18, 2008

Version 2 - Mortgage Calculator

Click on the images to download your free Mortgage Calculator now!




Change it to your preferred Colour Scheme, your preferred logo or image & append your contact details, Voila!

Features:

1. Auto tabulation of loan amount based:
a) on the lower of Purchase Price or Valuation Limit
b) Choice of % financing (80 or 90%)
c) Loan Tenor

2. Auto calculation of Stamp fees and other cost of conveyance

3. Adjustable interest rates to reflect difference scenario of loan financing

4. Auto calculation of monthly installments and total interest payable

$50 per customisation, great tool to impress your clients!

SPECIAL OFFER: 1st 50 customers get to personalise this tools @ $30 only!

Tuesday, January 1, 2008

Property Loan Calculator


I have just developed a mortgage loan calculator which caters to the local flavor. You can click on the image to download this free calculator.


Tuesday, August 7, 2007

Article on Home Loan - Home Concept magazine (August Issue)

If you are keen to find out more details on residential property loans, check out the Home Concept magazine (August Issue). I have contributed some ideas for your home loan needs. Should you have need clarification on some of the information, you may forward your queries to calgorix23@yahoo.com.sg

Wednesday, May 16, 2007

Why my housing loan application got rejected???

I believe there are more than a handful of people out there who have the same question on their mind when their housing loan applications got rejected by the banks. But how many actually know what goes on behind the scene in credit processing?

Besides the normal credit checks, banks have a standard procedure to calculate your Debt Servicing Ratio (DSR) to check if you meet their internal criteria. Based on my past experience, i have summarized the steps require to tabulate the DSR (may differ from bank to bank):

Scenario:

Client A (40 yrs old) would like to buy a freehold private property with indicative value of SGD 1,000,000. He is planning to take a loan from the bank for 20 years. He has a CPF lumpsum of SGD 350,000 sitting in the OA account after working for many year. He also have FD Savings of SGD 200,000 with a bank. He has a outstanding car loan where he pays a monthly installment of SGD 700, and a monthly installment of SGD 300 on his Credit Card. If he earns $4,500 gross employment income every month, will his loan application be approved (for 80% financing package)?

Step 1: Calculate Stamp Duty requirement

Stamp Duty Calculation:
1st $180,000 – 1%
2nd $180,000 – 2%
Subsequently – 3%

For property worth more than $360,000, you may use the following short cut formula:

Stamp Duty = Property value * 3% - 5,400

For Property Value @ 1,000,000

Stamp Duty
= 1,000,000 x 3% - 5,400
= 24,600

Step 2: Calculate Maximum Loan Amount (80% financing)

Private Property VL = $1,000,000
Maximum loan amount = $800,000

Step 3: Calculate Monthly installment for the loan after deducting CPF lumpsum

CPF lump sum available = $350,000
FD = $200,000
Stamp Duty = $26,400 (use CPF to offset)
Nett CPF available to use = $323,600
Loan Tenor required = 20 yrs

Income = $4,500 (Gross)
Car Loan = $700
Credit Card Monthly Installment = $300

Generic 80% loan package @
1 yr 3.50%
2 yr 3.75%
3 yr 3.98% (normally banks will take the largest to calculate)

Actual loan required
= $1,000,000 - $200,000 (FD) - $323,600 (CPF Lumpsum)
= $476,400 (less than 80% - ok )

For 20yr loan @ 3.98%, monthly installment:
Loan required (PV) = $476,400
Tenor (n) = 20 x 12
Interest (i) = 3.98/12

Compute montly installment (PMT) = $2881.87 (require amortization)

Step 4: Calculate DSR (most bank uses 40% as benchmark)

Total Current Liabilities = $2881.87 + 700 + 300 = $3881.87

Debt Servicing Ratio (DSR)
= Total Current Liaibilities / Total Gross Income
= 3881.87 / 4500 * 100%
= 86.26% > 40% (Loan will be rejected)

Options:
1) Get one Joint Applicant with income > $5204.68 (3887.87/40% - 4500)
2) Reduce loan amount
3) Increase loan tenor + joint applicant

Note: Most banks have age limitation on the applicant; they restrict the maximum age of applicant after the expiry of the loan to be at 65 years. In above scenario, Client A will be 60 years old after the loan expires, thus still within the age limit. Take note that legal fees not taken into account.

Thursday, November 23, 2006

To refinance or not....

Some of us must be contemplating on refinancing our housing loans to enjoy the lower interest rates offered by other banks. So it it true that all who refinance enjoy great savings? Read on...

Usually, banks would offer you package deals like legal subsidy, free fire insurance or free property valuation to lure prospective home owners to refinance with them. To check if you can benefit from the refinancing package offered, you need to make sure you have great savings on interest charged. You also need to make sure to take note any hidden costs:

Example, for an outstanding loan of $3ook, the legal subsidy will usually be 0.4% of loan capped at $2,000. Hence, the actual subsidy will only be $1,200. However, standard legal charges averages $2,000. In this case, you will need to fork out $800 cash from your own pocket before you can enjoy any savings.

Besides the tangibles, make sure you take note of the intangibles such as the time and inconvenience for the refinancing process. Sometimes, the process might take up to 3 months to complete!

Happy shopping for your best deals!