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

Law School COA Calculator and Comparison Spreadsheet - USE!!

Postby 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/0B1AHcFNmNuAwSUd6OHh0UUMtTFE/edit?usp=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
Posts: 94
Joined: Fri Nov 02, 2012 6:41 pm

Re: Law School COA Calculator and Comparison Spreadsheet

Postby Gustave » Mon Feb 24, 2014 2:45 pm

Link, please. K thx!

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

Re: Law School COA Calculator and Comparison Spreadsheet

Postby 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
Posts: 94
Joined: Fri Nov 02, 2012 6:41 pm

Re: Law School COA Calculator and Comparison Spreadsheet

Postby 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
Posts: 94
Joined: Fri Nov 02, 2012 6:41 pm

Re: Law School COA Calculator and Comparison Spreadsheet

Postby 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.

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

Re: Law School COA Calculator and Comparison Spreadsheet

Postby lawschool22 » Mon Feb 24, 2014 2:52 pm

Link added.

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

Re: Law School COA Calculator and Comparison Spreadsheet

Postby 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
Posts: 3875
Joined: Thu Jul 25, 2013 5:47 pm

Re: Law School COA Calculator and Comparison Spreadsheet

Postby lawschool22 » Mon Feb 24, 2014 2:55 pm

Actually I just noticed an error. Hold on everyone.

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

Re: Law School COA Calculator and Comparison Spreadsheet

Postby lawschool22 » Mon Feb 24, 2014 2:57 pm

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

User avatar
Cal Trask
Posts: 4720
Joined: Tue Nov 19, 2013 7:40 pm

Re: Law School COA Calculator and Comparison Spreadsheet

Postby 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
Posts: 1648
Joined: Tue Jul 23, 2013 11:49 pm

Re: Law School COA Calculator and Comparison Spreadsheet

Postby 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
Posts: 3875
Joined: Thu Jul 25, 2013 5:47 pm

Re: Law School COA Calculator and Comparison Spreadsheet

Postby lawschool22 » Mon Feb 24, 2014 3:08 pm

Yes the income items should be entered as negative numbers.

User avatar
Cal Trask
Posts: 4720
Joined: Tue Nov 19, 2013 7:40 pm

Re: Law School COA Calculator and Comparison Spreadsheet

Postby 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.

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

Re: Law School COA Calculator and Comparison Spreadsheet

Postby Kimikho » Mon Feb 24, 2014 3:12 pm

Thank you!!!

04102014
Posts: 1696
Joined: Mon Feb 09, 2009 2:42 am

Re: Law School COA Calculator and Comparison Spreadsheet

Postby 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
Posts: 3875
Joined: Thu Jul 25, 2013 5:47 pm

Re: Law School COA Calculator and Comparison Spreadsheet

Postby 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
Posts: 76
Joined: Mon Jan 27, 2014 3:22 pm

Re: Law School COA Calculator and Comparison Spreadsheet

Postby 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?

04102014
Posts: 1696
Joined: Mon Feb 09, 2009 2:42 am

Re: Law School COA Calculator and Comparison Spreadsheet

Postby 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
Posts: 1648
Joined: Tue Jul 23, 2013 11:49 pm

Re: Law School COA Calculator and Comparison Spreadsheet

Postby 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
Posts: 3875
Joined: Thu Jul 25, 2013 5:47 pm

Re: Law School COA Calculator and Comparison Spreadsheet

Postby 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
Posts: 3875
Joined: Thu Jul 25, 2013 5:47 pm

Re: Law School COA Calculator and Comparison Spreadsheet

Postby 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?

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

Re: Law School COA Calculator and Comparison Spreadsheet

Postby 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
Posts: 3875
Joined: Thu Jul 25, 2013 5:47 pm

Re: Law School COA Calculator and Comparison Spreadsheet

Postby 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
Posts: 1696
Joined: Mon Feb 09, 2009 2:42 am

Re: Law School COA Calculator and Comparison Spreadsheet

Postby 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
Posts: 3875
Joined: Thu Jul 25, 2013 5:47 pm

Re: Law School COA Calculator and Comparison Spreadsheet

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




Return to “Choosing a Law School”

Who is online

Users browsing this forum: AspiringAspirant, Impressionist, SmokeytheBear and 9 guests