Saving for College Calculator using Scenarios

Some of my first original content

I wanted to determine whether the Texas Tomorrow Fund or a standard 529 would be a better investment.

So, assuming that the college will cost 221k in 2032, how much would I need to invest today (2014) to ensure there were enough funds?  I wanted to compare the cost of tuition rate increase versus average market returns.
400 Type 1 units from Tuition fund (4 years of school) costs $47k today.  Currently, public university tuition is about 9k per year, and growing about 5%, would cost 221k in 18 years.  The chart below compares average market returns scenarios and tuition growth rate scenarios for that same 9k per year.
Any scenarios in green represents where Texas Tuition fund would be better investment.
Amount need to invest today to have $221k in 2032…

Cost of Tuition increase rate
2% 3% 4% 5% 6% 7% 8% 9% 10%
Average Market Return 2% $36,000 $42,911 $51,062 $60,661 $71,946 $85,194 $100,723 $118,898 $140,142
3% $30,202 $36,000 $42,838 $50,891 $60,358 $71,473 $84,501 $99,749 $117,571
4% $25,381 $30,253 $36,000 $42,767 $50,723 $60,063 $71,012 $83,826 $98,803
5% $21,365 $25,466 $30,304 $36,000 $42,697 $50,560 $59,775 $70,562 $83,169
6% $18,014 $21,472 $25,550 $30,353 $36,000 $42,629 $50,399 $59,494 $70,124
7% $15,212 $18,133 $21,577 $25,633 $30,402 $36,000 $42,562 $50,243 $59,219
8% $12,867 $15,337 $18,251 $21,681 $25,715 $30,450 $36,000 $42,496 $50,089
9% $10,900 $12,993 $15,461 $18,367 $21,784 $25,795 $30,497 $36,000 $42,432
10% $9,248 $11,023 $13,117 $15,583 $18,482 $21,885 $25,874 $30,543 $36,000

Kinda just depends what one think is going to happen over next 18 years, but there appears to be more upside in a 529 plan than tuition fund.

Sources

http://www.bloomberg.com/news/2014-08-18/college-tuition-costs-soar-chart-of-the-day.html

http://www.cnbc.com/id/47565202

Leave a Reply

Your email address will not be published. Required fields are marked *