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

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

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

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

Silver
Posts: 1005
Joined: Mon May 19, 2008 6:35 pm

Re: Law School COA Calculator and Comparison Spreadsheet

Post by 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

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

Want to continue reading?

Register now to search topics and post comments!

Absolutely FREE!


User avatar
jenesaislaw

Silver
Posts: 1005
Joined: Mon May 19, 2008 6:35 pm

Re: Law School COA Calculator and Comparison Spreadsheet

Post by 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

Silver
Posts: 1005
Joined: Mon May 19, 2008 6:35 pm

Re: Law School COA Calculator and Comparison Spreadsheet

Post by jenesaislaw » Mon Feb 24, 2014 5:30 pm

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

scootsy

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

Re: Law School COA Calculator and Comparison Spreadsheet

Post by 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

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

Want to continue reading?

Register for access!

Did I mention it was FREE ?


User avatar
jenesaislaw

Silver
Posts: 1005
Joined: Mon May 19, 2008 6:35 pm

Re: Law School COA Calculator and Comparison Spreadsheet

Post by 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

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

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

Silver
Posts: 1005
Joined: Mon May 19, 2008 6:35 pm

Re: Law School COA Calculator and Comparison Spreadsheet

Post by 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.

Register now!

Resources to assist law school applicants, students & graduates.

It's still FREE!


User avatar
barrelofmonkeys

Gold
Posts: 1942
Joined: Wed Jun 12, 2013 6:41 pm

Re: Law School COA Calculator and Comparison Spreadsheet

Post by barrelofmonkeys » Tue Feb 25, 2014 12:00 am

thanks ls22

User avatar
cron1834

Gold
Posts: 2299
Joined: Thu Jan 02, 2014 1:36 am

Re: Law School COA Calculator and Comparison Spreadsheet

Post by cron1834 » Tue Feb 25, 2014 12:22 am

This is a great effort and a great idea.

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 » 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

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

Re: Law School COA Calculator and Comparison Spreadsheet

Post by lawschool22 » Tue Feb 25, 2014 12:26 am

barrelofmonkeys wrote:thanks ls22
Where have you been all day?

Get unlimited access to all forums and topics

Register now!

I'm pretty sure I told you it's 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 » 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

Gold
Posts: 1942
Joined: Wed Jun 12, 2013 6:41 pm

Re: Law School COA Calculator and Comparison Spreadsheet

Post by 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

Gold
Posts: 1977
Joined: Fri Mar 22, 2013 3:11 pm

Re: Law School COA Calculator and Comparison Spreadsheet

Post by bombaysippin » Tue Feb 25, 2014 9:00 pm

This totally awesome. Thanks LS22!

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

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!


iskim88

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

Re: Law School COA Calculator and Comparison Spreadsheet

Post by iskim88 » Tue Mar 04, 2014 7:46 am

Tagging. Thanks! :)

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 » Thu Mar 13, 2014 10:21 am

bump

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 Mar 17, 2014 6:38 pm

cotiger wrote:bump
Added in separate COL and Tuition increase factors per your request.

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

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”