Top Law Schools

cotiger wrote:Other things.. in the monthly payment calculations, you used the third year Stafford interest rate on all of them (including for GradPLUS) instead of the individual years for Stafford/GP.

Also, when calculating the accumulated interest, accounting for the fact that loans are disbursed semesterly would increase accuracy.

I would just upload these edits myself, but I don't know how to save over the posted file or if that's even possible.

It's not possible because it's simply an uploaded Excel file - this is meant to be downloaded prior to editing.

I will fix point one tomorrow once I'm back on windows at work. I'll look into point two, but I think when I did in the past I decided the increased accuracy wasn't worth the increased complexity. It doesn't change the final COA all that much. But I'll take a look at it again.

Here ya go, brobrah. Already did it. Just copy and paste.

Total Stafford balance (cells B,C, and D44):
=B34/2*$S$12*(3+($C$58/12))+B34/2*$S$12*(2.5+($C$58/12))
=C34/2*$S$13*(2+($C$58/12))+C34/2*$S$13*(1.5+($C$58/12))
=D34/2*$S$14*(1+($C$58/12))+D34/2*$S$14*(0.5+($C$58/12))

Total GradPLUS balance (cells B,C, and D45):
=B38/2*$S$19*(3+($C$58/12))+B38/2*$S$19*(2.5+($C$58/12))
=C38/2*$S$20*(2+($C$58/12))+C38/2*$S$20*(1.5+($C$58/12))
=D38/2*$S$21*(1+($C$58/12))+D38/2*$S$21*(0.5+($C$58/12))

Stafford monthly payment (B52):
=-(PMT($S$12/12,$B$50*12,B44,,)+PMT($S$13/12,$B$50*12,C44,,)+PMT($S$14/12,$B$50*12,D44,,))

GradPLUS monthly payment (B53):
=-(PMT($S$12/12,$B$50*12,B45,,)+PMT($S$13/12,$B$50*12,C45,,)+PMT($S$14/12,$B$50*12,D45,,))

cotiger wrote:Here ya go, brobrah. Already did it. Just copy and paste.

Total Stafford balance (cells B,C, and D44):
=B34/2*$S$12*(3+($C$58/12))+B34/2*$S$12*(2.5+($C$58/12))
=C34/2*$S$13*(2+($C$58/12))+C34/2*$S$13*(1.5+($C$58/12))
=D34/2*$S$14*(1+($C$58/12))+D34/2*$S$14*(0.5+($C$58/12))

Total GradPLUS balance (cells B,C, and D45):
=B38/2*$S$19*(3+($C$58/12))+B38/2*$S$19*(2.5+($C$58/12))
=C38/2*$S$20*(2+($C$58/12))+C38/2*$S$20*(1.5+($C$58/12))
=D38/2*$S$21*(1+($C$58/12))+D38/2*$S$21*(0.5+($C$58/12))

Stafford monthly payment (B52):
=-(PMT($S$12/12,$B$50*12,B44,,)+PMT($S$13/12,$B$50*12,C44,,)+PMT($S$14/12,$B$50*12,D44,,))

GradPLUS monthly payment (B53):
=-(PMT($S$12/12,$B$50*12,B45,,)+PMT($S$13/12,$B$50*12,C45,,)+PMT($S$14/12,$B$50*12,D45,,))

Are you using the most recent version (1.5)? I think our rows might be off or something. I'm trying to get your formula to work but I'm having issues. Although I didn't spend that much time yet

Okay cotiger, I think I have it fixed. Take a look and let me know if it's right! Thanks - It's nice to have someone else look this stuff over lol

whyyyyy are you so great

it makes me feel like less of a legitimate individual

yes i did just make that all about myself

lawschool22 wrote:Okay cotiger, I think I have it fixed. Take a look and let me know if it's right! Thanks - It's nice to have someone else look this stuff over lol

No prob.

I think you must've re-uploaded the old version, because neither of those two things have changed lol

cotiger wrote:

lawschool22 wrote:Okay cotiger, I think I have it fixed. Take a look and let me know if it's right! Thanks - It's nice to have someone else look this stuff over lol

No prob.

I think you must've re-uploaded the old version, because neither of those two things have changed lol

My google drive background uploader was removed due to something someone in tech support was doing to my computer today at work. I updated it locally but it hasn't uploaded yet. I will have to fix it tomorrow when at work lol. Sorry!

lawschool22 wrote:

cotiger wrote:

lawschool22 wrote:Okay cotiger, I think I have it fixed. Take a look and let me know if it's right! Thanks - It's nice to have someone else look this stuff over lol

No prob.

I think you must've re-uploaded the old version, because neither of those two things have changed lol

My google drive background uploader was removed due to something someone in tech support was doing to my computer today at work. I updated it locally but it hasn't uploaded yet. I will have to fix it tomorrow when at work lol. Sorry!

Oh no worries. I make all the changes on my own file anyways. Just checking up for other peeps who might download it.

cotiger wrote:

lawschool22 wrote:

cotiger wrote:

lawschool22 wrote:Okay cotiger, I think I have it fixed. Take a look and let me know if it's right! Thanks - It's nice to have someone else look this stuff over lol

No prob.

I think you must've re-uploaded the old version, because neither of those two things have changed lol

My google drive background uploader was removed due to something someone in tech support was doing to my computer today at work. I updated it locally but it hasn't uploaded yet. I will have to fix it tomorrow when at work lol. Sorry!

Oh no worries. I make all the changes on my own file anyways. Just checking up for other peeps who might download it.

Lol I figured your file probably has some "tweaks"

Thank you LS22 for making this great spreadsheet (along with all the other ones you made)!!

coolbean2013 wrote:Thank you LS22 for making this great spreadsheet (along with all the other ones you made)!!

Thanks, no problem at all.

Also, the new sheet should be up for everyone. Version 1.6.

There's an error/typo in the 1L and 2L GradPLUS accumulated interest cells. Need to always divide yearly loans taken out by two and then multiply the interest by the (changing) number of years.

cotiger wrote:There's an error/typo in the 1L and 2L GradPLUS accumulated interest cells. Need to always divide yearly loans taken out by two and then multiply the interest by the (changing) number of years.

Fixed! Use version 1.7 everybody!

Omg I think I'm in love with you for doing this

snapdragon25 wrote:Omg I think I'm in love with you for doing this

Thanks! Glad you're finding it useful. This is one of the most important numbers that people need to know when evaluating decisions. Hopefully this makes it easier for people to see how much their "true" cost is.

Can someone give me a source that explains how unsubsidized Stafford loans interest capitalizes? You guys seem to be operating on the assumption that the interest accumulates but doesn't capitalize until repayment, yet I can't find a source for this.

aboutmydaylight wrote:Can someone give me a source that explains how unsubsidized Stafford loans interest capitalizes? You guys seem to be operating on the assumption that the interest accumulates but doesn't capitalize until repayment, yet I can't find a source for this.

For some reason I feel like we had this conversation somewhere but I don't remember where. I'll try to find it. If the spreadsheet is wrong I'll fix it.

Eta: Well I found the discussion but no source. Also it's proving difficult to get a clear answer on this from the searching in done.

Yea I can't seem to find an answer either...also on your spreadsheet, you've mixed up COL and Tuition rises.

aboutmydaylight wrote:Yea I can't seem to find an answer either...also on your spreadsheet, you've mixed up COL and Tuition rises.

Thanks!

No matter how hard I try you guys keep finding things I need to fix haha

Fixed the formulas and added a new section that compares the total cost of each school to the other three options and shows the difference.

Version 1.8 is what you want.

This is really awesome. Thanks.

.

You da man LS22

Am I wrong in thinking that the quarter system is much more favorable to student loans than the semester system? Not only does semester start about a month before quarter system, but you also have to take out more money up front because its divided by 2 instead of 3. That seems to be a pretty significant difference.


For example, assuming you start at the beginning of August and take out the max $20,500 in Stafford loans, that means $10,500 per semester. Second semester starts at the beginning of January. By the beginning of August next year you've had 12 months of interest on the first part of the loan, and 7 months of interest on the second part of your loan. With an interest rate of 5.41%, that's 5.41% * 10500 + (5.41%*(7/12)) * 10500 = 568.05 + 331.36 = $899.41 in interest.

For quarter system, its $6833 per quarter, in September, January, and April. That means by August of next year (assuming your big law job starts at the same time regardless of semester/quarter), you'll have 11 months on the first part of your loan, 7 months on the second part, and 4 months on the last part of your loan. Again, that's (11/12)*5.41%*6833 + (7/12)*5.41%*6833 + (4/12)*5.41%*6833 = $677.719 in interest. That's significantly lower.

Or am I making a wrong assumption about how loans are distributed?

aboutmydaylight wrote:Am I wrong in thinking that the quarter system is much more favorable to student loans than the semester system? Not only does semester start about a month before quarter system, but you also have to take out more money up front because its divided by 2 instead of 3. That seems to be a pretty significant difference.


For example, assuming you start at the beginning of August and take out the max $20,500 in Stafford loans, that means $10,500 per semester. Second semester starts at the beginning of January. By the beginning of August next year you've had 12 months of interest on the first part of the loan, and 7 months of interest on the second part of your loan. With an interest rate of 5.41%, that's 5.41% * 10500 + (5.41%*(7/12)) * 10500 = 568.05 + 331.36 = $899.41 in interest.

For quarter system, its $6833 per quarter, in September, January, and April. That means by August of next year (assuming your big law job starts at the same time regardless of semester/quarter), you'll have 11 months on the first part of your loan, 7 months on the second part, and 4 months on the last part of your loan. Again, that's (11/12)*5.41%*6833 + (7/12)*5.41%*6833 + (4/12)*5.41%*6833 = $677.719 in interest. That's significantly lower.

Or am I making a wrong assumption about how loans are distributed?

I didn't check your math but I don't really consider $220ish differential to be significant when we're talking about $100-$200k loans