Uncategorized

Buying Leasehold Properties in Singapore Guidelines

Financing restrictions

Banks will generally provide financing for the purchase of a leasehold property if home buyers are able to tap their Central Provident Fund contribution. CPF has several ways to calculate this.

The first formula is based on the sum of the age of the applicant and the remaining lease on the property. The total must be equal to or exceed 80 years. For instance, if the buyer is 40 and the remaining lease on the property is also 40 years, the total is 80 years. This means that the buyer is eligible to use his CPF contribution for the purchase of the leasehold property.

If the buyer is only 30, however, and the remaining lease on the property is 40 years, the total equals 70 years. In this case, the buyer will not be eligible to use his CPF contribution towards the purchase of the leasehold property. “This implies that young people cannot use their CPF to buy old leasehold properties”

CPF also requires that a property have a remaining lease of at least 60 years. If the lease on a property is below 60 years, but more than 30 years, a valuation limit is set on the amount of CPF contribution that can go towards the payment of the property.

In this scenario, the numerator in the ratio will be the remaining lease on the property when the purchaser turns 55. Assuming the buyer is 40 today and the remaining lease on the property he wants to buy is also 40 years, when he turns 55, the remaining lease will be 25 years. The denominator will be the remaining lease today, which is 40 years. The ratio of 25 years/40 years is equivalent to 62.5%.

This means if the property purchase price is $1 million, the buyer can withdraw from his CPF up to a limit of 62.5% of the value, that is, $625,000. And that percentage is the valuation limit.

Loan Eligibility

For first home loan you are eligible up to 80% financing, 2nd housing loan at 50% (30% if loan tenure is more than 30 years or loan past age 65). 3rd housing loan at 40%, (20% if loan tenure is more than 30 years).

Total Debt Servicing Ratio (TDSR) is at 60% of borrower’s gross income. Banks will take into consideration the borrower’s other outstanding debt obligations when assessing the loan application. This is applicable to Private property, HDB and Commercial Property that bought under individuals, sole proprietorships or any investment company that is set up to purchase the property.

Advertisements
Windows

How to securely erase HDD

Step 1: In order to wipe a hard drive, we will need 2 programs. Rufus and Darik’s Boot and Nuke(DBAN). Go ahead and download these.

Links:

Step 2:
Once your programs are downloaded and you have installed them, go ahead an plug in your USB (>= 4GB). Once you have plugged in your USB, go ahead an open Rufus.

Set the following:

  • MBR partition scheme for BIOS or UEFI computers
  • FAT32
  • Select the DBAN ISO image

Create the bootable USB.

Step 3:
Great, you installed DBAN on your USB, but how do you wipe the hard drive. To wipe your hard drive, go ahead and turn off the computer you would like to wipe, and plug in the USB with DBAN.
Once you do, go ahead and turn on the computer.

In order for DBAN to be used, you must make the computer boot off the USB. To do this, you must change the boot order. This can be achieved through the bios, or through another function called “Change Boot Option”. I can’t tell you what key you have to press as all computers are different.

Go ahead and type in ‘autonuke’. This will wipe your hard drive without having to type commands and/or pressing enter.

At this point, go ahead and let DBAN do its thing. From the hard drives I’ve wiped, it takes about 12 hours to wipe a 500GB hard drive.

Windows

SQL 2016 Licensing Summary

  • If you are using SQL Always On, you have to get the SQL Enterprise Edition (EE)
  • Primary licenses covered with SA include 1 secondary server only. Any additional secondary servers must be licensed for SQL server. E.g.
    • In Prod, if you are running 3 x SQL Always On and the VM is running 4 x vCPU, you need to purchase the following:
      • 1 x 4 Cores SQL EE (with SA) to cover 1 x Active + 1 x Passive node
      • 1 x 4 Cores SQL EE to cover the 2nd Passive node
    • In QA,
      • 1 x 4 Cores SQL EE (with SA) to cover 1 x Active + 1 x Passive node
    • Total: 12 Cores (6 x 2 cores Pack)
Management

The Climb

I attended one of the New Staff Orientation programs and one of the item that struck me was the usage of a song. The lyrics are what one should do in his job.

Here’s the lyrics:


I can almost see it
That dream I am dreaming
But there’s a voice inside my head saying
“You’ll never reach it”

Every step I’m taking
Every move I make feels
Lost with no direction
My faith is shaking

But I gotta keep trying
Gotta keep my head held high

There’s always gonna be another mountain
I’m always gonna wanna make it move
Always gonna be a uphill battle
Sometimes I’m gonna have to lose

Ain’t about how fast I get there
Ain’t about what’s waiting on the other side
It’s the climb

The struggles I’m facing
The chances I’m taking
Sometimes might knock me down
But no, I’m not breaking

I may not know it
But these are the moments that
I’m gonna remember most, yeah
Just gotta keep going

And I, I got to be strong
Just keep pushing on

‘Cause there’s always gonna be another mountain
I’m always gonna wanna make it move
Always gonna be a uphill battle
Sometimes I’m gonna have to lose

Ain’t about how fast I get there
Ain’t about what’s waiting on the other side
It’s the climb, yeah!

There’s always gonna be another mountain
I’m always gonna wanna make it move
Always gonna be an uphill battle
Somebody’s gonna have to lose

Ain’t about how fast I get there
Ain’t about what’s waiting on the other side
It’s the climb, yeah!

Keep on moving, keep climbing
Keep the faith, baby
It’s all about, it’s all about the climb
Keep the faith, keep your faith, whoa


Head over here to sing it: https://www.youtube.com/watch?v=pJ2m9uyF2bg

Windows

Installing Windows Server 2016 on Lenovo X270 ThinkPad

I love to install Windows Server OS into my laptop. Everytime, there are always new challenges. Here are some of them.

  1. Use Rufus (https://rufus.akeo.ie/) to create a bootable UEFI USB drive with the Windows Server 2016
    • Make sure you select GPT partition & FAT32
    • If you install Windows using the wrong mode, you won’t be able to use the features of that firmware mode without reformatting the drive. One of them being BitLocker which you won’t be able to turn it on if you’ve installed in the BIOS mode.
  2. After installing Windows Server 2016, remember to install the Wireless LAN Service via Server Manager
Windows

Enabling BitLocker on Windows Server

1. Install the BitLocker Drive Encryption feature with the Add Roles and Features Wizard. You need to restart the system after the installation

2. Open the Local Group Policy Editor (gpedit.msc) and go to Computer Configuration/Administrative Templates/Windows Components/BitLocker Drive Encryption/Operating System Drives. Double-click Require additional authentication at startup.

3. Select Enable and check Allow BitLocker without a compatibile TPM

4. After a restart, open the Control Panel, you’ll find the BitLocker configuration panel. Open it and click Turn On BitLocker.

* Remember to install Windows on UEFI and set Secure Boot to true in BIOS

Scripting

Changing IE Proxy using Powershell

Do you need to shuttle around to different places? If so, then this script may be of use to you.

Every customer’s site uses different proxy settings. Don’t you find it a chore having to keep changing the settings manually? If the answer is yes, then this script will definitely brighten up your day! This script has now become one of my “Most Popular Script” in my notebook.
switch ($args[0])
{
Site1 { $proxyServer = 'proxy1.com.sg:8080'; $proxyEnable = 1 }
Site2 { $proxyServer = 'proxy2.com.sg:8080'; $proxyEnable = 1 }
default { $proxyServer = ''; $proxyEnable = 0 }
}

# Write-Output $proxyServer
# Write-Output $proxyEnable

set-itemproperty 'HKCU:\Software\Microsoft\Windows\CurrentVersion\Internet Settings' -name ProxyEnable -value $proxyEnable
set-itemproperty 'HKCU:\Software\Microsoft\Windows\CurrentVersion\Internet Settings' -name ProxyServer -value $proxyServer

SetProxy.bat

powershell.exe -command "& '%userprofile%\AppData\Roaming\Microsoft\Internet Explorer\Quick Launch\Proxy.ps1' Site1"