Debt Calculator:

(Rankings, Profiles, Tuition, Student Life, . . . )
User avatar
Gatriel
Posts: 2015
Joined: Tue Sep 22, 2009 11:30 pm

Debt Calculator:

Postby Gatriel » Thu Apr 15, 2010 3:45 pm

Hey All:

So I know money can be a huge deciding factor when choosing a law school. I put this TVM calculator together, to help you guys get a better idea as to how much you would actually owe upon graduating from law school, as well as how much your monthly payment would be.

From my experience on the forum a good chunk of people don't know how to calculate compound interest. So when they calculate law school debt they take $120,000 * .05 and ah-ha that is what I must owe.

There are a ton of calculators online, however I didn't find one that broke the calculation down into individual years with differing loan amounts and the possibility of differing interest rates. That way people who go to an expensive school with scholarship which requires one to stay top 1/3rd or top 4% or top 50% can calculate how much it would cost if they lost their scholarship after the first year. As well as how much it would cost to do all 3 years at sticker.

If you have any suggestions on how I could better this, please shoot it my way.

Office 07:

Download here.

Office 03:

Download here.

Image
Last edited by Gatriel on Fri Feb 18, 2011 3:07 am, edited 10 times in total.

User avatar
JTX
Posts: 280
Joined: Mon Feb 08, 2010 12:23 pm

Re: Debt Calculator:

Postby JTX » Thu Apr 15, 2010 3:46 pm

i always download from strange links on message boards. anyone want to be first to make sure gatriel is not an evil ID theft from China?

User avatar
Gatriel
Posts: 2015
Joined: Tue Sep 22, 2009 11:30 pm

Re: Debt Calculator:

Postby Gatriel » Thu Apr 15, 2010 3:48 pm

Almost . . . .

Image

csgrant5
Posts: 13
Joined: Fri Mar 26, 2010 3:06 pm

Re: Debt Calculator:

Postby csgrant5 » Fri Apr 16, 2010 2:38 am

Could you post a .xls version?

Thx

User avatar
darknightbegins
Posts: 673
Joined: Sun Jan 31, 2010 11:51 pm

Re: Debt Calculator:

Postby darknightbegins » Fri Apr 16, 2010 3:07 am

Gatriel wrote:Almost . . . .

Image


Haha shit I want to make that pic my Tar

User avatar
thetheme
Posts: 3
Joined: Thu Apr 15, 2010 3:53 pm

Re: Debt Calculator:

Postby thetheme » Fri Apr 16, 2010 3:16 am

Just curious, why take the time to put together something that is both freely available and ubiquitous online? Does it do something special like file my 1040 at the end of the year?

User avatar
Gatriel
Posts: 2015
Joined: Tue Sep 22, 2009 11:30 pm

Re: Debt Calculator:

Postby Gatriel » Fri Apr 16, 2010 9:32 am

csgrant5 wrote:Could you post a .xls version?

Thx


Done.

thetheme wrote:Just curious, why take the time to put together something that is both freely available and ubiquitous online? Does it do something special like file my 1040 at the end of the year?


From my experience on the forum a good chunk of people don't know how to calculate compound interest. So when they go to calculated law school debt they take $120,000 * .05 and ah-ha that is what I must owe.

There are a ton of calculators online, however I didn't find one that broke the calculation down into individual years with differing loan amounts and the possibility of differing interest rates. That way people who go to an expense school with scholarship which requires one to stay top 1/3rd can calculate how much it would cost if they lost their scholarship after the first year.

User avatar
Dtackpat75
Posts: 217
Joined: Mon Apr 13, 2009 4:28 pm

Re: Debt Calculator:

Postby Dtackpat75 » Fri Apr 16, 2010 9:41 am

Pretty solid. And online with what my estimates had been.

User avatar
thetheme
Posts: 3
Joined: Thu Apr 15, 2010 3:53 pm

Re: Debt Calculator:

Postby thetheme » Fri Apr 16, 2010 3:09 pm

That looks nice, and very well laid out. Do you think you could work in differing debt and interest rates especially for differing loans that are capped at certain amounts? It seems unrealistic that you would take out a single loan at a single interest rate each year, but instead would be more likely to have subsidized, unsubsidized and possibly private loans all compounding at different interest rates.

User avatar
Dtackpat75
Posts: 217
Joined: Mon Apr 13, 2009 4:28 pm

Re: Debt Calculator:

Postby Dtackpat75 » Fri Apr 16, 2010 3:10 pm

Just come up with your own aggregate interest rate for the year.

User avatar
Gatriel
Posts: 2015
Joined: Tue Sep 22, 2009 11:30 pm

Re: Debt Calculator:

Postby Gatriel » Fri Apr 16, 2010 3:18 pm

thetheme wrote:That looks nice, and very well laid out. Do you think you could work in differing debt and interest rates especially for differing loans that are capped at certain amounts? It seems unrealistic that you would take out a single loan at a single interest rate each year, but instead would be more likely to have subsidized, unsubsidized and possibly private loans all compounding at different interest rates.


Yeah, I'll put up to 3 separate loans per year. If you look at the formulas I have each year chopping the borrowed amount in half, and distributing it per semester.

Good idea tho. Shouldn't be too challenging.

User avatar
stintez
Posts: 307
Joined: Fri Apr 02, 2010 12:55 pm

Re: Debt Calculator:

Postby stintez » Fri Apr 16, 2010 3:22 pm

What are interest and term lengths on average anyone?

User avatar
Gatriel
Posts: 2015
Joined: Tue Sep 22, 2009 11:30 pm

Re: Debt Calculator:

Postby Gatriel » Fri Apr 16, 2010 3:22 pm

stintez wrote:What are interest and term lengths on average anyone?


Many people shoot for complete repayment in a decade after graduation. Loan consolidations . . . . if your credit is good can get down to 3% right now.

User avatar
Gatriel
Posts: 2015
Joined: Tue Sep 22, 2009 11:30 pm

Re: Debt Calculator:

Postby Gatriel » Tue Jan 25, 2011 3:23 am

I just ran across this again from last year. I plugged in all my info, and still want to

--ImageRemoved--

FiveSermon
Posts: 1507
Joined: Tue Dec 14, 2010 6:56 pm

Re: Debt Calculator:

Postby FiveSermon » Fri Feb 18, 2011 2:33 am

Tag for future reference.

User avatar
sundance95
Posts: 2123
Joined: Wed Jun 09, 2010 7:44 pm

Re: Debt Calculator:

Postby sundance95 » Fri Feb 18, 2011 2:37 am

Word, this rules, should be stickied. Online calculators have really sucked in my experience. Thanks to OP.

User avatar
Gatriel
Posts: 2015
Joined: Tue Sep 22, 2009 11:30 pm

Re: Debt Calculator:

Postby Gatriel » Fri Feb 18, 2011 2:56 am

Agreed. Admin. . . . sticky this?

salvage
Posts: 113
Joined: Thu Sep 16, 2010 5:10 pm

Re: Debt Calculator:

Postby salvage » Fri Feb 18, 2011 4:22 pm

I'm an excel idiot. I'm confused, I plugged in the cost and scholly info, but how do I get it to run the cost for each year? When I try to click on "Amount Owed..." it just says "The Guts..."

User avatar
Gatriel
Posts: 2015
Joined: Tue Sep 22, 2009 11:30 pm

Re: Debt Calculator:

Postby Gatriel » Sat Feb 19, 2011 3:04 am

Did you download the correct version?

Delete it and try again. I tested this pretty hard before releasing it out on here. Hopefully it is just an easy fix. If you keep having problems, PM me and we'll get it figured out.

Peg
Posts: 331
Joined: Tue Jul 14, 2009 4:32 am

Re: Debt Calculator:

Postby Peg » Sat Feb 19, 2011 4:37 am

Thanks this looks neatly put together. Pretty much lines up with what I estimated for myself.

User avatar
Gatriel
Posts: 2015
Joined: Tue Sep 22, 2009 11:30 pm

Re: Debt Calculator:

Postby Gatriel » Sat Feb 19, 2011 5:55 pm

I'm glad it worked out well for you man.

User avatar
northwood
Posts: 4872
Joined: Fri May 14, 2010 7:29 pm

Re: Debt Calculator:

Postby northwood » Sat Feb 19, 2011 6:01 pm

thanks OP!

User avatar
Gatriel
Posts: 2015
Joined: Tue Sep 22, 2009 11:30 pm

Re: Debt Calculator:

Postby Gatriel » Sat Feb 19, 2011 6:04 pm

You are welcome.

User avatar
fatduck
Posts: 4186
Joined: Mon Sep 13, 2010 10:16 pm

Re: Debt Calculator:

Postby fatduck » Sat Feb 19, 2011 6:08 pm

nice spreadsheet

you might want to calculate the present value of the loans, though? that way people could numerically quantify their "debt aversion" via discount rate.

User avatar
Gatriel
Posts: 2015
Joined: Tue Sep 22, 2009 11:30 pm

Re: Debt Calculator:

Postby Gatriel » Sat Feb 19, 2011 6:20 pm

fatduck wrote:nice spreadsheet

you might want to calculate the present value of the loans, though? that way people could numerically quantify their "debt aversion" via discount rate.


That is a good idea. When I built the spreadsheet I thought about that, decided not to do it, but not I forgot why. I'll add that in later today.




Return to “Choosing a Law School”

Who is online

Users browsing this forum: izha, MikkelVilla and 3 guests