Page 1 of 5

Law School COA Calculator and Comparison Spreadsheet - USE!!

Posted: Mon Feb 24, 2014 2:38 pm
by lawschool22
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

Re: Law School COA Calculator and Comparison Spreadsheet

Posted: Mon Feb 24, 2014 2:45 pm
by Gustave
Link, please. K thx!

Re: Law School COA Calculator and Comparison Spreadsheet

Posted: Mon Feb 24, 2014 2:46 pm
by lawschool22
Yeah I had it up but had to remove it for a specific reason. Will be back up soon.

Re: Law School COA Calculator and Comparison Spreadsheet

Posted: Mon Feb 24, 2014 2:48 pm
by Gustave
You're a scholar and a gentleman. Thank you, and I await another morsel of spreadsheet goodness from ya.

Re: Law School COA Calculator and Comparison Spreadsheet

Posted: Mon Feb 24, 2014 2:50 pm
by Gustave
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.

Re: Law School COA Calculator and Comparison Spreadsheet

Posted: Mon Feb 24, 2014 2:52 pm
by lawschool22
Link added.

Re: Law School COA Calculator and Comparison Spreadsheet

Posted: Mon Feb 24, 2014 2:54 pm
by lawschool22
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 :)

Re: Law School COA Calculator and Comparison Spreadsheet

Posted: Mon Feb 24, 2014 2:55 pm
by lawschool22
Actually I just noticed an error. Hold on everyone.

Re: Law School COA Calculator and Comparison Spreadsheet

Posted: Mon Feb 24, 2014 2:57 pm
by lawschool22
If you downloaded this prior to this post, you should re-download.

Re: Law School COA Calculator and Comparison Spreadsheet

Posted: Mon Feb 24, 2014 3:03 pm
by Cal Trask
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.

Re: Law School COA Calculator and Comparison Spreadsheet

Posted: Mon Feb 24, 2014 3:04 pm
by cotiger
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!

Re: Law School COA Calculator and Comparison Spreadsheet

Posted: Mon Feb 24, 2014 3:08 pm
by lawschool22
Yes the income items should be entered as negative numbers.

Re: Law School COA Calculator and Comparison Spreadsheet

Posted: Mon Feb 24, 2014 3:11 pm
by Cal Trask
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.

Re: Law School COA Calculator and Comparison Spreadsheet

Posted: Mon Feb 24, 2014 3:12 pm
by Kimikho
Thank you!!!

Re: Law School COA Calculator and Comparison Spreadsheet

Posted: Mon Feb 24, 2014 3:15 pm
by 04102014
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.

Re: Law School COA Calculator and Comparison Spreadsheet

Posted: Mon Feb 24, 2014 3:18 pm
by lawschool22
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 :)

Re: Law School COA Calculator and Comparison Spreadsheet

Posted: Mon Feb 24, 2014 3:23 pm
by AdInfinitum
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?

Re: Law School COA Calculator and Comparison Spreadsheet

Posted: Mon Feb 24, 2014 3:26 pm
by 04102014
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.

Re: Law School COA Calculator and Comparison Spreadsheet

Posted: Mon Feb 24, 2014 3:32 pm
by cotiger
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%

Re: Law School COA Calculator and Comparison Spreadsheet

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

Re: Law School COA Calculator and Comparison Spreadsheet

Posted: Mon Feb 24, 2014 3:37 pm
by lawschool22
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?

Re: Law School COA Calculator and Comparison Spreadsheet

Posted: Mon Feb 24, 2014 3:40 pm
by cotiger
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.

Re: Law School COA Calculator and Comparison Spreadsheet

Posted: Mon Feb 24, 2014 3:41 pm
by lawschool22
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.

Re: Law School COA Calculator and Comparison Spreadsheet

Posted: Mon Feb 24, 2014 3:43 pm
by 04102014
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?

Re: Law School COA Calculator and Comparison Spreadsheet

Posted: Mon Feb 24, 2014 3:44 pm
by lawschool22
In case you guys missed it, download the current version above to get the correct rates (should be 6.33 and 7.33)