Debt Calculator: Forum

[DeeCee]

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.

Where is this spreadsheet?

[AreJay711]

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.

It would be hard to properly discount it since people can have different discount rates. For wealth maximization of a firm level you can assume the interest rate but on an individual level that isn't true and are facing multiple interest rates.

I like the calculator though even if it is kinda sketch for a non-regular to download it instead of piecing the info together from online calculators.

[Gatriel]

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.

Where is this spreadsheet?

Download links in the original post.

[Gatriel]

It would be hard to properly discount it since people can have different discount rates. For wealth maximization of a firm level you can assume the interest rate but on an individual level that isn't true and are facing multiple interest rates.

I like the calculator though even if it is kinda sketch for a non-regular to download it instead of piecing the info together from online calculators.

I think this is why I didn't include it. What discount rate could one use, prudently?

[fatduck]

It would be hard to properly discount it since people can have different discount rates. For wealth maximization of a firm level you can assume the interest rate but on an individual level that isn't true and are facing multiple interest rates.

I like the calculator though even if it is kinda sketch for a non-regular to download it instead of piecing the info together from online calculators.

I think this is why I didn't include it. What discount rate could one use, prudently?

for most people it's probably not necessary. at the most basic level you could use the rate of inflation. for someone who was doing a more complex comparative analysis (say, between law and an alternate career path), they might appreciate the ability to modify the rate to suit their needs.

[Gatriel]

[

for most people it's probably not necessary. at the most basic level you could use the rate of inflation. for someone who was doing a more complex comparative analysis (say, between law and an alternate career path), they might appreciate the ability to modify the rate to suit their needs.

One could do it at the rate of inflation, however that assumes a very very low to nill interest rate. I'm outlining right now. I'll do it tonight after dinner.

[pilchc]

Thanks OP.
This saved me a lot of time.

[Gatriel]

Yeah you're welcome dude.

[rundoxierun]

sticker at a top school comes to 10 yr. repayment plan of about 2500/month. lulz.

[Gatriel]

Yeah, lets hope you're pulling down $3500 a week so its NBD.

[005618502]

What should I put for interest rate if I plan to take out loans for full COA?

[maglialoro]

.

[pilchc]

This spreadsheet is awesome! But...
I changed computers. I am trying to download this calculator again and the link keeps sending me to a "free file hosting" site. I cannot find the spreadsheet. Any suggestions?

[YankeeFan2]

This spreadsheet is awesome! But...
I changed computers. I am trying to download this calculator again and the link keeps sending me to a "free file hosting" site. I cannot find the spreadsheet. Any suggestions?

Same here. ?????

[20130312]

Wait, does interest compound on law school loans? My UG loans only accrue interest on the principal.

[Gail]

Wait, does interest compound on law school loans? My UG loans only accrue interest on the principal.

I'm going to take a guess and say that the unsubsidized will. Subsidized will not accrue interest. So subtract the amount from subsidized and then add after 3 years.

I may be wrong with that though. I'm one of those that doesn't know how this works.

[Bronck]

Wait, does interest compound on law school loans? My UG loans only accrue interest on the principal.

I'm going to take a guess and say that the unsubsidized will. Subsidized will not accrue interest. So subtract the amount from subsidized and then add after 3 years.

I may be wrong with that though. I'm one of those that doesn't know how this works.

We don't got no subsidized loans no more. Congress got rid of em.

[Gail]

Wait, does interest compound on law school loans? My UG loans only accrue interest on the principal.

I'm going to take a guess and say that the unsubsidized will. Subsidized will not accrue interest. So subtract the amount from subsidized and then add after 3 years.

I may be wrong with that though. I'm one of those that doesn't know how this works.

We don't got no subsidized loans no more. Congress got rid of em.

Not even the loans from UG? The ones that you defer while going to LS? That would seriously suck.

[Bronck]

Wait, does interest compound on law school loans? My UG loans only accrue interest on the principal.

I'm going to take a guess and say that the unsubsidized will. Subsidized will not accrue interest. So subtract the amount from subsidized and then add after 3 years.

I may be wrong with that though. I'm one of those that doesn't know how this works.

We don't got no subsidized loans no more. Congress got rid of em.

Not even the loans from UG?

Oh well, if your UG loans are subsidized, then they'll remain subsidized. But all new loans will be unsubsidized.

[Mr. Pancakes]

that link didn't work, brah.

[20130312]

that link didn't work, brah.

It's two years old, brah.

Also, neither my subbed nor unsubbed UG loans have compound interest. Hell, even my private loan doesn't compound interest.

[izy223]

someone want to repost a link for us who didnt get there early enough

[Tiago Splitter]

Per vanwinkle in another thread that I can't find, interest does not compound while under IBR. So that 200K debt that you can't service will only be 350K instead of 400K when the tax bomb hits 20 years down the line. Everybody breathe a sigh of relief.

[005618502]

Wait, does interest compound on law school loans? My UG loans only accrue interest on the principal.

I'm going to take a guess and say that the unsubsidized will. Subsidized will not accrue interest. So subtract the amount from subsidized and then add after 3 years.

I may be wrong with that though. I'm one of those that doesn't know how this works.

We don't got no subsidized loans no more. Congress got rid of em.

Not even the loans from UG? The ones that you defer while going to LS? That would seriously suck.

I didnt know how this worked either, especially since I took a year off and am now paying on my loans. I just called, they said that once you defer payment due to being a full time student again, if the undergrad loans were subsidized they will once again have the interest payed by the gov while you are in law school.

Great news!

[Bronck]

Per vanwinkle in another thread that I can't find, interest does not compound while under IBR. So that 200K debt that you can't service will only be 350K instead of 400K when the tax bomb hits 20 years down the line. Everybody breathe a sigh of relief.

Oh man, what a treat.