## Law School COA Calculator and Comparison Spreadsheet - USE!!

(Rankings, Profiles, Tuition, Student Life, . . . )
lawschool22

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

### Re: Law School COA Calculator and Comparison Spreadsheet

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.

cotiger

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

### Re: Law School COA Calculator and Comparison Spreadsheet

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

lawschool22

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

### Re: Law School COA Calculator and Comparison Spreadsheet

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

lawschool22

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

### Re: Law School COA Calculator and Comparison Spreadsheet

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

thechancellor

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

### Re: Law School COA Calculator and Comparison Spreadsheet

whyyyyy are you so great

it makes me feel like less of a legitimate individual

yes i did just make that all about myself

cotiger

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

### Re: Law School COA Calculator and Comparison Spreadsheet

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

lawschool22

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

### Re: Law School COA Calculator and Comparison Spreadsheet

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!

cotiger

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

### Re: Law School COA Calculator and Comparison Spreadsheet

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.

lawschool22

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

### Re: Law School COA Calculator and Comparison Spreadsheet

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"

coolbean2013

Posts: 275
Joined: Fri Nov 30, 2012 8:24 pm

### Re: Law School COA Calculator and Comparison Spreadsheet

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

lawschool22

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

### Re: Law School COA Calculator and Comparison Spreadsheet

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.

cotiger

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

### Re: Law School COA Calculator and Comparison Spreadsheet

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.

lawschool22

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

### Re: Law School COA Calculator and Comparison Spreadsheet

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!

snapdragon25

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

### Re: Law School COA Calculator and Comparison Spreadsheet

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

lawschool22

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

### Re: Law School COA Calculator and Comparison Spreadsheet

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.

aboutmydaylight

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

### Re: Law School COA Calculator and Comparison Spreadsheet

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.

lawschool22

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

### Re: Law School COA Calculator and Comparison Spreadsheet

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.

aboutmydaylight

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

### Re: Law School COA Calculator and Comparison Spreadsheet

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

lawschool22

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

### Re: Law School COA Calculator and Comparison Spreadsheet

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

lawschool22

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

### Re: Law School COA Calculator and Comparison Spreadsheet

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.

IgosduIkana

Posts: 211
Joined: Sun Jan 09, 2011 7:50 pm

### Re: Law School COA Calculator and Comparison Spreadsheet

This is really awesome. Thanks.

norkanite

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

### Re: Law School COA Calculator and Comparison Spreadsheet

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

JustHawkin

Posts: 1794
Joined: Fri Mar 22, 2013 10:54 am

### Re: Law School COA Calculator and Comparison Spreadsheet

You da man LS22

aboutmydaylight

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

### Re: Law School COA Calculator and Comparison Spreadsheet

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?

lawschool22

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

### Re: Law School COA Calculator and Comparison Spreadsheet

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: Exabot [Bot], Majestic-12 [Bot], SiddFinch85, Socratease and 11 guests