Showing posts with label future value. Show all posts
Showing posts with label future value. Show all posts

31 July 2011

Housing Loan Reduction from EPF Account II - To withdraw or not to withdraw?


Question I have been asking: Is it always wise to withdraw EPF Account 2 for Home Mortgage Capital Repayment or in layman terms, reducing housing loan?

In the The Do’s and Don’t’s of EPF Withdrawal during an interview session at ntv7, Mr Yap Ming Hui stated that generally, if the “mortgage interest rate far exceed 5% (EPF dividend return)”, then it is advisable to do so.

Next question is, how much is “far exceeding” in this case?

I have been doing some simulation.
Referring to the table here:


26 July 2011

Anticipating the price of goods in "n" years


Approximate this by calculating the Future Value, FV using financial calculator or excel.

Say, GSC  movie ticket at RM 10.00. Ignoring personal inflation rate, we take CPI increment of 3% per year, in 10 years.

In Excel, type "=fv(", then you will key in "0.03" for "rate", "10" for "nper" which mean n number of periods, "0" for "pmt" which stands for periodic payment, and "-10" for "[pv],  present value for which it must be negative.

You will get the answer RM 14.80. This is the expected movie ticket price in 2022 if inflation remains constant each year.
Web Analytics