Well that's only for 1 year of loans, and that's only for $20,500 in Stafford loans, and that's before the loans capitalize. I haven't calculated the difference over repayment but it could easily turn out to be ~10k or so.lawschool22 wrote:I didn't check your math but I don't really consider $220ish differential to be significant when we're talking about $100-$200k loansaboutmydaylight 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?
Law School COA Calculator and Comparison Spreadsheet - USE!! Forum
- aboutmydaylight
- Posts: 580
- Joined: Tue Jan 08, 2013 7:50 pm
Re: Law School COA Calculator and Comparison Spreadsheet
- Yea All Right
- Posts: 579
- Joined: Tue Nov 26, 2013 6:27 pm
Re: Law School COA Calculator and Comparison Spreadsheet
Just stopping by to say thanks LawSchool22, very helpful!
- lawschool22
- Posts: 3875
- Joined: Thu Jul 25, 2013 5:47 pm
Re: Law School COA Calculator and Comparison Spreadsheet
Bump. Some of you need to be using this lol
- Pneumonia
- Posts: 2096
- Joined: Sun Jul 29, 2012 3:05 pm
Re: Law School COA Calculator and Comparison Spreadsheet - USE!!
would you pm this to me? I'm getting a 404 error when I try to download from google docs. thanks LS22
- lawschool22
- Posts: 3875
- Joined: Thu Jul 25, 2013 5:47 pm
Re: Law School COA Calculator and Comparison Spreadsheet - USE!!
Shoot me your emailPneumonia wrote:would you pm this to me? I'm getting a 404 error when I try to download from google docs. thanks LS22
Want to continue reading?
Register now to search topics and post comments!
Absolutely FREE!
Already a member? Login
- KatyMarie
- Posts: 616
- Joined: Fri Jun 21, 2013 2:16 pm
Re: Law School COA Calculator and Comparison Spreadsheet - USE!!
Thanks for this. This is so awesome
- bkegslounge
- Posts: 149
- Joined: Fri Jan 03, 2014 1:26 pm
Re: Law School COA Calculator and Comparison Spreadsheet - USE!!
Wow, this is really amazing! Everyone should use this! Thanks so much!
-
- Posts: 312
- Joined: Thu Oct 31, 2013 9:45 am
Re: Law School COA Calculator and Comparison Spreadsheet - USE!!
Great job LS22 and all helpers.
Tagging this awesome tool.
Mods should seriously sticky this.
Tagging this awesome tool.
Mods should seriously sticky this.
-
- Posts: 6
- Joined: Fri Apr 04, 2014 10:43 am
Re: Law School COA Calculator and Comparison Spreadsheet - USE!!
PLEASE READ....
Petition directed at Law Schools across the nation:
LOWER TUITION COSTS, for the sake of the future of the legal profession and the national economy...
Those bright law students you wish were applying to your schools right now?
Here we are, fed up at the high cost of tuition and law schools' blind adherence to the rankings game.
Is this the legacy that the legal profession deserves? Over-charging students who want to contribute to the legal profession itself?
We understand that institutions of higher learning have become for-profit based on a demand for certain degrees, including the J.D., but we do not concede to the incredible indebtedness that most of us will graduate with. It will limit our job choices. Even loan forgiveness programs for public interest are not guaranteed to those of us who may want to pursue that route.
The U.S. and World News Rankings allow for this insanity of elitism, over-charging and discrimination to endure. The game is dangerous in that it allows for the NUMBERS to do all the talking. Students have been as much at fault for adhering to the U.S. World News "recommendations" as law schools themselves, but as the cost of legal education rises beyond students' means for paying it, we become burdened with life-long debt that can eventually contribute to a crippling of the economy AS A WHOLE.
If the middle class (as most law students are) is burdened with crippling debt, the rest of the nation will also suffer. Any economist will attest to the fact that the middle class is an important pillar to the success of a nation's economy. If today's youth is put in a stranglehold of debt since their early twenties, how can we ever expect to recover, and therefore, contribute positively to the economy?
This is a petition written by law students and anyone else who believes in the future of the legal profession in allowing opportunities for future attorneys and practitioners to follow their passions by attaining economic stability.
A law degree should not be worth the same amount as a mortgage.
And this issue does not just belong solely to the economically underprivileged.
Sincerely,
Prospective law students of the United States
Petition directed at Law Schools across the nation:
LOWER TUITION COSTS, for the sake of the future of the legal profession and the national economy...
Those bright law students you wish were applying to your schools right now?
Here we are, fed up at the high cost of tuition and law schools' blind adherence to the rankings game.
Is this the legacy that the legal profession deserves? Over-charging students who want to contribute to the legal profession itself?
We understand that institutions of higher learning have become for-profit based on a demand for certain degrees, including the J.D., but we do not concede to the incredible indebtedness that most of us will graduate with. It will limit our job choices. Even loan forgiveness programs for public interest are not guaranteed to those of us who may want to pursue that route.
The U.S. and World News Rankings allow for this insanity of elitism, over-charging and discrimination to endure. The game is dangerous in that it allows for the NUMBERS to do all the talking. Students have been as much at fault for adhering to the U.S. World News "recommendations" as law schools themselves, but as the cost of legal education rises beyond students' means for paying it, we become burdened with life-long debt that can eventually contribute to a crippling of the economy AS A WHOLE.
If the middle class (as most law students are) is burdened with crippling debt, the rest of the nation will also suffer. Any economist will attest to the fact that the middle class is an important pillar to the success of a nation's economy. If today's youth is put in a stranglehold of debt since their early twenties, how can we ever expect to recover, and therefore, contribute positively to the economy?
This is a petition written by law students and anyone else who believes in the future of the legal profession in allowing opportunities for future attorneys and practitioners to follow their passions by attaining economic stability.
A law degree should not be worth the same amount as a mortgage.
And this issue does not just belong solely to the economically underprivileged.
Sincerely,
Prospective law students of the United States
- Hitchensian
- Posts: 208
- Joined: Sat Nov 02, 2013 7:34 pm
Re: Law School COA Calculator and Comparison Spreadsheet - USE!!
Tagging. And thanks to those who've contributed in putting this together/editing!
- Pneumonia
- Posts: 2096
- Joined: Sun Jul 29, 2012 3:05 pm
Re: Law School COA Calculator and Comparison Spreadsheet - USE!!
I'm no good with spreadsheets, but what would be the best way to incorporate undergrad debt into this?
- lawschool22
- Posts: 3875
- Joined: Thu Jul 25, 2013 5:47 pm
Re: Law School COA Calculator and Comparison Spreadsheet - USE!!
BUMP - does anyone know how to get this stickied?
-
- Posts: 106
- Joined: Wed Oct 30, 2013 5:14 pm
Re: Law School COA Calculator and Comparison Spreadsheet - USE!!
hey ls22, is the google doc down? I tried downloading it since I switched over computers but it wont load on my new laptop...is it just my laptop acting up?
NEVERMIND! GOT IT TO WORK
NEVERMIND! GOT IT TO WORK
Register now!
Resources to assist law school applicants, students & graduates.
It's still FREE!
Already a member? Login
-
- Posts: 312
- Joined: Thu Oct 31, 2013 9:45 am
Re: Law School COA Calculator and Comparison Spreadsheet - USE!!
Well deserved sticky!
Maybe LS22 can relinquish some edit rights to an admin (or just be diligent) so that interest rates can be updated each year. Unsubsidized Stafford graduate loans have an interest rate that varies each year to the tune of the June 1st T-Bill rate + 3.60% (with a cap at 9.5%); Grad Plus loans will have the Stafford rate + 1%.
Maybe LS22 can relinquish some edit rights to an admin (or just be diligent) so that interest rates can be updated each year. Unsubsidized Stafford graduate loans have an interest rate that varies each year to the tune of the June 1st T-Bill rate + 3.60% (with a cap at 9.5%); Grad Plus loans will have the Stafford rate + 1%.
- koval
- Posts: 196
- Joined: Sat Mar 16, 2013 12:19 am
Re: Law School COA Calculator and Comparison Spreadsheet - USE!!
Thanks for this, time to crunch some numbers!
- lawschool22
- Posts: 3875
- Joined: Thu Jul 25, 2013 5:47 pm
Re: Law School COA Calculator and Comparison Spreadsheet - USE!!
I'll try to keep up with it. I think I may just add the in a URL to those rates in the spreadsheet so people can update them on their own.buffalo_ wrote:Well deserved sticky!
Maybe LS22 can relinquish some edit rights to an admin (or just be diligent) so that interest rates can be updated each year. Unsubsidized Stafford graduate loans have an interest rate that varies each year to the tune of the June 1st T-Bill rate + 3.60% (with a cap at 9.5%); Grad Plus loans will have the Stafford rate + 1%.
-
- Posts: 312
- Joined: Thu Oct 31, 2013 9:45 am
Re: Law School COA Calculator and Comparison Spreadsheet - USE!!
Thanks!lawschool22 wrote:I'll try to keep up with it. I think I may just add the in a URL to those rates in the spreadsheet so people can update them on their own.buffalo_ wrote:Well deserved sticky!
Maybe LS22 can relinquish some edit rights to an admin (or just be diligent) so that interest rates can be updated each year. Unsubsidized Stafford graduate loans have an interest rate that varies each year to the tune of the June 1st T-Bill rate + 3.60% (with a cap at 9.5%); Grad Plus loans will have the Stafford rate + 1%.
Get unlimited access to all forums and topics
Register now!
I'm pretty sure I told you it's FREE...
Already a member? Login
-
- Posts: 430
- Joined: Thu Feb 07, 2013 9:51 am
Re: Law School COA Calculator and Comparison Spreadsheet - USE!!
This is awesome, thanks.
-
- Posts: 22
- Joined: Sat Apr 12, 2014 10:17 pm
Re: Law School COA Calculator and Comparison Spreadsheet - USE!!
This is so helpful -- thank you!
It's a lot to ask, but I'm wondering if a future version could include Perkins loans for those who qualify!
It's a lot to ask, but I'm wondering if a future version could include Perkins loans for those who qualify!
- Sls17
- Posts: 146
- Joined: Fri Jul 18, 2014 5:31 pm
Re: Law School COA Calculator and Comparison Spreadsheet - USE!!
zazmo2 wrote:This is so helpful -- thank you!
It's a lot to ask, but I'm wondering if a future version could include Perkins loans for those who qualify!
-
- Posts: 17
- Joined: Thu Apr 16, 2015 12:43 pm
Re: Law School COA Calculator and Comparison Spreadsheet - USE!!
I know this post is a year old, but I'm seriously loving this spreadsheet.
Is there a way to make a part-time version? I manipulated the interest calculations myself to be based on the 4 year plan instead of 3 years, but it could be helpful to post it for us non-traditional folks. Also - it would really be beneficial to incorporate the impact that making interest payments while in school will have on the total COA. I tried fiddling around myself to do this...but ADD got the best of me.
Is there a way to make a part-time version? I manipulated the interest calculations myself to be based on the 4 year plan instead of 3 years, but it could be helpful to post it for us non-traditional folks. Also - it would really be beneficial to incorporate the impact that making interest payments while in school will have on the total COA. I tried fiddling around myself to do this...but ADD got the best of me.
Communicate now with those who not only know what a legal education is, but can offer you worthy advice and commentary as you complete the three most educational, yet challenging years of your law related post graduate life.
Register now, it's still FREE!
Already a member? Login
- bmathers
- Posts: 889
- Joined: Mon Feb 22, 2016 2:27 pm
Re: Law School COA Calculator and Comparison Spreadsheet - USE!!
This is amazing - thank you for this. I've been searching Google for something like this and have had no luck. This is very helpful
- dietcoke1
- Posts: 1326
- Joined: Tue Mar 08, 2016 8:18 pm
Re: Law School COA Calculator and Comparison Spreadsheet - USE!!
this is awesome, thank you for this.
I'm not sure that I'm using it correctly tho. If I entered Cornell's tuition for year one at $61, 485 (from new 509) and put room fee at $23,436 (also from new 509), no scholarship info, a 10 year re payment period and 3 month long grace period, it says that the total amount of money I would pay is, with all the interest and fees accumulated, $488,825
would I really be paying close to half a million dollars to attend Cornell at sticker price and if I paid it all back in 10 years?????
I'm not sure that I'm using it correctly tho. If I entered Cornell's tuition for year one at $61, 485 (from new 509) and put room fee at $23,436 (also from new 509), no scholarship info, a 10 year re payment period and 3 month long grace period, it says that the total amount of money I would pay is, with all the interest and fees accumulated, $488,825
would I really be paying close to half a million dollars to attend Cornell at sticker price and if I paid it all back in 10 years?????
- guynourmin
- Posts: 3434
- Joined: Wed Jan 06, 2016 11:42 pm
Re: Law School COA Calculator and Comparison Spreadsheet - USE!!
It looks like while you are in school, you would accumulate ~$45,000 in interest before you even start paying anything back, which means your entire first year goes to basically nothing but interest. If that is the case, then paying ~$100,000 in interest otherwise seems about right (simple 7% interest over 10 years on $280,000 is well over $100,000).dietcoke1 wrote:this is awesome, thank you for this.
I'm not sure that I'm using it correctly tho. If I entered Cornell's tuition for year one at $61, 485 (from new 509) and put room fee at $23,436 (also from new 509), no scholarship info, a 10 year re payment period and 3 month long grace period, it says that the total amount of money I would pay is, with all the interest and fees accumulated, $488,825
would I really be paying close to half a million dollars to attend Cornell at sticker price and if I paid it all back in 10 years?????
- dietcoke1
- Posts: 1326
- Joined: Tue Mar 08, 2016 8:18 pm
Re: Law School COA Calculator and Comparison Spreadsheet - USE!!
wow, that is scary. thank you for thatguybourdin wrote:It looks like while you are in school, you would accumulate ~$45,000 in interest before you even start paying anything back, which means your entire first year goes to basically nothing but interest. If that is the case, then paying ~$100,000 in interest otherwise seems about right (simple 7% interest over 10 years on $280,000 is well over $100,000).dietcoke1 wrote:this is awesome, thank you for this.
I'm not sure that I'm using it correctly tho. If I entered Cornell's tuition for year one at $61, 485 (from new 509) and put room fee at $23,436 (also from new 509), no scholarship info, a 10 year re payment period and 3 month long grace period, it says that the total amount of money I would pay is, with all the interest and fees accumulated, $488,825
would I really be paying close to half a million dollars to attend Cornell at sticker price and if I paid it all back in 10 years?????
Seriously? What are you waiting for?
Now there's a charge.
Just kidding ... it's still FREE!
Already a member? Login