Parents of the HS Class of 2017 (Part 1)

Congratulations, @dfbdfb on your daughter’s acceptance to the great summer program & good luck to everyone’s DC who are finishing up junior year! @thermom, your D sounds a bit like my S… I’m really hoping he lands somewhere that is both academically serious/rigorous, but laid back/noncompetitive at the same time.

I finally succumbed yesterday and created a spreadsheet with key info for schools on our(my?) “list.” I think I will call it the Spreadsheet of (In)Sanity, since I made it immediately after a long discussion with DH in which we agreed I should wait until after he takes DS on college visits in June before trying to make any kind of list (and that I should stop thinking about colleges until after that trip haha), and I felt MUCH better after making it! (Maybe I should call it the Spreadsheet of Perceived Control). So far, no compromises (really need to pare this list down somehow).

@262mom: Yet another SOS! The cries for help, they’re everywhere!

@262mom

Spreadsheet of Perceived Control

I like that one a lot! I’d disagree with your DH unless money is absolutely no object and you can spend a lot on travel. But that’s just me. Even just the basics of financial comparison, chances of getting in and program ares of interest match seem that they need to be tracked at some level.

Truly, I am shocked that Spreadsheet of Perceived Control was not conceived by @Agentninetynine. :wink:

@RightCoaster Sorry for any confusion. I don’t have a D17, but a D16. She is definitely going to UK. It’s done.

Due to the atmosphere at her HS (small. private. affluent. she’s there on scholarship), there is pressure re: where to apply and what constitutes a “good” school. She really wanted to go to a private selective school, and those were choices number 1 and 2, and then another at maybe 3 or 4. UK was 3 or 4 also, the safety. She applied to 7 schools in total, EA or rolling. Accepted 7/7.

We did not take a hard line with her re: the budget, although we were open with her that we had concerns about affordability and might have to say no.

When we were running numbers winter/spring of her junior year, we were using estimates & basing it mostly on 2014, which was not a great year for us. As 2015 progressed, H’s compensation package was restructured and it was looking like 2015 > 2014. It made a difference in the NPCs, which are largely income-driven. Then, at the end of 2015, as decisions were coming in, two projects landed in my lap. If the projects stuck around, 2016 > 2015. AND, the following year, we’d go from 2 in college to 1.

The NPCs were not kind. On top of all of that, we were incurring some substantial out of network/out of pocket medical expenses with no end in sight. In the end, we did not have the appetite for financial risk and stretching for and UG degree for our snowflake.

Everyone’s situation is different. We did drink the Kool-Aid for a few days when those acceptances first came in, and your mind turns to selling a kidney. It’s worth it, right? We snapped out of it fairly quickly and ripped that band-aid off. We told her what we could afford and what we thought was the smart choice. She was not happy.

The CC mantra is do not let your kid apply to a school you cannot afford. I agree with that, for the most part. Our finances were a changing landscape. I did make the initial mistake of only looking at the net cost of attendance for D’s first year, which made some schools look like they were within reach. But when I did a four year calculation with % increases AND took older D out of college, OUCH.

Sorry so long! It seems like a good cautionary tale to share. She got it into her head that where she goes to college should be HER choice, and many of the affordable choices embarrassed her. It’s The Bubble at her HS, it’s not us.

On the other hand, she knows she got those acceptances and the only thing that is keeping her from going is lack of money, not that she isn’t smart enough to play with those other snowflakes.

There’s always grad school!

The other HUGE bonus to applying EA and rolling is we had decisions by Xmas, including decisions on some great scholarships. She’s had time to adjust, and she’s good to go, now. But there were some dark days there in January and February!

Can you make your kid apply to some schools she isn’t in love with? Yes, we did. Can your kid come around to being happy about a school she isn’t in love with? Yes, definitely.

First world problems!

Hang in there everyone!

Good story and advice @Midwest67 . Congrats to your daughter. Can you let us know if you had a Binder of Destiny or Spreadheet of Sanity made? For the record, I do not. I just want the other crazys in here to get a better understanding of your process.

@RightCoaster Anything worthwhile in life is worth having an accompanying fabulously organized spreadsheet.

Signed,

Spreadsheet Lover

@Midwest67 what % did you use for COA increases? I need to factor that in and see if it changes the landscape at all.

I also plan to re-run EVERYTHING in August when schools update their published merit info and NPC’s and show 2017-18 tuition.

@srk2017 and @thermom -

D15 was also on the fence between Chem & ChemE. Clearly they are very different tracks, but ultimately she decided to apply for ChemE because you can always transfer from ChemE to Chem, but at many schools it is very hard to transfer into an engineering program. She felt comfortable that her school was strong in both majors so she would be fine either way. So far she’s happy in ChemE, but it’s early days.

If Chem is the chosen route then check out Vassar. When we visited in 2014 they were constructing a brand new chemistry building. (p.s. just recalled that Vassar may be one of the schools that only offers need-based aid so probably not an option if you are chasing merit).

I finally did it! Because I. Just. Can’t. with certain holier than thou posters on this site, they are now on my “ignore” list. :slight_smile:

@midwest67 Your post is very similar to our IRL experiences. One of our sons applied to top schools with full knowledge that unaffordable meant no go. He is completely happy at Bama knowing that he has completely self-funded college via scholarships. He actually loves it there. So going the path that originally was not even a serious contender can turn out positively in the long run. Being part of CBH has opened up a lot of great opportunities. So for others in similar circumstances, high performing students in selective honors programs do get specialized attention and opportunities that can add a lot to their experience.

@eandesmom I took the current year’s posted COA and added 3% to get D’s freshman year estimated cost. And then I added in 3% for every year after that. I’ve read to expect anywhere from 3-5% inflation, annually.

My spreadsheet had “Estimated Net COA First Year”, the second, etc. and then total. It helped me “see” the cash flow problem we have. (We also have an older D in college).

I put in $1200 for books, for all the schools. And $2500 for expenses, for all schools. If a school required plane tickets, I added in another column as an additional expense.

For two of the private schools, upperclassmen generally move off-campus ASAP. There would likely be savings on the high cost of R&B. I had a column for this too, a deduction for living frugally off-campus.

Health insurance I had as $2000. UK looks like it is going to be about $2200 for the year. I didn’t enter % inflation for this one.

I also ran the numbers assuming the merit scholarships came in. It was understood these schools were off the table if the scholarships did not materialize.

One school gave her a full tuition scholarship that did not include fees. Watch the fine print.

Since D went to private high school, we are familiar with the annual filing of financial documents and waiting for your FA package to come in. With our fluctuating income, it always made me nervous that we’d get an unpleasant surprise. As it turned out, our FA package for HS was the same all four years, but the COA went up with inflation.

At UIUC where my older D is a senior, most students pay one rate for all four years.

Someone just posted the revised new PSAT to old PSAT concordance on the huge NMSF thread. The conversions are harsh - like if they are accurate it will take a perfect PSAT to be NMSF in a number of states. So check it out if you counting on national merit.

I’m going to go back to my happy thinking re: NMSF because the concordance doesn’t make sense…at all. Leaving the SI percentiles alone and changing the concordance chart the way they did creates even greater problems than the old chart did. Very few would make NMSF nation wide based on the new concordance charts.

Can I ask those of you with NMSF kids a question.

Was your child encouraged to study for the PSAT by school? Did you encourage them? Did they just take the test and master it on their own without studying?

Just curious. I have a freshman who will take it next year. I don’t think he will be a super high scoring kid, but he has tested better than son17.

Son17 didn’t do so hot on the PSAT, but he ended up doing OK on SAT and ACT. He did not study at all for PSAT and I don’t think any of his friends did, wasn’t even a topic of discussion at school.

My son ('14) didn’t study for the PSAT, but he took SATs and had SAT prep going into the test. We’re in VA so the bar was high for us to make NMF.

My son is debating between Chemistry related major and Computational Biology/Chemistry. Any one thinking about Computational Biology/Chemistry?

@2muchquan - Sure, I can take some of the colleges from your list, as long as they are not hot and humid places Z:-)

@caroldanvers Those concordance tables make 0 sense. A 1520 concords to a 222 for 2014. Since 2014 had states with 224 cutoffs, it is saying no students in those states would qualify even with perfect scores. We don’t know who his source is, but those tables are illogical.

@Rigjtcoaster My dd studied for the PSAT by studying for the SAT. She spent about 2 weeks taking some practice section tests.