Law School COA Calculator and Comparison Spreadsheet - USE!!

(Rankings, Profiles, Tuition, Student Life, . . . )
User avatar
lawschool22
Posts: 3875
Joined: Thu Jul 25, 2013 5:47 pm

Re: Law School COA Calculator and Comparison Spreadsheet

Postby lawschool22 » Tue Mar 18, 2014 12:27 am

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.

User avatar
cotiger
Posts: 1648
Joined: Tue Jul 23, 2013 11:49 pm

Re: Law School COA Calculator and Comparison Spreadsheet

Postby cotiger » Tue Mar 18, 2014 12:54 am

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,,))

User avatar
lawschool22
Posts: 3875
Joined: Thu Jul 25, 2013 5:47 pm

Re: Law School COA Calculator and Comparison Spreadsheet

Postby lawschool22 » Tue Mar 18, 2014 12:57 pm

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 :)

User avatar
lawschool22
Posts: 3875
Joined: Thu Jul 25, 2013 5:47 pm

Re: Law School COA Calculator and Comparison Spreadsheet

Postby lawschool22 » Tue Mar 18, 2014 2:22 pm

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

User avatar
thechancellor
Posts: 584
Joined: Thu Nov 07, 2013 1:01 pm

Re: Law School COA Calculator and Comparison Spreadsheet

Postby thechancellor » Tue Mar 18, 2014 4:14 pm

whyyyyy are you so great

it makes me feel like less of a legitimate individual

yes i did just make that all about myself

User avatar
cotiger
Posts: 1648
Joined: Tue Jul 23, 2013 11:49 pm

Re: Law School COA Calculator and Comparison Spreadsheet

Postby cotiger » Tue Mar 18, 2014 9:25 pm

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

User avatar
lawschool22
Posts: 3875
Joined: Thu Jul 25, 2013 5:47 pm

Re: Law School COA Calculator and Comparison Spreadsheet

Postby lawschool22 » Tue Mar 18, 2014 10:15 pm

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!

User avatar
cotiger
Posts: 1648
Joined: Tue Jul 23, 2013 11:49 pm

Re: Law School COA Calculator and Comparison Spreadsheet

Postby cotiger » Tue Mar 18, 2014 10:30 pm

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.

User avatar
lawschool22
Posts: 3875
Joined: Thu Jul 25, 2013 5:47 pm

Re: Law School COA Calculator and Comparison Spreadsheet

Postby lawschool22 » Tue Mar 18, 2014 11:38 pm

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" 8)

User avatar
coolbean2013
Posts: 274
Joined: Fri Nov 30, 2012 8:24 pm

Re: Law School COA Calculator and Comparison Spreadsheet

Postby coolbean2013 » Wed Mar 19, 2014 12:01 am

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

User avatar
lawschool22
Posts: 3875
Joined: Thu Jul 25, 2013 5:47 pm

Re: Law School COA Calculator and Comparison Spreadsheet

Postby lawschool22 » Wed Mar 19, 2014 9:23 am

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.

User avatar
cotiger
Posts: 1648
Joined: Tue Jul 23, 2013 11:49 pm

Re: Law School COA Calculator and Comparison Spreadsheet

Postby cotiger » Wed Mar 19, 2014 11:00 pm

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.

:wink:

User avatar
lawschool22
Posts: 3875
Joined: Thu Jul 25, 2013 5:47 pm

Re: Law School COA Calculator and Comparison Spreadsheet

Postby lawschool22 » Thu Mar 20, 2014 3:36 pm

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.

:wink:


Fixed! Use version 1.7 everybody!

snapdragon25
Posts: 374
Joined: Mon Feb 18, 2013 2:43 pm

Re: Law School COA Calculator and Comparison Spreadsheet

Postby snapdragon25 » Fri Mar 21, 2014 3:16 pm

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

User avatar
lawschool22
Posts: 3875
Joined: Thu Jul 25, 2013 5:47 pm

Re: Law School COA Calculator and Comparison Spreadsheet

Postby lawschool22 » Fri Mar 21, 2014 3:35 pm

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.

User avatar
aboutmydaylight
Posts: 580
Joined: Tue Jan 08, 2013 7:50 pm

Re: Law School COA Calculator and Comparison Spreadsheet

Postby aboutmydaylight » Sat Mar 22, 2014 2:54 pm

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.

User avatar
lawschool22
Posts: 3875
Joined: Thu Jul 25, 2013 5:47 pm

Re: Law School COA Calculator and Comparison Spreadsheet

Postby lawschool22 » Sat Mar 22, 2014 2:56 pm

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.

User avatar
aboutmydaylight
Posts: 580
Joined: Tue Jan 08, 2013 7:50 pm

Re: Law School COA Calculator and Comparison Spreadsheet

Postby aboutmydaylight » Sat Mar 22, 2014 4:40 pm

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

User avatar
lawschool22
Posts: 3875
Joined: Thu Jul 25, 2013 5:47 pm

Re: Law School COA Calculator and Comparison Spreadsheet

Postby lawschool22 » Sat Mar 22, 2014 4:47 pm

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 :D

User avatar
lawschool22
Posts: 3875
Joined: Thu Jul 25, 2013 5:47 pm

Re: Law School COA Calculator and Comparison Spreadsheet

Postby lawschool22 » Sat Mar 22, 2014 6:44 pm

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.

User avatar
IgosduIkana
Posts: 212
Joined: Sun Jan 09, 2011 7:50 pm

Re: Law School COA Calculator and Comparison Spreadsheet

Postby IgosduIkana » Sat Mar 22, 2014 7:00 pm

This is really awesome. Thanks.

norkanite
Posts: 83
Joined: Sun Jun 30, 2013 3:34 pm

Re: Law School COA Calculator and Comparison Spreadsheet

Postby norkanite » Mon Mar 24, 2014 9:51 am

.
Last edited by norkanite on Sun Aug 02, 2015 5:06 pm, edited 1 time in total.

User avatar
JustHawkin
Posts: 1769
Joined: Fri Mar 22, 2013 10:54 am

Re: Law School COA Calculator and Comparison Spreadsheet

Postby JustHawkin » Mon Mar 24, 2014 9:55 am

You da man LS22

User avatar
aboutmydaylight
Posts: 580
Joined: Tue Jan 08, 2013 7:50 pm

Re: Law School COA Calculator and Comparison Spreadsheet

Postby aboutmydaylight » Mon Mar 24, 2014 7:28 pm

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?

User avatar
lawschool22
Posts: 3875
Joined: Thu Jul 25, 2013 5:47 pm

Re: Law School COA Calculator and Comparison Spreadsheet

Postby lawschool22 » Mon Mar 24, 2014 7:35 pm

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




Return to “Choosing a Law School”

Who is online

Users browsing this forum: Google Adsense [Bot] and 5 guests