<p>
</p>
<p>I just set stuff up on a regular Excel spreadsheet, with these column titles:</p>
<p>College Name - Total COA - Grants - Loans - Work Study - College EFC. We Pay - Our full COA </p>
<p>The “total COA” was the hard figure provided to us by the college – tuition + room & board. </p>
<p>“Grants” would include merit money as well as need-based aid – it just was the total amount of cash being given to us.</p>
<p>“College EFC” was the family contribution part as from the student aid package, as determined by the college (not FAFSA EFC) </p>
<p>“Loans” meant student loans only, I never would count a parent PLUS loan as part of the financial aid package</p>
<p>“We pay” was the immediate out-of-pocket – what we would have to come up with each year – (grants & student loans). So that amount was a little higher than the “family contribution” part because I was shifting the work-study money over to the out-of-pocket side of the equation. That’s because work-study isn’t paid in advance and requires the kid to get a job and earn – the kid might not end up doing that, and even if he does, I have a hard time seeing how my kid’s hourly wages are anything other than amount of money that “we” are paying. (“We” means the whole family, not parents vs. kid. All the money I pay also comes from earnings from work, too.)</p>
<p>“Our full COA” has the loans added back into the equation – because (guess what?) - loans have to be paid back. I didn’t go to the trouble of calculating the true costs of the loans – loan origination fees + interest paid over time – but there are some excellent utilities at finaid.org that let you put in the loan figures and then generate a chart that will show you how much interest is paid over the years. That’s kind of mind-boggling – I’ve never quite seen how offering high-interest financing is seen as financial “aid” – the bottom line is that loans are expensive! (Again, I think that your math-y son is going to like seeing the numbers).</p>
<p>Usually once I have set something out on an Excel spreadsheet, I can just highlight the chart with my mouse & then use automated graphing features to create bar graphs. I find the bar charts particularly helpful to make sense of the different balance of grants / loans/ work study in different packages.</p>
<p>Here’s an example of what field values might look like in my chart:</p>
<p>College Name - Podunk U - Second C. – Stingy U.
Total COA - 25,000 55,000 55,000
Grants 10,000 30,000 15,000
Loans 3,000 2,000 6,000
Work Study 2,000 1,000 5,000
College EFC 10,000 22,000 29,000
We Pay 12,000 23,000 34,000
Our full COA 15,000 25,000 40,000</p>
<p>Even though I’ve invented the figures in the above example, that is very close to the choices we faced in my family. Even without meeting full need, the state publics came in substantially lower, whereas my kids’ 2nd choice colleges came in with the best offers for a private, and there was a top choice college in the mix with a stingy & work/loan heavy offer. You can see how important it is to tease out the work study/loan figures. Looking at “College EFC” vs. “We Pay” vs. “Our full COA” you can see that a small difference in out-of-pocket can become quite large when large loans & work study grants are factored in.</p>
<p>Anyway – I suggest that you show this to your son and let HIM make the spreadsheets – encourage him also to look at the true cost of a loan with interest-- & add in a 4-year projection as well as looking at interest paid over the cost of the loans. </p>
<p>I am absolutely sure that if your son is smart enough to be accepted to Williams & Carleton & Rice, he will be able to easily handle this problem. It is very simple math when it comes down to it.</p>