Wednesday, March 31, 2010

Timeline planning

Timeline Planning - ExpandedA spreadsheet to plot out the timeline and to gather one's assets in one page view is quite helpful.

You can include your CPF savings, other investments and maturity of policies, bank accounts, etc, to have an indication of what are your assets in total, present and future with a good estimate.

Timeline spreadsheet can also faciliate the planning for future needs and plug any gaps ahead.

Actually, there is no secret in doing this, just use your creativity, and insert formulas to aggregate the portfolios and add on as the time progress and the assets increase over the time.

Have fun in gathering and designing the spreadsheet to your own taste and colours.
(Click on the image and expand the view, you will see the example of the spreadsheet)

Thursday, March 25, 2010

Uni fees in 2015,2020 & 2030 with 6% inflation



In 2006, the fee for other courses in SMU was $7500 per year, and today ( 2010 ), it is $9890 which is 7.16% inflation.

I have drawn out an estimate, based on 6% inflation from 2006, by 2015, 2020 and 2030, the fees could be $12,671, $16,956 and $30,367 respectively.

This is time value of money and the fees will surely goes up with inflation.

Are we prepared in one way or another for our own children?

I know this figures because I paid $7500 per year for my own daughter who is finishing this year, but I have two more to provide for, if they survive the education system.

Unknowingly, I have put aside in the Growth Plan and some investment plans which will come in handy.

I have written an article on time line planning http://phuakahkengthomas.blogspot.com/2007/04/time-line-planning-leap-frog-forward.html in my blog. This was 3 years back, but it gives you an idea of how you can save for the future.

You can click on the link and take a look.

I hope it will be useful for your planning, the actual spreadsheet, if you do it, will have more information and assets you can gather.