Monday, August 1, 2022

Free online website to generate hi-res colorful QR codes with customized design

If you need to generate a QR code, for whatever reason, what tools do you normally use?

I have been using QRCode Monkey for quite some times, and I find this free online QR-code generating website is still among the best, as it is free of charge and feature-rich.


It allows you to generate QR codes of your own style and design. Your design can be colourful too.

Your QR code can be of high resolution until 2000x2000 px, which is good enough for most printing use.

You can save your QR code in the format of PNG file, as well as in vector graphics of SVG, PDF or EPS.

It even provides free API for your application to generate QR codes remotely.


If you need more advanced QR code functioning, you can also sign up for Pro account for free. That will enable you to generate QR code that integrates with various online application to do more wonders.




Thursday, July 28, 2022

How much can you save from loan early settlement?

Typically, there are 2 types of loans. One is fixed interest rate type, and another is variable interest rate type.

Some examples of fixed interest rate loan are: car loan, personal loan, credit card loan, study loan, business loan, etc.

Since the interest rate is fixed throughout the loan tenure, you can calculate its total interest using the simple interest formula of P x R% x T. The total loan repayment amount will then be principal plus total interest. The installment amount will be total repayment amount divided by no. of installments.

Variable interest rate loan has its interest calculated daily (daily rest), monthly (monthly rest), or other predetermined interval period. Property loan is normally of this type.

For this type of loan, since the interest rate in the future is unpredictable, the actual interest saved from early settlement is also unpredictable until the time has reached its original repayment end date. If we fix the last interest rate before the early settlement made for the rest of the original tenure, then the interest saved can be estimated using the simple interest formula above. Just substitute P with the early settlement amount will do.

The rest of this article will focus on how much we can save from early settlement of fixed interest rate loan.

The interest saved is usually called interest rebate, and is calculated according to the rule of 78. For Islamic loans, it is calculated according to the formula of Ibra'. Basically, both formulae are identical.

As an example, let's say a 7 years loan with principal 100k, 3% interest per annum, if we fully settle it 3 years after the borrowing, how much interest rebate can we get back?

Principal = 100k

Interest = 100k x 3% x 7 = 21k

7 years total repayment = 100k + 21k = 121k

Monthly installment = 121k/84 = 1440.476, rounded up to 1440.48

Since there is a round up of 0.004 for every installment, the last installment will then be 1440.16 only.

The sequential sum of all installment no. = 1+2+3+...+82+83+84 = (84)(84+1)/2 = 3570

According to rule of 78:

Interest for installment no. 1 = 21k x 84/3570

Interest for installment no. 2 = 21k x 83/3570

Interest for installment no. 3 = 21k x 82/3570

and so on...

Putting all the above information into an Excel worksheet, we can produce the following... 


and from the table above, we can produce the following graphs for better visualization of the interest portion:




We can observe that, for earlier installments the portion of interest is higher, and this will gradually reduce over time.

Back to our question, if we make an early settlement at the 36th installment, how much interest rebate can we get?

The interest rebate will be the sum of interest portion of the 37th installment until the last 84th installment.

There is a formula to quickly calculate this interest rebate:

Interest rebate = n(n+1)/N(N+1) x I

where:
N is the overall no. of installments
n is the no. of remaining installments
I is the overall interest amount = P x R% x T

Many financial institutions require an early notice period of at least 3 months, else a penalty will be imposed based on the interest amount of the notice shortcoming installments.

Some financial institutions also charge a fee, such as processing free, or early settlement fee, for early settlement.

By including these factors, our final formula will be:

Interest rebate = (n-t)(n-t+1)/N(N+1) x I - C

where:
t is the shortcoming of notice period
C is the related charge for early settlement

Last but not least, looking at our example above, we can observe that the interest is nearly fully paid off during the last 1.5 years of the loan tenure. As such, the interest rebate available in that time range is very minimal, and you can't save much for making early settlement at the final stage of the loan tenure.



Saturday, July 23, 2022

Investing in Kenanga Digital Investing (KDI)

Kenanga Digital Investing (KDI) has been around for a few months since early 2022, and I have just joint on the bandwagon last week.


KDI is a robo-advisory investment platform under Kenanga Investment Bank. It can be accessed either using web browser to its website, or via its mobile app available for Android and iOS.


FYI, this is the same Kenanga Investment Bank which has another popular investment platform called Rakuten Trade for online stock investment.

I just put in the minimum starting fund requirement of RM100 in KDI Save and RM250 in KDI Invest respectively for a trial to test its performance. I've used my friend's referral code during registration and got RM10 as a result. Therefore, my invested amount in KDI Invest has become RM250 + RM10 = RM260.



After invested for about a week, this is my portfolio performance so far. 

My KDI Save has gained RM0.08 (0.08%) from RM100, equivalent to 2.92% p.a over a period of 10 days.

My KDI Invest has gained RM2.03 (0.78%) from RM260, equivalent to 28.49% p.a. over a period of 8 days.


I would say, this investment result is pretty impressive. Hope that KDI can keep up this kind of performance for a long period of time.

Currently, KDI only has 2 investment products: KDI Save and KDI Invest.

KDI Save is similar to Opus Money Plus Fund (MPF), Touch n Go (TNG) GO+, StashAway Simple, and other money market fund (MMF). It is quite impossible to incur losses, and its return is expected to be just slightly higher than the bank's fixed deposit rate. This is a kind of investment of low risk low return.

KDI Save's return is daily calculated and daily credited into your account. Currently, for an investment amount of RM100, you can get RM0.01 per day. KDI does not incur any management fee, pretty similar to fixed deposit savings with bank.

KDI Invest is an A.I. operated ETF investment fund. It invests into ETF funds listed in the US market, which coverage is around the world.


The investment profit or loss of KDI Invest is daily updated in its returns value. Being an ETF fund, its fluctuation is pretty small.

You can decide your KDI Invest portfolio risk profile to be set as either Very Conservative, Conservative, Balanced, Growth or Aggressive Growth. That will determine the level of fluctuation of your daily profit or loss.

Invested amount of RM3,000 or less in KDI Invest is free from fund management fee. More than that, there will be a management fee of 0.3% to 0.7% per annum. On top of that, there is also an ETF transaction fee of 0.2% to 0.4%. per annum. This amount of fund charges is considered very minimal, compared with the charges of majority of the mutual funds in the market.

Both Malaysian and non-Malaysian who has bank account in Malaysia can invest with KDI. You can sign up your account in their website or via their mobile app.

If you want to get an additional RM10 in your KDI Invest account, you can sign up using this referral code114053

After signing up, before you can gain access to KDI and start investing, you need to wait for 1 or 2 days for the processing of your KYC verification. You will receive an email from KDI once your account application is approved.

Please remember that, in order to get your RM10 for using my referral code114053, you are required to transfer a minimum of RM250 from your bank account to KDI Invest within 30 days upon account creation. If your KDI Invest account is not activated with an initial investment after the expiry date, you will miss your opportunity of getting that RM10.


Hint: Click on the "Older Posts" link to continue reading, or click here for a listing of all my past 3 months articles.