Wednesday, March 20, 2019

Excel Unit Convert Tool

This is a Unit Converter for you to convert quickly & simply a long list of floor area size values from square meter to square feet, or vice versa. This is a simple Excel Add In to run on your Excel. Below is the demo. You can download the free complimentary version of this unit converter here.

More information on the Unit Converter is available here.

Convert a list of floor area size from Square Feet to Square Meter.



You can insert =CONVERT() formula into your Excel spreadsheet easily.

Read how to activate an Excel Add In for use.

Wednesday, July 26, 2017

Three Reasons Why Now Is Not a Good Time to Invest in REITs

Three reasons why it may not be a good time to invest in REITs now:
  1. Federal Reserve raised interest rate twice this year in Mar and June by 0.25% respectively. It is expected to raise interest rate at least one more time later this year.

    a. Such increase of interest rate have impacts on stock market especially on dividend yield stocks like REITs. When interest rate increases, market expects higher return from dividend yield too. (note: since risk free fixed deposit interest return increases, funds would expect dividend yield increases too.) With REIT rental income and dividend distribution remain the same amount (note: since dividend amount distribute depends on business performance), share price is expected to drop so that dividend yield will increase. REIT price (and bond price, dividend yield stock price) is expected to come down when interest rate goes up, UNLESS dividend pay-out increases (which is unlikely).

    b. All REITs borrow money to finance purchase of properties, raising interest rate means their cost will be higher and profit will be lower. (therefore unlikely to increase higher dividend to match raising interest rate return)


  2. Retail malls in US has been going down trend due to Amazon. Many malls in US has closed down. This should be a trend due to online retail. Many REITs in Malaysia are holding primarily shopping malls too, i.e. Capitaland, IGB REIT, Sunway, Pavilion, KLCC, etc.

    So theoretically the trend of online retail may have adverse impact on REITs that invested heavily in less important malls.



    (Note: I don’t think popular malls like Mid Valley and Garden (owned by IGBREIT) will face the fate like those malls in suburban US.)





  3. REIT’s earnings growth is not good. REIT earns rental income. You need to buy property to increase renting space in order to increase profit and dividend. This process of growth is generally slower than many other industries.

    In general investor don’t buy REIT for growth, they buy REIT for stable income and good dividend yield.

    (In certain economy phases, rental income is very stable. Therefore it is a good vehicle as dividend yield stock for 5% - 7% annual return.)


It also means,

  1. Buy REIT during the economy phase when interest rate start to fall from its peak (not now, not in at least 1 year time). That is the time when REIT price will hike; AND
  2. Buy REITs that invested in warehouse (for online retail) and probably not malls in general (but may be specific popular city’s malls like IGBREIT)

Monday, July 18, 2016

Buying home during turbulent times (5): Ten mistakes to avoid

Part 1: Buying home during turbulent times: Ten mistakes to avoid
Part 2: Buying home during turbulent times (2): Ten mistakes to avoid
Part 3: Buying home during turbulent times (3): Ten mistakes to avoid
Part 4: Buying home during turbulent times (4): Ten mistakes to avoid
Part 5: Buying home during turbulent times (5): Ten mistakes to avoid

Previous

9. Buy only the properties built by reliable developers

If you buy first hand from a developer with bad reputation, your risks are:
  • abandon project - the developer bankrupts, you loss your deposit and owe bank on sum released to the developer.
  • late delivery - you get your house after few years of delay. Not only you incur extra interest cost, you incur extra rental cost.
  • bad quality house, i.e. bad finishing, leaking, cracking, structural problems, etc.
  • bank may not want to lend you money for this project.


If you buy a property built by a developer with bad reputation from second hand market, your risks are equally high:

  • still, quality of the house. Not all quality issues are apparent to novice home buyer.
  • bank may not want to lend you money for this project after you have paid your down payment to the second hand seller.

In the case of apartment or condominiums where there are common interests & amenities:

  • if the developer go bankrupt later, liquidator (of the developer) can charge owner 2% of unit's value for whatever transactions involved, i.e. refinancing, selling, etc. There are laws restricting such handling or admin fees charged by developers to minimum. However, liquidators claim they are not subject to this law as they are not developers. If you wish to sell your property, you will have no choice but to pay the liquidator.
  • three party fights among resident association, financially dire developer and ever changing property managers over collection and usage of sinking funds and management fees.




I remember in 1998, Citibank & Standard Chartered declined to finance our purchase of a property precisely due to bad developer of the property.


10. Use your own lawyer

We did this right. Being accountants, my wife and I always insist on choosing our own lawyer. Even if my lawyer friend is not in the bank/ developer panel list, we will not let the bank/ developer to choose our lawyer for us. We try our best to decide which lawyer we want to deal with.

On buying our home, the bank delays the release of fund due to matters arising from the seller. The seller was having problem in redeeming her loan from her bank. She had two units of condominiums under one loan agreement. She had to refinance the remaining unsold unit.

We knew that the standard S&P agreement states that our 10% downpayment will be forfieted if the full payment is not made within 3 months. With our own lawyer who drafted the wordings in the S&P, we are protected as the delay was due to the seller's fault.

One of my friends, bought a house from a lawyer. He almost lost his 10% deposit to the seller as the bank refuse to release payment to the seller due to technical deadlock. His lawyer and banker helped him to overcome the technical issue.

Look at this clause:

"In the event that the Seller disagree to any and/or the all the above conditions you shall refund to us the earnest money in the sum of RMxx which we now pay to you within 3 days from the date of the seller’s disagreement."

What's wrong with the clause? The buyer seems well protected. Not really.

This happened to the company that I worked for. It was a renting of office case. After the down payment, the landlord gave ridiculous conditions that the tenant could possibly met. The landlord forfeited the down payment. You see, it was not that the landlord/ seller disagreed with buyer's conditions, but the buyer disagreed with seller's conditions (regardless how ridiculous they were). It was a court case now.

You don't want to use seller/ lender's lawyer.




I started this "Ten Home Buying Mistakes To Avoid" series of posts in 2011, it took me 5 years to reach the final part of the series.

Previous

Part 1: Buying home during turbulent times: Ten mistakes to avoid
Part 2: Buying home during turbulent times (2): Ten mistakes to avoid
Part 3: Buying home during turbulent times (3): Ten mistakes to avoid
Part 4: Buying home during turbulent times (4): Ten mistakes to avoid
Part 5: Buying home during turbulent times (5): Ten mistakes to avoid

Saturday, August 10, 2013

Attending Property Investment Convention 2013



I attend seminars or courses to learn property investing.

I can still remember the first property seminar that I attended many many years ago. It was an evening in one of the hotels in Kuala Lumpur. My friend persuaded me to join him to attend. The speaker was Mr Milan Doshi on strategy to buy such rental property like apartments periodically with property loans to build passive income.  I can still roughly remember the illustrated numbers that he used, i.e. buy a RM120,000 apartment in every 5 years, paying down the property loans with rental income. The speed of repaying the property loans will get faster and faster. By the time you retire, the passive income would have been high enough to fund your retirement.

Not long after that my wife and I bought our first rental apartment which happened to be at the price of RM120,000. The seminar gave me a perspective to invest in property and prompted me to take action.


Later, I attended seminars conducted by Robert Kiyosaki and T Harv Eker, and courses conducted by Azizi Ali, T Harv Eker, Peter Yee, etc. I remember it was the same friend that gave me a free ticket to Mines Resort to attend T Harv Eker's seminar. We later paid thousands of ringgit to attend T Harv Eker courses in Singapore's Expo. It was all worthwhile.

My friend who persuaded me to join him to attend these seminars and courses is now "ashore" or "got out of rat race". He and his wife noticed a development area in Johor Bahru while attending T Harv Eker's courses in Singapore. They brought me there to see the growing traffics of the new area and the then newly developed Jusco nearby. They bought two shops and when the project completed the price of the shops doubled. It was before 2009.

The marketing tactics that I learned from T Harv Eker's Guerrilla Business served me well. I have made progress since then for both of my personal projects and works.

There are some exciting property courses and conventions recently. Just a few weeks ago, there was this 7-day WTF Property Seminar conducted by celebrity investor Faizul Ridzuan. He started his property investment with seed capital of RM2,000. By the age of 29, he already owned 23 residential properties.

In coming week, there is another major event in property investment. Property Investment Convention 2013 will be held on 17th and 18th August 2013. There are a panel of speakers from various disciplines of property industry. Some are expert investors from the perspective of individual, some are important figures in charge of major development areas, some are major players and agencies of the industry. For instance, the GM of PKNS (Selangor State Development Corporation) will talk about development of Selangor. You can see the panel of speakers and their topics. Interestingly, Milan Doshi is one of them.

What can we expect out of the seminar? From the mix of speakers and their topics, we can expect a 360 degree views from property investors, developers, economy and development planners, analysts and economists, agencies and property portals, etc.

There are topics like major developments in Selangor and next hot spots in Kuala Lumpur, markets & economy outlook, strategy to build passive income, government polices on house prices, etc. You can follow the link to read about the speakers and their topics.

In a way, I am promoting this event as an affiliate. However, I think the event is good enough for me to write and promote it. It is worthwhile.

Monday, July 18, 2011

Buying home during turbulent times (4): Ten mistakes to avoid



Part 1: Buying home during turbulent times: Ten mistakes to avoid
Part 2: Buying home during turbulent times (2): Ten mistakes to avoid
Part 3: Buying home during turbulent times (3): Ten mistakes to avoid
Part 4: Buying home during turbulent times (4): Ten mistakes to avoid
Part 5: Buying home during turbulent times (5): Ten mistakes to avoid
Previous | Next

7. Types/ classes of home & areas

a. For the sake of investment, today, I would choose landed property over condominium or apartment as my home. Land is a scarce resource. Its price goes up when demand increases. Prices of condominiums or apartments may stay as demand can be easily fulfilled by further supply built. This may be different for other countries where land for bungalows is abundant but with limited sea view city condominiums. But the principle is the same - the force of supply and demand.

b. First choose area, then specific property within the area. We cannot change area but we can improve our house. Growth usually leads to appreciation of house prices of the entire area. So choose growth area, choose hot development area, choose high quality neighbourhood, etc. Even if you buy a lower end house at a good area, your house price will go up when the area's prices go up.

c. Within your budget, choose low end of higher range property over high end of lower range property. For instance, choose a small landed house over big apartment.

We made all 3 mistakes above. We chose condominium over landed property. We did not choose a good neighbourhood, but a good unit within a so-so neighbourhood. We chose higher end of lower range property, i.e. a big condominium (instead of lower end of a higher range property, i.e. a small landed house). Our condo price had never gone back to the price we paid for. Don't get me wrong, it is in fact a lovely place as home. However, it was a bad choice as investment.

Believe me, there is nothing stopping you to get a lovely place as your dream home AND at the same time this place becomes your best ever financial investment as the house price doubled in one year. Therefore, when you choose your dream home, chose those that can also give you a good investment return few years down the road.




8. Feng Shui and other beliefs

Even if you don't believe in Feng Shui, if a big part of your culture believe in it, your home value will be affected by Feng Shui and local beliefs.

We bought the 14th Floor unit. In Cantonese, 14 is pronounced as "sure die". In Malaysia and probably Hong Kong, most Chinese don't buy houses, apartments or cars with number 4 ("die").

Previous | Next

Part 1: Buying home during turbulent times: Ten mistakes to avoid
Part 2: Buying home during turbulent times (2): Ten mistakes to avoid
Part 3: Buying home during turbulent times (3): Ten mistakes to avoid
Part 4: Buying home during turbulent times (4): Ten mistakes to avoid
Part 5: Buying home during turbulent times (5): Ten mistakes to avoid

Thursday, May 01, 2008

Buying home during turbulent times (3): Ten mistakes to avoid



Part 1: Buying home during turbulent times: Ten mistakes to avoid
Part 2: Buying home during turbulent times (2): Ten mistakes to avoid
Part 3: Buying home during turbulent times (3): Ten mistakes to avoid
Part 4: Buying home during turbulent times (4): Ten mistakes to avoid
Part 5: Buying home during turbulent times (5): Ten mistakes to avoid


Previous | Next

5. Don't believe seller/ agent's bluff. Savvy sellers know how to create sense of urgency. You will be told despite current economy conditions, another potential buyer is rushing to close this deal.

As buyer, the one who pay money, remember, you make the call. Don't let the seller dictate your pace. When you are in control of the pace of negotiation, you get the fair price you want. When you cannot dictate negotiation pace, most likely this is not a good deal. Forget about the deal.

What if the "bluff" is for real, you ask. I once read "deal of a life time comes every two weeks" from either Robert Kiyosaki or Dolf De Roo. We should not worry about losing one deal. If you are not in a desperate position you have time to explore and compare. See hundred places, shortlist a few "dream home" and negotiate at the same time.

This leads to the next point...

6. You must see more properties and compare

When you have seen sufficient alternatives, you will learn there are many ways to imagine how a dream home can be. It leads to abundance mentality. You will know there are many places as good as the one you are seeing now. There are many places you can design to be your dream home. There are many ways to design most places to become your dream home. You will not stuck your mind to just-this-one.

Once you are exposed to many possibilities of a dream home, abundance mentality kick in. With abundance mentality instead of desperate or just-this-one mentality, you will be more equipped to negotiate. Savvy sellers will sense your solid position (on many options available to you, sensible financial choices, etc.) and become more willing to back down on price.

I was the one reluctant to explore more houses and condominiums offered in the market. I just wanted to get a good place and quickly got it done. We checked less than a dozen of places. The moment we found one good place within, though stretched to the limit of, our budget, we became desperate for this particular place. We were in scarcity mentally. We did not want to lose this deal. The seller's agent held firmed of the property's price (at its ever peak).


Previous | Next

Part 1: Buying home during turbulent times: Ten mistakes to avoid
Part 2: Buying home during turbulent times: Ten mistakes to avoid
Part 3: Buying home during turbulent times (3): Ten mistakes to avoid
Part 4: Buying home during turbulent times (4): Ten mistakes to avoid
Part 5: Buying home during turbulent times (5): Ten mistakes to avoid

Buying home during turbulent times (2): Ten mistakes to avoid



Previous | Next

Part 1: Buying home during turbulent times: Ten mistakes to avoid
Part 2: Buying home during turbulent times (2): Ten mistakes to avoid
Part 3: Buying home during turbulent times (3): Ten mistakes to avoid
Part 4: Buying home during turbulent times (4): Ten mistakes to avoid
Part 5: Buying home during turbulent times (5): Ten mistakes to avoid


Your position

2. Don't stretch to your financial limit

If your financial position is not strong, you are taking greater risk to buy a property during economy slowdown. By stretching to your limit of affordability, you left yourselves no buffer for unexpected adverse scenario, i.e. job loss, interest hike (until recently the central bank reaction to inflation pressure is to tighten monetary policy and increase interest rate) that lead to higher instalment.

We borrowed to our limit to buy our home in 1997. Asia financial crisis changed our view on risk for good. There is no solid ground in the stock market. Nothing is impossible, i.e. free fall of stock market index to 20% or less of original height. The company that I worked for was going through redundancy exercise. We lived through the period with financial fears knowing that just one of us losing our job we would have problem in repaying home loan. We learned, bit our teeth, went through the period safely and repaid the home loan in 7 years. I know I will never want to risk myself in such situation again.

3. Don't be a desperate buyer

Because if you are desperate buyer you cut yourselves from many money saving options, you can be "squeezed" by the seller, you left yourselves with little corner to turn away from a deal and get the best out of negotiation.

We were desperate buyer then because my wife refused to rent, I refused to move in to my in-laws house (lose face ;-) , and give her the power over me), and our earlier home purchase was delayed for about a year and was called off (not approved by local authorities due to developer own problem. Our deposit was refunded). The worst part is the seller agent knew our position.

This lead us to next section on negotiation.





Negotiation

4. Don't show it on your face.

If you like the property, don't show it on your face in front of the seller or his/her agent. If you are desperate to live at this place, don't show it on your face. Working in stock market industry, I used to think there is a fair market price blinking on the wall for anything. I thought mind game or pretensions is unnecessary for negotiation, as there must be a fair market price. I was wrong. The only fair market price in property is how desperate the seller want to sell and how desperate the buyer want this specific property.

We were naive, we wanted to let the seller know that we were genuine buyer and not just tires kicker. We revealed our "desperate" position. We discussed our true likeness or dis-likeness of specific property in front of her. When she brought us to a condominium, she saw the sparkles in our eyes. We did not hide our excitements. When negotiate, we could not reduce a single cent even in the midst of Asia financial crisis. Actually there was no reason for her to reduce the price. She knew how desperate we needed a place quickly, she knew how much we like the property.

We can always be friendly yet tightly guarding our position. Play your cards close to your chest.

Previous | Next

Part 1: Buying home during turbulent times: Ten mistakes to avoid
Part 2: Buying home during turbulent times (2): Ten mistakes to avoid
Part 3: Buying home during turbulent times (3): Ten mistakes to avoid
Part 4: Buying home during turbulent times (4): Ten mistakes to avoid
Part 5: Buying home during turbulent times (5): Ten mistakes to avoid

Buying home during turbulent times: Ten mistakes to avoid



Buying a home during turbulent times?

Share prices are falling. Inflation is rising. Property prices remains uncertain. Financial and banking system have never been seen as fragile before. Job market seems bleak. However, you (and your partner) have decided to buy a place call home. Below are the top ten mistakes you can avoid in buying a home.
We bought our home, a condominium, at the midst of Asian financial crisis in December 1997. The share market had fell by half. Future of property market seemed fragile but had without sign of cracking, yet. We made most of the mistakes listed below. Therefore, despite the economy conditions, the seller's agent was able to hold tight to the price offered. We did not manage to reduce a single cent. Looking back, we were lucky to go through that difficult period. However, if we were not so naive, we could have saved huge.

Market Timing

1. Not now, just delay for a while. In the time of fragile economy and slowing growth, you are taking greater risk to buy a property.

a. Property prices
Property prices may stay or fall further, while it is unlike to go up in near term. If the property prices had not fell or had not fell significantly, it does not hurt just to wait for while (3 - 6 months) and see.

b. Banks are reluctant to lend during this period
Your bank marketing officer assure you that you can get loan for this property. You happily place your 10% down payment to the seller. A week later, the bank credit department reject your loan application. You are left to scrabble for financing or risk losing your 10% down payment. Banks are simply reluctant to lend during economy slowdown.



In other scenario, your bank may want you to pay higher down payment and take less loan.

c. Depends on Central Bank strategies, interest may go up.

After just one year, the property market crashed (selectively) too. If we waited for just a while, we would have paid 30% lower.

We were lucky enough to get a loan during that period as I was working for a financial Group. The bank within the same group has got no problem in lending us home loan.

However, our first few instalments from July 1998 were lower than the monthly interest expenses due to interest rate hike after the loan was approved. IMF, though its aids was rejected by Malaysia government, was preaching for higher interest rates. All Western media was preaching about market forces and higher interest rates. (In 2000 and Today, US Federal Reserve did the opposite lowering interest rates. Western media kept quiet.)

Our loan principal went up for a few months.






Next

Part 1: Buying home during turbulent times: Ten mistakes to avoid
Part 2: Buying home during turbulent times (2): Ten mistakes to avoid
Part 3: Buying home during turbulent times (3): Ten mistakes to avoid
Part 4: Buying home during turbulent times (4): Ten mistakes to avoid
Part 5: Buying home during turbulent times (5): Ten mistakes to avoid

Tuesday, April 18, 2006

Return of Investment of cash as down payment of rental property



You are considering whether to invest RM20,000 as down payment of a rental property. The difficult part of the decision is that you don't know whether the return of this RM20,000 is as good as your fixed deposits or unit trust funds.

How to compare? You will need to know the Rate of Return of this investment in order to compare with your fixed deposit rate or your unit trust fund portfolio's rate of return.

The tricky part of the comparison is that you cannot use return over the purchase price of the rental property as what you pay is not the purchase price but only the down payment.

Neither can you use Cash on Cash return of investment, as Cash on Cash ignore the house ownership/ equity you acquire when you slowly pay off the bank loan.

Your pay only the RM20,000 down payment and may be some initial legal fees and stamp duty, etc. So your actual investment is the RM20,000, upfront fees & expenses and, if any, net cash outflow through the years.

Your return is the entire future value of the property after you have paid off all the property loan's instalments and, if any, the net cash inflow through the years.

Yes, through the years...so it involves time value of money.

You may download the Return of Investment calculator here. It is an Excel file, it may not work properly on browser.

The biggest assumption of this calculator is the Future Estimated Value of your rental property. We must realise we can never accurately estimate future value of an asset. The calculator also assume that the loan interest rate is constant through out the loan period. This is rather unrealistic viewing current interest rate movement. However, these are the assumptions necessary to calculate the return of investment.

Screenshot of the ROI calculator...