Breakdown of Debt

(Rankings, Profiles, Tuition, Student Life, . . . )
User avatar
hobie2515
Posts: 98
Joined: Thu Mar 03, 2011 4:12 pm

Breakdown of Debt

Postby hobie2515 » Sat Jan 26, 2013 1:39 pm

Good morning everyone. I have created a spreadsheet which some people may find useful. Essentially it breaks down and compares student loan amounts, calculates interest and shows how long it would take to pay the balance off, depending on a few variables. The highlighted cells are variables and can be changed to your own situation.

For example, just looking at the numbers I have entered, you can see "School A" requires around $44,000 in loans each year while "School B" requires nothing (however you pulled it off). School A has a starting salary of $70,000 while School B is $55,000. I entered an estimated 3% in annual salary growth and then allocated 25% of the annual salary to pay of the loan balance. Obviously everyone and every job is different so you can change them to your own hypothetical situation. The spreadsheet then takes that allotted money and begins to pay off your loan balance, starting with the highest interest loan, moving on to the next highest loan rate, and paying them off until all your loans are paid. Once they are paid off it just takes your entire salary and counts it as net revenue. So you can see in the example School A takes 12 years to pay off, but after 32 years of work end up making a higher net than School B.

Obviously there are shortcomings to this spreadsheet so please don't rip me apart. If you have constructive criticism or thoughts on how to improve the spreadsheet, I welcome your thoughts. I am aware these are all broad estimations and that there are numerous other components (cost of living, job situation, etc.) that are not factored in. This is just to give you a very basic idea of student debt, paying off loans and how it all affects you in the long run. Hope this helps a few people.

https://docs.google.com/a/elon.edu/spre ... odXc#gid=0

User avatar
dingbat
Posts: 4976
Joined: Wed Jan 11, 2012 9:12 pm

Re: Breakdown of Debt

Postby dingbat » Sat Jan 26, 2013 1:56 pm


User avatar
hobie2515
Posts: 98
Joined: Thu Mar 03, 2011 4:12 pm

Re: Breakdown of Debt

Postby hobie2515 » Sat Jan 26, 2013 2:13 pm

Yup go right ahead.

User avatar
hobie2515
Posts: 98
Joined: Thu Mar 03, 2011 4:12 pm

Re: Breakdown of Debt

Postby hobie2515 » Sat Jan 26, 2013 2:30 pm

Here is the file in case anyone wants it to have for their own to play around with. Might be better since Google Docs is a little more difficult to work with.

http://www.filedropper.com/budgetnumbers

User avatar
North
Posts: 4041
Joined: Wed Mar 02, 2011 7:09 pm

Re: Breakdown of Debt

Postby North » Sat Jan 26, 2013 3:08 pm

Nicely done.

lawhaus
Posts: 64
Joined: Tue Jan 17, 2012 11:08 pm

Re: Breakdown of Debt

Postby lawhaus » Sat Jan 26, 2013 5:32 pm

What's the difference between un-subsidized and subsidized stafford loans.
I thought the latter doesn't exist anymore

User avatar
hobie2515
Posts: 98
Joined: Thu Mar 03, 2011 4:12 pm

Re: Breakdown of Debt

Postby hobie2515 » Sat Jan 26, 2013 5:59 pm

lawhaus wrote:What's the difference between un-subsidized and subsidized stafford loans.
I thought the latter doesn't exist anymore


You are correct there is no difference anymore. I created this last year when I believe the subsidized was still available. What it does in this spreadsheet is the total loan balance for the subsidized loan balance doesn't accrue interest for the first 3 years. Rather than go back and change this I just left it because a) I'm lazy and b) it's just and additional $3500 in initial interest so it's not going to severely affect the point at which your loans would be paid off.




Return to “Choosing a Law School”

Who is online

Users browsing this forum: Baidu [Spider], charmonster, kolikotime and 2 guests