Law School COA Calculator and Comparison Spreadsheet - USE!!

(Rankings, Profiles, Tuition, Student Life, . . . )
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:53 pm

lawschool22 wrote:
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.


Lol no clue. Buuut here's historical data: http://www.multpl.com/interest-rate/table

It seems like it would be a good bet to assume it'll be somewhere between 3-5%. Considering it's better to end up with less debt than expected than more, I'd say go with something at least like 2.8>3.3>3.8

It's based on the yield on July 1.

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:57 pm

cotiger wrote:
Lol no clue. Buuut here's historical data: http://www.multpl.com/interest-rate/table

It seems like it would be a good bet to assume it'll be somewhere between 3-5%. Considering it's better to end up with less debt than expected than more, I'd say go with something at least like 2.8>3.3>3.8

It's based on the yield on July 1.


Okay, updated. I also fixed some formulas. They were all pulling the rate from year 1 instead of 1-3. So this may increase things slightly for people (sorry) :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 3:57 pm

I think this has the potential to freak some people out, but this is good. Better to be freaked out now than three years from now when it's real.

User avatar
jenesaislaw
Posts: 1006
Joined: Mon May 19, 2008 6:35 pm

Re: Law School COA Calculator and Comparison Spreadsheet

Postby jenesaislaw » Mon Feb 24, 2014 5:25 pm

Where'd you get that grad plus loan fee from? I thought it was 4.228%.

Glad to see you've put in this work, though. I know you're one of the people who will participate in the LST Beta. An email is coming very soon (tonight), and we have a feature that's very similar to this. I just tested with NYU, but we seem to be getting pretty similar numbers. The main difference I see so far is that we're using a different grad plus loan fee; the spreadsheet does not treat disbursements by semester (I think, I wasn't too careful in concluding that); and the interest rates within a year are not tied to one another like they should be.

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 5:26 pm

jenesaislaw wrote:Where'd you get that grad plus loan fee from? I thought it was 4.228%.

Glad to see you've put in this work, though. I know you're one of the people who will participate in the LST Beta. An email is coming very soon (tonight), and we have a feature that's very similar to this. I just tested with NYU, but we seem to be getting pretty similar numbers. The main difference I see so far is that we're using a different grad plus loan fee; the spreadsheet does not treat disbursements by semester (I think, I wasn't too careful in concluding that); and the interest rates within a year are not tied to one another like they should be.


Fixed the GradPlus rate (I think it was a typo). And no mine doesn't treat it by semester. I was too lazy to do that :D. Could you elaborate on the interest rate comment? I'd like to fix it if necessary.

User avatar
jenesaislaw
Posts: 1006
Joined: Mon May 19, 2008 6:35 pm

Re: Law School COA Calculator and Comparison Spreadsheet

Postby jenesaislaw » Mon Feb 24, 2014 5:27 pm

Stafford loans are fixed rate loans provided by the federal government to students attending graduate school at least half-time. Currently, only unsubsidized Stafford loans are available for graduate students, who may borrow up to $20,500 a year at a rate equal to the 10-year Treasury yield plus 3.6% (capped at 9.5%). The rate for the 2013-2014 academic year is 5.41%, with a 1.0% loan origination fee. Interest accrues from the time the loan is disbursed until the time the loan is repaid in full, but no payments are required until six months after graduation. There are no interest subsidies.

GradPLUS loans are fixed rate loans provided by the federal government to students attending graduate school at least half-time. Unlike Stafford loans, these loans have no limits and students may borrow up to the COA less any other financial aid they have secured at a rate equal to the 10-year Treasury yield plus 4.6% (capped at 10.5%). The rate for the 2013-2014 academic year is 6.41%, with a 4.228% loan origination fee for the 2013-2014 school year. Interest accrues from the time the loan is disbursed until the time the loan is repaid in full, but no payments are required until six months after graduation. There are no interest subsidies.
Last edited by jenesaislaw on Mon Feb 24, 2014 5:33 pm, edited 1 time in total.

User avatar
jenesaislaw
Posts: 1006
Joined: Mon May 19, 2008 6:35 pm

Re: Law School COA Calculator and Comparison Spreadsheet

Postby jenesaislaw » Mon Feb 24, 2014 5:30 pm

I just copy and pasted that from the new LST site.

scootsy
Posts: 21
Joined: Wed Jan 22, 2014 6:44 pm

Re: Law School COA Calculator and Comparison Spreadsheet

Postby scootsy » Mon Feb 24, 2014 6:41 pm

Thanks for this. Quite useful.

Can anyone comment on the accuracy of school's other expense estimates such as R&B and transportation?

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 6:51 pm

One thing I was thinking about, this may be slightly overestimating interest amounts. Does anyone know how the interest on federal loans compounds? Does it just accrue until 6 months after graduation, at which point it is then capitalized? If that's the case I will need to tweak the calc a bit (although I doubt it will have a major effect on the final number).

User avatar
jenesaislaw
Posts: 1006
Joined: Mon May 19, 2008 6:35 pm

Re: Law School COA Calculator and Comparison Spreadsheet

Postby jenesaislaw » Mon Feb 24, 2014 6:58 pm

lawschool22 wrote:One thing I was thinking about, this may be slightly overestimating interest amounts. Does anyone know how the interest on federal loans compounds? Does it just accrue until 6 months after graduation, at which point it is then capitalized? If that's the case I will need to tweak the calc a bit (although I doubt it will have a major effect on the final number).


Interest accrues on each loan's disbursement amount (by semester) until 6 months after graduation and then it capitalizes. Then interest starts accruing on each loan's new balance.

Why do you think you're overestimating?

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 7:18 pm

jenesaislaw wrote:
lawschool22 wrote:One thing I was thinking about, this may be slightly overestimating interest amounts. Does anyone know how the interest on federal loans compounds? Does it just accrue until 6 months after graduation, at which point it is then capitalized? If that's the case I will need to tweak the calc a bit (although I doubt it will have a major effect on the final number).


Interest accrues on each loan's disbursement amount (by semester) until 6 months after graduation and then it capitalizes. Then interest starts accruing on each loan's new balance.

Why do you think you're overestimating?


My calc is compounding interest annually, so it is charging interest on interest.

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 7:48 pm

lawschool22 wrote:
jenesaislaw wrote:Where'd you get that grad plus loan fee from? I thought it was 4.228%.

Glad to see you've put in this work, though. I know you're one of the people who will participate in the LST Beta. An email is coming very soon (tonight), and we have a feature that's very similar to this. I just tested with NYU, but we seem to be getting pretty similar numbers. The main difference I see so far is that we're using a different grad plus loan fee; the spreadsheet does not treat disbursements by semester (I think, I wasn't too careful in concluding that); and the interest rates within a year are not tied to one another like they should be.


Fixed the GradPlus rate (I think it was a typo). And no mine doesn't treat it by semester. I was too lazy to do that :D. Could you elaborate on the interest rate comment? I'd like to fix it if necessary.


You had it right the first time. Gradplus loan fee is 4.288%

http://studentaid.ed.gov/types/loans/plus

User avatar
jenesaislaw
Posts: 1006
Joined: Mon May 19, 2008 6:35 pm

Re: Law School COA Calculator and Comparison Spreadsheet

Postby jenesaislaw » Mon Feb 24, 2014 8:01 pm

cotiger wrote:
lawschool22 wrote:
jenesaislaw wrote:Where'd you get that grad plus loan fee from? I thought it was 4.228%.

Glad to see you've put in this work, though. I know you're one of the people who will participate in the LST Beta. An email is coming very soon (tonight), and we have a feature that's very similar to this. I just tested with NYU, but we seem to be getting pretty similar numbers. The main difference I see so far is that we're using a different grad plus loan fee; the spreadsheet does not treat disbursements by semester (I think, I wasn't too careful in concluding that); and the interest rates within a year are not tied to one another like they should be.


Fixed the GradPlus rate (I think it was a typo). And no mine doesn't treat it by semester. I was too lazy to do that :D. Could you elaborate on the interest rate comment? I'd like to fix it if necessary.


You had it right the first time. Gradplus loan fee is 4.288%

http://studentaid.ed.gov/types/loans/plus


Good find, it's been updated since I last checked.

User avatar
barrelofmonkeys
Posts: 1939
Joined: Wed Jun 12, 2013 6:41 pm

Re: Law School COA Calculator and Comparison Spreadsheet

Postby barrelofmonkeys » Tue Feb 25, 2014 12:00 am

thanks ls22

User avatar
cron1834
Posts: 2258
Joined: Thu Jan 02, 2014 1:36 am

Re: Law School COA Calculator and Comparison Spreadsheet

Postby cron1834 » Tue Feb 25, 2014 12:22 am

This is a great effort and a great idea.

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

Re: Law School COA Calculator and Comparison Spreadsheet

Postby lawschool22 » Tue Feb 25, 2014 12:26 am

You're all very welcome. There may be a few more tweaks here and there. I'll post anytime there is an update.

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

Re: Law School COA Calculator and Comparison Spreadsheet

Postby lawschool22 » Tue Feb 25, 2014 12:26 am

barrelofmonkeys wrote:thanks ls22


Where have you been all day?

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

Re: Law School COA Calculator and Comparison Spreadsheet

Postby lawschool22 » Tue Feb 25, 2014 10:57 am

New version (1.4) with updated calculations (more accurate) and instructions. I will now track this by version so you can see if you have the latest update.

This will probably show you around $6k or so less repayment at graduation.

Also added a feature where you can enter in your expected grace period (0-6 months) to estimate what it will be when you actually start repayment.

User avatar
barrelofmonkeys
Posts: 1939
Joined: Wed Jun 12, 2013 6:41 pm

Re: Law School COA Calculator and Comparison Spreadsheet

Postby barrelofmonkeys » Tue Feb 25, 2014 11:06 am

lawschool22 wrote:
barrelofmonkeys wrote:thanks ls22


Where have you been all day?


so busy :(

User avatar
bombaysippin
Posts: 1977
Joined: Fri Mar 22, 2013 3:11 pm

Re: Law School COA Calculator and Comparison Spreadsheet

Postby bombaysippin » Tue Feb 25, 2014 9:00 pm

This totally awesome. Thanks LS22!

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

Re: Law School COA Calculator and Comparison Spreadsheet

Postby cotiger » Tue Mar 04, 2014 2:09 am

Bump

Also, LS22, I have another suggestion. Tuition+fees and COL increase at different rates. Tuition+fees at about 4.5%, and COL at about 2%. Maybe separate that out instead of giving everything the same rate of increase?

iskim88
Posts: 130
Joined: Mon May 17, 2010 5:21 am

Re: Law School COA Calculator and Comparison Spreadsheet

Postby iskim88 » Tue Mar 04, 2014 7:46 am

Tagging. Thanks! :)

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

Re: Law School COA Calculator and Comparison Spreadsheet

Postby cotiger » Thu Mar 13, 2014 10:21 am

bump

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

Re: Law School COA Calculator and Comparison Spreadsheet

Postby lawschool22 » Mon Mar 17, 2014 6:38 pm

cotiger wrote:bump


Added in separate COL and Tuition increase factors per your request.

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

Re: Law School COA Calculator and Comparison Spreadsheet

Postby cotiger » Mon Mar 17, 2014 10:16 pm

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.




Return to “Choosing a Law School”

Who is online

Users browsing this forum: No registered users and 4 guests