Page 3 of 5

Re: Law School COA Calculator and Comparison Spreadsheet

Posted: Tue Mar 18, 2014 12:27 am
by lawschool22
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.

Re: Law School COA Calculator and Comparison Spreadsheet

Posted: Tue Mar 18, 2014 12:54 am
by cotiger
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,,))

Re: Law School COA Calculator and Comparison Spreadsheet

Posted: Tue Mar 18, 2014 12:57 pm
by lawschool22
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 :)

Re: Law School COA Calculator and Comparison Spreadsheet

Posted: Tue Mar 18, 2014 2:22 pm
by lawschool22
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

Re: Law School COA Calculator and Comparison Spreadsheet

Posted: Tue Mar 18, 2014 4:14 pm
by thechancellor
whyyyyy are you so great

it makes me feel like less of a legitimate individual

yes i did just make that all about myself

Re: Law School COA Calculator and Comparison Spreadsheet

Posted: Tue Mar 18, 2014 9:25 pm
by cotiger
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

Re: Law School COA Calculator and Comparison Spreadsheet

Posted: Tue Mar 18, 2014 10:15 pm
by lawschool22
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!

Re: Law School COA Calculator and Comparison Spreadsheet

Posted: Tue Mar 18, 2014 10:30 pm
by cotiger
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.

Re: Law School COA Calculator and Comparison Spreadsheet

Posted: Tue Mar 18, 2014 11:38 pm
by lawschool22
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)

Re: Law School COA Calculator and Comparison Spreadsheet

Posted: Wed Mar 19, 2014 12:01 am
by coolbean2013
Thank you LS22 for making this great spreadsheet (along with all the other ones you made)!!

Re: Law School COA Calculator and Comparison Spreadsheet

Posted: Wed Mar 19, 2014 9:23 am
by lawschool22
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.

Re: Law School COA Calculator and Comparison Spreadsheet

Posted: Wed Mar 19, 2014 11:00 pm
by cotiger
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:

Re: Law School COA Calculator and Comparison Spreadsheet

Posted: Thu Mar 20, 2014 3:36 pm
by lawschool22
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!

Re: Law School COA Calculator and Comparison Spreadsheet

Posted: Fri Mar 21, 2014 3:16 pm
by snapdragon25
Omg I think I'm in love with you for doing this

Re: Law School COA Calculator and Comparison Spreadsheet

Posted: Fri Mar 21, 2014 3:35 pm
by lawschool22
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.

Re: Law School COA Calculator and Comparison Spreadsheet

Posted: Sat Mar 22, 2014 2:54 pm
by aboutmydaylight
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.

Re: Law School COA Calculator and Comparison Spreadsheet

Posted: Sat Mar 22, 2014 2:56 pm
by lawschool22
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.

Re: Law School COA Calculator and Comparison Spreadsheet

Posted: Sat Mar 22, 2014 4:40 pm
by aboutmydaylight
Yea I can't seem to find an answer either...also on your spreadsheet, you've mixed up COL and Tuition rises.

Re: Law School COA Calculator and Comparison Spreadsheet

Posted: Sat Mar 22, 2014 4:47 pm
by lawschool22
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

Re: Law School COA Calculator and Comparison Spreadsheet

Posted: Sat Mar 22, 2014 6:44 pm
by lawschool22
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.

Re: Law School COA Calculator and Comparison Spreadsheet

Posted: Sat Mar 22, 2014 7:00 pm
by IgosduIkana
This is really awesome. Thanks.

Re: Law School COA Calculator and Comparison Spreadsheet

Posted: Mon Mar 24, 2014 9:51 am
by norkanite
.

Re: Law School COA Calculator and Comparison Spreadsheet

Posted: Mon Mar 24, 2014 9:55 am
by JustHawkin
You da man LS22

Re: Law School COA Calculator and Comparison Spreadsheet

Posted: Mon Mar 24, 2014 7:28 pm
by aboutmydaylight
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?

Re: Law School COA Calculator and Comparison Spreadsheet

Posted: Mon Mar 24, 2014 7:35 pm
by lawschool22
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