Malaysia Leasehold Property Auction Type

While reading Lowyat forum, I found that there are 2 types of leasehold property auction.

So I googled to understand further and below are the summary.

Type of Leasehold Auctions

  • Loan Agreement Cum Assignment (LACA) auctions
  • Non-Loan Agreement Cum Assignment (non-LACA) auctions

Non LACA (high court / land office)

Meaning individual strata title completed. Non bumi can buy from bumi owner (non bumi lot unit).

LACA (public auction)

Meaning still under master title or individual strata title yet to complete (beware the need to do double transfer) depend on the developer. need to check with developer because developer hold the title.

Developer can still convert bumi owner unit into bumi lot if they suddenly oversell the project to non bumi and fail to meet the bumi quota.
For some projects, maybe developer already paid up the penalty to the authority. Meaning majority units already being converted into open unit. No longer got bumi quota.

So conclusion, only developer holds the answer to your question if the lelong unit fall under this case.

Comparison Summary

ItemsNon-LACALACA
Strata Title CompletedYes. Title perfection doneNo. Still master title or title issued but perfection not done
Title owned by Who?Previous Owner (Proprietor)Developer or Previous Owner (but not yet fully completed)
Where Auctions Are ConductedHigh Court / Land OfficePublic Auction
Balance Purchase Price to be settled in (days)12090
Any potential problems?NoYes. Double transfer of strata title required by developer or The developer has transferred the property to the previous proprietor, and now the case was stucked at the proprietor and not transferred to the defendant (property owner) because the owner has not settled the legal fees and stamp duty.
Potential Additional Cost?NoMight have to pay twice stamp duty for previous owner and the buyer. (Please confirm with your lawyer)

Example of Impact

A question from Lowyat Forumer

I bought an auction unit and taken up a loan. Now my bank don't want to release the loan balance sum because the Letter of Confirmation and Undertaking stated that Strata Title is not yet been issued and that the developer is disagreed with a direct transfer and once the Strata title is out they will transfer to the first buyer name. Now my bank don't want to release the loan balance sum because of the disagree direct transfer. Why developer don't agreed to direct transfer? How to go about it if really can't direct transfer? What document do i have to follow up?

Answer:

Your lawyer should advice you better regarding the process. Same like sub sale whereby if developer disagreed to do direct transfer. Then you need to do double transfer.

In sub sale, the seller is responsible to settle the first transfer from developer to his/her name. But for auction, you need to do that and bear all cost involve which is legal fees + stamp duty / MOT to transfer the title from developer to the defaulter or bank first. Then only transfer another time to your name.

It is time consuming and cost consuming. Process may take 1 year especially if the property is leasehold. To extend the auction due date (90 or 120 days) will be up to the goodwill of the auction back whether to impose penalty/interest or not.

Conclusion

Try to avoid LACA auction except you are cash buyer and factor in additional cost to transfer the strata title.

References:

https://forum.lowyat.net/topic/4431314/+1780

https://www.propertyguru.com.my/property-guides/guide-to-property-auctions-malaysia-16482

NodeJS Reading and Writing to WordPress PHP via Rest API

I developed NodeJS program that can read and write to WordPress Rest API. I’m having problem of reading or writing properly the data in NodeJS and WordPress and vice versa.

NodeJS Writes JSON Objects to WordPress Rest API

Any JSON String[] or Object[], will be saved into serialized PHP string by WordPress.

Surprisingly, when NodeJS read the data save in serialize string, NodeJS can read it as JSON object without needs to call JSON.parse().

However JSON Object, will be saved as string by WordPress but still follows JSON string format.

As the JSON Object is saved as string, when NodeJS read the data via WordPress Rest API, NodeJS has to call JSON.parse() to convert it back into JSON Object.

Examples of JSON Object saved by WordPress Rest API

How To Have Consistency?

By having JSON arrays save as PHP serialize string and JSON object as string in PHP, I need to have do extra checking or conversion by calling JSON.parse()

Another possible solution is to call JSON.stringify() to JSON arrays so it is saved as string at PHP. However, it is still extra step that we need to do and it doesn’t solve the problem stated above where there is no consistency.

So, in short there is no possible solution to have consistency, we still need to do extra step as mentioned above.

PHP Serialize String and JSON Object

I’m not really understand difference between PHP serialize string and JSON object.

I notice PHP when stored data inside database is in PHP serialize string format. Serialize string is only available in PHP, hence it is not interoperable with NodeJS.

Hence, I did simple comparison for better understanding in order to make my NodeJS can read and write PHP data and vice versa.

PHP Array Conversion to PHP Serialize String and JSON Object

PHP Object Conversion to PHP Serialize String and JSON Object

PHP Array of Object Conversion to PHP Serialize String and JSON Object

Web Scraping – How To Get Hidden Data API that is Embedded in Google Map

I would like to get KFC Malaysia outlets that are located on top of Google Map. I tried using a scraper tool but it always gives me empty result.

So I have to find the hidden outlets API to retrieve it. I’m using Google Chrome to find the hidden data API.

Steps

1) Go to https://kfc.com.my/find-a-kfc/

2) Click on the outlets to view its details information.

kfc outlets location
kfc outlets location

3) Right click on the outlet’s information box and click Inspect.

kfc outlets inspect
kfc outlets inspect

 

4) You will see new window at bottom or right panel of your Chrome browser. Then click Network tab. The tab will be empty

kfc inspect network blank
kfc inspect network blank

5) Refresh your browser and you will see, it is populated with files and their types.

6) Sort by type and look for “fetch” type

identify data api by looking for fetch type
identify data api by looking for fetch type

7) Click on the file link and new window will appear. Click on “Response” tab.

Find until you see JSON format with outlet information. In KFC case, I found the file name is store?xxxxxxxx (xx denotes numbers)

kfc outlets api response
kfc outlets api response

8) You can also click “Preview” tab to see prettified JSON format.

kfc outlets api preview
kfc outlets api preview

9) After found the file that provides the outlets data, right click on the file and Copy -> Copy link address

get the outlets api by copying link address
get the outlets api by copying link address

10) Paste the link to a new browser tab and you can see the link

  • In KFC case it is, https://kfc.com.my/api/v2/store?1588173941864
  • You will see the response as below
kfc hidden outlets api response
kfc hidden outlets api response

11) Write a code that read the API and parse the JSON data

  • I’m using NodeJS and save it as CSV file.

11) Sample CSV Output

kfc sample csv output
kfc sample csv output
  • From the CSV, KFC Malaysia has 712 outlets as of 29/04/2020.

QGIS How To Create Hexagon Grid Based on Selangor State Boundary

GIS hexagon grid can be created using QGIS. In this case I’m using QGIS version 2.18.15.

First of all, you must have a boundary layer. I’m using Selangor parliamentary boundary.

QGIS Selangor Parliamentary Boundary
QGIS Selangor Parliamentary Boundary

Steps to Create Hexagon Grid

1) Enable the Processing Toolbox

View -> Panel -> Toolbox

QGIS Enable Toolbox
QGIS Enable Toolbox

2) From the Processing Toolbox, select Create Grid

QGIS Processing Toolbox
QGIS Processing Toolbox

3) After setting the configuration as follows, click run:

  • Grid type: Hexagon
  • Grid extent:  Select canvas and choose Selangor boundary or your boundary layer.
  • QGIS Use Extent Selangor Parliamentary
    QGIS Use Extent Selangor Parliamentary
  • Horizontal / Vertical spacing: 0.025 (means 0.025km)
  • Grid CRS: EPSG 4326 (or popularly known as WGS 84 where Google Map use this CRS)
QGIS Hexagon Grid Processing
QGIS Hexagon Grid Processing

4) After click Run, a hexagon grid layer will appear as follows:

QGIS Hexagon Grid Layer
QGIS Hexagon Grid Layer

5) Select Vector -> Research Tools -> Select by Location

QGIS Select By Location
QGIS Select By Location

6) Input the Configuratoin for Select by Location as follows, then click Run:

  • Layer to select: Your Hexagon Grid Layer
  • Additional layer (intersection layer): Your boundary layer in my case Selangor parliamentary
  • Geometric predicate: choose intersects, contains, touches, overlaps
QGIS Select By Location Configuration
QGIS Select By Location Configuration

7)Then click Select Features using an expression -> Invert Feature Selection

QGIS Invert Feature Selection
QGIS Invert Feature Selection

8)After inversion, your hexagon grid would look like below:

QGIS After inversion
QGIS After inversion

9) Click Toggle Editing (pencil icon) then Delete (trash icon)

QGIS Toggle Editing & Trash
QGIS Toggle Editing & Trash

10) Final output would look like this

QGIS Hexagon Grid
QGIS Hexagon Grid

How To Reduce Al Rajhi Housing Loan Principal

If you have extra money and want to reduce your housing loan principal with Al Rajhi bank, below are the steps.

Steps to Reduce Housing Loan Principal

  1. Send an official letter to Al Rajhi,
    • state the amount to reduce principal
    • state your saving account number with Al Rajhi
    • state your housing loan account number
    • authorize Al Rajhi to deduct the amount from your saving account with Al Rajhi
    • sign the letter
  2. Ensure the amount is in your Al Rajhi bank account
  3. Email the soft copy letter to customersupport@alrajhibank.com.my
  4. Ensure Al Rajhi provide you with acknowledgement
  • There is no minimum amount to reduce the principal
  • It takes 7 working days to process
Notes

This information is verified as of 31st March 2020, when I made a call to Al Rajhi call centre. Better to double confirm with Al Rajhi regarding your housing loan.

Latest update for  Al Rajhi Reducing Housing Loan Principal

To take or No Loan Moratorium due to Covid 19

Due to Covid 19, Malaysian government decided to give loan moratorium for 6 months starting April till September 2020.

The moratorium applied to all banks under Bank Negara Malaysia and for individuals and SME who have housing loan, car loans or business loans. The moratorium will accrue all profit/interest from the loan.

At same time all commercial banks decided not to compound the interest accrued during this 6 months.

The moratorium is to ease financial burden to all affected Malaysians.

Let say we decided to take the moratorium. I would like to analyze for housing loan only.

So what we shall do the additional fund from the 6 months moratorium?
1) Use it if you really need it
2) Save it for emergency fund
3) Use it, to reduce your loan principal

Use The Saving from 6 Months Moratorium to Reduce Your Loan Principal

I would like to simulate what is the best way to reduce your principal. Options available as follows:
1) Use the accumulated fund to pay the principal by the end of moratorium
2) Use the monthly installment to reduce principal on monthly basis

Assumptions:

Loan Amount: RM100,000
Tenure: 30 years
Interest: 5% per annum
Monthly Installment: RM536.82

If no moratorium, the principal should be RM99,272 based on the amortization table.

housing loan amoritization for RM100k loan
housing loan amoritization for RM100k loan

1) Use the Accumulated Fund to Pay Principal by The End of Moratorium

NoMonthPrincipal (RM)Profit / Interest (RM)
1April 2020100,000 416.67
2May 2020100,000 416.67
3June 2020100,000 416.67
4July 2020100,000 416.67
5August 2020100,000 416.67
6September 2020100,000 416.67

After 6 months:-
The accrued profit / interest: RM2,500
The accumulated fund saved from the monthly payment is: RM3,220.92

2) Use the Monthly Installment to Pay Principal On Monthly Basis

NoMonthPrincipal (RM)Profit / Interest (RM)
1April 2020 100,000.00 416.67
2May 2020 99,463.18 414.43
3June 2020 98,926.36 412.19
4July 2020 98,389.54 409.96
5August 2020 97,852.72 407.72
6September 2020 97,315.90 405.48

After 6 months:-
The accrued profit / interest: RM2,466.45
The accumulated fund saved from the monthly payment is: 0

Which Option Is Better?

PrincipalAmount after 6 Months (RM)Comparison vs Do Nothing
Do nothing - principal amount based on normal amortization99,272100.00%
Use the accumulated fund to pay the principal by the end of moratorium 99,279100.01%
Use the monthly installment to reduce principal on monthly basis 99,246 99.97%

There is not much difference in term of principal reduction.

Option (2) Use the monthly installment to pay principal on Monthly Basis is marginally better where it can reduce principal by 0.03%

How It Is Calculated?

Use the accumulated fund to pay the principal by the end of moratorium:

RM99,279 = RM100,000 (principal) + RM2,500 (accumulated interest) – RM3,220.92 (accumulated fund during 6 months moratorium)

Use the monthly installment to reduce principal on monthly basis:

RM99,246  = RM97,315.90 (principal on month 6) – RM536.82 (assuming reduce principal before starts interest charging from month 6 installment) + RM2,466.45 (accumulated interest)

How To Pay Outstanding Purchases At Maybank Stocks Online Trading Platform

Recently, I bought shares using Maybank Stocks Online Trading Platform. After purchasing the shares, I didn’t know how to pay for my purchases.

When I googled, I coudn’t find any useful help or information on how to make payment of my outstanding purchases. At the end, I had to make a call to Maybank call centre and get help.

According to Maybank, I must contact my stocks dealer to settle the payment via Maybank2u and my stock dealer informed me step by step on how to do it.

Before follow my steps, better call your dealer first. If you don’t know or remember your dealer phone number, you can contact Maybank help line (03 2297 8888) and they will provide you the dealer name and contact.

Steps to make payment on Outstanding Purchases

  1. Login to Maybank2u
  2. Select Pay & Transfer
  3. Select New Payment
  4. Select Maybank Investment Bank Berhad
  5. Enter your trading account number in “Trading Acct. No.”
  6. Enter your “Bill Reference No.”. Fill in:-
    • TRUST  – you will be transferring your money in Maybank Investment Bank account. (your trust account will be tagged with your trading account)
maybank trade oustanding pay
maybank trade oustanding pay
maybank trade - trust bill reference
maybank trade – trust bill reference
  1. Inform your dealer and share the receipt.

Remember to check that your Outstanding Purchase is cleared after the payment.

 

List of Malaysian Banks Giving Loan Moratorium Due to Covid 19

Due to Covid 19, lots of Malaysian and businesses are facing financial hardships. Fortunately we have our banking sector who is pro active in giving loan moratorium.

Loan moratorium is delay in paying your loan installments. In Malaysia, banks are giving 6 months loan moratorium.

List of Malaysian Banks That Give Loan Moratorium

list of malaysian banks offers loan moratorium due to covid 19

Where To Apply Loan Moratorium

**Latest update, your loans are automatically entitled for moratorium but you can opt out.

Below are the links that I found where you can apply online for loan moratorium.

CIMB Bank

Maybank

 

 

 

Dividend Yields Comparison Between Malaysian Banks

BanksDividend Yield (%)PEROE (%)
Affin Bank3.236.315.23
Ambank6.336.138.47
BIMB4.657.846.23
CIMB8.118.736.23
Hong Leong Bank3.7610.849.64
Maybank7.2310.8010.05
Public Bank4.7710.7812.64
RHB Bank9.638.383.95
Average5.968.737.81

Analysis

  1. CIMB has the highest dividend yield but low ROE and whether the dividend yield is sustainable in the long run.
  2. Maybank has 7.23% dividend yield which is commendable with ROE of 10% but with higher than average PE.
  3. Ambank has 6.33% dividend yield with PE of 6.13 which is below average which is good and above average ROE.
  4. Public Bank has highest ROE of 12.64 means it is very efficiency in using its capital vs other banks but it has very low dividend yield.

Conclusion

Based on the numbers, without evaluating its long term business, I would buy Ambank it has 6.33% dividend and take only 6 years to recover the capital.

However on safe side, it is better to buy Maybank shares as it is innovative in digital area for example first to introduce online banking and digital payment which I think is the new disruption in banking sector.

Notes

Total dividend amount declared for financial year ended 2018-12-31

  • Bank Islam
  • Affin Bank
  • CIMB
  • RHB Bank
  • Maybank

Total dividend amount declared for financial year ended 2019-03-31.

  • Ambank

Total dividend amount declared for financial year ended 2019-06-30.

  • Hong Leong Bank

source: MalaysiaStock.biz