Spreadsheets/calculators for LS debt repayment and budgeting from 1L - 3L. Forum
- MrJD2020
- Posts: 277
- Joined: Thu Jan 26, 2017 10:59 am
Spreadsheets/calculators for LS debt repayment and budgeting from 1L - 3L.
Anyone know of any good ones? Looking for two things:
1. Good spreadsheet I can use to track how much debt I'm accruing and how long it'd take to pay it off. Something where I can plug in amounts of debt taken out and when (using disbursement dates for each semester), the interest rates of the debt, the amount of each loan outstanding, and then a payoff trajectory (where I plug in the monthly amount I would pay toward each loan and the date I start paying off that loan).
2. LS budgeting spreadsheet. I've been working for years but budgeting with an income is a bit different than budgeting the use of student loan funds since you really only get "paid" a few times a year and have to plan months ahead, as well as plan for the summer (which I'm not totally familiar with).
1. Good spreadsheet I can use to track how much debt I'm accruing and how long it'd take to pay it off. Something where I can plug in amounts of debt taken out and when (using disbursement dates for each semester), the interest rates of the debt, the amount of each loan outstanding, and then a payoff trajectory (where I plug in the monthly amount I would pay toward each loan and the date I start paying off that loan).
2. LS budgeting spreadsheet. I've been working for years but budgeting with an income is a bit different than budgeting the use of student loan funds since you really only get "paid" a few times a year and have to plan months ahead, as well as plan for the summer (which I'm not totally familiar with).
-
- Posts: 200
- Joined: Tue May 24, 2016 12:30 pm
Re: Spreadsheets/calculators for LS debt repayment and budgeting from 1L - 3L.
I like your idea for 1. I'll try to make it tonight after work and would be happy to send it to you. Just do you happen to know if you take out loans in 3 different year from the same source (e.g. Stafford) does that get aggregated into 1 amount or are they considered 3 separate loans?MrJD2020 wrote:Anyone know of any good ones? Looking for two things:
1. Good spreadsheet I can use to track how much debt I'm accruing and how long it'd take to pay it off. Something where I can plug in amounts of debt taken out and when (using disbursement dates for each semester), the interest rates of the debt, the amount of each loan outstanding, and then a payoff trajectory (where I plug in the monthly amount I would pay toward each loan and the date I start paying off that loan).
2. LS budgeting spreadsheet. I've been working for years but budgeting with an income is a bit different than budgeting the use of student loan funds since you really only get "paid" a few times a year and have to plan months ahead, as well as plan for the summer (which I'm not totally familiar with).
- MrJD2020
- Posts: 277
- Joined: Thu Jan 26, 2017 10:59 am
Re: Spreadsheets/calculators for LS debt repayment and budgeting from 1L - 3L.
Thanks very much, that would be so helpful. I am 99% sure that loans from different years are considered separate loans -- they certainly are for undergraduate federal loans, so I assume the same happens with graduate loans (whether subsidized or not). I would expect to have at least six loans - sub and unsub for each year .CPA-->JD wrote:I like your idea for 1. I'll try to make it tonight after work and would be happy to send it to you. Just do you happen to know if you take out loans in 3 different year from the same source (e.g. Stafford) does that get aggregated into 1 amount or are they considered 3 separate loans?MrJD2020 wrote:Anyone know of any good ones? Looking for two things:
1. Good spreadsheet I can use to track how much debt I'm accruing and how long it'd take to pay it off. Something where I can plug in amounts of debt taken out and when (using disbursement dates for each semester), the interest rates of the debt, the amount of each loan outstanding, and then a payoff trajectory (where I plug in the monthly amount I would pay toward each loan and the date I start paying off that loan).
2. LS budgeting spreadsheet. I've been working for years but budgeting with an income is a bit different than budgeting the use of student loan funds since you really only get "paid" a few times a year and have to plan months ahead, as well as plan for the summer (which I'm not totally familiar with).
-
- Posts: 200
- Joined: Tue May 24, 2016 12:30 pm
Re: Spreadsheets/calculators for LS debt repayment and budgeting from 1L - 3L.
Ok thanks. And by sub you mean the interest doesn't accrue until x months after graduation? Are any of the loans we can take out subsidized?MrJD2020 wrote:Thanks very much, that would be so helpful. I am 99% sure that loans from different years are considered separate loans -- they certainly are for undergraduate federal loans, so I assume the same happens with graduate loans (whether subsidized or not). I would expect to have at least six loans - sub and unsub for each year .CPA-->JD wrote:I like your idea for 1. I'll try to make it tonight after work and would be happy to send it to you. Just do you happen to know if you take out loans in 3 different year from the same source (e.g. Stafford) does that get aggregated into 1 amount or are they considered 3 separate loans?MrJD2020 wrote:Anyone know of any good ones? Looking for two things:
1. Good spreadsheet I can use to track how much debt I'm accruing and how long it'd take to pay it off. Something where I can plug in amounts of debt taken out and when (using disbursement dates for each semester), the interest rates of the debt, the amount of each loan outstanding, and then a payoff trajectory (where I plug in the monthly amount I would pay toward each loan and the date I start paying off that loan).
2. LS budgeting spreadsheet. I've been working for years but budgeting with an income is a bit different than budgeting the use of student loan funds since you really only get "paid" a few times a year and have to plan months ahead, as well as plan for the summer (which I'm not totally familiar with).
- MrJD2020
- Posts: 277
- Joined: Thu Jan 26, 2017 10:59 am
Re: Spreadsheets/calculators for LS debt repayment and budgeting from 1L - 3L.
Yes, the "subsidized" loans are those for which the interest does not accrue until 6 months after graduation.CPA-->JD wrote:Ok thanks. And by sub you mean the interest doesn't accrue until x months after graduation? Are any of the loans we can take out subsidized?MrJD2020 wrote:Thanks very much, that would be so helpful. I am 99% sure that loans from different years are considered separate loans -- they certainly are for undergraduate federal loans, so I assume the same happens with graduate loans (whether subsidized or not). I would expect to have at least six loans - sub and unsub for each year .CPA-->JD wrote:I like your idea for 1. I'll try to make it tonight after work and would be happy to send it to you. Just do you happen to know if you take out loans in 3 different year from the same source (e.g. Stafford) does that get aggregated into 1 amount or are they considered 3 separate loans?MrJD2020 wrote:Anyone know of any good ones? Looking for two things:
1. Good spreadsheet I can use to track how much debt I'm accruing and how long it'd take to pay it off. Something where I can plug in amounts of debt taken out and when (using disbursement dates for each semester), the interest rates of the debt, the amount of each loan outstanding, and then a payoff trajectory (where I plug in the monthly amount I would pay toward each loan and the date I start paying off that loan).
2. LS budgeting spreadsheet. I've been working for years but budgeting with an income is a bit different than budgeting the use of student loan funds since you really only get "paid" a few times a year and have to plan months ahead, as well as plan for the summer (which I'm not totally familiar with).
I originally thought all federal graduate loans were "unsubsidized" (i.e., interest accruing from disbursement date). While both the Direct Stafford (which caps at $20,500), and the Direct Graduate PLUS (up to full need, minus other loans/grants) are unsubsidized, the Federal Perkins Loan actually IS subsidized. It's capped at $8,000 a year for grad students but not every school offers it. They generally only offer it for students with truly "exceptional" need and you'd have to ask your finaid office about it. I don't know if I'm eligible yet.
There may also be subsidized institutional loans (i.e., from the school, not the federal government), but not many schools do this and again it's for exceptional circumstances. If possible to track five loans for each semester in your spreadsheet that might be best, to cover all bases (Stafford, Grad PLUS, Perkins, Institutional and Private).
Want to continue reading?
Register now to search topics and post comments!
Absolutely FREE!
Already a member? Login
-
- Posts: 200
- Joined: Tue May 24, 2016 12:30 pm
Re: Spreadsheets/calculators for LS debt repayment and budgeting from 1L - 3L.
Ok sweet. I'll definitely try to build it all in. It might take me a while to make a clean interface but I'll try to do it as quickly as possible.MrJD2020 wrote:Yes, the "subsidized" loans are those for which the interest does not accrue until 6 months after graduation.CPA-->JD wrote:Ok thanks. And by sub you mean the interest doesn't accrue until x months after graduation? Are any of the loans we can take out subsidized?MrJD2020 wrote:Thanks very much, that would be so helpful. I am 99% sure that loans from different years are considered separate loans -- they certainly are for undergraduate federal loans, so I assume the same happens with graduate loans (whether subsidized or not). I would expect to have at least six loans - sub and unsub for each year .CPA-->JD wrote:I like your idea for 1. I'll try to make it tonight after work and would be happy to send it to you. Just do you happen to know if you take out loans in 3 different year from the same source (e.g. Stafford) does that get aggregated into 1 amount or are they considered 3 separate loans?MrJD2020 wrote:Anyone know of any good ones? Looking for two things:
1. Good spreadsheet I can use to track how much debt I'm accruing and how long it'd take to pay it off. Something where I can plug in amounts of debt taken out and when (using disbursement dates for each semester), the interest rates of the debt, the amount of each loan outstanding, and then a payoff trajectory (where I plug in the monthly amount I would pay toward each loan and the date I start paying off that loan).
2. LS budgeting spreadsheet. I've been working for years but budgeting with an income is a bit different than budgeting the use of student loan funds since you really only get "paid" a few times a year and have to plan months ahead, as well as plan for the summer (which I'm not totally familiar with).
I originally thought all federal graduate loans were "unsubsidized" (i.e., interest accruing from disbursement date). While both the Direct Stafford (which caps at $20,500), and the Direct Graduate PLUS (up to full need, minus other loans/grants) are unsubsidized, the Federal Perkins Loan actually IS subsidized. It's capped at $8,000 a year for grad students but not every school offers it. They generally only offer it for students with truly "exceptional" need and you'd have to ask your finaid office about it. I don't know if I'm eligible yet.
There may also be subsidized institutional loans (i.e., from the school, not the federal government), but not many schools do this and again it's for exceptional circumstances. If possible to track five loans for each semester in your spreadsheet that might be best, to cover all bases (Stafford, Grad PLUS, Perkins, Institutional and Private).
-
- Posts: 200
- Joined: Tue May 24, 2016 12:30 pm
Re: Spreadsheets/calculators for LS debt repayment and budgeting from 1L - 3L.
Hey I had a minute a to set one up. How do I send it to you?CPA-->JD wrote:Ok sweet. I'll definitely try to build it all in. It might take me a while to make a clean interface but I'll try to do it as quickly as possible.MrJD2020 wrote:Yes, the "subsidized" loans are those for which the interest does not accrue until 6 months after graduation.CPA-->JD wrote:Ok thanks. And by sub you mean the interest doesn't accrue until x months after graduation? Are any of the loans we can take out subsidized?MrJD2020 wrote:Thanks very much, that would be so helpful. I am 99% sure that loans from different years are considered separate loans -- they certainly are for undergraduate federal loans, so I assume the same happens with graduate loans (whether subsidized or not). I would expect to have at least six loans - sub and unsub for each year .CPA-->JD wrote:I like your idea for 1. I'll try to make it tonight after work and would be happy to send it to you. Just do you happen to know if you take out loans in 3 different year from the same source (e.g. Stafford) does that get aggregated into 1 amount or are they considered 3 separate loans?MrJD2020 wrote:Anyone know of any good ones? Looking for two things:
1. Good spreadsheet I can use to track how much debt I'm accruing and how long it'd take to pay it off. Something where I can plug in amounts of debt taken out and when (using disbursement dates for each semester), the interest rates of the debt, the amount of each loan outstanding, and then a payoff trajectory (where I plug in the monthly amount I would pay toward each loan and the date I start paying off that loan).
2. LS budgeting spreadsheet. I've been working for years but budgeting with an income is a bit different than budgeting the use of student loan funds since you really only get "paid" a few times a year and have to plan months ahead, as well as plan for the summer (which I'm not totally familiar with).
I originally thought all federal graduate loans were "unsubsidized" (i.e., interest accruing from disbursement date). While both the Direct Stafford (which caps at $20,500), and the Direct Graduate PLUS (up to full need, minus other loans/grants) are unsubsidized, the Federal Perkins Loan actually IS subsidized. It's capped at $8,000 a year for grad students but not every school offers it. They generally only offer it for students with truly "exceptional" need and you'd have to ask your finaid office about it. I don't know if I'm eligible yet.
There may also be subsidized institutional loans (i.e., from the school, not the federal government), but not many schools do this and again it's for exceptional circumstances. If possible to track five loans for each semester in your spreadsheet that might be best, to cover all bases (Stafford, Grad PLUS, Perkins, Institutional and Private).
I also assumed the interest from year 1 is not capitalized and compounded for the next 2 years, etc.
- MrJD2020
- Posts: 277
- Joined: Thu Jan 26, 2017 10:59 am
Re: Spreadsheets/calculators for LS debt repayment and budgeting from 1L - 3L.
Will PM you now.CPA-->JD wrote:Hey I had a minute a to set one up. How do I send it to you?CPA-->JD wrote:Ok sweet. I'll definitely try to build it all in. It might take me a while to make a clean interface but I'll try to do it as quickly as possible.MrJD2020 wrote:Yes, the "subsidized" loans are those for which the interest does not accrue until 6 months after graduation.CPA-->JD wrote:Ok thanks. And by sub you mean the interest doesn't accrue until x months after graduation? Are any of the loans we can take out subsidized?MrJD2020 wrote:Thanks very much, that would be so helpful. I am 99% sure that loans from different years are considered separate loans -- they certainly are for undergraduate federal loans, so I assume the same happens with graduate loans (whether subsidized or not). I would expect to have at least six loans - sub and unsub for each year .CPA-->JD wrote:I like your idea for 1. I'll try to make it tonight after work and would be happy to send it to you. Just do you happen to know if you take out loans in 3 different year from the same source (e.g. Stafford) does that get aggregated into 1 amount or are they considered 3 separate loans?MrJD2020 wrote:Anyone know of any good ones? Looking for two things:
1. Good spreadsheet I can use to track how much debt I'm accruing and how long it'd take to pay it off. Something where I can plug in amounts of debt taken out and when (using disbursement dates for each semester), the interest rates of the debt, the amount of each loan outstanding, and then a payoff trajectory (where I plug in the monthly amount I would pay toward each loan and the date I start paying off that loan).
2. LS budgeting spreadsheet. I've been working for years but budgeting with an income is a bit different than budgeting the use of student loan funds since you really only get "paid" a few times a year and have to plan months ahead, as well as plan for the summer (which I'm not totally familiar with).
I originally thought all federal graduate loans were "unsubsidized" (i.e., interest accruing from disbursement date). While both the Direct Stafford (which caps at $20,500), and the Direct Graduate PLUS (up to full need, minus other loans/grants) are unsubsidized, the Federal Perkins Loan actually IS subsidized. It's capped at $8,000 a year for grad students but not every school offers it. They generally only offer it for students with truly "exceptional" need and you'd have to ask your finaid office about it. I don't know if I'm eligible yet.
There may also be subsidized institutional loans (i.e., from the school, not the federal government), but not many schools do this and again it's for exceptional circumstances. If possible to track five loans for each semester in your spreadsheet that might be best, to cover all bases (Stafford, Grad PLUS, Perkins, Institutional and Private).
I also assumed the interest from year 1 is not capitalized and compounded for the next 2 years, etc.
-
- Posts: 6
- Joined: Thu Jun 02, 2016 11:01 am
Re: Spreadsheets/calculators for LS debt repayment and budgeting from 1L - 3L.
Hey is there any chance you could either send this to me in a PM or upload this online and provide a download link for everyone? Thanks in advance!
-
- Posts: 245
- Joined: Thu Oct 20, 2016 9:08 am
Re: Spreadsheets/calculators for LS debt repayment and budgeting from 1L - 3L.
Could I also have a copy of that spreadsheet?
I've been using this sheet so far that's from the Law School COA thread in the choosing forum, but i'd be interested in seeing what you come up with.
https://drive.google.com/file/d/0B1AHcF ... sp=sharing
I've been using this sheet so far that's from the Law School COA thread in the choosing forum, but i'd be interested in seeing what you come up with.
https://drive.google.com/file/d/0B1AHcF ... sp=sharing