THE SMARTMONEY COLLEGE SAVINGS WORKSHEET CALCULATOR          
         
Enter data regarding your college cost factors from the tables on the Financial Analysis page.  
  Use THE TAB Key to move down the worksheet.  Click the Reset Button to run another example.  
         
  Expected College Costs      
         
  Enter Amount Here (Table 1)    
         
  How much have you saved on your own.      
         
  Enter Amount Saved Here        
             
  How much will your savings be worth when you are ready to enter college. Chose a figure from the Lump-Sum-Multiplier Table 2          
         
  Enter Multiplier Here (Table 2)    
         
  Value of Savings Calculated Here    
         
  What do you expect to receive from family members and other sources before you start college      
         
  Enter Expected Amount Here    
         
  How close are you to your goal      
         
  This Amount is Calculated Here    
         
  How much do you still need?      
         
  Amount Required is Calculate Here     
         
         
  WHERE DO YOU GO FROM HERE      
         
  For this section we assume that you are putting your money in a tax advantaged 529 plan with an annual return of 8 percent. We also assume that that you keep contributing and earning these returns through your sophomore year.          
         
  Required Monthly Savings      
         
  Enter Divisor (Table 3)    
         
  Each month you will need to contribute:    
         
   
         
         
         
         

Powered By ExcelEverywhere