Happy 2017! An Excel to calculate the interest earned from OCBC 360 in 2016

Sunday, January 01, 2017

Happy new year to all the readers!

If you had been using OCBC 360 for the past one year, here's an excel table which you can use to calculate the interest earns. Do note that the bank pay interest daily (according to the website on this date), therefore there will be a slight difference in the amount. But the good thing is that you are actually earning slightly more than what is calculated from this excel.

If you are currently employed and still thinking that you do not have much money to put in the bank to earn interest, it's time to rethink and start helping your parents (especially if they are self-employed or retired) to earn some interest with the help of this table.

Start saving today and have a fruitful year ahead!

Link to download table:
https://www.dropbox.com/s/eotv44chfns3lmw/OCBC%20360%202016%20interest%20calculator.xlsx?dl=0




*Please take note:
-Most of you should probably just look at the interest earned on the left 4 columns
-Please ignore the no of days column
-You can simply delete the value in the yellow boxes during months which you had not hit some of the bonus criteria. 
-The balance will be the amount you have in the bank. If you are helping someone (such as your parents or siblings) to earn interest, you can input the value into the balance. The example in the table will be $30 000.
-Lastly, as the interest is not calculated daily, the amount you see will be slightly lesser than what you are actually getting from the bank. But the amount shouldn't deviate too much.

You Might Also Like

0 comments

Feel free to share!