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

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

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

Law School COA Calculator and Comparison Spreadsheet - USE!!

Post by lawschool22 » Mon Feb 24, 2014 2:38 pm

Bored at work and needed to set something like this up. Enjoy.

Don't edit anything in grey and you should be fine. Current numbers are not to be trusted. Enter in your own COA numbers from the website.

Link:
https://drive.google.com/file/d/0B1AHcF ... sp=sharing

Most recent version: 1.8
Last edited by lawschool22 on Tue Apr 01, 2014 6:13 pm, edited 9 times in total.

User avatar
Gustave

New
Posts: 94
Joined: Fri Nov 02, 2012 6:41 pm

Re: Law School COA Calculator and Comparison Spreadsheet

Post by Gustave » Mon Feb 24, 2014 2:45 pm

Link, please. K thx!

User avatar
lawschool22

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

Re: Law School COA Calculator and Comparison Spreadsheet

Post by lawschool22 » Mon Feb 24, 2014 2:46 pm

Yeah I had it up but had to remove it for a specific reason. Will be back up soon.

User avatar
Gustave

New
Posts: 94
Joined: Fri Nov 02, 2012 6:41 pm

Re: Law School COA Calculator and Comparison Spreadsheet

Post by Gustave » Mon Feb 24, 2014 2:48 pm

You're a scholar and a gentleman. Thank you, and I await another morsel of spreadsheet goodness from ya.

User avatar
Gustave

New
Posts: 94
Joined: Fri Nov 02, 2012 6:41 pm

Re: Law School COA Calculator and Comparison Spreadsheet

Post by Gustave » Mon Feb 24, 2014 2:50 pm

Also, I may just write ~20 posts about how great all of your spreadsheets are, since I need them to qualify for the USWNR 25 contest. I'm afraid to enter the lounge.

Want to continue reading?

Register now to search topics and post comments!

Absolutely FREE!


User avatar
lawschool22

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

Re: Law School COA Calculator and Comparison Spreadsheet

Post by lawschool22 » Mon Feb 24, 2014 2:52 pm

Link added.

User avatar
lawschool22

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

Re: Law School COA Calculator and Comparison Spreadsheet

Post by lawschool22 » Mon Feb 24, 2014 2:54 pm

Cotiger, when you pop in here at some point, take a look at this and make sure I didn't screw something up. Thanks! lol :)

User avatar
lawschool22

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

Re: Law School COA Calculator and Comparison Spreadsheet

Post by lawschool22 » Mon Feb 24, 2014 2:55 pm

Actually I just noticed an error. Hold on everyone.

User avatar
lawschool22

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

Re: Law School COA Calculator and Comparison Spreadsheet

Post by lawschool22 » Mon Feb 24, 2014 2:57 pm

If you downloaded this prior to this post, you should re-download.

Want to continue reading?

Register for access!

Did I mention it was FREE ?


User avatar
Cal Trask

Gold
Posts: 4720
Joined: Tue Nov 19, 2013 7:40 pm

Re: Law School COA Calculator and Comparison Spreadsheet

Post by Cal Trask » Mon Feb 24, 2014 3:03 pm

Am I doing this wrong, or does adding scholarship information add to the CoA? Not a huge deal, just need to enter the scholarships as negatives.

User avatar
cotiger

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

Re: Law School COA Calculator and Comparison Spreadsheet

Post by cotiger » Mon Feb 24, 2014 3:04 pm

I dig it. My only comment would be that the Stafford interest rates are low. If they were set right now, it'd be at 6.3%. Not going to get down to 5.4% any time soon. Also, since GradPLUS is Stafford+1%, you could link those two.

Thanks for this!

User avatar
lawschool22

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

Re: Law School COA Calculator and Comparison Spreadsheet

Post by lawschool22 » Mon Feb 24, 2014 3:08 pm

Yes the income items should be entered as negative numbers.

User avatar
Cal Trask

Gold
Posts: 4720
Joined: Tue Nov 19, 2013 7:40 pm

Re: Law School COA Calculator and Comparison Spreadsheet

Post by Cal Trask » Mon Feb 24, 2014 3:11 pm

lawschool22 wrote:Yes the income items should be entered as negative numbers.
I figured it out, it just gave me a brief panic attack when the resulting CoA had skyrocketed. Good work on this.

Register now!

Resources to assist law school applicants, students & graduates.

It's still FREE!


Kimikho

Gold
Posts: 3971
Joined: Fri Mar 16, 2012 7:01 pm

Re: Law School COA Calculator and Comparison Spreadsheet

Post by Kimikho » Mon Feb 24, 2014 3:12 pm

Thank you!!!

04102014

Gold
Posts: 1695
Joined: Mon Feb 09, 2009 2:42 am

Re: Law School COA Calculator and Comparison Spreadsheet

Post by 04102014 » Mon Feb 24, 2014 3:15 pm

lawschool22 wrote:Bored at work and needed to set something like this up. Enjoy.

Don't edit anything in grey and you should be fine. Current numbers are not to be trusted. Enter in your own COA numbers from the website.
I loves you.

User avatar
lawschool22

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

Re: Law School COA Calculator and Comparison Spreadsheet

Post by lawschool22 » Mon Feb 24, 2014 3:18 pm

Hoping this will make it easy for people to post correct COA in this forum. We may want to post the link to this in the stickied thread. It will prevent people from doing tuition x 3 for total COA :)

AdInfinitum

New
Posts: 80
Joined: Mon Jan 27, 2014 3:22 pm

Re: Law School COA Calculator and Comparison Spreadsheet

Post by AdInfinitum » Mon Feb 24, 2014 3:23 pm

Point of clarification, just to make sure I understand the math:

The reason why total repayment isn't just the COA for each year added up is because you accrue interest on the loans you take out while still in school?

Get unlimited access to all forums and topics

Register now!

I'm pretty sure I told you it's FREE...


04102014

Gold
Posts: 1695
Joined: Mon Feb 09, 2009 2:42 am

Re: Law School COA Calculator and Comparison Spreadsheet

Post by 04102014 » Mon Feb 24, 2014 3:26 pm

cotiger wrote:I dig it. My only comment would be that the Stafford interest rates are low. If they were set right now, it'd be at 6.3%. Not going to get down to 5.4% any time soon. Also, since GradPLUS is Stafford+1%, you could link those two.

Thanks for this!
How are Stafford interest rates determined? Sorry if this is a dumb question.

User avatar
cotiger

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

Re: Law School COA Calculator and Comparison Spreadsheet

Post by cotiger » Mon Feb 24, 2014 3:32 pm

ohpobrecito wrote:
cotiger wrote:I dig it. My only comment would be that the Stafford interest rates are low. If they were set right now, it'd be at 6.3%. Not going to get down to 5.4% any time soon. Also, since GradPLUS is Stafford+1%, you could link those two.

Thanks for this!
How are Stafford interest rates determined? Sorry if this is a dumb question.
Yield on 10 year treasuries plus 3.6%

User avatar
lawschool22

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

Re: Law School COA Calculator and Comparison Spreadsheet

Post by lawschool22 » Mon Feb 24, 2014 3:35 pm

AdInfinitum wrote:Point of clarification, just to make sure I understand the math:

The reason why total repayment isn't just the COA for each year added up is because you accrue interest on the loans you take out while still in school?
Yep.

User avatar
lawschool22

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

Re: Law School COA Calculator and Comparison Spreadsheet

Post by lawschool22 » Mon Feb 24, 2014 3:37 pm

cotiger wrote:I dig it. My only comment would be that the Stafford interest rates are low. If they were set right now, it'd be at 6.3%. Not going to get down to 5.4% any time soon. Also, since GradPLUS is Stafford+1%, you could link those two.

Thanks for this!
I didn't know that about GradPLUS. So they would be 7.3% at the moment? And they now fluctuate w/ the 10 year t-note as well?

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!


User avatar
cotiger

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

Re: Law School COA Calculator and Comparison Spreadsheet

Post by cotiger » Mon Feb 24, 2014 3:40 pm

lawschool22 wrote:
cotiger wrote:I dig it. My only comment would be that the Stafford interest rates are low. If they were set right now, it'd be at 6.3%. Not going to get down to 5.4% any time soon. Also, since GradPLUS is Stafford+1%, you could link those two.

Thanks for this!
I didn't know that about GradPLUS. So they would be 7.3% at the moment? And they now fluctuate w/ the 10 year t-note as well?
Yep.

User avatar
lawschool22

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

Re: Law School COA Calculator and Comparison Spreadsheet

Post by lawschool22 » Mon Feb 24, 2014 3:41 pm

cotiger wrote:
lawschool22 wrote:
cotiger wrote:I dig it. My only comment would be that the Stafford interest rates are low. If they were set right now, it'd be at 6.3%. Not going to get down to 5.4% any time soon. Also, since GradPLUS is Stafford+1%, you could link those two.

Thanks for this!
I didn't know that about GradPLUS. So they would be 7.3% at the moment? And they now fluctuate w/ the 10 year t-note as well?
Yep.
Okay, next question. What you would assume as far as appreciation on the rate? I don't really see it decreasing in the current environment, but I'm not sure what to factor in. Right now I have it set to appreciate 5% YOY. Obviously if we knew for sure we would be bond traders and not future lawyers, but your thoughts are always welcome.

04102014

Gold
Posts: 1695
Joined: Mon Feb 09, 2009 2:42 am

Re: Law School COA Calculator and Comparison Spreadsheet

Post by 04102014 » Mon Feb 24, 2014 3:43 pm

cotiger wrote:
ohpobrecito wrote:
cotiger wrote:I dig it. My only comment would be that the Stafford interest rates are low. If they were set right now, it'd be at 6.3%. Not going to get down to 5.4% any time soon. Also, since GradPLUS is Stafford+1%, you could link those two.

Thanks for this!
How are Stafford interest rates determined? Sorry if this is a dumb question.
Yield on 10 year treasuries plus 3.6%
Is it based on the average yield for the year?

User avatar
lawschool22

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

Re: Law School COA Calculator and Comparison Spreadsheet

Post by lawschool22 » Mon Feb 24, 2014 3:44 pm

In case you guys missed it, download the current version above to get the correct rates (should be 6.33 and 7.33)

Seriously? What are you waiting for?

Now there's a charge.
Just kidding ... it's still FREE!


Post Reply

Return to “Choosing a Law School”